inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "58-R-0179" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3e5e899d7050e023 | Beacon College Inc 58-R-0179 | 2025-06-26 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000d30BW&d=%2Fa%2FSJ000004e1eD%2FxC_biIWytCqnrD1Mvl0.mE_g2XCTlNxWF6o2Yee3DGM&asPdf=false | pdfs/58-R-0179_2025-06-26_3e5e899d7050e023.pdf | match | a442bdebf96cc44e607a0c1e7a5452113ef7e060431bde3cd1b0224fdfb2c8fc | |
| 1f6b9155de3fccd3 | Beacon College Inc 58-R-0179 | 2025-06-02 | 0 | 1 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000a0pKU&d=%2Fa%2FSJ000004CEcn%2FAlC7kfL7btmgEr9PZzb3oPZ5DBNC.5MqstFTpZwDjwE&asPdf=false | pdfs/58-R-0179_2025-06-02_1f6b9155de3fccd3.pdf | match | 16c29b70d187a3fbc5bbf03ba83ca90c2e231976e16a6cb2e2ccacfb81c67c8e |
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);