Data catalog / curated / fact_cad_incident
curated.fact_cad_incident
fact cad incident. 38,589 rows.
LayerCurated
Source systemCAD (SQL Server)
Data ownerPolice Chief
Data stewardJasmine Patel
ClassificationRestricted (public safety)
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01
Lineage
Columns
| Column | Type | Classification |
|---|---|---|
incident_no | text | |
agency | text | |
priority | bigint | |
call_type | text | |
beat | text | Internal |
received_at | timestamp without time zone | |
dispatched_at | timestamp without time zone | |
on_scene_at | timestamp without time zone | |
response_minutes | double precision |
Quality rules
Rules run on the cleansed source tables upstream.
Sample rows
| incident_no | agency | priority | call_type | beat | received_at | dispatched_at | on_scene_at | response_minutes |
|---|---|---|---|---|---|---|---|---|
| FD251001-0000 | SLFD | 2 | EMS medical | ST1 | 2025-10-01 00:00:00 | 2025-10-01 00:01:09 | 2025-10-01 00:04:27.600000 | 4.46 |
| FD251001-0002 | SLFD | 2 | EMS medical | ST3 | 2025-10-01 00:26:00 | 2025-10-01 00:26:36 | 2025-10-01 00:33:10.199999 | 7.17 |
| FD251001-0006 | SLFD | 1 | Fire alarm | ST1 | 2025-10-01 00:54:00 | 2025-10-01 00:55:00 | 2025-10-01 00:59:26.400000 | 5.44 |
| FD251001-0010 | SLFD | 3 | Structure fire | ST1 | 2025-10-01 01:03:00 | 2025-10-01 01:04:25.200000 | 2025-10-01 01:12:44.400000 | 9.74 |
| FD251001-0015 | SLFD | 2 | Gas leak | ST1 | 2025-10-01 03:34:00 | 2025-10-01 03:34:46.200000 | 2025-10-01 03:41:33 | 7.55 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.