Skip to content

thomassantosh/exploring-crime-data

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Intent

I was interested to ground myself in a few of the data trends made available from the FBI Crime Data Explorer. This dataset contains statistics on a number of state-wide crimes (homicide, burglary, etc.) offering up some baseline to consider how this has evolved with population changes. The key results largely analyze trend fluctuations after normalizing for population changes including how various states compare. There is also a sample correlation matrix, though this was not fully run since the implementation lacks sufficient performance characteristics and may be improved in a future iteration.

  • A few high-level learnings:
    • Overall, US per capita crimes rates are declining. The largest categories have been 'property crime', followed by 'larceny' and 'burglary'. Most other crimes are reported at <1% per capita. logo
    • By state, this is of course, different for various reasons. A few samples are shown below:
      • Washington (all crimes) logo
      • Washington (<1% crimes, after removing 'property', 'larceny' and 'burglary') logo
      • California (all crimes) logo
      • California (<1% crimes, after removing 'property', 'larceny' and 'burglary') logo
      • District of Columbia (all crimes) logo
      • District of Columbia (<1% crimes, after removing 'property', 'larceny' and 'burglary') logo
    • When you compare ten year blocks of time (1980,1990, 2000, 2010 and 2020) and rank states by crimes per capita and compare this to raw counts, interesting patterns emerge. For example, just considering 'property crime':
      • In 1990, the 'District of Columbia' topped the list with ~8% property crimes per capita, with Florida, Arizona, Texas and Georgia making up the remaining top 5... logo
      • ...based on raw values however, California and Texas topped the list given their larger square footage and population sizes... logo
      • In 2020, property crimes per capita had reduced significantly down to ~3%, with only the District of Columbia remaining in the top 5 (compared to 1990), and Louisiana, New Mexico, Colorado and Washington now registering on the list... logo
      • ...based on raw values, California, Texas, Florida and New York continued to be in the top 5 though at far lower counts than in 1990... logo

About

Exploring crime data in Databricks

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published