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

9 rows where cert_number = "16-R-0058" 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
03a076643be2 Connecticut State Community College 16-R-0058 2026-02-10   0 3 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000012DGbj&d=%2Fa%2FSJ000008Q83l%2FXLFbBJIXaIQY.3kUJz4linH6qk3kueoIADXJjewvHcg&asPdf=false pdfs/16-R-0058_2026-02-10_03a076643be2.pdf match 1c9598f80e9eec3d995674f24bacfa8b4c4c1f9227e0930e64f9a4fdbc8cac85
1096f8d633ad Connecticut State Community College 16-R-0058 2026-02-03   0 2 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000011Jzjc&d=%2Fa%2FSJ000008Hmej%2FfIZatuQIkBXexFqNZU4sEjUhaQig6KaIbkfE4bRW_z0&asPdf=false pdfs/16-R-0058_2026-02-03_1096f8d633ad.pdf match ebba06c6b6d493ece7c34fe0feaefb97deede5f7f7d073a16ff9df7b0cf65f76
3c1486122ff43301 Connecticut State Community College 16-R-0058 2025-11-19   0 1 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000uDiO4&d=%2Fa%2FSJ000007EJ3Z%2FaA9tJ1aZJHjDpS74Y_bUIaWGUhgQ14BCwuIBP9XsJc4&asPdf=false pdfs/16-R-0058_2025-11-19_3c1486122ff43301.pdf match 52872056b18f7b94d83e46002124eb2c64b9bdf804f56040ea31897f72e9007a
a486dc5f1229bf4d Connecticut State Community College 16-R-0058 2024-11-21   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000FFgfy&d=%2Fa%2FSJ000001DLu5%2F.wySofni0IHGZx7p2kXU7hCS8LV_Oo4xLyb_ZF7PI84&asPdf=false pdfs/16-R-0058_2024-11-21_a486dc5f1229bf4d.pdf match 980ff2e873e02c85556fb348339b8bf752e1ef8e4d17442c61c3d9b291102585
365c7cbb5112a327 Connecticut State Community College 16-R-0058 2024-11-06   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000DRkiS&d=%2Fa%2FSJ0000011241%2F3SxLOGVh.P2H3uYQ2SYZPDQQ81C1xX9EI3N0UvgBzR4&asPdf=false pdfs/16-R-0058_2024-11-06_365c7cbb5112a327.pdf match 735a86e5986cc57e8f2f9e11ee320b683927101ef4c81252b4cef940a00331a9
5ba700ed7df1dd9f Connecticut State Community College 16-R-0058 2024-10-10   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ000009GsDs&d=%2Fa%2FSJ000000exB3%2Fr_KcVRJpQv16M3uteTePSQ7BTX7rDjPTzi0soWXz6_c&asPdf=false pdfs/16-R-0058_2024-10-10_5ba700ed7df1dd9f.pdf match 7efdf1027c553069110d642f0347dfc530b05db9392f406e4184bd55d3cb9b1d
2664da45e12193df Connecticut State Community College 16-R-0058 2023-12-05   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000BEyLF&d=%2Fa%2F3d000002D3ax%2FiGAFHGY6_uCcq_hrjeLInfRBEKLoeZ9_MUPlYTMisf8&asPdf=false pdfs/16-R-0058_2023-12-05_2664da45e12193df.pdf match b8c3a0de2bc8c2a295eba1ba88191464f8e7a8f623ad303d36f39f1b230eef23
8dcd107aca56c65b Connecticut State Community College 16-R-0058 2023-10-31   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000AhG1M&d=%2Fa%2F3d0000025o7s%2FFA5SBnfB41y6fBiOta7ZCisNrYoQdcct9o_jjInd.cU&asPdf=false pdfs/16-R-0058_2023-10-31_8dcd107aca56c65b.pdf match 838670b519e5553ae7deeceab17f8b2f4b77e29b0244b8230ec27d249513bfb9
6d2e227f23e92849 Connecticut State Community College 16-R-0058 2023-10-23   0 0 0 0 https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000AWZa4&d=%2Fa%2F3d0000023aSy%2Fs1SimFjuwE8yuNT7.0xJHwoIImbvfIERAZgQ.FEgSvc&asPdf=false pdfs/16-R-0058_2023-10-23_6d2e227f23e92849.pdf match 853c85801952af1495a3a7718122a94817837b3728a9dcebb7f1adbdfca06df9

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