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

13 rows where cert_number = "55-R-0124" 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
f7c87e1b786e0285 APPALACHIAN STATE UNIVERSITY 55-R-0124 2026-01-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000yGF5f&d=%2Fa%2FSJ000007p19J%2FbEFPHpMhBijBluiJNTM1pbY1.apNg1pBD9YIDbtuWiQ&asPdf=false pdfs/55-R-0124_2026-01-09_f7c87e1b786e0285.pdf match 4a45d601d1875ff86da257e1ba8ace20a70502418fa33fd49ed21cf78a1341cb
aa46d23945e8a5c5 APPALACHIAN STATE UNIVERSITY 55-R-0124 2025-02-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000NmfJy&d=%2Fa%2FSJ000002EsDt%2Fyl5SDSUIrt0VaVdtNM0hod4K9BOvleAi_9WN7dC37aI&asPdf=false pdfs/55-R-0124_2025-02-13_aa46d23945e8a5c5.pdf match 556d6b216491266b3a3fb9842cf0c10dbc8640cd6c67781bf407a3a48af13611
b61c2640c94aaf9a APPALACHIAN STATE UNIVERSITY 55-R-0124 2024-07-24   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EfQ98&d=%2Fa%2F3d000003DxKQ%2F7vfSU66v1F77U9POjB1B_giXNjpVFpDqFL4qm1o8XU8&asPdf=false pdfs/55-R-0124_2024-07-24_b61c2640c94aaf9a.pdf match d51b85e8a1d3ebb30724781f86de72c3bcc8d2d1b6101745b208c7681e31f501
e8c65d30595883f4 APPALACHIAN STATE UNIVERSITY 55-R-0124 2023-05-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008cdj2&d=%2Fa%2F3d000001GnCu%2FHGt8cLx59LOTPIo9ujic49_d.Ry09zIdMXfOtV3q6_c&asPdf=false pdfs/55-R-0124_2023-05-31_e8c65d30595883f4.pdf match cbe016a5ece5462b2fa83ffc71b83897767c95fb4b4db7ae3ec3916e48ec7a2a
3514ec56255b17a6 APPALACHIAN STATE UNIVERSITY 55-R-0124 2022-05-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yx3Lv&d=%2Fa%2F3d000000pgLl%2FgCadozwkH8giRnsLmngD.gDfs_p7WYwvveOBVU4lQGA&asPdf=false pdfs/55-R-0124_2022-05-25_3514ec56255b17a6.pdf match 762acd25d2a8ff8614272dcc7863a203ca91467fea63532b7142060160715e47
f20a350980bea66f APPALACHIAN STATE UNIVERSITY 55-R-0124 2021-07-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMbGb&d=%2Fa%2F3d000000pgIt%2FGgYPciADg0kHKyIjsumhigMV6QLZjxCEnGEQ4Qg1wMw&asPdf=false pdfs/55-R-0124_2021-07-12_f20a350980bea66f.pdf match d4bcedb1734af8e280828d5ef432cdd10ffa09a4a29c60c938f5ba2865d08cbd
309c5df2d558b7b0 APPALACHIAN STATE UNIVERSITY 55-R-0124 2020-09-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eq5Fk&d=%2Fa%2F3d000000pgJI%2FYd9Ftzs6i50kY0gYpL4HY2CpKUFU9QMOnVo_EPymcxI&asPdf=false pdfs/55-R-0124_2020-09-22_309c5df2d558b7b0.pdf match 7aa191b5747a8e68e74cbfd09be1ef92a5c71524ffb3158f95e313875597ac4e
94b011b648657266 APPALACHIAN STATE UNIVERSITY 55-R-0124 2019-07-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglv3&d=%2Fa%2F3d000000pgJQ%2FcaSpOcPLr9vOBE6pzJ2eoQvByo4D_veXWfFUYZHrpQY&asPdf=false pdfs/55-R-0124_2019-07-11_94b011b648657266.pdf match 594be5077dc8dbc076edaf06986878723f86fba595dacaa2861060866d9a2b17
64d430d581adae73 APPALACHIAN STATE UNIVERSITY 55-R-0124 2018-07-20   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmA0&d=%2Fa%2F3d000000pgJr%2Fw0QtGgK0LDjEPUvLNTgKh4xyPLuWok7vnCGb07cWQys&asPdf=false pdfs/55-R-0124_2018-07-20_64d430d581adae73.pdf match d8d00234f9eeb442230b1f9276953eb84bdfc4d95fe4d5bd5e7b78d9d95cc045
04bcbdf0fb9ebe6a APPALACHIAN STATE UNIVERSITY 55-R-0124 2017-06-14   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglh4&d=%2Fa%2F3d000000pgIS%2FUZjyHYdPHtDzIyUBl2pJdJt7Pp66AZnWvQBnhPLsk1Y&asPdf=false pdfs/55-R-0124_2017-06-14_04bcbdf0fb9ebe6a.pdf match 12e5b27303adcb86b64552cc52417699a0ad5ea1d9931daff7d17554eb4ec0d3
9a95235ff8a9a3c1 APPALACHIAN STATE UNIVERSITY 55-R-0124 2016-04-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmMf&d=%2Fa%2F3d000000pgJv%2FQC.7oFl_dOiaEjd4ZG.JXrrqD2YquMQG6tC8GzCTUG8&asPdf=false pdfs/55-R-0124_2016-04-27_9a95235ff8a9a3c1.pdf match bdc3879d64602258d8eb9388dc09381178b8ae039445866201816877534a53fe
1948505fd2025204 APPALACHIAN STATE UNIVERSITY 55-R-0124 2015-08-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmKg&d=%2Fa%2F3d000000pgJg%2FvZtD3ougUoeIi9UyfkJJCoqI8uzixJ5H34ueoCmd220&asPdf=false pdfs/55-R-0124_2015-08-04_1948505fd2025204.pdf match a9ab8a2b25af64f9f065b3ae6d726bff6b9dca878b001bc6376dc0ba2fcb8a1d
f2817f4a27da4676 APPALACHIAN STATE UNIVERSITY 55-R-0124 2014-06-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmNQ&d=%2Fa%2F3d000000pgJT%2FPm0Rzgn1Wfpo_.37pyTwvvPCl1_15akLDLSPPghkiUE&asPdf=false pdfs/55-R-0124_2014-06-03_f2817f4a27da4676.pdf match db427cd0591e00cdff365b4a1ccbc6cc9f5dfaf3412e7e72750fd70f3575f45e

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