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

15 rows where cert_number = "14-R-0030" 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
7bcbd68f7d26 Brandeis University 14-R-0030 2026-05-14   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001D6XsY&d=%2Fa%2FSJ00000ARVZq%2FnCD.ctNkqnTYIaIto2s3Q6JqoTDzFfDQm.LB_h8yftY&asPdf=false pdfs/14-R-0030_2026-05-14_7bcbd68f7d26.pdf match c8dcfc14d1cdfa18e0392d589e91b692ea3d135f2779beea425d64c135a48ac5
8e03a1728b7cc5fd Brandeis University 14-R-0030 2025-07-23   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000fjQa4&d=%2Fa%2FSJ0000051mSj%2Fq9FGk1GcQeYlTfF.xzxt1qY8A6Icuq0os6nPMWrYY3c&asPdf=false pdfs/14-R-0030_2025-07-23_8e03a1728b7cc5fd.pdf match 042afc2ef6501f08e9b239806848921bb8b9a8871f7ec1884b3187632bd5b41b
b054e567211d50e5 Brandeis University 14-R-0030 2024-05-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000Damen&d=%2Fa%2F3d000002wasG%2FE7pB3PsB.tNCFOpNvv8MPrng5QAXK4HdEDkoamvnT_A&asPdf=false pdfs/14-R-0030_2024-05-09_b054e567211d50e5.pdf match 53d36fbe0e43f1e3cb456465d7c2fdbf8f957672fa9ac5f0b00306d0bb74a491
5ed39f443948ce27 Brandeis University 14-R-0030 2023-02-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uEqC&d=%2Fa%2F3d0000012mxs%2F3Ko4BGpwazPB8hqmgscbNHG2czDwDOEF7yQrkMenY8Q&asPdf=false pdfs/14-R-0030_2023-02-16_5ed39f443948ce27.pdf match bdc5a1be7207d046d8113898519e9d76f6dfae01216118fff71b3c19e0b152d6
cf5bb8d9e43f7d8e Brandeis University 14-R-0030 2022-04-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YwiNY&d=%2Fa%2F3d000000piTC%2FZiFnsT9x9wRWMrHYXYVtBDRhy9LWIDK7Wjl8gkwy1ig&asPdf=false pdfs/14-R-0030_2022-04-13_cf5bb8d9e43f7d8e.pdf match 3c6fd59238c727f960ae722491132b491a5b866bc0002da7c8876da1d787076e
b787cc39d538ab50 Brandeis University 14-R-0030 2022-01-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V98Ri&d=%2Fa%2F3d000000pgza%2Fa9FHaT5.ZP.oyimwp5Z.jOqM8C3mFBUxzu6jAee55.0&asPdf=false pdfs/14-R-0030_2022-01-20_b787cc39d538ab50.pdf match 622ca7ced7257fa6042bd395338175b90bf70cc76dd3524d168875189401864c
8619513ed15cf136 Brandeis University 14-R-0030 2021-10-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V8IM8&d=%2Fa%2F3d000000pRvf%2F9NbMGp8y0vlrrT6fmmmTTBZyyvTfg3BiJ6tE2268Ar0&asPdf=false pdfs/14-R-0030_2021-10-20_8619513ed15cf136.pdf match 9fe8a8967ca3b91b4ee182af523772b6e06afc85717a2f9a97583844165fb86b
b9e0596ec4f8c0b8 Brandeis University 14-R-0030 2021-07-01   1 3 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMYJY&d=%2Fa%2F3d000000pRtg%2FytE7V.14MQ0x21p6KFYQorLQD7c8Lkx1mDGOIb.F1QI&asPdf=false pdfs/14-R-0030_2021-07-01_b9e0596ec4f8c0b8.pdf match 49f9cc3b263e4a00aee5ea852874a153a9c935684c1f6a10c7a74ead4f13e004
265dfe9540fba87e Brandeis University 14-R-0030 2020-09-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ErnQJ&d=%2Fa%2F3d000000pjHt%2F2aD3pdEJ9J1zhaNDoLC3.u.bJqmQPKjaCRXEaetrqak&asPdf=false pdfs/14-R-0030_2020-09-30_265dfe9540fba87e.pdf match 087f03f557f45e8142c7cfd14586f326df173aeab41fc0452e6a2775017dd20a
c2d5235d2a7a8d09 Brandeis University 14-R-0030 2019-07-24   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXrZ&d=%2Fa%2F3d000000pbgB%2FwsdIk7eu3scUbwjk5YP5MWtTiu.s3ObxC27Aobi7E3o&asPdf=false pdfs/14-R-0030_2019-07-24_c2d5235d2a7a8d09.pdf match 8f2eb347ef0397ef01ef918b3f99f9dbc7ecebcf8987ba090d83e2b757c47f45
44e738012404a3bc Brandeis University 14-R-0030 2018-06-05   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeJK&d=%2Fa%2F3d000000pfZj%2F8N3oL9BJT8WMGFmyE0sDaIBkocvElj1zDEoJ4Gq_SaA&asPdf=false pdfs/14-R-0030_2018-06-05_44e738012404a3bc.pdf match b2e61ab8d52a9f7d3586285adfec9e3f5f333d90134970385d4752a58845f93d
74e7d635459cbc50 Brandeis University 14-R-0030 2017-04-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egewq&d=%2Fa%2F3d000000pg15%2FrSZEamJlFTiKFCzxpBjMEvbsnJ2n79Plc6Y77jdzkDU&asPdf=false pdfs/14-R-0030_2017-04-06_74e7d635459cbc50.pdf match 3bbb032ddba42f3f22177e4427965d1387b9b1f494d211cae56b2770729a888e
b6fb39b44e79ddd9 Brandeis University 14-R-0030 2016-06-16   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXkb&d=%2Fa%2F3d000000pn6j%2Fn4V6hq2fftF2P2tOuxinlohkT.gqTc_a0FL9HFXcV.M&asPdf=false pdfs/14-R-0030_2016-06-16_b6fb39b44e79ddd9.pdf match 4ea84f55f1491f98be02383bcb3901975513c2e504925ebd18730a566a08d453
eb65ba50d20707e1 Brandeis University 14-R-0030 2015-05-19   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgVr0&d=%2Fa%2F3d000000pfWx%2FwZLT4prqTDggkRdck9cSsNW3zYymORU6a_uMWgd7ZxE&asPdf=false pdfs/14-R-0030_2015-05-19_eb65ba50d20707e1.pdf match 5862b6c2015ae88e87d6010eb9b8dee9e1120a692945b9ded8945508a70275ef
eec2538640f6e97b Brandeis University 14-R-0030 2014-05-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYHw&d=%2Fa%2F3d000000plqg%2FAeSuPXQrp_XTaMK812A01MsnUs85iDvha5IU1stjTI8&asPdf=false pdfs/14-R-0030_2014-05-20_eec2538640f6e97b.pdf match ae5795ff618f7aae8ecc287519ca83c08e32bdcae6c833984f15a474fc309bc2

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