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 = "31-R-0029" 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
2cdeee9cd256 Miami University ORI 31-R-0029 2026-07-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001Jp8Q1&d=%2Fa%2FSJ00000BY5Rx%2FDdRiAxJE4vNyqGjj9gYh81ieSORXgZsH_d_TlSnVktY&asPdf=false pdfs/31-R-0029_2026-07-08_2cdeee9cd256.pdf match 628242e65a5e68cfbb730a7622f2951367ff8a7e13b85de5f0536a3b25c13f3f
32f0220db693f914 Miami University ORI 31-R-0029 2025-04-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000WpTVW&d=%2Fa%2FSJ000003gZ7h%2FyF9YHDBXz61oc00Tttmf3o2yFXdjbVxME6XtvvB8WOg&asPdf=false pdfs/31-R-0029_2025-04-30_32f0220db693f914.pdf match 8569320b79084665bb333e1407ede0d93f1c4997232764aa68ce1d637710cc1e
de4da8639e34af95 Miami University ORI 31-R-0029 2024-05-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000DgKxV&d=%2Fa%2F3d000002xq7l%2Fq7zpE_PGAJEM5XnfcpmjCA0KNLKUQHzPZQJq9IBB7Vk&asPdf=false pdfs/31-R-0029_2024-05-16_de4da8639e34af95.pdf match 728b43a0b1de75accfb8a2dea835e389bb28089a38e6db8d8b081c5bac821103
9ebf6317725f1846 Miami University ORI 31-R-0029 2023-07-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009ELDw&d=%2Fa%2F3d000001TaT7%2FNEIj2Jb.Eol1_SkQ33F25QoG1lxQRFrUOPDiXxiQop4&asPdf=false pdfs/31-R-0029_2023-07-20_9ebf6317725f1846.pdf match 59392214fd2385fcf97d63367211c9040696e94c2838a63727461f17bf144a91
07e449dc60264412 Miami University ORI 31-R-0029 2022-05-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ywx0i&d=%2Fa%2F3d000000peUL%2Ft0sxPEbXbwkLmcq52jMEDg0zhmIC_nTgtyciXhvxWPM&asPdf=false pdfs/31-R-0029_2022-05-10_07e449dc60264412.pdf match 248c56d046de140d891623a5682f861be02c55f8527df30825747974e29f6ad6
18eceeaddc8f7194 Miami University ORI 31-R-0029 2021-06-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000NhLYX&d=%2Fa%2F3d000000peRi%2FYnoMtDsfpbE_bK7CX2p8oMOLu0Qza.7AHOmSYGtczgA&asPdf=false pdfs/31-R-0029_2021-06-14_18eceeaddc8f7194.pdf match 2be303f82ee086d01f9e1a3a69ad360b4571cd1f67e31aad2831932e053b9ada
8980837c348cc1cb Miami University ORI 31-R-0029 2020-03-05   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egh7F&d=%2Fa%2F3d000000peS7%2FNFuxWimIkdZm.7iW5hBPrf1v0x8ORX7oX27ov.koG1A&asPdf=false pdfs/31-R-0029_2020-03-05_8980837c348cc1cb.pdf match dccab58a222bae953537b5b4d630717541980d39afdd319174224e0c0f28dfc2
2e1ad9ccba6beeab Miami University ORI 31-R-0029 2019-02-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglmf&d=%2Fa%2F3d000000peSI%2FrfpHQQ6FHZAHSRLum67kGR88PAllVMJrP6cX.EBGc48&asPdf=false pdfs/31-R-0029_2019-02-05_2e1ad9ccba6beeab.pdf match bd65e627a43437b7a32df7610c42f5554b9e7a44aad780df9a9d9df5cd43295f
89ed3c53933f5cee Miami University ORI 31-R-0029 2018-05-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggxY&d=%2Fa%2F3d000000peS1%2F4RljSEjI7HFHo.Iootw.CLgVa8fY4Z4LBQZK5HZiXVw&asPdf=false pdfs/31-R-0029_2018-05-17_89ed3c53933f5cee.pdf match faa35064e96201cd50d04b3d22c43e27ad243d0288e07caba6ccd9784e1cdc5c
ec14520930d82710 Miami University ORI 31-R-0029 2017-10-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EggW4&d=%2Fa%2F3d000000peRk%2FYVBhCnxgnnHBIR8FzX_nlzEgwK4JJz41K1VO4XrtypU&asPdf=false pdfs/31-R-0029_2017-10-12_ec14520930d82710.pdf match 437075cf57ff0f62fe9568dfe791ef4ff0b6a29016fccec8542ba5472df202f8
6e4a1d3029734c00 Miami University ORI 31-R-0029 2016-12-07   0 1 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXYc&d=%2Fa%2F3d000000peRx%2FM1Cr7WKtGvUJDs8xwxwkOZ8iZLWZs0IOVCxTrgWPwPM&asPdf=false pdfs/31-R-0029_2016-12-07_6e4a1d3029734c00.pdf match 80952096efb8beca8cb1bed21e45dd66aec2bfe2ed791ea1d0923d5a5096adb2
2fc948fb1be48ca7 Miami University ORI 31-R-0029 2016-02-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeH6&d=%2Fa%2F3d000000peRa%2FPipTPEj0ue5HHsdNgCRtbe79tinkKBkyhdsV0tyEX40&asPdf=false pdfs/31-R-0029_2016-02-11_2fc948fb1be48ca7.pdf match e98b67b4d4003d52a7837f969d39a77543b6c29c4815ecf15a268e7f54c14938
0818223b23511c4b Miami University ORI 31-R-0029 2015-05-12   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXel&d=%2Fa%2F3d000000peRE%2F3MHaxt0nOezOlEb58gaLTsAvU3KzHStTUPnOvoy6k5Y&asPdf=false pdfs/31-R-0029_2015-05-12_0818223b23511c4b.pdf match 7623506959b6aea0b24d8a1b461018174af715ad19ac5a25a7609dae66953ca7
14e5041e37399231 Miami University ORI 31-R-0029 2014-05-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eghlv&d=%2Fa%2F3d000000peRb%2FkJd0M6h5ijugoJuSqrFOsvhZM_kGC8XWBNKUQ.B2ueg&asPdf=false pdfs/31-R-0029_2014-05-27_14e5041e37399231.pdf match 0c9306400afd37832d4420264ae478d676173985ec018864a1d36c2105d05a30

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