saturn

/home/coolhand/html/datavis/data_trove/data/quirky/shipwrecks.json 5,569 rows sample n=5,569 seed 42 2026-05-01T18:07:22+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/quirky/shipwrecks.json
Total rows5,569
Profiled sample5,569
Columns14
Generated2026-05-01T18:07:22+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_011CacJ3Qkw6AJg5DNEkQQDu'}
  • 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_011CacJ3RCE2zcVkhHsAbFTE'}
  • 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_011CacJ3Rf1UrQh9xvgfzmX3'}
  • 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_011CacJ3S92xfVegCk1xFuLY'}
  • column:year_sunk: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_011CacJ3Sc4KM2kM41E6uW3g'}
  • 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_011CacJ3T7ZvZHrpDJiLA4Uq'}
  • 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_011CacJ3TbbSPp3ELMsPuJQo'}
  • column:wikidata: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_011CacJ3U3suKHiQzPtYnAo6'}
  • 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_011CacJ3UWQqPUQS9DCtuyea'}
  • 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_011CacJ3WBNVMyrXFWGsYEUz'}
  • 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_011CacJ3WnambR71Aobkr24R'}
  • column:depth: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_011CacJ3XEsLfPvrHUsMkHWo'}
  • 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_011CacJ3XmNGLtvkhwhnQFRQ'}
  • 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_011CacJ3YKrRySB9p9MMZJv9'}
  • 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_011CacJ3YqcN8NFsg2LGm9PL'}

Numeric correlation

name text

98.7% of rows are unique strings
rows5,569
null0 (0.0%)
unique5,497
len_min2
len_max153
len_mean17.813
len_median20.000
len_p9521.000
word_mean2.073
word_median2.000
n_empty0
n_duplicates72
duplicate_rate0.013
vocab_size6,255
readability_flesch_mean71.329
emoji_rate0.000
url_rate0.000
one_word_rate0.103
allcaps_rate0.017
boilerplate_rate0.000
Sample values (first 10)
  1. Nordland
  2. Probable USMC Landing Craft
  3. Ship Wreck
  4. Shipwreck 1183795103
  5. Shipwreck 6653835473
  6. Port Werburgh Concrete Barge
  7. Shipwreck 7075573076
  8. Shipwreck 1387382577
  9. Железобетонное судно типа "Викинг"
  10. U-869 (Wrack)

lat numeric

rows5,569
null0 (0.0%)
unique5,561
min-77.425
max82.171
mean28.414
median40.643
std31.355
q112.536
q350.357
iqr37.822
skew-1.136
kurtosis0.083
n_outliers112
outlier_rate0.020
zero_rate0.000

lon numeric

9.7% rows beyond 1.5 IQR
rows5,569
null0 (0.0%)
unique5,568
min-179.283
max179.447
mean1.413
median2.033
std76.754
q1-58.597
q322.131
iqr80.728
skew0.527
kurtosis0.244
n_outliers542
outlier_rate0.097
zero_rate0.000

year_sunk categorical

35 singleton categories 99.3% null
rows5,569
null5,532 (99.3%)
unique36
top_value1942
top_rate0.054
cardinality36
entropy5.155
entropy_ratio0.997
Top values (rank 1–20)
  1. 1942 — 2
  2. 30 June 1890 — 1
  3. 1854 — 1
  4. 1971 — 1
  5. 1937-09-02 — 1
  6. 1963-02 — 1
  7. 1643..1663 — 1
  8. 1982 — 1
  9. June 7, 1928 — 1
  10. 1435 — 1
  11. 1920-12-16 — 1
  12. 1490s — 1
  13. ~1700 — 1
  14. 20 April 1943 — 1
  15. 25 May 1963 — 1
  16. 1710 — 1
  17. 1915 — 1
  18. 1909 — 1
  19. 1951 — 1
  20. 1952 — 1

type categorical

17 singleton categories
rows5,569
null0 (0.0%)
unique30
top_valueshipwreck
top_rate0.912
cardinality30
entropy0.565
entropy_ratio0.115
Top values (rank 1–20)
  1. shipwreck — 5,081
  2. ship — 381
  3. barge — 27
  4. submarine — 18
  5. aircraft — 17
  6. plane — 10
  7. boat — 4
  8. vehicle — 3
  9. motor_vehicle — 3
  10. schooner — 2
  11. car — 2
  12. sailboat — 2
  13. battleship — 2
  14. steamer — 1
  15. airplane — 1
  16. freightcar — 1
  17. train — 1
  18. paddle steamer — 1
  19. motorbike — 1
  20. helicopter — 1

wikipedia categorical

303 singleton categories 94.4% null
rows5,569
null5,256 (94.4%)
unique307
top_valueen:SS Edmund Fitzgerald
top_rate0.013
cardinality307
entropy8.245
entropy_ratio0.998
Top values (rank 1–20)
  1. en:SS Edmund Fitzgerald — 4
  2. fr:Armorique (navire) — 2
  3. en:Curtiss C-46 Commando — 2
  4. en:USS Amesbury — 2
  5. en:SS America (1939) — 1
  6. ar:سفينة زيستل جورم — 1
  7. en:BOS 400 — 1
  8. en:New Carissa — 1
  9. en:MV Cita — 1
  10. en:SS Richard Montgomery — 1
  11. en:Kroombit Tops National Park#Crash site — 1
  12. en:Astron (ship) — 1
  13. en:SS Yongala — 1
  14. et:Raketa (laev, 1949) — 1
  15. en:USNS General Hoyt S. Vandenberg (T-AGM-10) — 1
  16. en:USS Oriskany (CV-34) — 1
  17. en:USS Massachusetts (BB-2) — 1
  18. en:Water Witch (schooner) — 1
  19. en:Burlington Bay Horse Ferry — 1
  20. en:Champlain II — 1

