Download the data
Every table produced by the analysis, as CSV. They load straight into Excel, Power BI or Tableau. Column definitions are in the case study and the repository data dictionary.
| File | Rows | Size |
|---|---|---|
| q1_clearance_by_offense_family.csv | 18 | 0.8 KB |
| q1_clearance_by_year.csv | 10 | 0.4 KB |
| q1_definition_comparison.csv | 4 | 0.3 KB |
| q1_exceptional_clearance_reasons.csv | 5 | 0.2 KB |
| q2_km_curves.csv | 57 | 1.1 KB |
| q2_time_to_clearance_summary.csv | 3 | 0.3 KB |
| q3_division_mix_adjusted.csv | 14 | 0.5 KB |
| q3_npa_rates.csv | 427 | 18.0 KB |
| q4_monthly_volume_stl.csv | 117 | 4.4 KB |
| q4_weekday_month_volume.csv | 84 | 1.6 KB |
| q5_lag_vs_clearance.csv | 4 | 0.1 KB |
| q5_report_lag.csv | 18 | 0.7 KB |
| q6_fbi_peer_clearance.csv | 96 | 6.2 KB |
| q6_validation_open_data_vs_fbi.csv | 6 | 0.2 KB |