inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "23-A-0805" sorted by inspection_date descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 85b03eabf49a8ff7 | David B Kauffman 23-A-0805 | 2025-03-14 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000RPVHU&d=%2Fa%2FSJ000002kagr%2F8H9FLTEBA_Ri2HIUrDX8yIa6ZXOUNbueJasDIkSdTj0&asPdf=false | pdfs/23-A-0805_2025-03-14_85b03eabf49a8ff7.pdf | match | 8ceeced729380b022df25efa1ea9b35f7096253a5255bd067e9d289efdbf8411 | |
| a4875644a86572fb | David B Kauffman 23-A-0805 | 2024-12-09 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000HHBGk&d=%2Fa%2FSJ000001OrCH%2Ffc9cJ.ySHQFie1euVewvrdmLv8Pl8l5ZJaUgPerHvN4&asPdf=false | pdfs/23-A-0805_2024-12-09_a4875644a86572fb.pdf | no_cert_ok | 40cfe202647bbeb5595dd02ab9dfa6936b1f8a16b0c748c2f1b6c3ef63cb80f1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);