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

10 rows where cert_number = "52-R-0121" 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
a33563519a2c0a8c Christopher Newport University 52-R-0121 2023-05-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008YXwr&d=%2Fa%2F3d000001F5wt%2FgL5_9KxJO7rxNDfmP8DW_D0SVcb14J4xCTmxPDZe0B8&asPdf=false pdfs/52-R-0121_2023-05-25_a33563519a2c0a8c.pdf match 9d4cc028d286863ecb6fae4464399e91564942637b2881f923a8a2d58da3afc6
09ab743b350a6afd Christopher Newport University 52-R-0121 2022-07-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yxj0w&d=%2Fa%2F3d000000pjeJ%2FJK6R5BaWO_0De1i.M4shc8CBp0D4quZ3FgPVANXdN54&asPdf=false pdfs/52-R-0121_2022-07-21_09ab743b350a6afd.pdf match 1958fa7453dbbf2294e062ddbcb02e5dc608f89241d092cfcbf821c0232b08d4
8f0268bd5a1ed2b1 Christopher Newport University 52-R-0121 2020-11-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000FyIyD&d=%2Fa%2F3d000000pjbi%2FKfY3F6lPcT6ui0kTZqIcLis7NJN.TI451bXSJSO09i4&asPdf=false pdfs/52-R-0121_2020-11-03_8f0268bd5a1ed2b1.pdf match 1dd4c0989f0185fcca5596d9336e79fb7141e1bc3e4724c444a4de74352e912e
2134539fddbb8a44 Christopher Newport University 52-R-0121 2019-12-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn5z&d=%2Fa%2F3d000000pjaY%2F8jaHfO4gTwYGiM5JdBCqxNzT8WgvA2TePqAx8AiZUN0&asPdf=false pdfs/52-R-0121_2019-12-05_2134539fddbb8a44.pdf match d901d00cc32b1c57ac2a605126543aea3bcc80511f40baa1f479b8f203945481
150337e1ea1044f1 Christopher Newport University 52-R-0121 2019-03-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn9R&d=%2Fa%2F3d000000pjbf%2F.HDWjN3xihhWbYcnch17ryLSnaUaNb._DtxayX6Jsrg&asPdf=false pdfs/52-R-0121_2019-03-28_150337e1ea1044f1.pdf match 63c76dc760416c86b08e1fe2b5fa476cfe2f03bae0838dabc422f3e45982701e
a98e3e638ead4a9d Christopher Newport University 52-R-0121 2018-01-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmrV&d=%2Fa%2F3d000000pjas%2F69orUaiZADmFowh4DWJhbqkFUMt6FsHJTiD2rSzrob8&asPdf=false pdfs/52-R-0121_2018-01-09_a98e3e638ead4a9d.pdf match 97d0043e882f921bba89ce485bd2afc35106ea815cd314ddc9f01c3acca2c9fb
e07f53749132a741 Christopher Newport University 52-R-0121 2016-12-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmoG&d=%2Fa%2F3d000000pjaT%2Fmmpnp78h8waQb6oZ1Cs0Xnqfr56QxAJLQ3kROWB3WQ4&asPdf=false pdfs/52-R-0121_2016-12-19_e07f53749132a741.pdf match bb6757c828ca48105a03205ce4c8f19dac780e9f9fd311c33ad6de6bfbf82d90
4b9a7e4acf9306f6 Christopher Newport University 52-R-0121 2016-04-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnKW&d=%2Fa%2F3d000000pjbj%2FRzL6.CdcfqAL10n8xlI59IZ2kDxxqMyUCxLIq7HPpi0&asPdf=false pdfs/52-R-0121_2016-04-04_4b9a7e4acf9306f6.pdf match 50200088ccf3c892868a1326c434496a59d4bffbe34631d869ff3f24ff8b9ab1
f248a549945e79d0 Christopher Newport University 52-R-0121 2015-05-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnM2&d=%2Fa%2F3d000000pjb0%2FyCUJmYfCXx61PSlBQbPXSPnpQ3KOpD1.Fml0.M1D3BY&asPdf=false pdfs/52-R-0121_2015-05-06_f248a549945e79d0.pdf match ec783a31ec262916a4c3da76d72a4802a68c6a4f48593c9d052d6c24ff605b30
44d9db24f95ba19d Christopher Newport University 52-R-0121 2014-08-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmTK&d=%2Fa%2F3d000000pjbT%2FCQb15C8pCd2vkxg0qw.5EdH4qjzrNh1Pd9NJ5o9mJS8&asPdf=false pdfs/52-R-0121_2014-08-26_44d9db24f95ba19d.pdf match 524534f35f0cf5bcefe4b17f399006c7f356764f85c1227397590413b3e79e97

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