saturn

/home/coolhand/html/datavis/data_trove/data/wild/ghost_sightings.csv 10,992 rows sample n=10,992 seed 42 2026-05-01T18:37:32+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/wild/ghost_sightings.csv
Total rows10,992
Profiled sample10,992
Columns12
Generated2026-05-01T18:37:32+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 (13)
  • 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_011CacLLqdMtWh8hbXz22Uzq'}
  • column:city: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_011CacLLrJnzvmsfkqNGmg5q'}
  • 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_011CacLLs3SodGMqUsWQyzJB'}
  • 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_011CacLLsRmFjVdSBw7zeL5K'}
  • column:location: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_011CacLLssYnZ4sZCmvLJEv6'}
  • 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_011CacLLtZDzp3MrN1KeY2Sh'}
  • column:state_abbrev: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_011CacLLuV2zSVv2U9oYyqhz'}
  • 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_011CacLLut6pY6dTgcdE8KhC'}
  • 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_011CacLLviD2xXs7fDJR9XBQ'}
  • column:city_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_011CacLLwkiJfv6Yp7x98x3R'}
  • column:city_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_011CacLLxGDYMn2YVmyubWqw'}
  • column:location_2: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_011CacLLxkjkgpTFUSwCS9D6'}
  • column:city_location: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_011CacLLyMxCN8cwsMSZ7z85'}

Numeric correlation

city text

73.2% rows are a single word 95th-percentile length under 20 chars 60.1% duplicate strings
rows10,992
null3 (0.0%)
unique4,385
len_min3
len_max49
len_mean9.043
len_median9.000
len_p9514.000
word_mean1.291
word_median1.000
n_empty0
n_duplicates6,604
duplicate_rate0.601
vocab_size3,988
readability_flesch_mean20.488
emoji_rate0.000
url_rate9.10e-05
one_word_rate0.732
allcaps_rate4.55e-04
boilerplate_rate0.000
Sample values (first 10)
  1. Ann Arbor
  2. Forest Park
  3. Fernandina
  4. Gregg
  5. Sheridan
  6. Greenville
  7. Dawson Springs
  8. Higginsville
  9. Houston
  10. Pontiac

country categorical

top value is 100.0% of rows
rows10,992
null0 (0.0%)
unique1
top_valueUnited States
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. United States — 10,992

description text

100.0% of rows are unique strings
rows10,992
null0 (0.0%)
unique10,987
len_min2
len_max5,280
len_mean380.032
len_median297.000
len_p95954.000
word_mean70.331
word_median55.000
n_empty0
n_duplicates5
duplicate_rate4.55e-04
vocab_size33,001
readability_flesch_mean69.672
emoji_rate0.000
url_rate5.09e-03
one_word_rate1.82e-04
allcaps_rate6.37e-04
boilerplate_rate6.46e-03
Sample values (first 10)
  1. Story goes some time in the late 70s a student named Mary (last name never mentioned) who, while working on some lighting fixtures alone one day, fell from the catwalks head first and died upon the stage. Sightings include actors and stagehands seeing a girl up in the catwalks we…
  2. There is also a women whom wears a white dress that sings a lullaby to a small infant she carries with her. She is usually seen at dusk but has also been seen during reenactments of the battle.
  3. Fort Clinch is an old Union Civil War fort that was never finished due to of lack of funding from the government. During construction, the fort was ambushed quite a few times by Confederate troops. Several of the Union men died in the process. One incident included a man who was …
  4. Old Caddo Indian museum - Museum off Farmed Market road also known as loop 1845 has been closed down for many years. The museum displayed artifacts that were found in burial sites in East Texas. Several people have seen a little ghost girl standing beside the road or in front of …
  5. there have been many strange and unusual happening in the building, mostly at night when a lonely deputy is on duty making copies in the office or just simply sitting down and having a cup of coffee, Report seeing people out of the corner of their eye when the building is empty. …
  6. Update: also known as Devil's Castle - Has since burned down - Reports of footsteps that break into a run, then screams, on the first floor. On the third floor feelings of being pushed accompanied by loud clattering in the hall and items moving, and apparitions. Singing has been …
  7. Numerous incidents have been reported over the years at this small cemetery just outside Dawson Springs. Glowing eyes, ghosts of the dead, things appearing and disappearing.
  8. There is the confederate park is across the street it is a state park and has many graves of confederate and union soldiers and you may check it out because it is rumored to be haunted as well.
  9. Most of the times when students are walking alone they feel the presence of some one following them, but only on the third floor. Many students have said they have seen a young girl running down the halls.
  10. This corporate office is haunted by the spirit of women who was brutally murdered by her husband in the purchasing department. Officer Dolinski who is a security officer has spotted her ghost on numerous occasions and is said that people have instantly soiled themselves.

location text