wikidata categorical

347 singleton categories 93.5% null
rows5,569
null5,208 (93.5%)
unique353
top_valueQ1286267
top_rate0.011
cardinality353
entropy8.446
entropy_ratio0.998
Top values (rank 1–20)
  1. Q1286267 — 4
  2. Q959696 — 2
  3. Q215692 — 2
  4. Q2862787 — 2
  5. Q1145708 — 2
  6. Q11675753 — 2
  7. Q463091 — 1
  8. Q32276 — 1
  9. Q115709756 — 1
  10. Q14213801 — 1
  11. Q2877353 — 1
  12. Q7006376 — 1
  13. Q6719379 — 1
  14. Q41771616 — 1
  15. Q7394285 — 1
  16. Q7420193 — 1
  17. Q1359321 — 1
  18. Q4811601 — 1
  19. Q1424289 — 1
  20. Q1618842 — 1

description categorical

269 singleton categories 93.9% null
rows5,569
null5,227 (93.9%)
unique291
top_valueWWII era concrete fuel barge converted into breakwater
top_rate0.041
cardinality291
entropy7.983
entropy_ratio0.975
Top values (rank 1–20)
  1. WWII era concrete fuel barge converted into breakwater — 14
  2. Wrecks — 7
  3. WWII concrete barge sunk as part of jetty, partially covered by jetty and fill — 5
  4. Location is based on divers hand drawn maps. Due to the wreak breaking up and salvage, the wreak is scattered over a large area. — 4
  5. Partially sunken ships — 4
  6. Concrete petrol barge sunk as part of breakwater — 4
  7. Wrecks of Zulu fishing boats — 3
  8. Chaloupe abandonnée à terre — 3
  9. WWII era concrete fuel barge sunk as part of jetty foundation — 3
  10. Armada Ship — 2
  11. remains of sunken wooden boats — 2
  12. Hundido el 3 de julio de 1898 durante la batalla naval de Santiago de Cuba en la Guerra Hispano-Cubana-Norteamericana. — 2
  13. 09/09/2006 : Epave en bois, longue de 20 mètres, large de 4 mètres et haute de 3 mètres. — 2
  14. Steamer — 2
  15. Iron-hulled barque — 2
  16. On shore wreck of a small abandoned wooden ship. — 2
  17. Épave — 2
  18. Dojście do wraków w zasadzie wolne. Jednak mogą wystąpić sytuacje gdy będzie to utrudnione lub niemożliwe. — 2
  19. Wrecked sealing vessel — 2
  20. Staten Island boat graveyard — 2

heritage categorical

3 singleton categories 99.8% null
rows5,569
null5,556 (99.8%)
unique4
top_value2
top_rate0.769
cardinality4
entropy1.145
entropy_ratio0.573
Top values (rank 1–20)
  1. 2 — 10
  2. no — 1
  3. yes — 1
  4. 1 — 1

access categorical

90.9% null
rows5,569
null5,061 (90.9%)
unique8
top_valueyes
top_rate0.669
cardinality8
entropy1.649
entropy_ratio0.550
Top values (rank 1–20)
  1. yes — 340
  2. no — 73
  3. permit — 27
  4. private — 27
  5. unknown — 20
  6. permissive — 17
  7. customers — 3
  8. foot — 1

depth categorical

120 singleton categories 96.3% null
rows5,569
null5,361 (96.3%)
unique154
top_value7
top_rate0.029
cardinality154
entropy7.085
entropy_ratio0.975
Top values (rank 1–20)
  1. 7 — 6
  2. 30m — 4
  3. 16 — 4
  4. 14 — 4
  5. 8 — 4
  6. 10 — 4
  7. 25m — 3
  8. 12.2 — 3
  9. 15.6 — 3
  10. 15 — 3
  11. 4 — 3
  12. 5 — 3
  13. 6.1 — 2
  14. -0.3 — 2
  15. 97 — 2
  16. 11 — 2
  17. 6.4 — 2
  18. 42 — 2
  19. 18 — 2
  20. 3 — 2

seamark_type categorical

top value is 98.4% of rows
rows5,569
null459 (8.2%)
unique10
top_valuewreck
top_rate0.984
cardinality10
entropy0.148
entropy_ratio0.044
Top values (rank 1–20)
  1. wreck — 5,026
  2. hulk — 56
  3. shoreline_construction — 14
  4. obstruction — 7
  5. harbour — 2
  6. restricted_area — 1
  7. plane — 1
  8. beacon_special_purpose — 1
  9. landmark — 1
  10. no — 1

osm_id numeric

rows5,569
null0 (0.0%)
unique5,569
min13,059,633
max13,535,646,301
mean4,031,676,969
median2,348,528,796
std3,874,691,690
q11,181,359,593
q36,516,228,547
iqr5,334,868,954
skew1.071
kurtosis-0.204
n_outliers0
outlier_rate0.000
zero_rate0.000

osm_type categorical

rows5,569
null0 (0.0%)
unique2
top_valuenode
top_rate0.656
cardinality2
entropy0.928
entropy_ratio0.928
Top values (rank 1–20)
  1. node — 3,656
  2. way — 1,913