My first data visualization will show information regarding all Texas counties in ascending order based on their crime rates over a span five years, 2010-2015. It will show each of the counties average crime rate associated with the specific year. The visualization will illuminate a consistent pattern in the prevalence of crime attributed to specific counties over the course of five years. I will be emphasizing counties, such as Kennedy County, which have consistently high crime rates compared to other counties. The questions that I will answer with the data provided in the visual are as follows:
- Over the span of five years which county has the highest crime rate?
- What specific year had the highest overall crime rate?
- Which counties, if any, had a significant fluctuation in crime rate from one year to another?
Furthermore, my data will show the average property crime rates per Texas county over the span of five years. For this data, the following are categories that fall under “Property Crimes,” burglary, larceny, motor vehicle theft, and arson. I will emphasize certain counties with the highest property crime rates, such as Loving County and how it compares to others that have low rates, like Dallas County. My data will show if there is a correlation between counties with high violent crime rates and counties with high property crime rates. I will be emphasizing the correlations, if any, of those certain counties. This data visualization will answer the following:
- Which county has the highest property crime rate over the five years?
- What specific year had the highest property crime rate?
- Is there a correlation between the counties with high violent crime rates and the counties with high property crime rates?
In addition, I will show two visualizations that represent the highest violent crime overall, which is rape, and the highest property crime overall, which is larceny. Rape data for “Forcible Rape” was collected under “Rape Legacy” until it was revised in the year 2013 to include more offenses as well as male victims within the Summary Reporting System. For this visualization I have combined the “Rape Legacy” category as well as the “Rape Revised” category to get the total average of rape per county per year
These two visualizations will show which region in Texas has the highest of the two separate crimes. I will discuss how the two different crime rates play a roll in the total crime rate of the county as well as Texas itself. These two visualizations will answer the following:
- Which county has the highest rape rate?
- Which county has the highest larceny rate?
- How do the counties with the highest two crime rates tie into the total average of Texas’ crime rates?
In conclusion I will show the nine counties of the Houston-The Woodlands-Sugar Land metropolitan area and their population size. This visualization is to show how the nine counties make up for a fairly decent amount of the Texas population in total. I will be discussing how the counties population size may or may not play a part in the high/low amount of crime the county has. Following this visualization I will show the nine counties and their violent crime rates per year per county. After, I will give one last visualization that included the nine counties’ property crime rates per year per county. These two visualizations are to show how this specific metropolitan area’s crime rates have tied in to the total amount of crime in Texas. All three of the visuals will show how the role, that the crime in Houston has taken in Texas’ total amount of violent and property crimes over the years. Along with that I will be emphasizing the fluctuation, if any, of Houston crimes over the years. For example, there is some fluctuation with how Harris County jumped up in average violent crime rates from the year 2012-2013. These three visualizations will answer the following questions:
- How does Houston and its surrounding counties population affect the total Texas population?
- How big of a part does Houston and its surrounding counties have in the total violent crime rate and property crime rate in Texas?
- Have Houston’s crime rates increased or decreased more over the years? If so, how much did it effect Texas’ total crime rates?
This will be the set order of my seven data visualizations. I chose this order because it creates a nice flow starting from the big picture and the breakdowns that help make it whole. Starting with the main visualization of Texas counties and their crime rates over the years gives it a nice and broad start. As the visualizations are show in order they will continue to give different break downs of how just one county effects a state’s total crime rate. The visualizations in this order answer will be able to answer multiple different questions ranging from, the total crime rates throughout Texas, down to how a small county with a population of 29,563 can increase/decrease those rates.
Written By: Courtney Shook