Most Dangerous Cities, Part 2

Part
01
of ten
Part
01

FBI Law Enforcement Data, Part 1

Of the cities listed in rows 3 -396 of the attached spreadsheet, Chicago, Illinois had the highest number of law enforcement officers in 2017 with 13,566 and a population-to-officer ratio of 199.48 people to one officer. Ankeny, Iowa had the lowest number of law enforcement officers in 2017 with 65 and a population-to-officer ratio of 938.85 people to one officer.

Using the 2017 Crime in the United States report, the number of full time law enforcement officers in 2017 were identified and placed in rows 3-396 of the attached spreadsheet. However, there were numerous cities that were not listed in the official FBI report. Since this source was the only allowable source for this request, we N/A in column P for the following cities:
Part
02
of ten
Part
02

FBI Law Enforcement Data, Part 2

In the attached spreadsheet, we provided the total number of full-time law enforcement officials in the cities in rows 397 through 791 of the '2017 FBI Crime Data By State (50k+)' tab, using only data provided by the FBI. The FBI did not provide this data for some cities, including the following:

  • Pontiac, Michigan
  • Rochester Hills, Michigan
  • Bellevue, Nebraska
  • Newark, New Jersey
  • Albuquerque, New Mexico
  • Rio Rancho, New Mexico
  • Canton, Ohio
  • Cleveland, Ohio
  • Dayton, Ohio
  • Green Township, Ohio
  • West Chester Township, Ohio
  • Rock Hill, South Carolina
  • Amarillo, Texas
  • Arlington, Texas
  • Brownsville, Texas
  • Cedar Park, Texas
  • College Station, Texas
  • Conroe, Texas
  • Corpus Christi
  • Flower Mound, Texas
  • Harlingen, Texas
  • Longview, Texas
  • Mission, Texas
  • New Braunfels, Texas
  • Pflugerville, Texas
  • Pharr, Texas
  • Plano, Texas
  • Richardson, Texas
  • Round Rock, Texas
  • Rowlett, Texas
  • San Marcos, Texas
  • Sugar Land, Texas
  • Victoria, Texas
We entered '0' in the rows of cities for which the FBI did not provide data.
Part
03
of ten
Part
03

FBI Violent Crime Data 2016, Part 1

The requested information for violent crimes in 2016 for the cities in rows 3 to 396 has been entered in the attached spreadsheet. For any of the cells that do not have a number, the 2016 report did not include that city.
Part
04
of ten
Part
04

FBI Violent Crime Data 2016, Part 2

The information for violent crimes in 2016 for the cities in rows 397 to 791 has been entered into the attached spreadsheet. For any cell left blank the 2016 report did not include that city.

Part
05
of ten
Part
05

FBI Property Crime Data 2016, Part 1

The attached spreadsheet has been completed to include property crime data for 393 American cities as reported by the 2016 Crime in the United States report published by the FBI. Specifically, Rows 3 through 396, Column W have been completed. Sources have been provided in Column X.

For cities not listed in the FBI report, the appropriate cell has been marked "0." Those cities for which data was not available include:
  • Hoover, Alabama
  • Yuma, Arizona
  • Arvada, Colorado
  • Noblesville, Indiana
Part
06
of ten
Part
06

FBI Property Crime Data 2016, Part 2

Our research identified the major property crimes in 2016 for the cities in rows 397 to 791 in the attached spreadsheet.
  • In 2016, property crime in Lake Charles, Louisiana was 11.77% lower than in 2017.
  • There were 2,369 property crimes reported in Cambridge, Massachusetts in 2016.
  • In Detroit, Michigan 31,630 property crimes were reported in 2016.
  • Property crime in Hamilton Township, Mercer County was 26.78% lower in 2016 than in 2017.
  • In 2016, 125,278 property crimes were reported in New York, New York.
Part
07
of ten
Part
07

FBI Population Data 2016, Part 1

Our research identified the population in 2016 for the cities in rows 3 to 396 in the attached spreadsheet. For any cells with no population, the 2016 report did not provide data for that city. We therefore left the cell blank.

  • In 2016, Anchorage, Alaska's population was 299,097.
  • Bakersfield, California has a population of 378,788 in 2016.
  • Yuma, Arizona was not included in the 2016 report.
  • In 2016, Los Angeles, California had a population of 4,007,905.
  • Commerce City, Colorado had a population of 55,341 in 2016.
Part
08
of ten
Part
08

FBI Population Data 2016, Part 2

Population data for 394 United States cities, as reported by the FBI's 2016 Crime in the United States report, has been provided in Column Y, Rows 397 through 791 of the attached spreadsheet. Sources have been provided in Column AA.

Cities for which population data was not available in the attached report have been marked with a "0." These cities include:
  • Camden County, New Jersey
  • Irondequoit Town, New York
  • Durham, North Carolina
  • Gastonia, North Carolina
  • Greensboro, North Carolina,
  • Greenville, North Carolina
  • Jacksonville, North Carolina
  • Lorain, Ohio
  • Longview, Texas
  • Victoria, Texas
Part
09
of ten
Part
09

Dangerous Cities: Census Data, Part 1

The requested census data for Decatur , Dothan , Hoover, Huntsville, Mobile, Montgomery, Tuscaloosa , Anchorage , Avondale , and Buckeye has been entered into rows 3 to 12 in the attached spreadsheet.

Research strategy

We began our research by looking for information from the U.S. Census and the most recent data publicly available. We were able to find population estimates for 2017 from the U.S. Census. This information was used to provide all the required information.
Part
10
of ten
Part
10

Dangerous Cities: Census Data, Part 2

Goodyear and Peoria City have the lowest population density figures as compared to others on the list, Peoria City has a population density of 883.4/sq mile, and for Goodyear, it is 340.90/sq mile. Glendale City has a population density of 3,780.20/sq mile and median household income amounting to $49,383. The details about each of the requested cities have been populated in the columns AB-AH for rows 13-22 on the 2017 FBI Crime Data by State (50k+) Tab of the attached spreadsheet.

Chandler, Arizona

Flagstaff City, Arizona

Gilbert, Arizona

Glendale, Arizona

Goodyear, Arizona

Lake Havasu City, Arizona

Mesa, Arizona

Peoria City, Arizona

Phoenix, Arizona

Scottsdale City, Arizona

Research Strategy:

The research criteria for this request is to use the census data either for the year 2010 or 2017, for each of the city we visited their respective statistic pages, but for all the profiles, the employment percentage was not available. Hence, we could not provide the data for the employment percentage section.

Also, for the percentage of youth population we could only provide the data for population below 18 years of age and above five years of age, because the census website offers data in two specific ranges; below 18 years or below 65 years, hence no categorization can be found for 18-24 years population specifically.

We also searched through the BLS and Census reporter websites to gather the missing info, but none of the above mentioned websites categorized the age profile for 18-24 years specifically. Alternatively, BLS provides the unemployment rate data for the cities, but according to the research criteria we are not allowed to use sources other than listed by census.gov website; hence the data from BLS could not be included.
Sources
Sources

From Part 09