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

14 rows where cert_number = "52-R-0001" 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
b1778581066a1d4c Blue Ridge Community College 52-R-0001 2024-10-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000COdW1&d=%2Fa%2FSJ000000vlOn%2FktXmD0GztR1n5Ee76Yi.D4wJKEKsKY_ADs.Li0hQFkU&asPdf=false pdfs/52-R-0001_2024-10-30_b1778581066a1d4c.pdf match 18c17920a3078f105deae37b9ae73e8cb40f969bb2153f6dc5fecb6367e7483b
2d5a63af1d2194a0 Blue Ridge Community College 52-R-0001 2024-02-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000C1mXc&d=%2Fa%2F3d000002S34l%2F9shhxA2_iHPYX0H4ZswzThXSDC8elywt9m2vmJxtwjU&asPdf=false pdfs/52-R-0001_2024-02-01_2d5a63af1d2194a0.pdf match 6156b3d39e440e61282d4ddb4cc87e97891c299b5403fa4839c83adda1b6af09
5d04fa574295a961 Blue Ridge Community College 52-R-0001 2023-05-08   0 3 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008M8lz&d=%2Fa%2F3d000001BcfL%2FgPFmSq3uHRA2TdN138HyqIgug2KVgivSFxCpG36cm3k&asPdf=false pdfs/52-R-0001_2023-05-08_5d04fa574295a961.pdf match c29f7e2f67cf7657be6740c543af01d97700cb36f7313c6a7b620dabde49e3dd
f8594da9bfb1c589 Blue Ridge Community College 52-R-0001 2022-08-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yy4Jo&d=%2Fa%2F3d000000pXu9%2FXWuWVkujJtbN_d8JADdJMyHHqlXb9ZVgXa6RwDkKQ6U&asPdf=false pdfs/52-R-0001_2022-08-18_f8594da9bfb1c589.pdf match 4b094688536f438b5dd49b70a8a63eba4c481013df15afe23c4dfaf1149ba473
6346a28c213a57d3 Blue Ridge Community College 52-R-0001 2022-07-29   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000gvNCC&d=%2Fa%2F3d000000pcps%2FjnQfCJDneWLVyVmz6cm21PGH204Cl8c310F8iVAsCw4&asPdf=false pdfs/52-R-0001_2022-07-29_6346a28c213a57d3.pdf match e689dda559d1252b3dc8d0657214c5ec45cbc1cb2a5a4b3701a3367a63e372db
879ff856bcac9eb8 Blue Ridge Community College 52-R-0001 2021-08-31   0 2 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PN5q8&d=%2Fa%2F3d000000pXrp%2Fwb9BIV1lWzV7a0S6bC6ci.8kgeovVYoSNs8BrMrk_1w&asPdf=false pdfs/52-R-0001_2021-08-31_879ff856bcac9eb8.pdf match 1e144543b26c4d5a51b4a49ed57c99b23806c8382bc7bbf648e7ff4532989fa0
cd5bbc1074590811 Blue Ridge Community College 52-R-0001 2020-01-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnX0&d=%2Fa%2F3d000000pXuC%2FfdIjXbQX3bFxYrvv5OmwhkHQzFZa0FQr95x6cHfM5Gk&asPdf=false pdfs/52-R-0001_2020-01-08_cd5bbc1074590811.pdf match b1f90a7e12ae9a7309ec0e30d333314e20a150c74f2d23d89762ec07051183b9
23c47475fb66b09f Blue Ridge Community College 52-R-0001 2019-05-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgnQY&d=%2Fa%2F3d000000pXt5%2FOI.TfGLvFLT6_4UUi2C768K97WZ8oOVYL_KjI22xD74&asPdf=false pdfs/52-R-0001_2019-05-28_23c47475fb66b09f.pdf match c78e218f3a8fbf1e0fb32bfecca485e69d3d2e078a3c94bbd19219382f9f393b
60f466a5faf3b4be Blue Ridge Community College 52-R-0001 2019-05-09   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkXa&d=%2Fa%2F3d000000pXuG%2Fb9CBqROmMjWFaZ81itdYWZYAbvUuWti16obyhCeuLro&asPdf=false pdfs/52-R-0001_2019-05-09_60f466a5faf3b4be.pdf match 23c0763e66572a3899985b93c7cbce32c79499b5a907b391398193eff9f77ead
f4dfbbae96ed7844 Blue Ridge Community College 52-R-0001 2018-04-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeM1&d=%2Fa%2F3d000000pXu3%2Ft1BW8cQsLTCqxYhx6UqSIE8GCv14HFEic7ORai3yFKE&asPdf=false pdfs/52-R-0001_2018-04-11_f4dfbbae96ed7844.pdf match 50dd646316cc5399c1d913958aeb78d1c907dc2f20887756164be7dd53e7dbcb
92174beb66050079 Blue Ridge Community College 52-R-0001 2017-01-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egd30&d=%2Fa%2F3d000000pXsR%2F9ROrB0aXNO2RD1yven00FqawM4i0ou80O1FDCdZC8bY&asPdf=false pdfs/52-R-0001_2017-01-24_92174beb66050079.pdf match fe6f057a544a9d4a68e2e1f7026ee2a524b0ab015f017e40cc0f0ed0a0445eab
b83d6228e213c970 Blue Ridge Community College 52-R-0001 2016-04-27   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXLl&d=%2Fa%2F3d000000pXtH%2F9mZMVjThWsZ9OfpswuAp59w8DmwpDORG1EzT6C5on08&asPdf=false pdfs/52-R-0001_2016-04-27_b83d6228e213c970.pdf match bd94bbdcb515f2f1e81221c0a3f63878e4fc022bd3dfd1559b227e97083d330a
5de72206b8994a94 Blue Ridge Community College 52-R-0001 2015-09-16   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZJ8&d=%2Fa%2F3d000000pXt6%2FmtlyAFxHcEpmpSDBJKypRQPZ8s7vAtjHTB0SCR_tU6Q&asPdf=false pdfs/52-R-0001_2015-09-16_5de72206b8994a94.pdf match a8c6ae2d32b178684fe86e14e76cf3c94f9618bd6765f80b2aa83b77869c274e
a7d30023c3a948f1 Blue Ridge Community College 52-R-0001 2014-09-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgfAu&d=%2Fa%2F3d000000pXtg%2FYMUi.mEWvPhjRhbY9HDTd6cniAw1_0AyHP7f64_59E4&asPdf=false pdfs/52-R-0001_2014-09-15_a7d30023c3a948f1.pdf match d524ea8ebe955ff2b1eac698e61bf4545732f9e831041c24d3c12d81ca9bf79b

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