rows10,992
null3 (0.0%)
unique9,903
len_min2
len_max1,016
len_mean19.299
len_median17.000
len_p9534.000
word_mean2.976
word_median3.000
n_empty0
n_duplicates1,086
duplicate_rate0.099
vocab_size8,232
readability_flesch_mean45.794
emoji_rate0.000
url_rate0.000
one_word_rate0.063
allcaps_rate3.37e-03
boilerplate_rate0.000
Sample values (first 10)
  1. Huron High School theatre.
  2. Chickamauga Battle Fields
  3. Fort Clinch
  4. Memorial Middle School
  5. The Historic Sheridan Inn
  6. Old Tuberculosis Hospital
  7. Olney Road
  8. Confederate Park
  9. Austin high school
  10. Johnson Controls

state categorical

rows10,992
null0 (0.0%)
unique51
top_valueCalifornia
top_rate0.097
cardinality51
entropy5.194
entropy_ratio0.916
Top values (rank 1–20)
  1. California — 1,070
  2. Texas — 696
  3. Pennsylvania — 649
  4. Michigan — 529
  5. Ohio — 477
  6. New York — 459
  7. Illinois — 395
  8. Kentucky — 370
  9. Indiana — 351
  10. Massachusetts — 342
  11. Florida — 328
  12. Missouri — 314
  13. Georgia — 289
  14. Wisconsin — 274
  15. Alabama — 224
  16. Tennessee — 221
  17. Washington — 218
  18. Oklahoma — 211
  19. North Carolina — 211
  20. New Jersey — 194

state_abbrev categorical

rows10,992
null0 (0.0%)
unique51
top_valueCA
top_rate0.097
cardinality51
entropy5.194
entropy_ratio0.916
Top values (rank 1–20)
  1. CA — 1,070
  2. TX — 696
  3. PA — 649
  4. MI — 529
  5. OH — 477
  6. NY — 459
  7. IL — 395
  8. KY — 370
  9. IN — 351
  10. MA — 342
  11. FL — 328
  12. MO — 314
  13. GA — 289
  14. WI — 274
  15. AL — 224
  16. TN — 221
  17. WA — 218
  18. OK — 211
  19. NC — 211
  20. NJ — 194

longitude numeric

rows10,992
null1,261 (11.5%)
unique8,774
min-164.722
max168.697
mean-91.997
median-87.231
std17.686
q1-99.119
q3-80.304
iqr18.816
skew0.251
kurtosis15.196
n_outliers131
outlier_rate0.013
zero_rate0.000

latitude numeric

rows10,992
null1,261 (11.5%)
unique8,775
min-45.024
max66.893
mean38.343
median39.280
std5.259
q134.676
q341.873
iqr7.197
skew-0.971
kurtosis11.384
n_outliers124
outlier_rate0.013
zero_rate0.000

city_longitude numeric

rows10,992
null29 (0.3%)
unique5,222
min-164.724
max-67.840
mean-91.909
median-87.090
std16.401
q1-98.493
q3-80.506
iqr17.987
skew-1.155
kurtosis1.328
n_outliers128
outlier_rate0.012
zero_rate0.000

city_latitude numeric

rows10,992
null29 (0.3%)
unique5,310
min19.576
max66.898
mean38.377
median39.283
std5.067
q134.738
q341.847
iqr7.109
skew-0.325
kurtosis1.478
n_outliers128
outlier_rate0.012
zero_rate0.000

location_2 text

100.0% rows are all-caps
rows10,992
null1,261 (11.5%)
unique8,776
len_min22
len_max43
len_mean30.809
len_median29.000
len_p9536.000
word_mean2.000
word_median2.000
n_empty0
n_duplicates955
duplicate_rate0.098
vocab_size17,549
readability_flesch_mean120.205
emoji_rate0.000
url_rate0.000
one_word_rate0.000
allcaps_rate1.000
boilerplate_rate0.000
Sample values (first 10)
  1. POINT(-83.433713 45.0629087)
  2. POINT(-84.5779283 33.9830727)
  3. POINT(-80.1239712 26.1195078)
  4. POINT(-95.90999810000001 30.0578156)
  5. POINT(-108.390103 44.8377923)
  6. POINT(-82.10835469999999 34.2120049)
  7. POINT(-79.50235669999999 36.1027527)
  8. POINT(-90.3387251 38.5892737)
  9. POINT(-95.2774671 29.7107917)
  10. POINT(-83.279726 42.6192354)

city_location text

100.0% rows are all-caps 51.6% duplicate strings
rows10,992
null29 (0.3%)
unique5,311
len_min22
len_max43
len_mean31.193
len_median29.000
len_p9536.000
word_mean2.000
word_median2.000
n_empty0
n_duplicates5,652
duplicate_rate0.516
vocab_size10,532
readability_flesch_mean120.205
emoji_rate0.000
url_rate0.000
one_word_rate0.000
allcaps_rate1.000
boilerplate_rate0.000
Sample values (first 10)
  1. POINT(-83.7430378 42.2808256)
  2. POINT(-85.2594586 34.9330742)
  3. POINT(-81.46259189999999 30.6696818)
  4. POINT(-97.69610259999999 26.1906306)
  5. POINT(-106.9561791 44.7971939)
  6. POINT(-82.3940104 34.85261759999999)
  7. POINT(-87.6925074 37.1672684)
  8. POINT(-93.7171621 39.0725121)
  9. POINT(-95.3698028 29.7604267)
  10. POINT(-83.29104679999999 42.6389216)