saturn

/home/coolhand/html/datavis/data_trove/data/natural_hazards/storms.json 14,770 rows sample n=14,770 seed 42 2026-05-01T18:38:10+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/natural_hazards/storms.json
Total rows14,770
Profiled sample14,770
Columns14
Generated2026-05-01T18:38:10+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 (15)
  • 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_011CacLPbU9crR5edxkipd1U'}
  • column:latitude: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_011CacLPbwgMfUkCGFzDeqFF'}
  • column:longitude: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_011CacLPcXQPJbeMUfo6i8gF'}
  • 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_011CacLPd2R9HAc1Tkmxc6DB'}
  • column:description: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_011CacLPdVh1X4SXd2YWyQSj'}
  • column:category: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_011CacLPdxUaakGAqukmDFjL'}
  • column:date: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_011CacLPecAUcWHMCKTChfss'}
  • column:country: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_011CacLPfRnANHtJ4aihmgyV'}
  • column:event_type: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_011CacLPgxZAzP8XRQhsKZGr'}
  • column:state: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_011CacLPhVYf2doriv3kKQDu'}
  • column:magnitude: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_011CacLPi4HDd57fenqqjkah'}
  • column:injuries: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_011CacLPia36Br3wRMP2DQsC'}
  • column:fatalities: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_011CacLPj4obkgD7TJpKus9J'}
  • column:damage_property: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_011CacLPjYpoZfH3XGntcMbz'}
  • column:source: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_011CacLPjz7sHUZkFo4GLBW3'}

Numeric correlation

Languages detected

Per-string language detection across text columns (sampled).

latitude numeric

rows14,770
null0 (0.0%)
unique7,810
min-14.324
max70.127
mean37.278
median37.120
std5.247
q133.630
q341.129
iqr7.499
skew-0.179
kurtosis3.341
n_outliers159
outlier_rate0.011
zero_rate0.000

longitude numeric

rows14,770
null0 (0.0%)
unique8,828
min-170.732
max171.469
mean-90.940
median-90.220
std11.696
q1-96.400
q3-84.230
iqr12.170
skew1.286
kurtosis55.608
n_outliers623
outlier_rate0.042
zero_rate0.000

name text

13 languages detected in sample 54.9% duplicate strings
rows14,770
null0 (0.0%)
unique6,660
len_min17
len_max134
len_mean30.219
len_median29.000
len_p9541.000
word_mean4.588
word_median4.000
n_empty0
n_duplicates8,110
duplicate_rate0.549
vocab_size1,980
readability_flesch_mean31.163
emoji_rate0.000
url_rate0.000
one_word_rate0.000
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. Tornado in LOUISIANA, CADDO
  2. Flood in LOUISIANA, BEAUREGARD
  3. Tornado in NORTH CAROLINA, ANSON
  4. Thunderstorm Wind in GEORGIA, NEWTON
  5. Hail in WISCONSIN, DODGE
  6. Flash Flood in MISSOURI, DENT
  7. Tornado in PENNSYLVANIA, LUZERNE
  8. Flash Flood in KENTUCKY, FRANKLIN
  9. Lightning in FLORIDA, PALM BEACH
  10. Tornado in SOUTH CAROLINA, DARLINGTON

description text

5 languages detected in sample 60.8% duplicate strings
rows14,770
null0 (0.0%)
unique5,796
len_min3
len_max259
len_mean50.085
len_median36.000
len_p95166.000
word_mean7.393
word_median5.000
n_empty0
n_duplicates8,974
duplicate_rate0.608
vocab_size4,289
readability_flesch_mean29.858
emoji_rate0.000
url_rate0.000
one_word_rate2.71e-04
allcaps_rate2.71e-04
boilerplate_rate0.000
Sample values (first 10)
  1. Magnitude 0; 40 injuries, 9 fatalities; $250K property damage
  2. $40.00M property damage
  3. $3.00M property damage
  4. EG55.00; 1 injuries, 1 fatalities; $20.00K property damage; A weak upper-level wave moving across the state resulted in widespread strong to severe thunderstorms across north and central Georgia.
  5. Magnitude 1.75; $3.17M property damage
  6. $15.00M property damage
  7. 5 injuries, 0 fatalities; $1.00M property damage
  8. 0 injuries, 1 fatalities
  9. 1 injuries, 1 fatalities
  10. Magnitude 0; 0 injuries, 1 fatalities; $25K property damage

category categorical

top value is 100.0% of rows
rows14,770
null0 (0.0%)
unique1
top_valuesignificant_us_storms
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. significant_us_storms — 14,770

date text

100.0% rows are a single word 100.0% rows are all-caps 95th-percentile length under 20 chars 65.8% duplicate strings
rows14,770
null0 (0.0%)
unique5,058
len_min10
len_max10
len_mean10.000
len_median10.000
len_p9510.000
word_mean1.000
word_median1.000
n_empty0
n_duplicates9,712
duplicate_rate0.658
vocab_size5,058
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. 1950-02-12
  2. 2016-03-10
  3. 2020-04-13
  4. 2018-06-25
  5. 2006-04-13
  6. 2024-11-05
  7. 2006-12-01
  8. 2021-12-11
  9. 2018-07-10
  10. 1961-04-12

