Violent Crime Rate California (2000-2013)

Data & Processing

This table contains data on the rate of violent crime (crimes per 1,000 population) for California, its regions, counties, cities and towns. Crime and population data are from the Federal Bureau of Investigations, Uniform Crime Reports. Rates above the city/town level include data from city, university and college, county, state, tribal, and federal law enforcement agencies.

Data source: Violent Crime Rate, California (The dataset was downloaded on 04/01/2019)

Attribution	Value	Sreenshot
Size	9.9 MB
Rows	49.228
Columns	27
Data Types	String, Number, Date, Location (County)

Licence: "The Government Operations Agency sponsors data.ca.gov, a statewide open data portal created to improve collaboration, expand transparency and lead to innovation and increased effectiveness. "

Relevant columns

Column name	Description
county_name	Describes the county the crime was reported
reportyear	The year of the report
strata_level_name	Crime type such as; Robbery, Forcible rape, Aggravated assault, etc.
strata_level_name_code	Represents the strata_level_name with numeric values ranging from 1-6
numerator	Number of crimes by type of crime
denominator	Total population as reported by the Federal Bureau of Investigation
rate	Number of violent crimes per 1,000 population

The full data set description by data.ca.gov can be downloaded her

Initial processing

The only data processing done to the data is to calculate the rate column for each row by using the numerator and denominator. I also had to add a few new rows to include the average violent crime rate for California as a whole. This included adding a new strata level name "caliAverage". The California average is calculated by the same formula as mentioned above, and will only be used for the line chart. The data processing was all done by a python script that you can download her.