saturn

/home/coolhand/html/datavis/data_trove/data/quirky/geothermal.json 8,776 rows sample n=8,776 seed 42 2026-05-01T18:07:54+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/quirky/geothermal.json
Total rows8,776
Profiled sample8,776
Columns13
Generated2026-05-01T18:07:54+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 (14)
  • 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_011CacJ5n49jFjMR1Buzhkqs'}
  • 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_011CacJ5nSxy9Zf7GQ7KsnrK'}
  • column:lat: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_011CacJ5nsGdiNeg3uV3shQi'}
  • column:lon: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_011CacJ5oVUN4jb5dFBm4KVD'}
  • 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_011CacJ5ptK6HFnuUL8qw38Z'}
  • column: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_011CacJ5qjuYPX7vKwyG9dCq'}
  • column:temperature: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_011CacJ5rCCHchPApHrVM7Cu'}
  • column:wikipedia: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_011CacJ5rdVNtR98U6P8gx5N'}
  • 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_011CacJ5s4Y1HoKgK6FoNQzF'}
  • column:intermittent: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_011CacJ5t4opnrqQ2ZkKKghn'}
  • column:access: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_011CacJ5taZeVVwiJQSryWtm'}
  • column:tourism: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_011CacJ5wLktX6rMMSh1G8dG'}
  • column:osm_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_011CacJ5xJo6TWZJEpKvqFLo'}
  • column:osm_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_011CacJ5xp4aBa1eThjFQjh4'}

Numeric correlation

name text

25.3% rows are all-caps
rows8,776
null0 (0.0%)
unique8,316
len_min1
len_max60
len_mean17.099
len_median19.000
len_p9524.000
word_mean2.160
word_median2.000
n_empty0
n_duplicates460
duplicate_rate0.052
vocab_size9,610
readability_flesch_mean101.588
emoji_rate0.000
url_rate0.000
one_word_rate0.151
allcaps_rate0.253
boilerplate_rate0.000
Sample values (first 10)
  1. Sapphire Pool
  2. Resort
  3. Hot_Spring 1314069995
  4. Seismograph Pool
  5. Базова точка
  6. Hot_Spring 1332652552
  7. Hot_Spring 10157173617
  8. Hot_Spring 1317055945
  9. Hot_Spring 1313849084
  10. Горячий источник Кындыг-1

lat numeric

skew=-2.36 10.1% rows beyond 1.5 IQR
rows8,776
null0 (0.0%)
unique8,758
min-54.677
max70.961
mean34.775
median40.860
std18.125
q132.311
q344.532
iqr12.221
skew-2.360
kurtosis6.277
n_outliers889
outlier_rate0.101
zero_rate0.000

lon numeric

rows8,776
null0 (0.0%)
unique8,747
min-176.630
max179.359
mean-23.992
median-21.228
std89.393
q1-110.809
q344.149
iqr154.958
skew0.404
kurtosis-1.179
n_outliers0
outlier_rate0.000
zero_rate0.000

country categorical

5 singleton categories 99.9% null
rows8,776
null8,768 (99.9%)
unique6
top_valueIQ
top_rate0.375
cardinality6
entropy2.406
entropy_ratio0.931
Top values (rank 1–20)
  1. IQ — 3
  2. TW — 1
  3. MX — 1
  4. DE — 1
  5. RU — 1
  6. JP — 1

type categorical

rows8,776
null0 (0.0%)
unique2
top_valuehot_spring
top_rate0.807
cardinality2
entropy0.708
entropy_ratio0.708
Top values (rank 1–20)
  1. hot_spring — 7,082
  2. geyser — 1,694

temperature categorical

44 singleton categories 98.3% null
rows8,776
null8,628 (98.3%)
unique56
top_valuehot
top_rate0.514
cardinality56
entropy3.734
entropy_ratio0.643
Top values (rank 1–20)
  1. hot — 76
  2. 90 — 4
  3. 100 — 4
  4. 21 — 3
  5. 95 — 3
  6. 37 — 2
  7. 43 — 2
  8. 28 — 2
  9. 40 — 2
  10. 42 — 2
  11. 38 — 2
  12. 48 — 2
  13. 37-39° — 1
  14. 35-37 °C — 1
  15. 58°C — 1
  16. 52,1 — 1
  17. 25-30 — 1
  18. 98°C — 1
  19. 40-43° — 1
  20. 77 — 1

wikipedia categorical

