data trove veteran population by county

source /home/coolhand/html/datavis/data_trove/demographic/veterans/military_firearm_veterans.csv 49 rows 5 columns profiled 2026-06-22 raw JSON static .html .ipynb Report Notebook

Reading

dataset summary · high confidence anthropic:default

This dataset contains U.S. state-level veteran population statistics for 49 states, including total population, veteran counts, and the percentage of the population that are veterans. The most important signal is in veteran_percentage, which is extremely right-skewed (skew: 5.79) with 8 outliers and a max of 277.05 — far above the median of 5.08 — suggesting a small number of states have dramatically elevated veteran shares worth investigating. Total population and veteran population both distribute relatively evenly across states with no outliers, meaning the percentage anomalies are not simply a function of small population size.

citing: veteran_percentage.stats.skew · veteran_percentage.stats.median · veteran_percentage.stats.max · veteran_percentage.alerts · veteran_percentage.stats.n_outliers · total_population.stats.skew · veteran_population.stats.n_outliers · row_count

Charts the summary said to look at first

veteran_percentage · Look for the extreme right tail — a handful of states have veteran percentages far above the median of 5.08, with one reaching 277.05.

Show data table

Histogram bins for veteran_percentage (median: 5.08).
bin	count
0.22 – 39.77	45
39.77 – 79.31	3
79.31 – 118.9	0
118.9 – 158.4	0
158.4 – 198	0
198 – 237.5	0
237.5 – 277.1	1

veteran_population · Compare veteran population counts across states to see which states have the largest absolute veteran communities.

Show data table

Histogram bins for veteran_population (median: 932756.0).
bin	count
6.109e+04 – 3.076e+05	13
3.076e+05 – 5.542e+05	4
5.542e+05 – 8.007e+05	5
8.007e+05 – 1.047e+06	7
1.047e+06 – 1.294e+06	8
1.294e+06 – 1.54e+06	8
1.54e+06 – 1.787e+06	4

total_population · Total population varies widely across states, providing context for interpreting differences in veteran counts and percentages.

Show data table

Histogram bins for total_population (median: 19582629.0).
bin	count
5.49e+05 – 6.074e+06	11
6.074e+06 – 1.16e+07	5
1.16e+07 – 1.713e+07	4
1.713e+07 – 2.265e+07	10
2.265e+07 – 2.818e+07	7
2.818e+07 – 3.37e+07	2
3.37e+07 – 3.923e+07	10

veteran_percentage · Ranked by state, this reveals which specific states are driving the outlier veteran percentage values identified in the histogram.

Show data table

Histogram bins for veteran_percentage (median: 5.08).
bin	count
0.22 – 39.77	45
39.77 – 79.31	3
79.31 – 118.9	0
118.9 – 158.4	0
158.4 – 198	0
198 – 237.5	0
237.5 – 277.1	1

Schema

5 columns

Per-column summary. Click column name to jump to its detail.
				Alerts
NAME	categorical	0.0%	49	long_tail
state	categorical	0.0%	49	long_tail
veteran_population	numeric	0.0%	49
total_population	numeric	0.0%	49
veteran_percentage	numeric	0.0%	49	high_skew outliers

NAME

categorical label long_tail

This column contains U.S. state names, with 49 unique values across 49 rows and zero nulls — consistent with a near-complete list of U.S. states (50 states minus one, or possibly including a territory/district instead). Every value appears exactly once (top_rate = 0.0204, i.e., 1/49), yielding a maximum entropy_ratio of 1.0, which flags as a long-tail alert but is actually a perfectly uniform identifier distribution. The missing 50th entry is worth investigating — one state may be absent or replaced by a non-standard entry. Treatment: Use as a join key or group-by label; audit for the missing 50th U.S. state before aggregation. high · anthropic:default

n: 49
nulls: 0 (0.0%)
unique: 49
top_value: California
top_rate: 0.02041
cardinality: 49
entropy: 5.615
entropy_ratio: 1

