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

13 rows where cert_number = "52-R-0131" 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
8d02492b5a0c3277 GOV SOURCE INCORPORATED 52-R-0131 2021-04-05   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000NgwkR&d=%2Fa%2F3d000000pe23%2F0VMvx.e_u6u5ZV5LsQz15YInQZUjRFx3yWpL4tLgyNA&asPdf=false pdfs/52-R-0131_2021-04-05_8d02492b5a0c3277.pdf match 538c67f0cebc5f230459aacb47df91803656503ddce41d0afd02e21953f61bf3
8a1a623f926d GOV SOURCE INCORPORATED 52-R-0131 2019-08-14   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmLB&d=%2Fa%2F3d000000pf4D%2FcGOBSejYQIQygP8HD9fbCorZ6SA3Tmx8PJPjFYPgTWc&asPdf=false pdfs/52-R-0131_2019-08-14_8a1a623f926d.pdf match abe5d502e5bbc81d46671aaef179c531ec611c4bdc90bca3dc0f8252b7928058
87730a4bd4728c08 GOV SOURCE INCORPORATED 52-R-0131 2019-08-14   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnVJ&d=%2Fa%2F3d000000pWPS%2FUGvfnwhIY_0HFSxaKkY9.ToVUotDa8hYnB94mSWSfCk&asPdf=false pdfs/52-R-0131_2019-08-14_87730a4bd4728c08.pdf match 5a46a5627df12ee27773abf74b8c593696a738b8ee93cd2c3353bc59ae1ab48f
95d2d37d937c8c58 GOV SOURCE INCORPORATED 52-R-0131 2019-06-06   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYp1&d=%2Fa%2F3d000000pkHq%2F7tpEyrTbi9_ZHydriwSrpDvWnCK2Au7P2cb7uSGN8jE&asPdf=false pdfs/52-R-0131_2019-06-06_95d2d37d937c8c58.pdf match 30a90e91ebdc65cd0a39fc54cc6e2573c96c32591018924f17575da94d1804e5
084112f73cdf9906 GOV SOURCE INCORPORATED 52-R-0131 2018-08-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn8G&d=%2Fa%2F3d000000pT9b%2F.uTm49ysYmavbUuVuHnd_T23g7lBUk9vyLODhxx7A20&asPdf=false pdfs/52-R-0131_2018-08-08_084112f73cdf9906.pdf match 11bd72d3c796ff32f3671965ec5b6cb45cc3b71398484cbdfeb98d856ec0d6bd
2967c42dccdba312 GOV SOURCE INCORPORATED 52-R-0131 2018-07-30   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egcr9&d=%2Fa%2F3d000000pSqb%2FqMMbMwso9T7dhFlOR5DvAG30uchzsxjLJUEobQS_oDQ&asPdf=false pdfs/52-R-0131_2018-07-30_2967c42dccdba312.pdf match 884633331747466653bbe29cfe0c93f17f4ad64112b6bcbe01cf41672c50e63e
b9b6eadbddab1ddb GOV SOURCE INCORPORATED 52-R-0131 2018-07-19   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglkT&d=%2Fa%2F3d000000pSnG%2FhzrHDlG196G.7UrwNf.2QHBIi0xB64dwAA.OvcjXKSo&asPdf=false pdfs/52-R-0131_2018-07-19_b9b6eadbddab1ddb.pdf match e0c81e2c00dd4534f9085710ec83498c3fca6a1e6de33e868fb39c2a8bb00983
648f78fb6eae0da0 GOV SOURCE INCORPORATED 52-R-0131 2017-07-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgecT&d=%2Fa%2F3d000000poeq%2FpY6IaWtYNKNbT38.qmTWw5cpdNIpuR2u01CYTqK1JSg&asPdf=false pdfs/52-R-0131_2017-07-13_648f78fb6eae0da0.pdf match 4108acb99921eff29a5d1a445ae068e248bf876f124c667ae775131338808e6f
5933fc5efc5b63fe GOV SOURCE INCORPORATED 52-R-0131 2017-05-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmnW&d=%2Fa%2F3d000000pUVK%2Fn2PhSDm07h5FgM0Sg7QM1hfuCex2fKna2GQrBkuoSzA&asPdf=false pdfs/52-R-0131_2017-05-17_5933fc5efc5b63fe.pdf match 5378bdf95932b165f37dd8221be1aab7374406ef8d5d461e9853e5dce56ea164
2210d7bf8d7aab3e GOV SOURCE INCORPORATED 52-R-0131 2016-09-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgoLk&d=%2Fa%2F3d000000pdts%2FbulrogiuCX.kuVDWamlqXDpga9sONbBZPTLPHPDnATc&asPdf=false pdfs/52-R-0131_2016-09-21_2210d7bf8d7aab3e.pdf match 391dbaa9090d2b53f6ab276eda06f78ff9e9b076b2b8335f112f288b411afa8d
9de30731746f75e4 GOV SOURCE INCORPORATED 52-R-0131 2015-06-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmkR&d=%2Fa%2F3d000000poLF%2Fkl6VI3HPP.aPNHiXbz3ufC2kbFadWoLWN2kBHIX5ol8&asPdf=false pdfs/52-R-0131_2015-06-04_9de30731746f75e4.pdf match 9f29bd7299aa49f7f49c27d9e1e96c3d888547d17ce2b4e23d4626bcbd571680
18a363673f36874c GOV SOURCE INCORPORATED 52-R-0131 2014-09-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ego6k&d=%2Fa%2F3d000000pkHz%2FMNokxMGHIcipXAhktni8rFibsePDthrylRPXwQq7kRs&asPdf=false pdfs/52-R-0131_2014-09-05_18a363673f36874c.pdf match 92bf9a214c3c616a6a0b622a8a0a7af10f351e09335b86e806c606c83e56440d
aaaa426f4b322168 GOV SOURCE INCORPORATED 52-R-0131 2014-07-08   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeT0&d=%2Fa%2F3d000000pSL9%2Fh7YFOI3SgZqNUBWJAjvmBSWst7DAmihL9iPOVFKCyPw&asPdf=false pdfs/52-R-0131_2014-07-08_aaaa426f4b322168.pdf match 16b046d8cb1255a3b9599ea91ed16590d640e5579078504819de42eb93e478ce

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.113ms · Data license: Public Domain (U.S. Government data) · Data source: USDA Animal and Plant Health Inspection Service, Animal Care public search tool · Privacy