fivethirtyeight: hate-crimes/hate_crimes: 51 rows sorted by share_voters_voted

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 sorted by share_voters_voted_trump

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
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
12	12	Hawaii	71223	0.034	0.76	0.904	0.08	0.07	0.433	0.81	0.3
5	5	California	60487	0.059	0.97	0.806	0.13	0.09	0.471	0.61	0.33	0.255805361	2.397985899
46	46	Vermont	60708	0.037	0.35	0.91	0.01	0.1	0.444	0.06	0.33	0.324149109	1.90308139
22	22	Massachusetts	63151	0.046	0.97	0.89	0.09	0.08	0.475	0.27	0.34	0.630810592	4.801899339
21	21	Maryland	76165	0.051	0.97	0.89	0.08	0.06	0.443	0.5	0.35	0.37043897	1.324839538
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
48	48	Washington	59068	0.052	0.86	0.897	0.08	0.09	0.441	0.31	0.38	0.67748765	3.817740296
14	14	Illinois	54916	0.054	0.9	0.864	0.07	0.07	0.465	0.37	0.39	0.195344549	1.044015798
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
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
7	7	Connecticut	70161	0.052	0.94	0.886	0.06	0.06	0.486	0.3	0.41	0.335392269	3.772701469
38	38	Oregon	58875	0.062	0.87	0.891	0.07	0.1	0.449	0.26	0.41	0.832849608	3.394886113
8	8	Delaware	57522	0.049	0.9	0.874	0.05	0.08	0.44	0.37	0.42	0.322754169	1.469979563
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
6	6	Colorado	60940	0.04	0.8	0.893	0.06	0.07	0.457	0.31	0.44	0.390523301	2.804688765
20	20	Maine	51710	0.044	0.54	0.902		0.12	0.437	0.09	0.45	0.615574023	2.626610924
24	24	Minnesota	67244	0.038	0.75	0.915	0.05	0.05	0.44	0.18	0.45	0.62747993	3.612411816
47	47	Virginia	66155	0.043	0.89	0.866	0.06	0.07	0.459	0.38	0.45	0.363248898	1.724754584
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
45	45	Utah	63383	0.036	0.82	0.904	0.04	0.08	0.419	0.19	0.47	0.136546733	2.384065044
23	23	Michigan	52005	0.05	0.87	0.879	0.04	0.09	0.451	0.24	0.48	0.403779375	3.200442266
50	50	Wisconsin	58080	0.043	0.69	0.898	0.03	0.09	0.43	0.22	0.48	0.226197105	1.121944651
10	10	Florida	46140	0.052	0.96	0.853	0.09	0.11	0.474	0.46	0.49	0.187521223	0.698070342
39	39	Pennsylvania	55173	0.053	0.87	0.879	0.03	0.09	0.461	0.24	0.49	0.285101092	0.43092759
3	3	Arizona	49254	0.063	0.9	0.842	0.1	0.09	0.455	0.49	0.5	0.225319954	3.413927994
11	11	Georgia	49555	0.058	0.82	0.839	0.08	0.09	0.468	0.48	0.51	0.120420267	0.412011824
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
16	16	Iowa	57810	0.036	0.6	0.914	0.03	0.09	0.427	0.15	0.52	0.454427421	0.561395565
36	36	Ohio	49644	0.045	0.75	0.876	0.03	0.1	0.452	0.21	0.52	0.190713964	3.240420404
2	2	Alaska	67629	0.064	0.63	0.914	0.04	0.06	0.422	0.42	0.53	0.143740118	1.656700109
44	44	Texas	53875	0.042	0.92	0.799	0.11	0.08	0.469	0.56	0.53	0.213583938	0.752768305
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
15	15	Indiana	48060	0.044	0.79	0.866	0.03	0.12	0.44	0.2	0.57	0.247008877	1.757356567
17	17	Kansas	53444	0.044	0.64	0.897	0.04	0.11	0.445	0.25	0.57	0.105152471	2.143986672
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
19	19	Louisiana	42406	0.06	0.81	0.822	0.02	0.12	0.475	0.42	0.58	0.109733348	1.341169554
25	25	Mississippi	35521	0.061	0.45	0.804		0.14	0.468	0.44	0.58	0.067446801	0.622745989
13	13	Idaho	53438	0.042	0.7	0.884	0.04	0.11	0.433	0.16	0.59	0.124208173	1.891330529
4	4	Arkansas	44922	0.052	0.69	0.824	0.04	0.12	0.458	0.26	0.6	0.069060773	0.869208872
28	28	Nebraska	56870	0.029	0.6	0.898	0.05	0.07	0.432	0.21	0.6	0.159489633	2.68624842
43	43	Tennessee	43716	0.057	0.82	0.831	0.04	0.13	0.468	0.27	0.61	0.19993848	3.13605115
42	42	South Dakota	53053	0.035	0.51	0.899		0.08	0.442	0.17	0.62		3.301737127
1	1	Alabama	42278	0.06	0.64	0.821	0.02	0.12	0.472	0.35	0.63	0.125838926	1.806410489
18	18	Kentucky	42786	0.05	0.56	0.817	0.03	0.17	0.466	0.15	0.63	0.324396969	4.207889621
35	35	North Dakota	60730	0.028	0.5	0.901	0.03	0.09	0.433	0.15	0.64		4.741069885
37	37	Oklahoma	47199	0.044	0.59	0.856	0.04	0.1	0.454	0.35	0.65	0.133629099	1.08167215
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
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 sorted by share_voters_voted_trump

Advanced export