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

19 rows where cert_number = "31-R-0092" 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
a0783e5d075a Northeast Ohio Medical University 31-R-0092 2026-04-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000018AYo7&d=%2Fa%2FSJ000009TEf7%2FGZrcfI48Gy5HBBcAvPDHbmPNZ6xaBIR1E7cFJft_lzE&asPdf=false pdfs/31-R-0092_2026-04-01_a0783e5d075a.pdf match 16c3d1beed0b4eec6a374194f13253422f5da49a2bff11df803b49d1c7b27a06
4d57ac424afd10c8 Northeast Ohio Medical University 31-R-0092 2025-06-03   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000aA9iB&d=%2Fa%2FSJ000004DmNt%2Ff_LXKt4O7eLP_nqmICWgpbGsBNr.DhAFKq2mPmRoXt8&asPdf=false pdfs/31-R-0092_2025-06-03_4d57ac424afd10c8.pdf match 9f200d6cc95b3e2c47a2cbaacfad096018bcbd0d5315ae3bb80527b60704fff0
8c97d2b8533e556e Northeast Ohio Medical University 31-R-0092 2024-07-01   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EMWc4&d=%2Fa%2F3d00000387sG%2FsGYHUp2IuxxckwhVTkpHbtcsP_a1tAt3xRXmYUaXuRw&asPdf=false pdfs/31-R-0092_2024-07-01_8c97d2b8533e556e.pdf match e8bc533cd3af8aa10275824f00078716e2174fd51f818d752e808449b4206715
cb0da4ace682621e Northeast Ohio Medical University 31-R-0092 2023-02-16   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uFqR&d=%2Fa%2F3d0000012mcr%2FgmfdB_Wm5DTaF2EeA6jwSwx2P8u1fTvj4xh3WxhUNKQ&asPdf=false pdfs/31-R-0092_2023-02-16_cb0da4ace682621e.pdf match 663c977c4f46f02a3b4fc03ad444e7fc287cc7b58dfae49b990669ad1dbb77ac
3d1254cf5ed6a68b Northeast Ohio Medical University 31-R-0092 2022-06-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000YxI5D&d=%2Fa%2F3d000000phWq%2FgdgdjDnIds6btjfCrpzy_OmcBa5jYHB.cLr8Ft5yyFI&asPdf=false pdfs/31-R-0092_2022-06-16_3d1254cf5ed6a68b.pdf match e480dc53c224a1969f159ce954f024caeadb8ef4cb610534559945c41524ee23
8e142082b971b12d Northeast Ohio Medical University 31-R-0092 2021-05-26   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000NhCP4&d=%2Fa%2F3d000000phWy%2FRZIW12MkuW0_Vl_7eAoj0R2FW8dRWFTnXGWBEVt3WC4&asPdf=false pdfs/31-R-0092_2021-05-26_8e142082b971b12d.pdf match 4ceec83787e3ffe33ce5f4ccabd78cfcdccbd7123d54166c4a2242d54afd66a8
2ea444ea9c59b35c Northeast Ohio Medical University 31-R-0092 2020-10-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ERkM2&d=%2Fa%2F3d000000phXf%2FnH1UfnmxWlrLkbsUICQmJmbgatQTFgaTrJEzcD52NqE&asPdf=false pdfs/31-R-0092_2020-10-07_2ea444ea9c59b35c.pdf match b6e6e3c958dc99f457d6d6a88227036d97737b2bd43f5989040554eb7411b61e
4fe96fe330df5875 Northeast Ohio Medical University 31-R-0092 2019-10-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Eglzx&d=%2Fa%2F3d000000phWO%2FSBqLpQ77Y.IsA3qK7wQLYEre6TJHL99cUiayMtx3q.Y&asPdf=false pdfs/31-R-0092_2019-10-09_4fe96fe330df5875.pdf match 0a84830b6a8504657f18e4bffe2617b5bddfcf233b01e39c6d94b6a842d80b1b
2bdc0b82afe38084 Northeast Ohio Medical University 31-R-0092 2018-11-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZEp&d=%2Fa%2F3d000000phXe%2Ft.ALCXDJq_86M5a0IJ_nmm8o1O07Cq4rYmVlh0hjgpc&asPdf=false pdfs/31-R-0092_2018-11-27_2bdc0b82afe38084.pdf match 94e6ad9b97657302a987f73c7d32080c107b02b95e188ff5718605c31fc37f6d
ccd044e90cd124ba Northeast Ohio Medical University 31-R-0092 2018-06-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZ5m&d=%2Fa%2F3d000000phXb%2FiQ08L36xKdDtyshCrxjCovrsgKJ64NSrt_3ZrQFiZvI&asPdf=false pdfs/31-R-0092_2018-06-25_ccd044e90cd124ba.pdf match 9a86334588262b8a4909a1c0e1ebd016a1bcab92491ccbe0d5468f0a98f95a5e
c2f35025bfe7c62f Northeast Ohio Medical University 31-R-0092 2018-01-04   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZOh&d=%2Fa%2F3d000000phWh%2Fg_e9OG81_Q0XOa94RqOC0WpyfkELjYU7b2PRn47GCz0&asPdf=false pdfs/31-R-0092_2018-01-04_c2f35025bfe7c62f.pdf match cb3ef2e3c95ab9d695252d1d24f28c65d5f0cb4d2642f97c0bff423fbfedd6f4
ed38c709168b4319 Northeast Ohio Medical University 31-R-0092 2017-03-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmSE&d=%2Fa%2F3d000000pWYJ%2FXLV2t2vtCVZpZyZ96t0AIcWB3X.c7EeO28XSqy6c1mk&asPdf=false pdfs/31-R-0092_2017-03-23_ed38c709168b4319.pdf match 4f75dc3af28dc2b616ab620a77d0fc425dd06db6f80e862248c3a8af02765226
f6f3574938506d59 Northeast Ohio Medical University 31-R-0092 2017-01-10   1 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgVda&d=%2Fa%2F3d000000phXa%2FxQVbifvXDw_3dgKkw0vePsXNL9AECN_.tcb.aExv0x4&asPdf=false pdfs/31-R-0092_2017-01-10_f6f3574938506d59.pdf match 8575be3b4d363d6fcb8b36674925e5c24f9c7566d8fe898cae3e463722dca120
ae929b28a2a3 Northeast Ohio Medical University 31-R-0092 2015-12-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZO8&d=%2Fa%2F3d000000phXn%2Fky9wQha.yOiCIfrCPh5DlsawPOkLy.eqw3NUV4CsBBE&asPdf=false pdfs/31-R-0092_2015-12-17_ae929b28a2a3.pdf match 52748fbe68d33b4dd022a6aa8464ad146c41c8c5871706614f8303cb9a265d00
3ee1524b3634996b Northeast Ohio Medical University 31-R-0092 2015-12-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EglFR&d=%2Fa%2F3d000000pe1b%2FkMI1RQiJ3WXgsNyWUXwGKM39Rf1rnsXjPY40x5VnwjI&asPdf=false pdfs/31-R-0092_2015-12-17_3ee1524b3634996b.pdf match 29c51bbb466788e8b863e75b776ab6178ec9b55de31271eccdf6ffea27293ba5
d639cb08aa64d625 Northeast Ohio Medical University 31-R-0092 2015-07-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgkcG&d=%2Fa%2F3d000000poBm%2Fc.oXgGQsidvgHE4LZtQHDxnx4ClyF7nqKQjyWwYg8_s&asPdf=false pdfs/31-R-0092_2015-07-27_d639cb08aa64d625.pdf match 10768524f192199a074203a960796e206d2584526d0aa21f66589428d8ca4a1d
a2151c18da3d6b9a Northeast Ohio Medical University 31-R-0092 2015-02-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZ9K&d=%2Fa%2F3d000000phX0%2FUT83tTfyiABNM_uG5ZBZ6C54H7XQ1enuZUhR3QnDMC4&asPdf=false pdfs/31-R-0092_2015-02-17_a2151c18da3d6b9a.pdf match 652ff86d6f77de7b8487c3a5fa96635b2b7abc27a75b514628008d81613b12f5
bfbbde768bd09a45 Northeast Ohio Medical University 31-R-0092 2014-07-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egmbn&d=%2Fa%2F3d000000pSqM%2FAkXLk.1cYzjBSx4Eo0zW_NcoE.QGv.mEtGNqmDTjWe0&asPdf=false pdfs/31-R-0092_2014-07-29_bfbbde768bd09a45.pdf match c2bae791b71180738d115496010d2994211a89ffc5fa05d971fe3b1f76d76866
b5503e556543682c Northeast Ohio Medical University 31-R-0092 2014-02-20   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgXDa&d=%2Fa%2F3d000000phXQ%2FNXj0q3A7LHLh.JY34DU873ZrgHvXohC75jqmNB0GQ_g&asPdf=false pdfs/31-R-0092_2014-02-20_b5503e556543682c.pdf match df220a6f9663c729d851afa6fb12be75db727e2ccf5f9eb72433879d27f73551

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