saturn

/home/coolhand/html/datavis/data_trove/data/policy/veterans/merged_county_analysis.csv 3,144 rows sample n=3,144 seed 42 2026-05-01T17:52:13+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/policy/veterans/merged_county_analysis.csv
Total rows3,144
Profiled sample3,144
Columns18
Generated2026-05-01T17:52:13+00:00

Insights opt-in

Model-generated narrative. These are opinions, not facts — the stats below are what saturn measured. Generated by: anthropic:claude-opus-4-7.

Errors during insight pass (19)
  • dataset:__global__:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtNSunW313EZ6N4BZt'}
  • column:STATEFP:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtNzeizLvLovtYuS81'}
  • column:COUNTYFP:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtPUvgJ3WEeRa1qemy'}
  • column:COUNTYNS:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtPygfUXvqfrT1S6u7'}
  • column:GEOIDFQ:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtQWgUddSXUm4Q7hqz'}
  • column:GEOID:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtR3Bhhca5ed65ammP'}
  • column:NAME:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtRUERmyScWxhNs3Hx'}
  • column:NAMELSAD:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtSjt94xvzguhVdYZP'}
  • column:STUSPS:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtTW22tnjvzoR3TzkY'}
  • column:STATE_NAME:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtU4W3Ggx1VudnJGvp'}
  • column:LSAD:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtUa1q6fvo4J1PyYgf'}
  • column:ALAND:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtVFCNBmA2842WQvXR'}
  • column:AWATER:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtVseWa4HRyxauJFp7'}
  • column:fips:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtWKgNtu563uz4dcvr'}
  • column:active_duty_est:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtWuuKo7JvjwM92VgT'}
  • column:veterans_est:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtXTQ9B8NhWbuN8n3f'}
  • column:total_pop:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtXy9swJXw1rBf9o1y'}
  • column:active_duty_per_10k:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtYQh4s3tgBqt8AmPr'}
  • column:veterans_per_100:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacGtYqEtCiS9xFFrtkHR'}

Numeric correlation

STATEFP numeric

rows3,144
null0 (0.0%)
unique51
min1.000
max56.000
mean30.264
median29.000
std15.153
q118.000
q345.000
iqr27.000
skew-0.081
kurtosis-1.099
n_outliers0
outlier_rate0.000
zero_rate0.000

COUNTYFP numeric

skew=+2.84 5.6% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique329
min1.000
max840.000
mean103.874
median79.000
std107.567
q135.000
q3133.500
iqr98.500
skew2.841
kurtosis11.377
n_outliers176
outlier_rate0.056
zero_rate0.000

COUNTYNS numeric

rows3,144
null0 (0.0%)
unique3,144
min23,901
max2,830,254
mean950,290
median974,128
std516,824
q1484,978
q31,384,001
iqr899,024
skew0.172
kurtosis-0.802
n_outliers11
outlier_rate3.50e-03
zero_rate0.000

GEOIDFQ text

100.0% of rows are unique strings 100.0% rows are a single word 100.0% rows are all-caps 95th-percentile length under 20 chars
rows3,144
null0 (0.0%)
unique3,144
len_min14
len_max14
len_mean14.000
len_median14.000
len_p9514.000
word_mean1.000
word_median1.000
n_empty0
n_duplicates0
duplicate_rate0.000
vocab_size3,144
readability_flesch_mean121.220
emoji_rate0.000
url_rate0.000
one_word_rate1.000
allcaps_rate1.000
boilerplate_rate0.000
Sample values (first 10)
  1. 0500000US01119
  2. 0500000US40123
  3. 0500000US38089
  4. 0500000US31001
  5. 0500000US51009
  6. 0500000US35029
  7. 0500000US39061
  8. 0500000US42079
  9. 0500000US48485
  10. 0500000US49023

GEOID numeric

rows3,144
null0 (0.0%)
unique3,144
min1,001
max56,045
mean30,368
median29,174
std15,170
q118,174
q345,080
iqr26,905
skew-0.079
kurtosis-1.099
n_outliers0
outlier_rate0.000
zero_rate0.000

NAME text

93.4% rows are a single word 95th-percentile length under 20 chars 41.5% duplicate strings
rows3,144
null0 (0.0%)
unique1,838
len_min3
len_max30
len_mean7.050
len_median7.000
len_p9511.000
word_mean1.072
word_median1.000
n_empty0
n_duplicates1,306
duplicate_rate0.415
vocab_size1,875
readability_flesch_mean36.735
emoji_rate0.000
url_rate0.000
one_word_rate0.934
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. Sumter
  2. Pontotoc
  3. Stark
  4. Adams
  5. Amherst
  6. Luna
  7. Hamilton
  8. Luzerne
  9. Wichita
  10. Juab

NAMELSAD text

