saturn

/home/coolhand/html/datavis/data_trove/data/quirky/lighthouses.json 14,585 rows sample n=14,585 seed 42 2026-05-01T18:36:44+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/quirky/lighthouses.json
Total rows14,585
Profiled sample14,585
Columns13
Generated2026-05-01T18:36:44+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_011CacLHJifjNT5ZCBbPcFGS'}
  • 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_011CacLHKCwDxjaQK1M3pGWd'}
  • 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_011CacLHKfUGQvGbP7wxGoAo'}
  • 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_011CacLHL4HSSJ8N5Wp2trZ1'}
  • 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_011CacLHLU64wrGcoRNVWpEN'}
  • column:height: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_011CacLHLwNPqfFuTa5geqoK'}
  • column:year_built: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_011CacLHMTd17QiM6z5dzDtM'}
  • column:operator: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_011CacLHMysa4AecWdLezunE'}
  • column:seamark_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_011CacLHNTQ8ruuSj3URiaUU'}
  • column:light_character: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_011CacLHNwBBLmMhknbect4s'}
  • column:heritage: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_011CacLHPSS7M2Pp4JBGkz64'}
  • 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_011CacLHQ6NYNZzQ8avLXpxB'}
  • 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_011CacLHQYfKLCTTQo6xnyCA'}
  • 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_011CacLHR2vuvqvttHa4Hzjm'}

Numeric correlation

name text

97.6% of rows are unique strings
rows14,585
null0 (0.0%)
unique14,239
len_min2
len_max91
len_mean18.948
len_median21.000
len_p9527.000
word_mean2.327
word_median2.000
n_empty0
n_duplicates346
duplicate_rate0.024
vocab_size14,670
readability_flesch_mean75.784
emoji_rate0.000
url_rate0.000
one_word_rate0.107
allcaps_rate0.058
boilerplate_rate0.000
Sample values (first 10)
  1. Far de Capdepera
  2. Lighthouse 12736917711
  3. 出雲日御碕灯台
  4. Pilsumer Leuchtturm
  5. Lighthouse 3592895556
  6. Hải đăng Vạn Ca
  7. Lighthouse 3954003290
  8. Lighthouse 666429022
  9. Farol do Bugio
  10. Vejsnæs Nakke

lat numeric

8.9% rows beyond 1.5 IQR
rows14,585
null0 (0.0%)
unique14,572
min-63.396
max81.800
mean34.520
median40.812
std24.643
q128.111
q348.983
iqr20.871
skew-1.458
kurtosis2.028
n_outliers1,295
outlier_rate0.089
zero_rate0.000

lon numeric

rows14,585
null0 (0.0%)
unique14,565
min-179.197
max179.340
mean23.039
median14.975
std79.396
q1-40.500
q3112.445
iqr152.945
skew0.053
kurtosis-0.954
n_outliers0
outlier_rate0.000
zero_rate0.000

country categorical

11 singleton categories 99.6% null
rows14,585
null14,524 (99.6%)
unique19
top_valueLV
top_rate0.295
cardinality19
entropy3.442
entropy_ratio0.810
Top values (rank 1–20)
  1. LV — 18
  2. DE — 8
  3. EE — 7
  4. HT — 6
  5. US — 5
  6. GB — 2
  7. PT — 2
  8. IM — 2
  9. JP — 1
  10. KY — 1
  11. PH — 1
  12. IN — 1
  13. FI — 1
  14. PL — 1
  15. IT — 1
  16. RU — 1
  17. UZ — 1
  18. MX — 1
  19. TW — 1

height categorical

197 singleton categories 90.2% null
rows14,585
null13,153 (90.2%)
unique316
top_value15
top_rate0.041
cardinality316
entropy6.837
entropy_ratio0.823
Top values (rank 1–20)
  1. 15 — 59
  2. 12 — 55
  3. 14 — 54
  4. 10 — 51
  5. 8 — 45
  6. 18 — 44
  7. 20 — 43
  8. 13 — 38
  9. 6 — 37
  10. 17 — 33
  11. 25 — 31
  12. 11 — 28
  13. 30 — 28
  14. 16 — 27
  15. 23 — 26
  16. 21 — 21
  17. 19 — 20
  18. 28 — 19
  19. 9 — 19
  20. 26 — 18

year_built categorical

271 singleton categories 93.2% null
rows14,585
null13,593 (93.2%)
unique429
top_valueC19
top_rate0.031
cardinality429
entropy8.142
entropy_ratio0.931
Top values (rank 1–20)
  1. C19 — 31
  2. 1875 — 16
  3. 1872 — 15
  4. 1881 — 12
  5. C20 — 12
  6. 1906 — 11
  7. 1871 — 11
  8. 1877 — 11
  9. 1882 — 11
  10. 1874 — 11
  11. 1873 — 11
  12. 1939 — 10
  13. 1898 — 10
  14. 1897 — 9
  15. 1870 — 9
  16. 1909 — 8
  17. 1884 — 8
  18. 1890 — 8
  19. 1911 — 7
  20. 1950 — 7

