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 = "93-R-0580" 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
176876d6e95d BLP Biolab Services Inc 93-R-0580 2026-06-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001Ic233&d=%2Fa%2FSJ00000BMy7F%2F8Tl.JaFohsT92jlA4TVlYSL0O5220S9R5vcizXzrKbw&asPdf=false pdfs/93-R-0580_2026-06-23_176876d6e95d.pdf match 5eb205b8623cb6d197bd78958473f455feeafa0e7098ab591e5373f088cac22a
8475cbac2cf3e525 BLP Biolab Services Inc 93-R-0580 2025-06-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000c0zKF&d=%2Fa%2FSJ000004Uplz%2FIyIDNcV4Qzw_sbGLxl_3YQ9GM0z9ZzPRXDHEsHEUga0&asPdf=false pdfs/93-R-0580_2025-06-18_8475cbac2cf3e525.pdf match 2601c824bb75048a3eb922a4ad4ddbc10571cd339e70dc3704dd4f68e28d443c
6d92de5e57c3066d BLP Biolab Services Inc 93-R-0580 2024-06-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EKMYR&d=%2Fa%2F3d0000037m9c%2FxNJNTTBBc9M.IntgovS73eFj8Oly1CyTwu8HJSxFFqY&asPdf=false pdfs/93-R-0580_2024-06-26_6d92de5e57c3066d.pdf match 9119fd0c1692df90ab28f253f268e5f22487bd43ff7e1cbb426684c415596ae0
d1b21ac0f42313c3 BLP Biolab Services Inc 93-R-0580 2023-06-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008rppb&d=%2Fa%2F3d000001LkbW%2F_.zfzL9nDEGkSVmuhtqTg6hirXyeMg_DmbLFLF4MgZc&asPdf=false pdfs/93-R-0580_2023-06-20_d1b21ac0f42313c3.pdf match 25f8094128795c6625660f9a622a8ee24426a934419591799a5ba6d08093e20d
9a1496bd0bfe764f BLP Biolab Services Inc 93-R-0580 2021-11-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V8kq6&d=%2Fa%2F3d000000pgnC%2F4Z0MuTIVi6.TigN3S4k4Tr_vDUzppyd1obqBULcChKk&asPdf=false pdfs/93-R-0580_2021-11-29_9a1496bd0bfe764f.pdf match ae41e8f4919fb2a9320d3911c60160fe36c4bc3291e124fb2dc33df74c41ceb7
487a8b0e010d4727 BLP Biolab Services Inc 93-R-0580 2021-08-30   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PN922&d=%2Fa%2F3d000000pRu6%2F7L60IZHKWRwdeyuGGEgBFclQQoPYgYwBb0JkddEOBiU&asPdf=false pdfs/93-R-0580_2021-08-30_487a8b0e010d4727.pdf match f20183a7217f0545f39de13df8b521ee66bdf29058a7a5d974e2748d5e2e9770
7dd8d838c63d5e90 BLP Biolab Services Inc 93-R-0580 2021-06-23   0 0 1 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMZDf&d=%2Fa%2F3d000000pRtT%2FTezExQ7wp.jwAjBY5zf2jX5Qmy2q5uSYTsX.TOC.yEk&asPdf=false pdfs/93-R-0580_2021-06-23_7dd8d838c63d5e90.pdf match 83e446019967dfb3ea1ab3947bec2c439492326739106a8218ae6def0fb4f233
a0299a5b1950a929 BLP Biolab Services Inc 93-R-0580 2020-09-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EpNWD&d=%2Fa%2F3d000000pRif%2Fa2t6qSfRpYvLSAWdJNRdYoImAIvok8_BxYiV1bW6OlU&asPdf=false pdfs/93-R-0580_2020-09-21_a0299a5b1950a929.pdf match 4f74067487fa0c910e420ec7e2fcd73a0543bcdedf77a4fab9767944fb8b0f8c
2abc87124911420f BLP Biolab Services Inc 93-R-0580 2019-08-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egdv7&d=%2Fa%2F3d000000pkvM%2FgnnolsfFBuSs.qY3Pa5IcIw.Ja49vR98qrTmn2Vt.ac&asPdf=false pdfs/93-R-0580_2019-08-15_2abc87124911420f.pdf match 12d1dbdfdef3a4738da6982375331061a10955365a79b006b47442bd08366cce
d222243506cfb715 BLP Biolab Services Inc 93-R-0580 2018-05-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggO7&d=%2Fa%2F3d000000pSco%2FRHAQ.161OOSdo3LVLU_htm8nP0Cx_CJX0tyeJRISarQ&asPdf=false pdfs/93-R-0580_2018-05-22_d222243506cfb715.pdf match 59f27ad6c294e206c800ef14fbead78eb1d4cf670b27c8cc9196f12476adb454

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