How Redistricting Affects The Battle For State Legislatures: fivethirtyeight_state_legislative_district_analysis.csv

Table actions

This repo contains the data behind the story How Redistricting Affects The Battle For State Legislatures. fivethirtyeight_state_legislative_district_analysis.csv contains results of FiveThirtyEight's analysis of state legislative district lines drawn in the redistricting process to reflect the 2020 census. This file also contains the same analysis results for the previously enacted map for each state and chamber included in the analysis, to allow for comparisons in how redistricting shaped and shifted political power in state legislative chambers.

Header Definition
year Year the district lines were active. 2022 dictates new lines drawn in redistricting process to reflect 2020 census. 2020 dictates old lines that were active prior to the 2020-21 redistricting process.
state Two-letter state abbreviation. 15 states are included: AZ, CO, CT, FL, GA, ME, MI, MN, NC, NM, NV, OR, PA, TX and VA.
chamber State legislative chamber. Either upper (state Senate) or lower (state House). Blank for Arizona, where state legislative chambers share the same map.
district District number. statewide rows contain metrics that apply to the legislative map as a whole, not for individual districts (efficiency_gap and median metrics).
metric Metric name:
  • total_pop: Total population
  • total_vap: Total voting age population
  • biden_2020: Joe Biden's voteshare in the 2020 election within these specific district lines
  • Trump_2020: Donald Trump's voteshare in the 2020 election within these specific district lines
  • pvi: FiveThirtyEight's partisan lean index. (The average margin difference between how a state or district votes and how the country votes overall. This version of partisan lean, meant to be used for congressional and gubernatorial elections, is calculated as 50 percent the state or district’s lean relative to the nation in the most recent presidential election, 25 percent its relative lean in the second-most-recent presidential election and 25 percent a custom state-legislative lean.)
  • median: Difference between the pvi of the chamber's median district and the pvi of the state as a whole (only populated when the district column is statewide).
  • efficiency_gap: Efficiency Gap (a measure of how efficiently distributed each party’s votes are) for this statewide map (only populated when the district column is statewide).
Voting age population by race/ethnicity:
  • asian_vap: Non-Hispanic Asian voting age population
  • black_vap: Non-Hispanic Black or African American voting age population
  • hispanic_vap: Hispanic or Latino voting age population of any race(s)
  • native_vap: Non-Hispanic American Indian and Alaska Native voting age population
  • other_vap: Non-Hispanic "Some Other Race" voting age population
  • pacisl_vap: Non-Hispanic Native Hawaiian and Other Pacific Islander voting age population
  • two_plus_vap: Non-Hispanic voting age population or two or more races
  • white_vap: Non-Hispanic White voting age population
value Numeric value for metric (when applicable). Populated for all metric values besides biden_2020 and trump_2020.
pct Percent of total for metric (when applicable). Populated for biden_2020, trump_2020, and all voting age population by race/ethnicity metric values.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

