saturn·

← all readings

nationwide 2020 election

source /home/coolhand/html/datavis/data_trove/data/geographic/nationwide/2020_election.csv 3,152 rows 10 columns profiled 2026-05-01 raw JSON static .html .ipynb Report Notebook

Reading

dataset summary · high confidence anthropic:claude-opus-4-7

This dataset covers 3,152 U.S. counties from a 2020 election results file, with 10 columns spanning vote totals, party percentages, and geographic identifiers. Vote-count fields (total_votes, votes_dem, votes_gop, diff) are extremely right-skewed with high kurtosis and 12-16% outlier rates, reflecting a few massive-population counties dominating the raw counts — worth inspecting on a log scale. The percentage fields tell a cleaner story: per_gop has a median of 0.68 versus per_dem's 0.30, and per_point_diff is negatively skewed, indicating Republican margins in most counties despite Democrats winning the national popular vote. State coverage is led by Texas (254 counties), Georgia (159), and Virginia (133), so any state-level aggregation should account for that imbalance.

citing: row_count · column_count · columns · kinds

per_gop · Distribution of Republican vote share across counties — note the median near 0.68 and left skew.
Show data table
bincount
0.05397 – 0.076671
0.07667 – 0.099372
0.09937 – 0.12212
0.1221 – 0.14486
0.1448 – 0.16756
0.1675 – 0.190115
0.1901 – 0.21285
0.2128 – 0.235514
0.2355 – 0.258213
0.2582 – 0.280927
0.2809 – 0.303626
0.3036 – 0.326333
0.3263 – 0.34934
0.349 – 0.371742
0.3717 – 0.394448
0.3944 – 0.417152
0.4171 – 0.439867
0.4398 – 0.462580
0.4625 – 0.485267
0.4852 – 0.507979
0.5079 – 0.530667
0.5306 – 0.553399
0.5533 – 0.576127
0.576 – 0.5987124
0.5987 – 0.6214141
0.6214 – 0.6441143
0.6441 – 0.6668155
0.6668 – 0.6895173
0.6895 – 0.7122180
0.7122 – 0.7349203
0.7349 – 0.7576213
0.7576 – 0.7802196
0.7802 – 0.8029203
0.8029 – 0.8256169
0.8256 – 0.8483132
0.8483 – 0.871103
0.871 – 0.893765
0.8937 – 0.916427
0.9164 – 0.93919
0.9391 – 0.96184
per_point_diff · County-level partisan margin; most counties cluster on the GOP side but a long Democratic tail extends to -0.87.
Show data table
bincount
-0.8675 – -0.82261
-0.8226 – -0.77762
-0.7776 – -0.73263
-0.7326 – -0.68775
-0.6877 – -0.64278
-0.6427 – -0.597812
-0.5978 – -0.55286
-0.5528 – -0.507812
-0.5078 – -0.462914
-0.4629 – -0.417922
-0.4179 – -0.37329
-0.373 – -0.32834
-0.328 – -0.28329
-0.283 – -0.238149
-0.2381 – -0.193142
-0.1931 – -0.148256
-0.1482 – -0.103264
-0.1032 – -0.0582370
-0.05823 – -0.0132775
-0.01327 – 0.0316977
0.03169 – 0.0766572
0.07665 – 0.121691
0.1216 – 0.1666133
0.1666 – 0.2115117
0.2115 – 0.2565132
0.2565 – 0.3015142
0.3015 – 0.3464159
0.3464 – 0.3914166
0.3914 – 0.4363182
0.4363 – 0.4813210
0.4813 – 0.5263197
0.5263 – 0.5712198
0.5712 – 0.6162213
0.6162 – 0.6611175
0.6611 – 0.7061140
0.7061 – 0.7511102
0.7511 – 0.79669
0.796 – 0.84129
0.841 – 0.885911
0.8859 – 0.93094
total_votes · Raw turnout per county is heavily right-skewed (max 4.26M vs median 12,335) — consider a log scale.
Show data table
bincount
66 – 1.067e+052839
1.067e+05 – 2.132e+05142
2.132e+05 – 3.198e+0567
3.198e+05 – 4.264e+0542
4.264e+05 – 5.33e+0519
5.33e+05 – 6.396e+0511
6.396e+05 – 7.462e+057
7.462e+05 – 8.527e+0510
8.527e+05 – 9.593e+055
9.593e+05 – 1.066e+062
1.066e+06 – 1.172e+061
1.172e+06 – 1.279e+061
1.279e+06 – 1.386e+060
1.386e+06 – 1.492e+060
1.492e+06 – 1.599e+061
1.599e+06 – 1.705e+062
1.705e+06 – 1.812e+060
1.812e+06 – 1.919e+060
1.919e+06 – 2.025e+060
2.025e+06 – 2.132e+061
2.132e+06 – 2.238e+060
2.238e+06 – 2.345e+061
2.345e+06 – 2.452e+060
2.452e+06 – 2.558e+060
2.558e+06 – 2.665e+060
2.665e+06 – 2.771e+060
2.771e+06 – 2.878e+060
2.878e+06 – 2.984e+060
2.984e+06 – 3.091e+060
3.091e+06 – 3.198e+060
3.198e+06 – 3.304e+060
3.304e+06 – 3.411e+060
3.411e+06 – 3.517e+060
3.517e+06 – 3.624e+060
3.624e+06 – 3.731e+060
3.731e+06 – 3.837e+060
3.837e+06 – 3.944e+060
3.944e+06 – 4.05e+060
4.05e+06 – 4.157e+060
4.157e+06 – 4.263e+061
state_name · County counts by state, dominated by Texas, Georgia, and Virginia — relevant when aggregating.
Show data table
valuecountshare
Texas2548.1%
Georgia1595.0%
Virginia1334.2%
Kentucky1203.8%
Missouri1153.6%
Kansas1053.3%
Illinois1023.2%
North Carolina1003.2%
Iowa993.1%
Tennessee953.0%
Nebraska933.0%
Indiana922.9%
Ohio882.8%
Minnesota872.8%
Michigan832.6%
Mississippi822.6%
Oklahoma772.4%
Arkansas752.4%
Wisconsin722.3%
Alabama672.1%
votes_dem · Democratic vote totals show extreme skew (skew ≈ 14) driven by a handful of urban counties.
Show data table
bincount
4 – 7.573e+042920
7.573e+04 – 1.514e+05109
1.514e+05 – 2.272e+0543
2.272e+05 – 3.029e+0527
3.029e+05 – 3.786e+0513
3.786e+05 – 4.543e+0518
4.543e+05 – 5.301e+053
5.301e+05 – 6.058e+056
6.058e+05 – 6.815e+055
6.815e+05 – 7.572e+051
7.572e+05 – 8.329e+051
8.329e+05 – 9.087e+051
9.087e+05 – 9.844e+052
9.844e+05 – 1.06e+061
1.06e+06 – 1.136e+060
1.136e+06 – 1.212e+060
1.212e+06 – 1.287e+060
1.287e+06 – 1.363e+060
1.363e+06 – 1.439e+060
1.439e+06 – 1.514e+060
1.514e+06 – 1.59e+060
1.59e+06 – 1.666e+060
1.666e+06 – 1.742e+061
1.742e+06 – 1.817e+060
1.817e+06 – 1.893e+060
1.893e+06 – 1.969e+060
1.969e+06 – 2.044e+060
2.044e+06 – 2.12e+060
2.12e+06 – 2.196e+060
2.196e+06 – 2.272e+060
2.272e+06 – 2.347e+060
2.347e+06 – 2.423e+060
2.423e+06 – 2.499e+060
2.499e+06 – 2.575e+060
2.575e+06 – 2.65e+060
2.65e+06 – 2.726e+060
2.726e+06 – 2.802e+060
2.802e+06 – 2.877e+060
2.877e+06 – 2.953e+060
2.953e+06 – 3.029e+061

