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

16 rows where cert_number = "93-R-0568" 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
be8b40abc322 Auris Health Inc 93-R-0568 2026-02-11   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000012F0xJ&d=%2Fa%2FSJ000008QR4n%2FqY08HjEtNG5YFc7jGHTBwNr7sW69dASCmKpO1KI6KFs&asPdf=false pdfs/93-R-0568_2026-02-11_be8b40abc322.pdf match 847058447c6e5674931a8a080d475359b929f42b132df3ad6512a6f4a812ef4f
589ebee0cf08cd81 Auris Health Inc 93-R-0568 2025-03-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000PhndR&d=%2Fa%2FSJ000002VJq1%2FTf1JzTXk3PF4k1QA3Kru3iQapcNqX4kE8nTpcaUFzw8&asPdf=false pdfs/93-R-0568_2025-03-04_589ebee0cf08cd81.pdf match 999b313806bcfb013d5ceed7f94cc836cfcf7a7c5e6799befbfbba80eb14f101
4696e5382b936ee7 Auris Health Inc 93-R-0568 2024-03-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000Ca8PT&d=%2Fa%2F3d000002bkMh%2FbtmtBosc4VN2F7_L9Zs3cbq9YAhnGPAUS86uLvTuTXI&asPdf=false pdfs/93-R-0568_2024-03-07_4696e5382b936ee7.pdf match 27b1b2da7f21984be5745d14b99e5fb55e9c5a8a86a1ce27e38c4ad13ad9f43a
d97a221b7b57ac61 Auris Health Inc 93-R-0568 2024-02-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000COR2r&d=%2Fa%2F3d000002Y3lV%2F3JlOIsngAtdXLw8KGrlNujMJYumjbKejGyGUcHvZljQ&asPdf=false pdfs/93-R-0568_2024-02-21_d97a221b7b57ac61.pdf match 935b4061f877fd5e687d923ca5ae371a20d26cd44ed593e61f7a191c64cf48a3
cb7292a15a42 Auris Health Inc 93-R-0568 2023-02-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uLit&d=%2Fa%2F3d0000012oI8%2Fv41eC1Y4NnJ1R0cp6VmAiD3d8LzhmsBAcwSB15g1tn8&asPdf=false pdfs/93-R-0568_2023-02-21_cb7292a15a42.pdf match 830b29c04246be27a50b66797cf2649f3a89aaac6ae6aacb5ada7a2f3f2c0e4d
f7a525218a8a2daa Auris Health Inc 93-R-0568 2023-02-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uMsP&d=%2Fa%2F3d0000012pGZ%2FK7ljpjs7oGlWxeg4BooXKFwqrZo.x17r.VILZdBUy2s&asPdf=false pdfs/93-R-0568_2023-02-21_f7a525218a8a2daa.pdf match c7d74f7dfa9b48b9ff2a02a964208a94c8ee9ebbd3aacba341bb7fe4a0ee37a3
de013a5a62c16f16 Auris Health Inc 93-R-0568 2022-04-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ywkfo&d=%2Fa%2F3d000000piSu%2F5aylJ9oUiWV3ssFHVQLmiGcfjmnvKY2HEU9HSJnlzc4&asPdf=false pdfs/93-R-0568_2022-04-27_de013a5a62c16f16.pdf match 3035c0929028f6fd6bb36401b9f0b31c5715d3492b84faa67944afebd3415331
69ace6606851c3f5 Auris Health Inc 93-R-0568 2022-04-19   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ywfyq&d=%2Fa%2F3d000000piSk%2FO.F05lSoYFZNjC92CNv0hEYeJugdWPQ7DnvdHwkbLak&asPdf=false pdfs/93-R-0568_2022-04-19_69ace6606851c3f5.pdf match 626f38f5cca316a72fa5116f31eb7a8c457219e180a0a4fba710610dbe469b75
b5ce6ec39a8e2224 Auris Health Inc 93-R-0568 2021-08-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PN4xP&d=%2Fa%2F3d000000pRtz%2Frn9BN5xLjw8AZoTjQdlpuBIzBT5KdHMfnezoXC8xAeM&asPdf=false pdfs/93-R-0568_2021-08-31_b5ce6ec39a8e2224.pdf match b2d5d7714b77dacb63ff362c600dfcb0f44ad03b91596d88eda179403b25befa
e21de88b908a009b Auris Health Inc 93-R-0568 2021-07-22   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMgmy&d=%2Fa%2F3d000000pRsj%2FWzgAAHL5LsptOTQsnrIg6JiPL6wwKint43AKIAv_xdw&asPdf=false pdfs/93-R-0568_2021-07-22_e21de88b908a009b.pdf match a08ead1550a4fe3e7c6c68072cd21889a50cb2270a84392a4b95eab73d55d41b
2122b339d4eabc45 Auris Health Inc 93-R-0568 2020-09-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EqcyB&d=%2Fa%2F3d000000pjI3%2FvMlhuyp03D1aksn6UcCejoI325vTwd_GzAXss1n0eB4&asPdf=false pdfs/93-R-0568_2020-09-29_2122b339d4eabc45.pdf match de602da2931963a9c010a8808915c468778ff09705d83fd5b290b7f368b530e5
3e86926d56cef25b Auris Health Inc 93-R-0568 2019-05-28   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglan&d=%2Fa%2F3d000000pk7U%2FQnDndVIWy51U1VTtsfWlqrKHb5V1AqET4XxvPUjtF.E&asPdf=false pdfs/93-R-0568_2019-05-28_3e86926d56cef25b.pdf match 33616ae8a8f4b1288509f156c88b8f8a36228cfc70f0832420174ff5adf355e3
00ae4c26b16d6718 Auris Health Inc 93-R-0568 2018-09-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmhJ&d=%2Fa%2F3d000000pRys%2FJs6cFvgplUSQ5Xm1RKl4i3iV3DKOET.zjOMDXbvWvh0&asPdf=false pdfs/93-R-0568_2018-09-21_00ae4c26b16d6718.pdf match 4d0b19b10c4326b6cb40ac1dedd5748474fe088ff44ea43d36201fb17b830f21
2889bd99d1a142d2 Auris Health Inc 93-R-0568 2017-11-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egmve&d=%2Fa%2F3d000000perQ%2F8MLDk2sE1lAw2J3Dik4zpKwmAltlleS3SkshEBBf5KA&asPdf=false pdfs/93-R-0568_2017-11-01_2889bd99d1a142d2.pdf match 6feb2491ea7dc98cdbacb989af45068ef72db3adae1f9708e1b62e6b95494c02
033cc5dfede730b6 Auris Health Inc 93-R-0568 2016-10-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egn3R&d=%2Fa%2F3d000000plZW%2F4LlMIhxGRsRlvaqlQ.mhE03Ks5r7Arol7.9QtmWLjm8&asPdf=false pdfs/93-R-0568_2016-10-21_033cc5dfede730b6.pdf match 494554203438829c95f1adb3e07cbb7604305d69c85f7ae0f902618ae5858527
9da9d8a603a2ace0 Auris Health Inc 93-R-0568 2016-09-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egmdp&d=%2Fa%2F3d000000pdor%2F72J5mkttOZO_88mKLJZgr_rVlyubZOrI_8RQA7jwwYA&asPdf=false pdfs/93-R-0568_2016-09-27_9da9d8a603a2ace0.pdf match dea91a8d43174897f7f3f63812933c229b3e504a0f4cc173f64919a48930253c

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