95th-percentile length under 20 chars 40.1% duplicate strings
rows3,144
null0 (0.0%)
unique1,882
len_min10
len_max46
len_mean14.084
len_median14.000
len_p9518.000
word_mean2.080
word_median2.000
n_empty0
n_duplicates1,262
duplicate_rate0.401
vocab_size1,883
readability_flesch_mean35.292
emoji_rate0.000
url_rate0.000
one_word_rate0.000
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. Sumter County
  2. Pontotoc County
  3. Stark County
  4. Adams County
  5. Amherst County
  6. Luna County
  7. Hamilton County
  8. Luzerne County
  9. Wichita County
  10. Juab County

STUSPS categorical

rows3,144
null0 (0.0%)
unique51
top_valueTX
top_rate0.081
cardinality51
entropy5.277
entropy_ratio0.930
Top values (rank 1–20)
  1. TX — 254
  2. GA — 159
  3. VA — 133
  4. KY — 120
  5. MO — 115
  6. KS — 105
  7. IL — 102
  8. NC — 100
  9. IA — 99
  10. TN — 95
  11. NE — 93
  12. IN — 92
  13. OH — 88
  14. MN — 87
  15. MI — 83
  16. MS — 82
  17. OK — 77
  18. AR — 75
  19. WI — 72
  20. AL — 67

STATE_NAME categorical

rows3,144
null0 (0.0%)
unique51
top_valueTexas
top_rate0.081
cardinality51
entropy5.277
entropy_ratio0.930
Top values (rank 1–20)
  1. Texas — 254
  2. Georgia — 159
  3. Virginia — 133
  4. Kentucky — 120
  5. Missouri — 115
  6. Kansas — 105
  7. Illinois — 102
  8. North Carolina — 100
  9. Iowa — 99
  10. Tennessee — 95
  11. Nebraska — 93
  12. Indiana — 92
  13. Ohio — 88
  14. Minnesota — 87
  15. Michigan — 83
  16. Mississippi — 82
  17. Oklahoma — 77
  18. Arkansas — 75
  19. Wisconsin — 72
  20. Alabama — 67

LSAD categorical

top value is 95.4% of rows
rows3,144
null0 (0.0%)
unique9
top_value06
top_rate0.954
cardinality9
entropy0.371
entropy_ratio0.117
Top values (rank 1–20)
  1. 06 — 2,999
  2. 15 — 64
  3. 25 — 40
  4. 04 — 13
  5. 05 — 11
  6. PL — 9
  7. 03 — 4
  8. 00 — 2
  9. 12 — 2

ALAND numeric

skew=+26.82 11.5% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique3,144
min5,300,262
max377,055,293,513
mean2,910,687,221
median1,594,401,059
std9,305,576,678
q11,116,442,350
q32,393,787,080
iqr1,277,344,730
skew26.821
kurtosis953.230
n_outliers362
outlier_rate0.115
zero_rate0.000

AWATER numeric

skew=+13.18 14.0% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique3,144
min0.000
max25,989,628,379
mean222,044,737
median19,389,010
std1,241,426,292
q17,131,561
q359,462,367
iqr52,330,806
skew13.183
kurtosis210.807
n_outliers440
outlier_rate0.140
zero_rate3.18e-04

fips numeric

rows3,144
null0 (0.0%)
unique3,144
min1,001
max56,045
mean30,368
median29,174
std15,170
q118,174
q345,080
iqr26,905
skew-0.079
kurtosis-1.099
n_outliers0
outlier_rate0.000
zero_rate0.000

active_duty_est numeric

skew=+13.14 14.3% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique3,028
min36.000
max5,240,842
mean53,783
median11,698
std176,263
q14,722
q332,590
iqr27,868
skew13.138
kurtosis288.571
n_outliers449
outlier_rate0.143
zero_rate0.000

veterans_est numeric

skew=+8.01 13.0% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique2,424
min0.000
max244,160
mean5,419
median1,548
std13,105
q1634.750
q34,428
iqr3,793
skew8.014
kurtosis100.022
n_outliers408
outlier_rate0.130
zero_rate3.18e-04

total_pop numeric

skew=+13.17 14.0% rows beyond 1.5 IQR
rows3,144
null0 (0.0%)
unique3,080
min50.000
max9,936,690
mean105,311
median25,784
std333,792
q110,836
q368,080
iqr57,244
skew13.175
kurtosis289.761
n_outliers440
outlier_rate0.140
zero_rate0.000

active_duty_per_10k numeric

rows3,144
null0 (0.0%)
unique3,144
min1,708
max7,200
mean4,694
median4,733
std592.219
q14,331
q35,102
iqr771.582
skew-0.377
kurtosis0.842
n_outliers57
outlier_rate0.018
zero_rate0.000

veterans_per_100 numeric

rows3,144
null0 (0.0%)
unique3,143
min0.000
max18.087
mean6.190
median5.985
std1.998
q14.920
q37.136
iqr2.216
skew0.880
kurtosis2.029
n_outliers125
outlier_rate0.040
zero_rate3.18e-04