Schema

10 columns
Alerts
state_name categorical 0.0% 51
county_fips numeric 0.0% 3,152
county_name text 0.0% 1,887
short_text duplicates
votes_gop numeric 0.0% 2,965
high_skew outliers
votes_dem numeric 0.0% 2,762
high_skew outliers
total_votes numeric 0.0% 3,049
high_skew outliers
diff numeric 0.0% 2,906
high_skew outliers
per_gop numeric 0.0% 3,151
per_dem numeric 0.0% 3,151
per_point_diff numeric 0.0% 3,152

state_name

categorical
n
3,152
nulls
0 (0.0%)
unique
51
top_value
Texas
top_rate
0.08058
cardinality
51
entropy
5.279
entropy_ratio
0.9306

county_fips

numeric
n
3,152
nulls
0 (0.0%)
unique
3,152
min
1,001
max
56,045
mean
3.03e+04
median
29,166
std
1.521e+04
q1
1.816e+04
q3
4.508e+04
iqr
26,913
skew
-0.07763
kurtosis
-1.104
n_outliers
0
outlier_rate
0
zero_rate
0

county_name

text short_text duplicates
n
3,152
nulls
0 (0.0%)
unique
1,887
len_min
10
len_max
27
len_mean
13.9
len_median
14
len_p95
17
word_mean
2.063
word_median
2
n_empty
0
n_duplicates
1,265
duplicate_rate
0.4013
vocab_size
1,880
readability_flesch_mean
35.12
emoji_rate
0
url_rate
0
one_word_rate
0
allcaps_rate
0
boilerplate_rate
0

