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

12 rows where cert_number = "55-R-0019" 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
00bb5200b5b16da2 Central Carolina Community College 55-R-0019 2025-09-09   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000kpKH7&d=%2Fa%2FSJ000005lmXl%2FGT8tGUBjqs6S7lyCx6XADKRSUsFPILxjy0b9dmcmw2s&asPdf=false pdfs/55-R-0019_2025-09-09_00bb5200b5b16da2.pdf match 7cf9a9abbe6ff235ce1fbe10698a919fc790c3ffe0d237c125af492b1d921517
b245d3d2f68d235a Central Carolina Community College 55-R-0019 2024-01-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BqDqm&d=%2Fa%2F3d000002OsFW%2FXogk0EkNs4jz80uMeTaRfC0gC9FZ3CMx3IfZHLoYOW8&asPdf=false pdfs/55-R-0019_2024-01-23_b245d3d2f68d235a.pdf match 43fdbf57bd08f4e1e5e0691eeac003b91ece2aef7b978776659dddf94951dd65
7718f77bfadbe908 Central Carolina Community College 55-R-0019 2023-03-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000007uZFN&d=%2Fa%2F3d0000012vkD%2FWEeAXGTPCHG9POz_UeEMQ3BWD1vMmzRL1dz5LoKbxf4&asPdf=false pdfs/55-R-0019_2023-03-10_7718f77bfadbe908.pdf match f2ef0085aaea656e02f60f5f86eb2934a65039977f8ad86e84f742b2b28efafe
4cd298d29d9383db Central Carolina Community College 55-R-0019 2022-07-14   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Yxd2Y&d=%2Fa%2F3d000000pj0F%2FiRa6vkEIcNWXfrGRwCswEFqztYMiu.BLTO6ujapMHt4&asPdf=false pdfs/55-R-0019_2022-07-14_4cd298d29d9383db.pdf match 669da3881feb78151c46d56844b0d2019c0275cb041b2f99ba5ed201af4f70a6
9e0e5a903866a812 Central Carolina Community College 55-R-0019 2021-08-17   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000PMv9I&d=%2Fa%2F3d000000pizB%2Fd0W69AtXpV5FSO8fJ8cp6C3H17vD0oktW2LH0Kb7JFc&asPdf=false pdfs/55-R-0019_2021-08-17_9e0e5a903866a812.pdf match 681f7722ab45ee2578a081b6d054b125d6bff505f2ab0e6d9fad16b362664e1a
2fa901ef4e5a92fc Central Carolina Community College 55-R-0019 2020-10-15   0 0 0 1 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000FS4xw&d=%2Fa%2F3d000000pizK%2FQpVTAYhwFx00zYB8yWyPxgi.sFmTpDQ1B7g1qu2zMJw&asPdf=false pdfs/55-R-0019_2020-10-15_2fa901ef4e5a92fc.pdf match a01f2a9b106dd4fc8f9ab84ce6376d4883cdedf3c11edc6027ef98504d3744e0
2fa3342d80140961 Central Carolina Community College 55-R-0019 2019-05-30   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egd13&d=%2Fa%2F3d000000pj0d%2FR9Dtt_QvF6x6RU6Qyso2GmdbusRzWNjpSNOgd2320QU&asPdf=false pdfs/55-R-0019_2019-05-30_2fa3342d80140961.pdf match fa9f5dba18a4c86950ab62f6fa5dd85c49a953ad868ccd549db027e5168c4819
4f24a026d439176e Central Carolina Community College 55-R-0019 2018-06-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egf1r&d=%2Fa%2F3d000000pj02%2F2NZocxjp7_SbPJz55nRil250TIs_LXCtkhsZBKsSl1g&asPdf=false pdfs/55-R-0019_2018-06-27_4f24a026d439176e.pdf match eefd42390d555597ddd1634cfa78ff9aef91a73ea9f6f4dbb849beaca99e9b6c
6e473b775a5791ec Central Carolina Community College 55-R-0019 2017-04-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Ege29&d=%2Fa%2F3d000000pj0T%2FgC.F.RUC7qCKiTI0Xj1LCZ1F1B7PxNy4HHP1l0X24Yo&asPdf=false pdfs/55-R-0019_2017-04-18_6e473b775a5791ec.pdf match 3496f5ac8db286a30fce7774506b23008c6a14b20409663e40db4126441f359e
ce07855dc2064afa Central Carolina Community College 55-R-0019 2016-08-16   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000Egemo&d=%2Fa%2F3d000000pj0X%2F_CK3gZGRPhPPxlV.GA3cEAt7AXPJ5IUGy4BOd2JunY0&asPdf=false pdfs/55-R-0019_2016-08-16_ce07855dc2064afa.pdf match 41d6e63cbbbabcf604c6dd685868986814f8482fb643e606cb215272ad6ddb89
c25ee7feffacd299 Central Carolina Community College 55-R-0019 2015-03-18   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgcgV&d=%2Fa%2F3d000000pj0S%2F5rhyGcy_CzHzorFe_pHeMZ2W0IKh47f_cWf8_3mOx8Y&asPdf=false pdfs/55-R-0019_2015-03-18_c25ee7feffacd299.pdf match 1150163e6e646a1e015b6dfd3f4ed51ec44c7e57f3d97c4bfbd2d33664b8ffb5
51cf8ad426e95ddc Central Carolina Community College 55-R-0019 2014-02-27   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgcV1&d=%2Fa%2F3d000000pizC%2FTfdYIfc.T9y99IEKh3yMx9YFmRE_ViRzKwxp1kGpw8Q&asPdf=false pdfs/55-R-0019_2014-02-27_51cf8ad426e95ddc.pdf match c1f33cc28b2d3e5d2064e555a286636bf312fe7ce63f73d1e9a122903842c6b3

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