home / aphis

inspections

APHIS inspection records for licensed facilities. 110,000+ inspections from 2014–present with violation counts and links to official reports.

Data license: Public Domain (U.S. Government data) · Data source: USDA Animal and Plant Health Inspection Service, Animal Care public search tool

12 rows where cert_number = "52-R-0114" sorted by inspection_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

inspection_type 0

id cert_number inspection_date ▲ inspection_type critical_count noncritical_count direct_count teachable_moment_count pdf_url pdf_local_path cert_verification pdf_sha256
3291b41ef2fa07da ATSCC 52-R-0114 2024-10-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000BQGnc&d=%2Fa%2FSJ000000qhNR%2Ff9l72fRHnUYNjjQ9glzx5WQE0m0wQzUXwUL6xvCMsDA&asPdf=false pdfs/52-R-0114_2024-10-24_3291b41ef2fa07da.pdf match d466882c675b18e24a5acca42c5c584b344790f794a7496002f2563123cbdb9e
43e96fe377d440d9 ATSCC 52-R-0114 2024-04-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000DJRo3&d=%2Fa%2F3d000002rOlo%2FWgBZogfOogUjgTVZV9dnoZ2eGZmqCraDrnoXdoBGoSY&asPdf=false pdfs/52-R-0114_2024-04-25_43e96fe377d440d9.pdf match a8bcbc5b4e5c4a6ec7081990e002b20f23477754ee89f337065796d84157a0da
f2cf593bf8d1e185 ATSCC 52-R-0114 2023-05-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008X6oi&d=%2Fa%2F3d000001EeL7%2FdEa5stqt0FXobCibbiNPb5wm5b2I0Ar__BA0X7PjPZo&asPdf=false pdfs/52-R-0114_2023-05-23_f2cf593bf8d1e185.pdf match e5decf33dd9f1654404c8252b231ede4f869a0b57a9cbcadd685cceaafdfe789
d5e58fb6be3966bf ATSCC 52-R-0114 2022-07-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxivS&d=%2Fa%2F3d000000pjel%2FXU1COB9_G0ybOEyMRuAbiK1koGZvCysXYitOgRVFbWI&asPdf=false pdfs/52-R-0114_2022-07-19_d5e58fb6be3966bf.pdf match dbfd3a8817904e87c1a7505835b06d10c75af02771c49e9020340f007bcbb0f5
568464818483d064 ATSCC 52-R-0114 2021-09-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PNCMH&d=%2Fa%2F3d000000pjTA%2F_jkVFUxTXskSqmAeOtJKQ2nZ88ijEAQlcBTwWhvIhYs&asPdf=false pdfs/52-R-0114_2021-09-13_568464818483d064.pdf match 29dacc33978804b7289f492e8eaf230a22625d0ac2470c827da9d45fdef9a904
769b9a94673c731c ATSCC 52-R-0114 2019-12-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgoKz&d=%2Fa%2F3d000000pjSf%2Fq17lqsJfZeyKIlvyNI58KlAEGWdX9KYNLs3FBcQxu6c&asPdf=false pdfs/52-R-0114_2019-12-19_769b9a94673c731c.pdf match cd1420c19df1f14572056266542a33842ab0538d7270079f25d3454662fd0da0
498234a838b20423 ATSCC 52-R-0114 2019-05-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egjpb&d=%2Fa%2F3d000000pjSs%2FCREtRNH2SL41MYq0akzsfAtcWLC..Noi5ilGwWlsaqw&asPdf=false pdfs/52-R-0114_2019-05-08_498234a838b20423.pdf match 22a673ec20472cacb61d6fb1f20cfedb82b9a7e5cc5612d8c7085149e00e1cc4
e3a6be94140e672b ATSCC 52-R-0114 2018-08-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgjLP&d=%2Fa%2F3d000000pjTV%2FYxDOU_ASaPe6XietY2sXPa7rCTAbw1TltVmSCno5Ags&asPdf=false pdfs/52-R-0114_2018-08-08_e3a6be94140e672b.pdf match 3e3f55556a5628a46ed6dcda16443552660832fb31455b3e58ecdac953ba3c1a
c2343e733a40d69a ATSCC 52-R-0114 2017-07-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egjvr&d=%2Fa%2F3d000000pjSe%2FXs0eDEoanBe1jLUHr.34ED.PYxzoSSmy.GOcbIU.0Yg&asPdf=false pdfs/52-R-0114_2017-07-26_c2343e733a40d69a.pdf match c0542e9a936d4f3f1968a07deeb50a9b89fcfe5045c8513df5c82d82981a7bba
bb713e4ebe681448 ATSCC 52-R-0114 2016-04-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egnk1&d=%2Fa%2F3d000000pjT3%2FY2WgxQfygdPfUOF8OmFsBovQEB_PzIvF7cR2Xxnq5Fw&asPdf=false pdfs/52-R-0114_2016-04-05_bb713e4ebe681448.pdf match 4ae48a7a2b322eab92e974e8ba4ff0b16422f6ff16184237f2128e82460031d2
f773279ad1608c2c ATSCC 52-R-0114 2015-09-21   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgceZ&d=%2Fa%2F3d000000pg7B%2FP32gq0GvpGcow1uR3x8dDM3xjpziLmiMooEAS8KJmv8&asPdf=false pdfs/52-R-0114_2015-09-21_f773279ad1608c2c.pdf match 586a93ae32fcbc5037168e0073a8a4acd7e348e20ea6390533445c834cad9abb
c56da1490b0c6235 ATSCC 52-R-0114 2014-08-14   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egbe8&d=%2Fa%2F3d000000pju5%2FPTsuoCH_3NzoBi1DtvNUylKyE4mLDZqrJDHDRgD2Avk&asPdf=false pdfs/52-R-0114_2014-08-14_c56da1490b0c6235.pdf match 4db28719d37e7e7bfb8b9438f0a3586ac425a14fd292f03d2584b4f4906ae6ba

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE inspections (
    id TEXT PRIMARY KEY,
    cert_number TEXT REFERENCES facilities(cert_number),
    inspection_date TEXT,
    inspection_type TEXT,
    critical_count INTEGER,
    noncritical_count INTEGER,
    direct_count INTEGER,
    teachable_moment_count INTEGER,
    pdf_url TEXT,
    pdf_local_path TEXT
, cert_verification TEXT, pdf_sha256 TEXT);
CREATE INDEX idx_inspections_date ON inspections(inspection_date);
CREATE INDEX idx_inspections_cert ON inspections(cert_number);
Powered by Datasette · Queries took 1.028ms · Data license: Public Domain (U.S. Government data) · Data source: USDA Animal and Plant Health Inspection Service, Animal Care public search tool · Privacy