votes_gop

numeric high_skew outliers
n
3,152
nulls
0 (0.0%)
unique
2,965
min
60
max
1.146e+06
mean
2.354e+04
median
8,123
std
5.404e+04
q1
3662
q3
2.051e+04
iqr
1.685e+04
skew
8.684
kurtosis
122.7
n_outliers
387
outlier_rate
0.1228
zero_rate
0

votes_dem

numeric high_skew outliers
n
3,152
nulls
0 (0.0%)
unique
2,762
min
4
max
3.029e+06
mean
2.578e+04
median
3,690
std
9.693e+04
q1
1320
q3
1.194e+04
iqr
10,625
skew
14.13
kurtosis
340.1
n_outliers
468
outlier_rate
0.1485
zero_rate
0

total_votes

numeric high_skew outliers
n
3,152
nulls
0 (0.0%)
unique
3,049
min
66
max
4.263e+06
mean
5.026e+04
median
1.234e+04
std
1.494e+05
q1
5415
q3
3.33e+04
iqr
2.789e+04
skew
11.88
kurtosis
245.2
n_outliers
437
outlier_rate
0.1386
zero_rate
0

diff

numeric high_skew outliers
n
3,152
nulls
0 (0.0%)
unique
2,906
min
-1.883e+06
max
119,005
mean
-2239
median
2,984
std
5.587e+04
q1
816.8
q3
7286
iqr
6470
skew
-17.7
kurtosis
485.4
n_outliers
499
outlier_rate
0.1583
zero_rate
0

per_gop

numeric
n
3,152
nulls
0 (0.0%)
unique
3,151
min
0.05397
max
0.9618
mean
0.6478
median
0.6817
std
0.162
q1
0.5541
q3
0.7738
iqr
0.2196
skew
-0.792
kurtosis
0.1515
n_outliers
44
outlier_rate
0.01396
zero_rate
0

per_dem

numeric
n
3,152
nulls
0 (0.0%)
unique
3,151
min
0.03091
max
0.9215
mean
0.3339
median
0.3002
std
0.1599
q1
0.21
q3
0.4258
iqr
0.2159
skew
0.8178
kurtosis
0.2146
n_outliers
46
outlier_rate
0.01459
zero_rate
0

per_point_diff

numeric
n
3,152
nulls
0 (0.0%)
unique
3,152
min
-0.8675
max
0.9309
mean
0.314
median
0.3797
std
0.3214
q1
0.1294
q3
0.5644
iqr
0.435
skew
-0.8011
kurtosis
0.178
n_outliers
46
outlier_rate
0.01459
zero_rate
0