56,023 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ year state chamber district metric value pct
1 1 2020 AZ   1 asian_vap 3382 1.66
2 2 2020 AZ   1 biden_2020   31.81
3 3 2020 AZ   1 black_vap 2083 1.02
4 4 2020 AZ   1 hispanic_vap 20838 10.22
5 5 2020 AZ   1 native_vap 1640 0.8
6 6 2020 AZ   1 other_vap 868 0.43
7 7 2020 AZ   1 pacisl_vap 255 0.13
8 8 2020 AZ   1 pvi R+42.8  
9 9 2020 AZ   1 total_pop 246622  
10 10 2020 AZ   1 total_vap 203978 100.0
11 11 2020 AZ   1 trump_2020   66.86
12 12 2020 AZ   1 two_plus_vap 7147 3.5
13 13 2020 AZ   1 white_vap 167765 82.25
14 14 2020 AZ   2 asian_vap 2371 1.42
15 15 2020 AZ   2 biden_2020   60.7
16 16 2020 AZ   2 black_vap 5319 3.19
17 17 2020 AZ   2 hispanic_vap 89583 53.73
18 18 2020 AZ   2 native_vap 2022 1.21
19 19 2020 AZ   2 other_vap 477 0.29
20 20 2020 AZ   2 pacisl_vap 202 0.12
21 21 2020 AZ   2 pvi D+14.5  
22 22 2020 AZ   2 total_pop 217702  
23 23 2020 AZ   2 total_vap 166718 100.0
24 24 2020 AZ   2 trump_2020   38.0
25 25 2020 AZ   2 two_plus_vap 2944 1.77
26 26 2020 AZ   2 white_vap 63800 38.27
27 27 2020 AZ   3 asian_vap 4610 2.79
28 28 2020 AZ   3 biden_2020   72.87
29 29 2020 AZ   3 black_vap 5165 3.12
30 30 2020 AZ   3 hispanic_vap 85333 51.57
31 31 2020 AZ   3 native_vap 5449 3.29
32 32 2020 AZ   3 other_vap 605 0.37
33 33 2020 AZ   3 pacisl_vap 207 0.13
34 34 2020 AZ   3 pvi D+39.6  
35 35 2020 AZ   3 total_pop 207569  
36 36 2020 AZ   3 total_vap 165474 100.0
37 37 2020 AZ   3 trump_2020   25.78
38 38 2020 AZ   3 two_plus_vap 3951 2.39
39 39 2020 AZ   3 white_vap 60154 36.35
40 40 2020 AZ   4 asian_vap 2150 1.31
41 41 2020 AZ   4 biden_2020   55.36
42 42 2020 AZ   4 black_vap 6255 3.82
43 43 2020 AZ   4 hispanic_vap 94815 57.95
44 44 2020 AZ   4 native_vap 7950 4.86
45 45 2020 AZ   4 other_vap 542 0.33
46 46 2020 AZ   4 pacisl_vap 219 0.13
47 47 2020 AZ   4 pvi D+7.2  
48 48 2020 AZ   4 total_pop 222582  
49 49 2020 AZ   4 total_vap 163621 100.0
50 50 2020 AZ   4 trump_2020   43.01
51 51 2020 AZ   4 two_plus_vap 3502 2.14
52 52 2020 AZ   4 white_vap 48188 29.45
53 53 2020 AZ   5 asian_vap 2345 1.24
54 54 2020 AZ   5 biden_2020   24.02
55 55 2020 AZ   5 black_vap 1782 0.94
56 56 2020 AZ   5 hispanic_vap 27019 14.24
57 57 2020 AZ   5 native_vap 3669 1.93
58 58 2020 AZ   5 other_vap 583 0.31
59 59 2020 AZ   5 pacisl_vap 320 0.17
60 60 2020 AZ   5 pvi R+57.6  
61 61 2020 AZ   5 total_pop 228031  
62 62 2020 AZ   5 total_vap 189752 100.0
63 63 2020 AZ   5 trump_2020   74.74
64 64 2020 AZ   5 two_plus_vap 7327 3.86
65 65 2020 AZ   5 white_vap 146707 77.32
66 66 2020 AZ   6 asian_vap 2870 1.5
67 67 2020 AZ   6 biden_2020   45.09
68 68 2020 AZ   6 black_vap 2068 1.08
69 69 2020 AZ   6 hispanic_vap 26923 14.1
70 70 2020 AZ   6 native_vap 10615 5.56
71 71 2020 AZ   6 other_vap 877 0.46
72 72 2020 AZ   6 pacisl_vap 301 0.16
73 73 2020 AZ   6 pvi R+15.7  
74 74 2020 AZ   6 total_pop 232171  
75 75 2020 AZ   6 total_vap 190917 100.0
76 76 2020 AZ   6 trump_2020   53.25
77 77 2020 AZ   6 two_plus_vap 7058 3.7
78 78 2020 AZ   6 white_vap 140205 73.44
79 79 2020 AZ   7 asian_vap 900 0.63
80 80 2020 AZ   7 biden_2020   62.58
81 81 2020 AZ   7 black_vap 712 0.5
82 82 2020 AZ   7 hispanic_vap 8642 6.07
83 83 2020 AZ   7 native_vap 91145 64.02
84 84 2020 AZ   7 other_vap 244 0.17
85 85 2020 AZ   7 pacisl_vap 52 0.04
86 86 2020 AZ   7 pvi D+19.1  
87 87 2020 AZ   7 total_pop 194163  
88 88 2020 AZ   7 total_vap 142379 100.0
89 89 2020 AZ   7 trump_2020   35.95
90 90 2020 AZ   7 two_plus_vap 2714 1.91
91 91 2020 AZ   7 white_vap 37970 26.67
92 92 2020 AZ   8 asian_vap 2558 1.46
93 93 2020 AZ   8 biden_2020   41.65
94 94 2020 AZ   8 black_vap 8218 4.69
95 95 2020 AZ   8 hispanic_vap 53315 30.43
96 96 2020 AZ   8 native_vap 10166 5.8
97 97 2020 AZ   8 other_vap 578 0.33
98 98 2020 AZ   8 pacisl_vap 435 0.25
99 99 2020 AZ   8 pvi R+21.6  
100 100 2020 AZ   8 total_pop 229764  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "redistricting-2022-state-legislatures/fivethirtyeight_state_legislative_district_analysis" (
"year" INTEGER,
  "state" TEXT,
  "chamber" TEXT,
  "district" TEXT,
  "metric" TEXT,
  "value" TEXT,
  "pct" REAL
);