fivethirtyeight: hate-crimes/hate

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 · About: simonw/fivethirtyeight-datasette

51 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	state	median_household_income	share_unemployed_seasonal	share_population_in_metro_areas	share_population_with_high_school_degree	share_non_citizen	share_white_poverty	gini_index	share_non_white	share_voters_voted_trump	hate_crimes_per_100k_splc	avg_hatecrimes_per_100k_fbi
1	1	Alabama	42278	0.06	0.64	0.821	0.02	0.12	0.472	0.35	0.63	0.125838926	1.806410489
2	2	Alaska	67629	0.064	0.63	0.914	0.04	0.06	0.422	0.42	0.53	0.143740118	1.656700109
3	3	Arizona	49254	0.063	0.9	0.842	0.1	0.09	0.455	0.49	0.5	0.225319954	3.413927994
4	4	Arkansas	44922	0.052	0.69	0.824	0.04	0.12	0.458	0.26	0.6	0.069060773	0.869208872
5	5	California	60487	0.059	0.97	0.806	0.13	0.09	0.471	0.61	0.33	0.255805361	2.397985899
6	6	Colorado	60940	0.04	0.8	0.893	0.06	0.07	0.457	0.31	0.44	0.390523301	2.804688765
7	7	Connecticut	70161	0.052	0.94	0.886	0.06	0.06	0.486	0.3	0.41	0.335392269	3.772701469
8	8	Delaware	57522	0.049	0.9	0.874	0.05	0.08	0.44	0.37	0.42	0.322754169	1.469979563
9	9	District of Columbia	68277	0.067	1.0	0.871	0.11	0.04	0.532	0.63	0.04	1.52230172	10.95347971
10	10	Florida	46140	0.052	0.96	0.853	0.09	0.11	0.474	0.46	0.49	0.187521223	0.698070342
11	11	Georgia	49555	0.058	0.82	0.839	0.08	0.09	0.468	0.48	0.51	0.120420267	0.412011824
12	12	Hawaii	71223	0.034	0.76	0.904	0.08	0.07	0.433	0.81	0.3
13	13	Idaho	53438	0.042	0.7	0.884	0.04	0.11	0.433	0.16	0.59	0.124208173	1.891330529
14	14	Illinois	54916	0.054	0.9	0.864	0.07	0.07	0.465	0.37	0.39	0.195344549	1.044015798
15	15	Indiana	48060	0.044	0.79	0.866	0.03	0.12	0.44	0.2	0.57	0.247008877	1.757356567
16	16	Iowa	57810	0.036	0.6	0.914	0.03	0.09	0.427	0.15	0.52	0.454427421	0.561395565
17	17	Kansas	53444	0.044	0.64	0.897	0.04	0.11	0.445	0.25	0.57	0.105152471	2.143986672
18	18	Kentucky	42786	0.05	0.56	0.817	0.03	0.17	0.466	0.15	0.63	0.324396969	4.207889621
19	19	Louisiana	42406	0.06	0.81	0.822	0.02	0.12	0.475	0.42	0.58	0.109733348	1.341169554
20	20	Maine	51710	0.044	0.54	0.902		0.12	0.437	0.09	0.45	0.615574023	2.626610924
21	21	Maryland	76165	0.051	0.97	0.89	0.08	0.06	0.443	0.5	0.35	0.37043897	1.324839538
22	22	Massachusetts	63151	0.046	0.97	0.89	0.09	0.08	0.475	0.27	0.34	0.630810592	4.801899339
23	23	Michigan	52005	0.05	0.87	0.879	0.04	0.09	0.451	0.24	0.48	0.403779375	3.200442266
24	24	Minnesota	67244	0.038	0.75	0.915	0.05	0.05	0.44	0.18	0.45	0.62747993	3.612411816
25	25	Mississippi	35521	0.061	0.45	0.804		0.14	0.468	0.44	0.58	0.067446801	0.622745989
26	26	Missouri	56630	0.053	0.78	0.868	0.02	0.07	0.455	0.2	0.57	0.18452351	1.908954989
27	27	Montana	51102	0.041	0.34	0.908	0.01	0.1	0.435	0.1	0.57	0.495491032	2.954959378
28	28	Nebraska	56870	0.029	0.6	0.898	0.05	0.07	0.432	0.21	0.6	0.159489633	2.68624842
29	29	Nevada	49875	0.067	0.87	0.839	0.1	0.08	0.448	0.5	0.46	0.14167316	2.113990154
30	30	New Hampshire	73397	0.034	0.63	0.913	0.03	0.06	0.425	0.09	0.47	0.151549595	2.105988585
31	31	New Jersey	65243	0.056	1.0	0.874	0.11	0.07	0.464	0.44	0.42	0.078305908	4.413202591
32	32	New Mexico	46686	0.068	0.69	0.828	0.06	0.1	0.464	0.62	0.4	0.294811321	1.886435184
33	33	New York	54310	0.051	0.94	0.847	0.1	0.1	0.499	0.42	0.37	0.350620446	3.102164284
34	34	North Carolina	46784	0.058	0.76	0.843	0.05	0.1	0.464	0.38	0.51	0.244006588	1.262679796
35	35	North Dakota	60730	0.028	0.5	0.901	0.03	0.09	0.433	0.15	0.64		4.741069885
36	36	Ohio	49644	0.045	0.75	0.876	0.03	0.1	0.452	0.21	0.52	0.190713964	3.240420404
37	37	Oklahoma	47199	0.044	0.59	0.856	0.04	0.1	0.454	0.35	0.65	0.133629099	1.08167215
38	38	Oregon	58875	0.062	0.87	0.891	0.07	0.1	0.449	0.26	0.41	0.832849608	3.394886113
39	39	Pennsylvania	55173	0.053	0.87	0.879	0.03	0.09	0.461	0.24	0.49	0.285101092	0.43092759
40	40	Rhode Island	58633	0.054	1.0	0.847	0.08	0.08	0.467	0.28	0.4	0.095401641	1.282571834
41	41	South Carolina	44929	0.057	0.79	0.836	0.03	0.09	0.461	0.36	0.55	0.209894423	1.937082833
42	42	South Dakota	53053	0.035	0.51	0.899		0.08	0.442	0.17	0.62		3.301737127
43	43	Tennessee	43716	0.057	0.82	0.831	0.04	0.13	0.468	0.27	0.61	0.19993848	3.13605115
44	44	Texas	53875	0.042	0.92	0.799	0.11	0.08	0.469	0.56	0.53	0.213583938	0.752768305
45	45	Utah	63383	0.036	0.82	0.904	0.04	0.08	0.419	0.19	0.47	0.136546733	2.384065044
46	46	Vermont	60708	0.037	0.35	0.91	0.01	0.1	0.444	0.06	0.33	0.324149109	1.90308139
47	47	Virginia	66155	0.043	0.89	0.866	0.06	0.07	0.459	0.38	0.45	0.363248898	1.724754584
48	48	Washington	59068	0.052	0.86	0.897	0.08	0.09	0.441	0.31	0.38	0.67748765	3.817740296
49	49	West Virginia	39552	0.073	0.55	0.828	0.01	0.14	0.451	0.07	0.69	0.328677075	2.037053631
50	50	Wisconsin	58080	0.043	0.69	0.898	0.03	0.09	0.43	0.22	0.48	0.226197105	1.121944651
51	51	Wyoming	55690	0.04	0.31	0.918	0.02	0.09	0.423	0.15	0.7		0.26694076

Advanced export

JSON shape: default, array, newline-delimited

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
);

Hate Crimes: hate_crimes.csv

Correction

51 rows

Advanced export