operator categorical

167 singleton categories 92.7% null
rows14,585
null13,520 (92.7%)
unique283
top_valueU.S. Coast Guard
top_rate0.077
cardinality283
entropy7.013
entropy_ratio0.861
Top values (rank 1–20)
  1. U.S. Coast Guard — 82
  2. Plovput — 49
  3. INEA — 42
  4. Tagbilaran Station, Philippine Coast Guard — 27
  5. Cebu Station, Philippine Coast Guard — 26
  6. Catbalogan Station, Philippine Coast Guard — 18
  7. Surigao Station, Philippine Coast Guard — 18
  8. Masbate Station, Philippine Coast Guard — 17
  9. Maasin Station, Philippine Coast Guard — 17
  10. 海上保安庁 — 16
  11. Directorate General of Lighthouses and Lightships — 15
  12. Romblon Station, Philippine Coast Guard — 15
  13. Iloilo Station, Philippine Coast Guard — 14
  14. Puerto Princesa Station, Philippine Coast Guard — 14
  15. Bacolod Station, Philippine Coast Guard — 13
  16. Sorsogon Station, Philippine Coast Guard — 13
  17. Cagayan de Oro Station, Philippine Coast Guard — 13
  18. Marine Department of Sabah — 13
  19. Dumaguete Station, Philippine Coast Guard — 12
  20. Appari Station, Philippine Coast Guard — 12

seamark_type categorical

48.0% null
rows14,585
null7,002 (48.0%)
unique25
top_valuelight_minor
top_rate0.461
cardinality25
entropy1.657
entropy_ratio0.357
Top values (rank 1–20)
  1. light_minor — 3,496
  2. light_major — 3,051
  3. landmark — 716
  4. beacon_special_purpose — 146
  5. beacon_lateral — 102
  6. beacon_cardinal — 19
  7. light — 9
  8. beacon — 5
  9. beacon_isolated_danger — 5
  10. building — 4
  11. daymark — 4
  12. radio_station — 3
  13. pile — 3
  14. signal_station_traffic — 3
  15. signal_station_warning — 3
  16. buoy_lateral — 3
  17. navigation_line — 2
  18. fishing_facility — 2
  19. light_vessel — 1
  20. cone — 1

light_character categorical

71.3% null
rows14,585
null10,401 (71.3%)
unique19
top_valueFl
top_rate0.747
cardinality19
entropy1.503
entropy_ratio0.354
Top values (rank 1–20)
  1. Fl — 3,126
  2. Iso — 249
  3. F — 245
  4. Q — 182
  5. Oc — 151
  6. LFl — 148
  7. VQ — 24
  8. Al.Fl — 24
  9. Mo — 14
  10. FFl — 4
  11. Al — 4
  12. IQ — 3
  13. Al.LFl — 2
  14. Al.Oc — 2
  15. Q+LFl — 2
  16. IVQ — 1
  17. Fl(2) — 1
  18. LFl W 10s — 1
  19. Al.Iso — 1

heritage categorical

96.9% null
rows14,585
null14,132 (96.9%)
unique7
top_value2
top_rate0.757
cardinality7
entropy1.244
entropy_ratio0.443
Top values (rank 1–20)
  1. 2 — 343
  2. 3 — 52
  3. 4 — 26
  4. yes — 25
  5. 1 — 4
  6. regional — 2
  7. no — 1

wikipedia text

97.9% of rows are unique strings 86.2% null
rows14,585
null12,577 (86.2%)
unique1,965
len_min6
len_max55
len_mean22.296
len_median22.000
len_p9533.000
word_mean2.996
word_median3.000
n_empty0
n_duplicates43
duplicate_rate0.021
vocab_size2,370
readability_flesch_mean48.916
emoji_rate0.000
url_rate0.000
one_word_rate0.076
allcaps_rate0.000
boilerplate_rate0.000
Sample values (first 10)
  1. de:Neuer Leuchtturm Borkum
  2. hr:Svjetionik Hrid Blitvenica
  3. en:Gay Head Light
  4. ja:葛登支岬灯台
  5. en:Sentinel Island Light
  6. it:Faro di Scilla
  7. es:Faro Punta Bajos
  8. en:Grassy Island Range Lights
  9. fr:Phare de Kéréon
  10. fr:Phare de Tuskar Rock

osm_id numeric

rows14,585
null0 (0.0%)
unique14,584
min13,391,742
max13,525,496,137
mean3,722,756,855
median1,574,285,300
std3,828,250,124
q11,000,644,758
q36,401,686,693
iqr5,401,041,935
skew1.073
kurtosis-0.199
n_outliers0
outlier_rate0.000
zero_rate0.000

osm_type categorical

rows14,585
null0 (0.0%)
unique2
top_valuenode
top_rate0.779
cardinality2
entropy0.762
entropy_ratio0.762
Top values (rank 1–20)
  1. node — 11,358
  2. way — 3,227