Hate Crimes: hate_crimes.csv

This table contains data behind the story Higher Rates Of Hate Crimes Are Tied To Income Inequality.

Header Definition
state State name
median_household_income Median household income, 2016
share_unemployed_seasonal Share of the population that is unemployed (seasonally adjusted), Sept. 2016
share_population_in_metro_areas Share of the population that lives in metropolitan areas, 2015
share_population_with_high_school_degree Share of adults 25 and older with a high-school degree, 2009
share_non_citizen Share of the population that are not U.S. citizens, 2015
share_white_poverty Share of white residents who are living in poverty, 2015
gini_index Gini Index, 2015
share_non_white Share of the population that is not white, 2015
share_voters_voted_trump Share of 2016 U.S. presidential voters who voted for Donald Trump
hate_crimes_per_100k_splc Hate crimes per 100,000 population, Southern Poverty Law Center, Nov. 9-18, 2016
avg_hatecrimes_per_100k_fbi Average annual hate crimes per 100,000 population, FBI, 2010-2015

Sources: Kaiser Family Foundation Kaiser Family Foundation Kaiser Family Foundation Census Bureau Kaiser Family Foundation Kaiser Family Foundation Census Bureau Kaiser Family Foundation United States Elections Project Southern Poverty Law Center FBI

Correction

Please see the following commit: https://github.com/fivethirtyeight/data/commit/fbc884a5c8d45a0636e1d6b000021632a0861986

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

51 rows sorted by share_voters_voted_trump

View and edit SQL

Suggested facets: share_non_citizen, share_white_poverty

Link rowid state median_household_income gini_index hate_crimes_per_100k_splc avg_hatecrimes_per_100k_fbi
9 District of Columbia 68277 0.532 1.52230172 10.95347971
12 Hawaii 71223 0.433    
5 California 60487 0.47100000000000003 0.255805361 2.397985899
46 Vermont 60708 0.444 0.324149109 1.90308139
22 Massachusetts 63151 0.475 0.630810592 4.801899338999999
21 Maryland 76165 0.44299999999999995 0.37043897 1.324839538
33 New York 54310 0.499 0.35062044600000003 3.1021642839999997
48 Washington 59068 0.441 0.67748765 3.817740296
14 Illinois 54916 0.465 0.19534454899999998 1.044015798
32 New Mexico 46686 0.46399999999999997 0.294811321 1.886435184
40 Rhode Island 58633 0.467 0.095401641 1.282571834
7 Connecticut 70161 0.486 0.33539226899999997 3.772701469
38 Oregon 58875 0.449 0.832849608 3.394886113
8 Delaware 57522 0.44 0.322754169 1.469979563
31 New Jersey 65243 0.46399999999999997 0.078305908 4.413202591
6 Colorado 60940 0.457 0.390523301 2.804688765
20 Maine 51710 0.43700000000000006 0.615574023 2.626610924
24 Minnesota 67244 0.44 0.62747993 3.6124118160000003
47 Virginia 66155 0.45899999999999996 0.363248898 1.724754584
29 Nevada 49875 0.44799999999999995 0.14167316 2.113990154
30 New Hampshire 73397 0.425 0.151549595 2.105988585
45 Utah 63383 0.419 0.136546733 2.384065044
23 Michigan 52005 0.451 0.403779375 3.200442266
50 Wisconsin 58080 0.43 0.226197105 1.121944651
10 Florida 46140 0.474 0.18752122300000001 0.6980703420000001
39 Pennsylvania 55173 0.461 0.285101092 0.43092759
3 Arizona 49254 0.455 0.225319954 3.413927994
11 Georgia 49555 0.46799999999999997 0.120420267 0.41201182399999997
34 North Carolina 46784 0.46399999999999997 0.244006588 1.262679796
16 Iowa 57810 0.42700000000000005 0.454427421 0.561395565
36 Ohio 49644 0.452 0.19071396399999999 3.240420404
2 Alaska 67629 0.42200000000000004 0.143740118 1.656700109
44 Texas 53875 0.469 0.213583938 0.752768305
41 South Carolina 44929 0.461 0.209894423 1.937082833
15 Indiana 48060 0.44 0.247008877 1.757356567
17 Kansas 53444 0.445 0.105152471 2.143986672
26 Missouri 56630 0.455 0.18452351 1.9089549890000002
27 Montana 51102 0.435 0.49549103200000005 2.9549593780000003
19 Louisiana 42406 0.475 0.10973334800000001 1.3411695540000002
25 Mississippi 35521 0.46799999999999997 0.067446801 0.622745989
13 Idaho 53438 0.433 0.124208173 1.891330529
4 Arkansas 44922 0.45799999999999996 0.06906077299999999 0.8692088720000001
28 Nebraska 56870 0.43200000000000005 0.15948963300000002 2.68624842
43 Tennessee 43716 0.46799999999999997 0.19993848 3.13605115
42 South Dakota 53053 0.442   3.301737127
1 Alabama 42278 0.47200000000000003 0.125838926 1.8064104890000001
18 Kentucky 42786 0.466 0.324396969 4.2078896210000005
35 North Dakota 60730 0.433   4.741069885
37 Oklahoma 47199 0.45399999999999996 0.133629099 1.08167215
49 West Virginia 39552 0.451 0.328677075 2.037053631
51 Wyoming 55690 0.423   0.26694076

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "hate-crimes/hate_crimes" (
"state" TEXT,
  "median_household_income" INTEGER,
  "share_unemployed_seasonal" REAL,
  "share_population_in_metro_areas" REAL,
  "share_population_with_high_school_degree" REAL,
  "share_non_citizen" REAL,
  "share_white_poverty" REAL,
  "gini_index" REAL,
  "share_non_white" REAL,
  "share_voters_voted_trump" REAL,
  "hate_crimes_per_100k_splc" REAL,
  "avg_hatecrimes_per_100k_fbi" REAL
)
Powered by Datasette · Query took 164.922ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub