inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "91-A-0147" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| b6d40c046d2ad79c | Richard and Nancy Noble Foundation 91-A-0147 | 2025-03-25 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000S5qsO&d=%2Fa%2FSJ000002qptJ%2F33eR3ZO9KWjUeQWzNQQWm331d41dLW06B2f09EDlZBA&asPdf=false | pdfs/91-A-0147_2025-03-25_b6d40c046d2ad79c.pdf | match | 5cbd05c9d3528aea9d6161bfc075cb19155288cf45654f8482ede873a9c15017 | |
| cf314789889c0fe8 | Richard and Nancy Noble Foundation 91-A-0147 | 2024-12-11 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000JfrdX&d=%2Fa%2FSJ000001iZnt%2FvEjhFzlJ7FpLd6XyiDhPMJTdx7Meu42DbzK_EC22nP8&asPdf=false | pdfs/91-A-0147_2024-12-11_cf314789889c0fe8.pdf | match | cbb78c5c4dffe5d3226c1b8ee3d7768fba7fe00e770588b9ec63e4fcb02b9f63 |
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);