Data catalog / curated / fact_inspection
curated.fact_inspection
fact inspection. 16,464 rows.
LayerCurated
Source systemEnerGov
Data ownerDevelopment Services Director
Data stewardMichael Okafor
ClassificationInternal
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01
Lineage
Columns
| Column | Type | Classification |
|---|---|---|
inspection_id | text | |
permit_no | text | |
inspection_type | text | |
requested_at | timestamp without time zone | |
completed_at | timestamp without time zone | |
result | text | |
business_days_to_complete | integer |
Quality rules
Rules run on the cleansed source tables upstream.
Sample rows
| inspection_id | permit_no | inspection_type | requested_at | completed_at | result | business_days_to_complete |
|---|---|---|---|---|---|---|
| INS-700001 | BLD-26-06324 | Plumbing rough | 2026-09-27 10:00:00 | 2026-09-29 15:00:00 | Pass | 1 |
| INS-700002 | TRD-26-02909 | Final | 2026-03-18 15:00:00 | 2026-03-19 11:00:00 | Pass | 1 |
| INS-700003 | TRD-26-02142 | Electrical rough | 2026-02-28 13:00:00 | 2026-03-06 13:00:00 | Pass | 4 |
| INS-700004 | TRD-26-05741 | Electrical rough | 2026-08-19 15:00:00 | 2026-08-20 09:00:00 | Pass | 1 |
| INS-700005 | ACC-26-02027 | Framing | 2026-02-10 12:00:00 | 2026-02-11 12:00:00 | Fail | 1 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.