country categorical

top value is 100.0% of rows
rows14,770
null0 (0.0%)
unique1
top_valueUSA
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. USA — 14,770

event_type categorical

rows14,770
null0 (0.0%)
unique17
top_valueTornado
top_rate0.429
cardinality17
entropy2.336
entropy_ratio0.572
Top values (rank 1–20)
  1. Tornado — 6,334
  2. Flash Flood — 2,358
  3. Thunderstorm Wind — 2,257
  4. Flood — 1,777
  5. Hail — 1,246
  6. Lightning — 574
  7. Heavy Rain — 99
  8. Marine Strong Wind — 43
  9. Debris Flow — 43
  10. Marine Thunderstorm Wind — 25
  11. Marine High Wind — 5
  12. Dust Devil — 3
  13. Waterspout — 2
  14. Tropical Storm — 1
  15. High Wind — 1
  16. Heat — 1
  17. Marine Lightning — 1

state categorical

rows14,770
null0 (0.0%)
unique65
top_valueTEXAS
top_rate0.098
cardinality65
entropy5.182
entropy_ratio0.861
Top values (rank 1–20)
  1. TEXAS — 1,450
  2. MISSOURI — 648
  3. ARKANSAS — 602
  4. MISSISSIPPI — 570
  5. GEORGIA — 562
  6. ILLINOIS — 560
  7. IOWA — 527
  8. LOUISIANA — 507
  9. TENNESSEE — 499
  10. FLORIDA — 498
  11. OKLAHOMA — 490
  12. NEBRASKA — 486
  13. ALABAMA — 469
  14. WISCONSIN — 463
  15. OHIO — 441
  16. MICHIGAN — 426
  17. NORTH CAROLINA — 422
  18. KANSAS — 418
  19. INDIANA — 408
  20. KENTUCKY — 383

magnitude categorical

51.8% null
rows14,770
null7,648 (51.8%)
unique170
top_value0
top_rate0.542
cardinality170
entropy3.586
entropy_ratio0.484
Top values (rank 1–20)
  1. 0 — 3,863
  2. 1.75 — 383
  3. 2.75 — 220
  4. 70.00 — 162
  5. 50.00 — 151
  6. 2.00 — 150
  7. 2.50 — 123
  8. 61.00 — 122
  9. 65.00 — 104
  10. 52.00 — 95
  11. 78.00 — 80
  12. 70 — 79
  13. 3.00 — 77
  14. 56.00 — 76
  15. 87.00 — 65
  16. 60.00 — 63
  17. 50 — 59
  18. 60 — 54
  19. 1.50 — 50
  20. 61 — 47

injuries categorical

rows14,770
null0 (0.0%)
unique178
top_value0
top_rate0.681
cardinality178
entropy2.468
entropy_ratio0.330
Top values (rank 1–20)
  1. 0 — 10,064
  2. 1 — 893
  3. 2 — 552
  4. 3 — 343
  5. 4 — 236
  6. 5 — 234
  7. 10 — 219
  8. 6 — 196
  9. 12 — 158
  10. 7 — 134
  11. 8 — 121
  12. 20 — 114
  13. 15 — 111
  14. 11 — 90
  15. 9 — 85
  16. 13 — 70
  17. 14 — 69
  18. 30 — 68
  19. 25 — 56
  20. 16 — 48

fatalities categorical

rows14,770
null0 (0.0%)
unique49
top_value0
top_rate0.691
cardinality49
entropy1.423
entropy_ratio0.254
Top values (rank 1–20)
  1. 0 — 10,209
  2. 1 — 3,208
  3. 2 — 649
  4. 3 — 222
  5. 4 — 112
  6. 5 — 74
  7. 6 — 66
  8. 7 — 38
  9. 9 — 25
  10. 10 — 24
  11. 8 — 21
  12. 11 — 20
  13. 13 — 11
  14. 16 — 10
  15. 12 — 9
  16. 14 — 8
  17. 17 — 6
  18. 20 — 6
  19. 25 — 4
  20. 23 — 3

damage_property text

100.0% rows are a single word 87.2% rows are all-caps 95th-percentile length under 20 chars 93.1% duplicate strings
rows14,770
null0 (0.0%)
unique1,014
len_min0
len_max8
len_mean4.381
len_median5.000
len_p957.000
word_mean1.000
word_median1.000
n_empty368
n_duplicates13,756
duplicate_rate0.931
vocab_size1,013
readability_flesch_mean116.977
emoji_rate0.000
url_rate0.000
one_word_rate1.000
allcaps_rate0.872
boilerplate_rate0.000
Sample values (first 10)
  1. 250K
  2. 40.00M
  3. 3.00M
  4. 20.00K
  5. 3.17M
  6. 15.00M
  7. 1.00M
  8. 0.00K
  9. 0.00K
  10. 25K

source categorical

top value is 100.0% of rows
rows14,770
null0 (0.0%)
unique1
top_valueNOAA Storm Events Database
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. NOAA Storm Events Database — 14,770