DATA ANALYSIS ON US CRIMES

DATA ANALYSIS
USING TABLEAU

PROJECTS

Average assaults in Buffalo,NY



Taking into account the appropriate Agency Jurisdiction and the Assaults field in a Bar graph.

Trend of each crime in every juridiction from 1975-2000



The agency jurisdiction and report year are taken in columns. The sum of all categories of crimes such as rapes, violent crimes, assaults, robberies and homicides are taken in rows. Each agency code is given a unique color to represent the agency jurisdiction.

Safest Agency Jurisdiction



The agency juridiction and the sum of crimes percapita are plotted in horizontal bars.

Decline in the violent crimes over the years



The agency juridiction,report year and sum of violent crimes are plotted in line graphs.

Number of violent crimes that took place



Report year and sum of violent crimes are plotted in a line graph.

Year of highest number of rapes in Albuquerque



Agency jurisdiction is filtered to Albuquerque,Report year and sum of rapes are plotted in a line graph.

Agency jurisdiction with the least homicides in 1980



The agency jurisdiction,the report year(1980) and the sum of homicides in a gantt view.

Most Unsafe State



The agency jurisdiction and the average of violent crimes are plotted in a bar graph.

Most populated Jurisdiction in 1975



The agency jurisdiction is sort to find out the least, the yearbis filtered to 1975 along with the sum of population in a gantt view.

Jurisdiction with Highest average voilent crimes in 1983



The agency jurisdiction is sort to find out the maximum average of violent crimes, the report year is filtered to 1983 along with average of violent crimes in a gantt view.

Safest state in 2003 in the category of robberies in each jurisdiction



The agency jurisdiction is sort in ascending to find the safest state, the report year is filtered to 2003 and the sum of robberies are graphed into a dot plot.

States with the highest and least number of robberies overrall



The agency jurisdiction is sort in ascending to find the states with highest and least robberies overrall, and the sum of robberies are graphed into a convenient bar graph.

Top 5 most populated agency jurisdictions in 1978



The agency jurisdiction is sort in descending to find the top 5 most populated, the report year is flitered to 1978 and the sum of population are graphed in a dot plot.

State with least number of rapes



The agency jurisdiction is sort to find the state with least rape rate,and the sum of rapes are plotted in a bar graph.

Unsafe jurisdictions in Tennessee in 1994 according to assaults percapita



The agency juridiction is filtered to tennessee states, the report year is filtered to 1994 and the sum of assaults percapita are graphed into a dot plot.

Population of Chicago from 1975-2015



The agency juridiction is filtered to chicago and the sum of population are plot into a line graph.

Homicides rate in Chicago from 1975-2015



The agency jurisdiction is filtered to Chicago and the sum of homicides are plotted in a line graph.

Jurisdiction in Ohio with the lowest violent crimes to population ratio in the year 2000



The agency jurisdiction is filtered to Ohio states, the report year is filtered to 2000 and the ration violent crimes and population are graphed into a dot plot.

Average population of jurisdictions from 1975-2015



The agency jurisdiction and average of population are plotted into a bar graph.

Robberies rate from 2000-2015



The agency jurisdiction,the report year and the sum of robberies are plotted into horizontal line charts.

ABOUT

The analysis shown have been performed using Tableau Public.

They help to answer some of the most asked and demanded questions about the US crimes.

The data has been recorded from 1975 to 2015 on assaults,homicides,rapes,robberies and other violent crimes.