state

categorical label long_tail

This column contains US state names, with exactly 49 rows and 49 unique values — meaning every row is a distinct state (notably, only 49 of the 50 US states are present, so one state is missing from the dataset). The entropy ratio of 1.0 and uniform frequency of 1 per state confirm perfect cardinality with zero repetition, making this a de facto identifier rather than a grouping variable. The 'long_tail' alert is technically a misnomer here: all values occur exactly once, so there is no skew whatsoever. Treatment: Use as a row label or join key; do not one-hot encode with cardinality 49 without dimensionality reduction — consider mapping to regions or numeric features instead. high · anthropic:default

n: 49
nulls: 0 (0.0%)
unique: 49
top_value: California
top_rate: 0.02041
cardinality: 49
entropy: 5.615
entropy_ratio: 1

veteran_population

numeric feature

This column represents the veteran population count for each of 49 geographic units (likely U.S. states or territories, given the count). All 49 rows are unique and non-null, consistent with one record per jurisdiction. The distribution is remarkably symmetric (skew ≈ -0.04) and platykurtic (kurtosis ≈ -1.34), meaning values are spread broadly and uniformly across a wide range from 61,090 to 1,786,891 with no outliers — an unusual flatness for a population variable, which typically skews right. Treatment: Use as-is or normalize per total state population to create a veteran rate before modelling. high · anthropic:default

n: 49
nulls: 0 (0.0%)
unique: 49
min: 61,090
max: 1.787e+06
mean: 8.446e+05
median: 932,756
std: 5.302e+05
q1: 298,167
q3: 1.283e+06
iqr: 984,585
skew: -0.04385
kurtosis: -1.344
n_outliers: 0
outlier_rate: 0
zero_rate: 0

total_population

numeric feature

This column represents total population counts for 49 distinct geographic units (likely US states or similar administrative regions), with every row populated and fully unique. Values span from 548,984 to 39,227,468 with a mean of ~18.8M and median of ~19.6M, suggesting a reasonably balanced distribution — the near-zero skew (0.10) and platykurtic kurtosis (-1.16) confirm a flat, spread-out distribution rather than a peaked one. The wide IQR of ~20.4M and std of ~12.2M reflect the natural size heterogeneity across regions, and notably there are zero detected outliers despite this spread. Treatment: Use as-is or consider per-capita normalization when combining with other count-based columns. high · anthropic:default

n: 49
nulls: 0 (0.0%)
unique: 49
min: 548,984
max: 3.923e+07
mean: 1.876e+07
median: 1.958e+07
std: 1.221e+07
q1: 7.056e+06
q3: 2.744e+07
iqr: 2.038e+07
skew: 0.1013
kurtosis: -1.158
n_outliers: 0
outlier_rate: 0
zero_rate: 0

veteran_percentage

numeric feature high_skew outliers

This column represents veteran percentage figures across 49 fully distinct, non-null records — likely a rate or share (%) of veterans in some population unit such as counties, districts, or organizations. The distribution is severely right-skewed (skew = 5.79, kurtosis = 34.86): the median is only 5.08 while the mean is pulled to 14.92 by extreme outliers. Most strikingly, the maximum value is 277.05, which exceeds 100% and is physically impossible for a percentage, strongly suggesting data quality issues — either unit errors (e.g., per-thousand rates mixed with percentages) or data entry errors among the 8 flagged outliers (outlier rate = 16.3%). Treatment: Investigate and correct values exceeding 100 before use; consider log-transform or winsorization after cleaning to address skew. high · anthropic:default

n: 49
nulls: 0 (0.0%)
unique: 49
min: 0.22
max: 277.1
mean: 14.92
median: 5.08
std: 40.37
q1: 1.7
q3: 7.83
iqr: 6.13
skew: 5.789
kurtosis: 34.86
n_outliers: 8
outlier_rate: 0.1633
zero_rate: 0