Most Dangerous Cities, Part 2

Delivered March 30th, 2019. Contributors: Shannon L., Kevin D., Emma H., Kiersten M., Sumit B. and

Part

of ten

Part

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:
 Huntsville, Alabama 
 Mobile3, Alabama 
 Montgomery, Alabama 
 Aliso Viejo, California 
 Apple Valley, California 
 Bellflower, California 
 Camarillo, California 
 Carson, California 
 Cerritos, California 
 Chino Hills, California 
 Compton, California 
 Cupertino, California 
 Diamond Bar, California 
 Dublin, California 
 East Vale, California 
 Encinitas, California 
 Hesperia, California 
 Highland, California 
 Jurupa Valley, California 
 Laguna Niguel, California 
 Lake Elsinore, California 
 Lake Forest, California 
 Lakewood, California 
 Lancaster, California 
 Lynwood, California 
 Menifee, California 
 Mission Viejo, California 
 Moreno Valley, California 
 Norwalk, California 
 Palm Desert, California 
 Palmdale, California 
 Paramount, California 
 Perris, California 
 Pico Rivera, California 
 Poway, California 
 Rancho Cordova, California 
 Rancho Cucamonga, California 
 Rosemead, California 
 San Clemente, California 
 San Marcos, California 
 Santa Clarita, California 
 Santee, California 
 Temecula, California 
 Thousand Oaks, California 
 Victorville, California 
 Vista, California 
 Yorba Linda, California 
 Yucaipa, California 
 Doral, Florida 
 Lauderhill, Florida 
 Miami Beach, Florida 
 Pensacola, Florida 
 Sunrise, Florida 
 Wellington, Florida 
 Alpharetta, Georgia 
 Columbus, Georgia 
 Aurora, Illinois 
 Bolingbrook, Illinois 
 Naperville, Illinois 
 Normal, Illinois 
 Palatine, Illinois 
 Peoria, Illinois 
 Elkhart3, Indiana 
 Noblesville3, Indiana 

Part

of ten

Part

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

of ten

Part

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.
 
In 2016, Los Angeles, California had 28,817 violent crimes.
Greenwich, Connecticut experienced 14 violent crimes in 2016.
 30,126 violent crimes took place in Chicago, Illinois in 2016.
Washington, DC experienced 7,711 violent crimes in 2016.
In 2016, 10,700 violent crimes were reported in Phoenix, Arizona.

Part

of ten

Part

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.

In 2016, 1,815 violent crimes took place in Salt Lake City, Utah.
 23,960 violent crimes were reported in Houston, Texas in 2016.
In 2016, 43 violent crimes occurred in Albany, Oregon.
 13,705 violent crimes were reported in Detroit, Michigan in 2016.
In 2016, 11,010 violent crimes took place in Baltimore, Maryland.

Part

of ten

Part

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

of ten

Part

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

of ten

Part

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

of ten

Part

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

of ten

Part

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. 

Decatur has a population density of 1037.4, and an unemployment rate of 6.2%.
Dothan's median household income is $43,176.
 96% of Hoover's population over the age of 25 has graduated from high school.
 7.1% of Huntsville's population is aged between 15 and 24.
 7.9% of Mobile's population is unemployed.
Montgomery's median household income is $44,339, and the city has an unemployment rate of 7.9%.
Tuscaloosa's population density is 1501.9. 
The median household income in Anchorage is $82,271.
Avondale's unemployment rate is 6%.
 8.8% of Buckeye's population is between the age of 15 and 24.
Research strategyWe 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

of ten

Part

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 Population Density - 3,665.80 per sq mile
 
Median Household Income - $77,278
  
% Youth Population - 26.30%
  
Education Level % - 92.40%
 
Flagstaff City, Arizona Population Density - 3,665.80 per sq mile
 
Median Household Income - $77,278
  
% Youth Population - 18.1% 
Education Level % - 92.40%
  
Gilbert, Arizona Population Density - 3,067.2 per sq mile
  
Median Household Income - $87,566
 
% Youth Population - 30.8% 
Education Level % - 95.9%
  
Glendale, Arizona Population Density - 3,780.2 per sq mile
 
Median Household Income - $49,383
  
% Youth Population - 26.1%  
Education Level % - 83.40%
  
Goodyear, Arizona Population Density - 340.90 per sq mile
  
Median Household Income - $77,930
 
% Youth Population - 25.5% 
Education Level % - 91.70%
 
Lake Havasu City, Arizona Population Density - 1,182.1 per sq mile
  
Median Household Income - $47,424
 
% Youth Population - 15.8% 
Education Level % - 90.00%
 
Mesa, Arizona Population Density - 3,217.50 per sq mile
 
Median Household Income - $52,155
 
% Youth Population - 24.5% 
 
Education Level % - 87.70%
 
Peoria City, Arizona  
Population Density - 883.4 per sq mile
  
Median Household Income - $69,589
 
% Youth Population - 24.80%  
Education Level % - 92.70%
 
Phoenix, ArizonaPopulation Density - 2,797.8 per sq mile
  
Median Household Income - $52,080
  
% Youth Population - 26.80%
  
Education Level % - 81.2%
  
Scottsdale City, Arizona Population Density - 1,182.0 per sq mile
  
Median Household Income - $80,306
  
% Youth Population - 16.50%
  
Education Level % - 96.40%  
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.