# Source Coverage Audit

Generated: 2026-06-10T11:55:25+00:00

## CAS Summary
- Files: {'crash': 7, 'person': 7, 'vehicle': 15}
- Unique records: {'crash': 85397, 'person': 203828, 'vehicle': 163954}
- Unique crash IDs represented by type: {'crash': 85397, 'person': 85397, 'vehicle': 85397}
- Date range: 2018-01-01 to 2026-06-07
- Latest date by severity: {'Fatal Crash': '2026-06-01', 'Minor Crash': '2026-06-04', 'Non-Injury Crash': '2026-05-23', 'Serious Crash': '2026-06-07'}
- Years: 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025, 2026
- Severities: Fatal Crash, Minor Crash, Non-Injury Crash, Serious Crash
- Missing expected years: none
- Crash IDs missing person records: 0
- Crash IDs missing vehicle records: 0
- Person crash IDs absent from crash extracts: 0
- Vehicle crash IDs absent from crash extracts: 0
- Duplicate record rows across files: {'vehicle': 23251}
- Coverage conclusion: no crash, person, vehicle, year, severity, or year-severity gap was found.

## Year and Severity Coverage

| Year | Severity | Crashes | Missing person | Missing vehicle |
|---|---|---:|---:|---:|
| 2018 | Minor Crash | 2,965 | 0 | 0 |
| 2018 | Non-Injury Crash | 9,102 | 0 | 0 |
| 2018 | Fatal Crash | 50 | 0 | 0 |
| 2018 | Serious Crash | 515 | 0 | 0 |
| 2019 | Minor Crash | 2,941 | 0 | 0 |
| 2019 | Non-Injury Crash | 8,291 | 0 | 0 |
| 2019 | Serious Crash | 519 | 0 | 0 |
| 2019 | Fatal Crash | 39 | 0 | 0 |
| 2020 | Serious Crash | 446 | 0 | 0 |
| 2020 | Fatal Crash | 33 | 0 | 0 |
| 2020 | Minor Crash | 2,301 | 0 | 0 |
| 2020 | Non-Injury Crash | 7,117 | 0 | 0 |
| 2021 | Serious Crash | 475 | 0 | 0 |
| 2021 | Fatal Crash | 52 | 0 | 0 |
| 2021 | Minor Crash | 2,453 | 0 | 0 |
| 2021 | Non-Injury Crash | 7,329 | 0 | 0 |
| 2022 | Serious Crash | 531 | 0 | 0 |
| 2022 | Fatal Crash | 52 | 0 | 0 |
| 2022 | Minor Crash | 2,493 | 0 | 0 |
| 2022 | Non-Injury Crash | 6,606 | 0 | 0 |
| 2023 | Serious Crash | 522 | 0 | 0 |
| 2023 | Fatal Crash | 41 | 0 | 0 |
| 2023 | Minor Crash | 2,627 | 0 | 0 |
| 2023 | Non-Injury Crash | 6,660 | 0 | 0 |
| 2024 | Serious Crash | 519 | 0 | 0 |
| 2024 | Fatal Crash | 31 | 0 | 0 |
| 2024 | Minor Crash | 2,524 | 0 | 0 |
| 2024 | Non-Injury Crash | 5,955 | 0 | 0 |
| 2025 | Serious Crash | 501 | 0 | 0 |
| 2025 | Fatal Crash | 39 | 0 | 0 |
| 2025 | Minor Crash | 2,383 | 0 | 0 |
| 2025 | Non-Injury Crash | 5,970 | 0 | 0 |
| 2026 | Serious Crash | 216 | 0 | 0 |
| 2026 | Fatal Crash | 21 | 0 | 0 |
| 2026 | Minor Crash | 1,023 | 0 | 0 |
| 2026 | Non-Injury Crash | 2,055 | 0 | 0 |

## Treatment Inventory
- Registered treatment records: 4,986; 1,806 supplied reduction rows and 1,651 official-GIS reduction supplements.
- Listed local-street reversals with a matching reduction record: 1,479 of 1,480 unique road names.
- Listed local-street reversals without a reduction record in current sources: LATHAM AVENUE.
- High-confidence reduction-reversal pairs: 791; 662 meet the primary three-period crash-count requirements (26 corridors and 636 local streets).

## Traffic Sources
- AT count workbook: 2008-01-06 to 2026-03-27; 431 of 662 three-period roads have a road-name match.
- AT count phase coverage: {'pre': 371, 'reduced': 209, 'raised': 109}; 56 roads have counts in all three periods.
- TMS telemetry: 2017-12-31 to 2026-05-12; 440 Auckland sites; 12 of 662 model roads have a site-description match.

## Current Pipeline Source
- Current pipeline input ends 2026-06-07; new partitions end 2026-06-07.
- New partition crashes absent from the current pipeline source: 0 ({}).