Crime data story base

[almudenamarco]

• [x] crime_rate development
• [x] crime_rate per borough
• [ ] crime_rate per crime_type
• [ ] crime_rate per offense_type
• [ ] top 5/10 crime_rate per offense
• [x] crime_rate per crime_type per borough
• [ ] crime_rate per offense_type per borough
• [ ] top 5/10 crime_rate per offense per borough
• [x] report_rate vs. crime_date
• [x] report_rate vs. crime_date per crime_type
• [x] report_rate vs. crime_date per offense_type

[almudenamarco]

report_date vs. crime_date here top 10 longest periods:

I would suggest to create grouping for this metric with the following buckets:

• less than 5 years
• between 5-10 years
• between 10-20 years
• more than 20 years

@Jeff-Brady @patschae

[almudenamarco]

Share by time to report bucket:

Took only the more than 20 years bucket and the 10 to 20years per offense_category:

[almudenamarco]

Ideas:

• [x] look on historical data
• [x] deep dive into sexual, property crimes per borough (crimes with longest time until report)
• [x] nicer view on how to show the data

[almudenamarco]

update on time to report buckets:

• less than 1 year

• between 1-5 years

• 5-10 years

• 10-20 years

• 20-30 years

• more than 30 years

• look at locations when sexual type and borough

[Jeff-Brady]

Different Crime Types in total NYC over time:

[almudenamarco]

total should be: 8.9M