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

11 rows where cert_number = "31-R-0132" 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
1de673bb3a6d Royal Canin USA Inc 31-R-0132 2026-04-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001AyXkb&d=%2Fa%2FSJ00000A02aL%2FwP0EKgXmFfXGDcie_kS0kxbTuUKLD5UrCYgyxZjG30w&asPdf=false pdfs/31-R-0132_2026-04-27_1de673bb3a6d.pdf match 6d84219030b8779a65d687c22a99897ae014a735061c605d959c88978c3d3aee
65373520eaf5e598 Royal Canin USA Inc 31-R-0132 2025-04-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000UT7rM&d=%2Fa%2FSJ000003EGKw%2FrkPt4529jgycZPbVZHZzVYMfPG7T5Q1BLvU2L26X_O8&asPdf=false pdfs/31-R-0132_2025-04-15_65373520eaf5e598.pdf match 0efe9aae492119a7a171eef3d2c80da80163f6e4511ccdb9b85699b0ad0c60a6
afddc4f020597a57 Royal Canin USA Inc 31-R-0132 2024-05-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000DV6lY&d=%2Fa%2F3d000002v4PM%2FlDxrjGE2KghsPZVr2UYuB1j2JBglMJZ2Mw2_a6ZnOHk&asPdf=false pdfs/31-R-0132_2024-05-07_afddc4f020597a57.pdf match 57f232dbf10729d94d5151fa3e82cafe63eb2cb4ac4f056213c7e1f58a11ccbe
cde953b12b0f1aff Royal Canin USA Inc 31-R-0132 2023-07-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009K50Z&d=%2Fa%2F3d000001W1gZ%2F9z61wBHMSCVz9jhysKuXQGrSCQ.iXuhx7y73RempqXw&asPdf=false pdfs/31-R-0132_2023-07-25_cde953b12b0f1aff.pdf match cf8fa0384ad99c9e730e42ca1f9723e64df2e8e3b72ae75d5b5b778136fbf8a2
b9a672cb136b8cb1 Royal Canin USA Inc 31-R-0132 2022-08-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yxvjo&d=%2Fa%2F3d000000pU1h%2Fa2fGEUkgKG9Os.XicZfzcaajwEV9J9bsrUnOljYjA_I&asPdf=false pdfs/31-R-0132_2022-08-09_b9a672cb136b8cb1.pdf match 0d449fc71d6009fb4862a862f3f2960c21f70662ad4a2864db09459f35e6657b
e84bc234cdaed442 Royal Canin USA Inc 31-R-0132 2021-07-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMQJG&d=%2Fa%2F3d000000pU2g%2FQXp45ktd_P0SYoUHurKT83m8mHFsm3lHWjB3Uek.6Sg&asPdf=false pdfs/31-R-0132_2021-07-01_e84bc234cdaed442.pdf match 31a75761286aa1c59262776a187e616ffdf17dbc010b51c4b703151d6a60c1bc
2e3f30ad3009a18b Royal Canin USA Inc 31-R-0132 2020-09-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egy1c&d=%2Fa%2F3d000000pU1w%2FmQp7_WONqhd59npc67AHI0HoNZ_0yeeXAAeASPj6Rqw&asPdf=false pdfs/31-R-0132_2020-09-15_2e3f30ad3009a18b.pdf match 6959074c553eedcce2e891843f8962d3f4d4e8243317588d434a0fe9c98efc34
193920630d4e8188 Royal Canin USA Inc 31-R-0132 2018-12-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egeea&d=%2Fa%2F3d000000pU1K%2FQ4tvNOws2XXOAlYOKjIjinPc9NfsTmadB7LkAG1qK9U&asPdf=false pdfs/31-R-0132_2018-12-19_193920630d4e8188.pdf match 44ddeff5bc5c94e8aa3368e623a71ad5c202c557e0959a10d9fb76c6b49de134
fa4721e4e1048fc3 Royal Canin USA Inc 31-R-0132 2018-03-15   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgeS6&d=%2Fa%2F3d000000pU2A%2FEAbJp8RCHT6.12HeoxTFPkRk7ipc6YYUuJ9BsybxBjY&asPdf=false pdfs/31-R-0132_2018-03-15_fa4721e4e1048fc3.pdf match 8fc9c417ea3c72256373b1c2c8962fbe6b4bfbaf8b3a8ea6b333d17e92d2ce1f
676a4abb63671d96 Royal Canin USA Inc 31-R-0132 2017-07-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egc0v&d=%2Fa%2F3d000000pU1a%2FPsDe_RnC0lWab7.xG6ntIjTsJ9Cz40jJ_ilqfzW8HDE&asPdf=false pdfs/31-R-0132_2017-07-19_676a4abb63671d96.pdf match 4f626a0449865e335de0cc64957649d207411abd1a0845c33a0e8f546147f1cc
4bfa2150ba8e207f Royal Canin USA Inc 31-R-0132 2016-08-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgdFD&d=%2Fa%2F3d000000pU28%2FPawP3HzYC_l6wLM2iGbHwf9JQ9HNXVyP8DDONLjbDmQ&asPdf=false pdfs/31-R-0132_2016-08-22_4bfa2150ba8e207f.pdf match ea4ac92d303f9093fd119f288131b0d2c3ce01fe6d7eeff11889d9e51c99c15a

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