119 singleton categories 98.5% null
rows8,776
null8,646 (98.5%)
unique124
top_valueen:Olympic Hot Springs
top_rate0.023
cardinality124
entropy6.924
entropy_ratio0.996
Top values (rank 1–20)
  1. en:Olympic Hot Springs — 3
  2. en:Fan and Mortar Geysers — 2
  3. ja:鉢形駅 — 2
  4. ja:男衾駅 — 2
  5. ru:Дачные горячие источники — 2
  6. is:Geysir — 1
  7. en:Wilbur Hot Springs — 1
  8. en:Morning Glory Pool — 1
  9. en:Giant Geyser — 1
  10. en:Great Fountain Geyser — 1
  11. fr:Echinus Geyser — 1
  12. en:Excelsior Geyser — 1
  13. en:Turquoise Pool — 1
  14. en:Opal Pool — 1
  15. en:Fishing Cone — 1
  16. is:Strokkur (hver) — 1
  17. de:Wallender Born — 1
  18. en:Fountain Paint Pot — 1
  19. de:Geysir Andernach — 1
  20. en:Old Faithful — 1

description categorical

131 singleton categories 98.1% null
rows8,776
null8,606 (98.1%)
unique141
top_valueMud geyser created from recent seismic activity
top_rate0.071
cardinality141
entropy6.894
entropy_ratio0.966
Top values (rank 1–20)
  1. Mud geyser created from recent seismic activity — 12
  2. 熱海七湯 — 5
  3. Free outdoor foot bath hot spring — 4
  4. Активная группа источников. входящая в состав Дачных горячих источников. Открыта и названа Кирсановым И.Т. и Кирсановой Т.П. в 1962 г. — 3
  5. Hot Spring — 3
  6. Exploitation traditionnelle — 3
  7. Горячие термальные источники — 3
  8. For 70/100 THB, possibility to get a private room — 2
  9. hot spring — 2
  10. Strong sulfur smell. ≈22°C, https://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania — 2
  11. The only true geyser in the state of Colorado. Frequency of the eruptions vary, 30 to 40 minute intervals are most common. The action is slight and boils 12-15 minutes emitting carbon dioxide and hydrogen sulfide gas. Temperature is usually 82.4 F. — 1
  12. Bad. Thapai Hot springs 300฿ tickets — 1
  13. Heilwasser mit leicht erhöhtem Arsengehalt — 1
  14. Вода содержит примеси кобальта — 1
  15. Termálna voda 60 stupňov — 1
  16. sulfur baths — 1
  17. Two blue fibreglass pools perched on a cliff, overlooking the river valley, surrounded by a wooden deck set amongst bush and forest. Pools are feed from a naturally hot thermal spring in the surrounding geology — 1
  18. 29.8-30 °C, 30-70 l/s https://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania — 1
  19. 29.7-30 °C, 5-50 l/s https://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania — 1
  20. Private hot spring pools — 1

intermittent categorical

97.9% null
rows8,776
null8,591 (97.9%)
unique2
top_valueno
top_rate0.919
cardinality2
entropy0.406
entropy_ratio0.406
Top values (rank 1–20)
  1. no — 170
  2. yes — 15

access categorical

99.0% null
rows8,776
null8,687 (99.0%)
unique5
top_valueyes
top_rate0.270
cardinality5
entropy2.194
entropy_ratio0.945
Top values (rank 1–20)
  1. yes — 24
  2. customers — 21
  3. private — 20
  4. no — 19
  5. permissive — 5

tourism categorical

97.5% null
rows8,776
null8,553 (97.5%)
unique10
top_valueattraction
top_rate0.870
cardinality10
entropy0.913
entropy_ratio0.275
Top values (rank 1–20)
  1. attraction — 194
  2. hotel — 9
  3. yes — 7
  4. camp_site — 3
  5. camp_site;loding — 3
  6. information — 2
  7. viewpoint — 2
  8. picnic_site — 1
  9. caravan_site — 1
  10. guest_house — 1

osm_id numeric

rows8,776
null0 (0.0%)
unique8,776
min27,750,092
max13,535,658,843
mean7,186,022,131
median8,262,841,268
std4,373,813,805
q11,334,332,064
q311,275,946,516
iqr9,941,614,452
skew-0.301
kurtosis-1.430
n_outliers0
outlier_rate0.000
zero_rate0.000

osm_type categorical

rows8,776
null0 (0.0%)
unique2
top_valuenode
top_rate0.764
cardinality2
entropy0.788
entropy_ratio0.788
Top values (rank 1–20)
  1. node — 6,705
  2. way — 2,071