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

7 rows where cert_number = "41-R-0093" 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
539910809f99 Element Research Group 41-R-0093 2026-02-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ0000142GM4&d=%2Fa%2FSJ000008hVC1%2F7TI02usBxapzRxYoKN0RNSUlU737ID8zQgyFGGXvwzA&asPdf=false pdfs/41-R-0093_2026-02-26_539910809f99.pdf match d031deb286a15d0fa8ea44a0edc4f7183b981d4911ef9de5a1fa7cbdafea261b
71bb268deebbcc45 Element Research Group 41-R-0093 2025-07-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000eIO3Q&d=%2Fa%2FSJ000004oqFd%2FynoPfrMN77U7rc7VULbNKL_Ah_fMP.HkiGz90JL.gqI&asPdf=false pdfs/41-R-0093_2025-07-09_71bb268deebbcc45.pdf match 1010e73fbbd2a0789274ccc8445e30063fd20fa0c3ce5757975276fc817bc9d7
50211588ea3ec398 Element Research Group 41-R-0093 2025-06-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000dGzad&d=%2Fa%2FSJ000004fwIf%2FM8apwTV8oBXp6uxvOu19P_z4Mqlz6md_NOOTtU5zHvY&asPdf=false pdfs/41-R-0093_2025-06-27_50211588ea3ec398.pdf match 5d3690daed92b9c02eb318cac0e48f4e2f5a86fc915e74af872b4763846bd56d
0b81c0c5a2dd46cb Element Research Group 41-R-0093 2024-08-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000003aIkj&d=%2Fa%2FSJ000000BsYA%2FpuWnS.wzYFQGT76EMLtvXdWHwg839ymznUiGd01Hbts&asPdf=false pdfs/41-R-0093_2024-08-30_0b81c0c5a2dd46cb.pdf match 58d4fb768067496c4694a49b9ef62ffac8835c163f7a440d14b4cb6a81da2d5f
73eb1f94fa06e061 Element Research Group 41-R-0093 2024-03-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000ClggD&d=%2Fa%2F3d000002fTFR%2FQCwW7uPzs6bEMCFLMyN.emW1W3Y.LjpSjFUAcwjmSZI&asPdf=false pdfs/41-R-0093_2024-03-19_73eb1f94fa06e061.pdf match 34c4e4da649c14886acfba60d0c2fa9b58a749bf823494effb1848116a532ff7
d08425b23222596d Element Research Group 41-R-0093 2023-06-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008mclc&d=%2Fa%2F3d000001KDMj%2FG.o329WhAVcVDU0YEKqJaodiDuCGZ6GsrxGsGpLR1i0&asPdf=false pdfs/41-R-0093_2023-06-13_d08425b23222596d.pdf match 0b232888712a5bf3e854769229a6b76d4b361ebed4a6f21f5ae8fdb00e40e6a3
dc7f788587f238b2 Element Research Group 41-R-0093 2022-06-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxIsZ&d=%2Fa%2F3d000000phZd%2FcxqWGCHeO0k01f5BZbSSXkTQMi0qhhU6GFG8IGgu5xE&asPdf=false pdfs/41-R-0093_2022-06-17_dc7f788587f238b2.pdf match 6ca6118e25d79d7b9d601efea4aaf67e1e89d2790337135e7fe67279b272cec0

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