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 = "31-R-0017" 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
6a121f2f1de4 Cleveland Clinic Foundation 31-R-0017 2026-06-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00001F0Qkn&d=%2Fa%2FSJ00000Alpao%2F89e5xYRcfuA5jW2x035iR4YBm3gA2QrE4iJI6QFwz8Q&asPdf=false pdfs/31-R-0017_2026-06-02_6a121f2f1de4.pdf match 568d7baf6e4b53a2d3f73842623e3d9ba84aab10571fcaca964417bbbe0e0ce0
37900f678e54222e Cleveland Clinic Foundation 31-R-0017 2025-06-12   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000bXPHC&d=%2Fa%2FSJ000004QPA9%2FjVhJ5fiR_viORhBcRybjTX9EplqceElX_KcA622po6o&asPdf=false pdfs/31-R-0017_2025-06-12_37900f678e54222e.pdf match f61ea7ae5244089d5555e81464dfed4b386e4b945ca5d4883e5b71b6bb4545ba
3790b5ceec9a4076 Cleveland Clinic Foundation 31-R-0017 2024-05-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000DfZuZ&d=%2Fa%2F3d000002xcCw%2FLneznC_rRCO0N41stMdk.pU22_mV6J6hvmIJLXz4Z0s&asPdf=false pdfs/31-R-0017_2024-05-16_3790b5ceec9a4076.pdf match a356f3f544175b305a79348e27b01ec730b129505e44d6e688e1e4692c33ec76
94e716f731cddab5 Cleveland Clinic Foundation 31-R-0017 2023-06-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000008uRmS&d=%2Fa%2F3d000001MigA%2FpxylPYtZ71snLZauwuneufZbag0ijCvZaDHgQcJ2a2o&asPdf=false pdfs/31-R-0017_2023-06-23_94e716f731cddab5.pdf match 0e985113c971e04ae18354af42bc6a6086fe39ef037d27f68b9ca20dbd8771d0
b8d36a7071fa0d9d Cleveland Clinic Foundation 31-R-0017 2022-01-13   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000V93JP&d=%2Fa%2F3d000000pgvt%2FyM_eXKW7S_.ZkxFyr9YbWuU0gwkJgTwhuLt4NLDBX.U&asPdf=false pdfs/31-R-0017_2022-01-13_b8d36a7071fa0d9d.pdf match ac4b0cb892a50b626664a1d6f8eea832456af7dfd49b706bbb85c1bd54c2dcf8
e19068f21004cceb Cleveland Clinic Foundation 31-R-0017 2020-12-08   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000ERWPc&d=%2Fa%2F3d000000pRke%2F8Dxy2A3emfLlopxDiTa0LoFLzNrIXrSNKw5VHWJoBmU&asPdf=false pdfs/31-R-0017_2020-12-08_e19068f21004cceb.pdf match 9ca287e6753f190e5bea877b40ba6e08c7357c38bfb6cceae30b2590f793860d
aef055eee215c37c Cleveland Clinic Foundation 31-R-0017 2019-10-29   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egnuc&d=%2Fa%2F3d000000pmk5%2FeRwcajreDp3HKOJBe0FBtLmqnhOyaEYUxJF1KNWE6kI&asPdf=false pdfs/31-R-0017_2019-10-29_aef055eee215c37c.pdf match 81d12a212c544343bc953c8d273301858028bbb059170eedfa1516a7b826d9a9
0014dad52ac30155 Cleveland Clinic Foundation 31-R-0017 2018-11-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgaBH&d=%2Fa%2F3d000000pn5d%2FbGu4mDcTSTBqudNPqyHCBySoj33RS2O6r3jcJKv9bZk&asPdf=false pdfs/31-R-0017_2018-11-14_0014dad52ac30155.pdf match 1bd32c339498dc130f53e01733c8899d4e07d8dfb9fd9c2e80986b894f679496
cfe439b5859bd2b4 Cleveland Clinic Foundation 31-R-0017 2018-03-07   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ega61&d=%2Fa%2F3d000000pWQ4%2F1iHSUyQSj7iI.xcl1t1kzGFCJUmSp3sSSZmz2rqEOdA&asPdf=false pdfs/31-R-0017_2018-03-07_cfe439b5859bd2b4.pdf match a412e8e5ab60011eb96004234984380a5937ce5959e721d261c7d63c41abca21
1f6f6282122738a7 Cleveland Clinic Foundation 31-R-0017 2017-01-25   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYno&d=%2Fa%2F3d000000pmpk%2FPlGVYWLUq8tJQ7.c.8vKvMZHbrpMf9dUuA1qtQeeNQU&asPdf=false pdfs/31-R-0017_2017-01-25_1f6f6282122738a7.pdf match 8459f1a2b5b628dfc56adc5c5e548efe3a4454e154359d29086ef58a3e5d65dd
60f8c399d162a05a Cleveland Clinic Foundation 31-R-0017 2016-04-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgYbV&d=%2Fa%2F3d000000plka%2FQRkmWQ8CK0XbvEUQC9U.FrVDvZohkKHjs8a.qG8ctxk&asPdf=false pdfs/31-R-0017_2016-04-18_60f8c399d162a05a.pdf match 8d662ac6691a75ca82a9b502da5d0b4d83f22b9096e6791f23a8edb725345444
f46d366e02a138bc Cleveland Clinic Foundation 31-R-0017 2015-03-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZkc&d=%2Fa%2F3d000000pWsK%2FyQ02U5XFP1MI5O.gT7PURsrn.dhiPAjTKUEt.m9GjXc&asPdf=false pdfs/31-R-0017_2015-03-30_f46d366e02a138bc.pdf match 631ffe9e520787057fd722fdecb3cdf9eb69bbe5df23e5a666cc7e89f19c6f1a
11307539ee97d84a Cleveland Clinic Foundation 31-R-0017 2014-06-02   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgZnF&d=%2Fa%2F3d000000pSrE%2FFaytHlWKOF_2YXoLtF4UhxDtbzAx8sfzpp7OTvDoMRE&asPdf=false pdfs/31-R-0017_2014-06-02_11307539ee97d84a.pdf match cf5fb40493f4e93e92874139ef0456cbcc94bae2f64d4993dc408038b043cc51

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