saturn

/home/coolhand/html/datavis/data_trove/data/wild/bigfoot_sightings.json 5,411 rows sample n=5,411 seed 42 2026-05-01T18:06:57+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/wild/bigfoot_sightings.json
Total rows5,411
Profiled sample5,411
Columns9
Generated2026-05-01T18:06:57+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 (10)
  • 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_011CacJ1amtU6srdbPkEWTL7'}
  • column:id: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_011CacJ1bLNKDR5R7mvXtnmT'}
  • 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_011CacJ1bqsnCo73RpZYyFGG'}
  • column:state_code: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_011CacJ1cKuQB2wnFKtaXfSS'}
  • column:county: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_011CacJ1cngH3HjE4HJs5dbC'}
  • column:url: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_011CacJ1dGTULj5m55tYqUwJ'}
  • column:month: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_011CacJ1djVEy1BGGP62RJmB'}
  • column:year: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_011CacJ1eQfPM4mTKvVFUHHS'}
  • column:classification: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_011CacJ1f1dMoA9tBJcfVgJJ'}
  • 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_011CacJ1fcLpQfQLczigExxK'}

Numeric correlation

id numeric

rows5,411
null0 (0.0%)
unique5,411
min60.000
max79,711
mean23,288
median16,598
std21,383
q14,898
q336,362
iqr31,464
skew0.911
kurtosis-0.151
n_outliers0
outlier_rate0.000
zero_rate0.000

state categorical

rows5,411
null0 (0.0%)
unique53
top_valueWashington
top_rate0.117
cardinality53
entropy5.025
entropy_ratio0.877
Top values (rank 1–20)
  1. Washington — 631
  2. California — 431
  3. Ohio — 317
  4. Florida — 314
  5. Oregon — 253
  6. Illinois — 239
  7. Texas — 238
  8. Michigan — 217
  9. Missouri — 161
  10. Georgia — 135
  11. Colorado — 128
  12. Pennsylvania — 125
  13. British Columbia — 122
  14. New York — 116
  15. Kentucky — 115
  16. Arkansas — 104
  17. Tennessee — 104
  18. West Virginia — 104
  19. Oklahoma — 101
  20. Idaho — 99

state_code categorical

rows5,411
null0 (0.0%)
unique53
top_valuewa
top_rate0.117
cardinality53
entropy5.025
entropy_ratio0.877
Top values (rank 1–20)
  1. wa — 631
  2. ca — 431
  3. oh — 317
  4. fl — 314
  5. or — 253
  6. il — 239
  7. tx — 238
  8. mi — 217
  9. mo — 161
  10. ga — 135
  11. co — 128
  12. pa — 125
  13. ca-bc — 122
  14. ny — 116
  15. ky — 115
  16. ar — 104
  17. tn — 104
  18. wv — 104
  19. ok — 101
  20. id — 99

county text

100.0% rows are a single word 95th-percentile length under 20 chars 81.1% duplicate strings
rows5,411
null0 (0.0%)
unique1,022
len_min0
len_max23
len_mean6.621
len_median7.000
len_p9510.000
word_mean1.000
word_median1.000
n_empty338
n_duplicates4,389
duplicate_rate0.811
vocab_size1,020
readability_flesch_mean16.897
emoji_rate0.000
url_rate0.000
one_word_rate1.000
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. Bibb
  2. Houston
  3. Lewis
  4. Cowlitz
  5. Montmorency
  7. Cass
  8. Skamania
  9. Ferry
  10. Navajo

url text

100.0% of rows are unique strings 100.0% rows are a single word 100.0% rows contain a URL
rows5,411
null0 (0.0%)
unique5,411
len_min46
len_max49
len_mean48.557
len_median49.000
len_p9549.000
word_mean1.000
word_median1.000
n_empty0
n_duplicates0
duplicate_rate0.000
vocab_size5,411
readability_flesch_mean-301.780
emoji_rate0.000
url_rate1.000
one_word_rate1.000
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. https://www.bfro.net/GDB/show_report.asp?id=21714
  2. https://www.bfro.net/GDB/show_report.asp?id=7604
  3. https://www.bfro.net/GDB/show_report.asp?id=12803
  4. https://www.bfro.net/GDB/show_report.asp?id=55658
  5. https://www.bfro.net/GDB/show_report.asp?id=27009
  6. https://www.bfro.net/GDB/show_report.asp?id=43994
  7. https://www.bfro.net/GDB/show_report.asp?id=14942
  8. https://www.bfro.net/GDB/show_report.asp?id=21473
  9. https://www.bfro.net/GDB/show_report.asp?id=25722
  10. https://www.bfro.net/GDB/show_report.asp?id=29358

month categorical

rows5,411
null160 (3.0%)
unique32
top_valueAugust
top_rate0.121
cardinality32
entropy3.807
entropy_ratio0.761
Top values (rank 1–20)
  1. August — 634
  2. October — 632
  3. July — 618
  4. September — 515
  5. June — 468
  6. November — 458
  7. May — 303
  8. April — 259
  9. December — 233
  10. January — 228
  11. Summer — 217
  12. March — 201
  13. February — 163
  14. Fall — 129
  15. Spring — 96
  16. Winter — 57
  17. Late — 6
  18. about — 6
  19. mid — 5
  20. or — 5

year numeric

rows5,411
null57 (1.1%)
unique99
min1,870
max2,025
mean1,998
median2,001
std15.785
q11,987
q32,009
iqr22.000
skew-0.974
kurtosis1.997
n_outliers49
outlier_rate9.15e-03
zero_rate0.000

classification categorical

rows5,411
null0 (0.0%)
unique3
top_valueClass B
top_rate0.503
cardinality3
entropy1.049
entropy_ratio0.662
Top values (rank 1–20)
  1. Class B — 2,722
  2. Class A — 2,655
  3. Class C — 34

description text

99.9% of rows are unique strings
rows5,411
null0 (0.0%)
unique5,407
len_min10
len_max221
len_mean67.042
len_median65.000
len_p95101.500
word_mean10.621
word_median10.000
n_empty0
n_duplicates4
duplicate_rate7.39e-04
vocab_size7,169
readability_flesch_mean55.705
emoji_rate0.000
url_rate0.000
one_word_rate0.000
allcaps_rate0.000
boilerplate_rate1.85e-04
Sample values (first 10)
  1. Rescue workers describes possible stalking on the Cahaba River outside Montevallo
  2. Possible bigfoot activity near Walker County line.
  3. Hikers off Lewis River Trail find large footprint east of Cougar
  4. Hunters on bikes have close encounter with a sasquatch near Randle
  5. Woman recalls daylight sighting while driving and a possible incident at a home east of Gaylord
  6. Possible sighting near Bowser on Vancouver Island
  7. County workers find possible footprints near Bena
  8. Man and girlfriend, camping, hear loud footsteps and tree knocking near Cispus, Washington
  9. Possible reoccurring activity at a hunting spot near Republic
  10. Brief daylight sighting within the city limits of Show Low