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

7 rows where cert_number = "96-R-0007" 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
1f4c8e904a8d Alaska Department Of Fish And Game 96-R-0007 2026-07-23   1 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001MeZlG&d=%2Fa%2FSJ00000Bzsl7%2FHfOIWlwT6OycpwCv4zgrpQFKxrcfR9w3Z_cHhBcIGw8&asPdf=false pdfs/96-R-0007_2026-07-23_1f4c8e904a8d.pdf match 4c132c796836da2e6554e93bd42c2bfb9517d952eecc4836259a6ec9d5d2145b
f0ec6029f7359435 Alaska Department Of Fish And Game 96-R-0007 2025-08-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000hQCft&d=%2Fa%2FSJ000005H6pJ%2Fw6fdafvl8W3MXslRwQZdzwSO8YZ_Rsid2xdLXX126N4&asPdf=false pdfs/96-R-0007_2025-08-07_f0ec6029f7359435.pdf match e8097ded52650984a0b4d90f58a96de8c3740a62a5d5af7b27eb0494cc70792d
15e61a90b46916fc Alaska Department Of Fish And Game 96-R-0007 2024-09-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000003iuJJ&d=%2Fa%2FSJ000000CYsL%2FTHh9CtRTZ.CXIiwC5_RqEwomwvvaq7u87P8z7Uz5i_M&asPdf=false pdfs/96-R-0007_2024-09-03_15e61a90b46916fc.pdf match d5d03c9c9d2c618646a754b09b9bd094c9b55d761deb0c543fc89eae478c950c
0c56ffae2c8435d0 Alaska Department Of Fish And Game 96-R-0007 2023-07-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009KJDx&d=%2Fa%2F3d000001W7Lb%2FLkgG3QMMLW4bTEEt5TrK4kM0R0gBSnsNTNpt6K5PnSI&asPdf=false pdfs/96-R-0007_2023-07-27_0c56ffae2c8435d0.pdf match 248426ff29624c94c11f9af91445590ce170e66f45ca9c699cbac54105f3f1d5
98955273c01e0916 Alaska Department Of Fish And Game 96-R-0007 2022-07-25   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxnqN&d=%2Fa%2F3d000000pU0Q%2Fmv1Y__XVq_7V2LAVGepwxaQHH.doJ_IJsAXs3jE7gW4&asPdf=false pdfs/96-R-0007_2022-07-25_98955273c01e0916.pdf match e7ce304415d3e4a93a42893134e874e7e23842de0b39e44008d0a9b5a379a28e
c66a13835ab34b38 Alaska Department Of Fish And Game 96-R-0007 2021-01-11   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ERxhg&d=%2Fa%2F3d000000pThn%2FrRvGS6maOyDoeBfB3Sz2emYMdzCglsjfkup6QTvF0Og&asPdf=false pdfs/96-R-0007_2021-01-11_c66a13835ab34b38.pdf match 55b71565632ad92df052b5aa3d9bef16ce731c9a5ad8d4056c2244b4ffb0a362
53f8859e7872981d Alaska Department Of Fish And Game 96-R-0007 2019-08-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egdia&d=%2Fa%2F3d000000pTgV%2F9Oy26mD1g9AnZOOi98.czayIEveshXZaIF4w4PWwsvw&asPdf=false pdfs/96-R-0007_2019-08-26_53f8859e7872981d.pdf match baae86b849dc794d50130db77073b22d4683a16766a3ed0d1fea53c678f1f5f2

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