saturn

/home/coolhand/html/datavis/data_trove/data/quirky/ufo_shapes_aggregated.json 28 rows sample n=28 seed 42 2026-05-01T17:08:23+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/quirky/ufo_shapes_aggregated.json
Total rows28
Profiled sample28
Columns5
Generated2026-05-01T17:08:23+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.

Dataset high anthropic:claude-opus-4-7

This dataset aggregates UFO sightings by shape, with 28 rows and 5 columns covering shape categories, sighting counts, average durations, and nested sightings/yearly trend data. The numeric fields are highly skewed: avgDuration ranges from 30 to 37,800 with a mean of about 3,749 and skew near 3.95, while count ranges from 1 to 12,877 with a median of just 993.5. Both fields flag outliers worth inspecting — likely a few dominant shape categories pulling the distribution. The shape column has 28 unique values (one row per shape), so it functions as an identifier rather than a grouping variable. Start by looking at which shapes drive the count and duration extremes.

shape high anthropic:claude-opus-4-7

This column enumerates UFO shape descriptors (light, triangle, circle, fireball, sphere, disk, oval, formation, etc.). Every one of the 28 rows holds a distinct value, giving cardinality 28 and entropy_ratio 1.0 — the column behaves as a unique key rather than a categorical feature. The presence of bucket terms like 'unknown' and 'other' alongside specific shapes suggests this is a reference/lookup list of shape categories, not observations.

count high anthropic:claude-opus-4-7

Numeric tally column with 28 rows, 24 unique values, no nulls or zeros, ranging from 1 to 12877 with a median of 993.5 and mean of 2163.93. The distribution is heavily right-skewed (skew 2.06, kurtosis 4.84) with one outlier flagged at the high end and an IQR of 3786 against a std of 2876.24.

sightings low anthropic:claude-opus-4-7

The column 'sightings' was skipped by the profiler, so its kind is unknown and no descriptive statistics were computed. The only confirmed facts are 28 rows and a null rate of 0.0; cardinality and value distribution are unavailable.

yearlyTrend low anthropic:claude-opus-4-7

The column 'yearlyTrend' was skipped by the profiler, so its kind is unknown and no statistics were computed beyond a row count of 28 and a null rate of 0.0. With no uniqueness, type, or value signals available, its content and role cannot be inferred from this evidence.

avgDuration high anthropic:claude-opus-4-7

Likely a per-group average duration metric (probably seconds) summarised across 28 unique entities with no nulls. The distribution is heavily right-skewed (skew 3.95, kurtosis 15.42) with a median of 1906.65 but a max of 37800 — roughly 20x the median — and 2 outliers (7.14%) pulling the mean up to 3748.62. Standard deviation (7305.74) exceeds the mean, confirming a long tail.

Numeric correlation

shape categorical

28 singleton categories
rows28
null0 (0.0%)
unique28
top_valuelight
top_rate0.036
cardinality28
entropy4.807
entropy_ratio1.000
Top values (rank 1–20)
  1. light — 1
  2. triangle — 1
  3. circle — 1
  4. fireball — 1
  5. unknown — 1
  6. other — 1
  7. sphere — 1
  8. disk — 1
  9. oval — 1
  10. formation — 1
  11. cigar — 1
  12. changing — 1
  13. flash — 1
  14. rectangle — 1
  15. cylinder — 1
  16. diamond — 1
  17. chevron — 1
  18. teardrop — 1
  19. egg — 1
  20. cone — 1

count numeric

skew=+2.06
rows28
null0 (0.0%)
unique24
min1.000
max12,877
mean2,164
median993.500
std2,876
q1134.250
q33,920
iqr3,786
skew2.060
kurtosis4.845
n_outliers1
outlier_rate0.036
zero_rate0.000

sightings unknown

no profiler for kind=unknown
rows28
null0 (0.0%)

yearlyTrend unknown

no profiler for kind=unknown
rows28
null0 (0.0%)

avgDuration numeric

skew=+3.95 7.1% rows beyond 1.5 IQR
rows28
null0 (0.0%)
unique28
min30.000
max37,800
mean3,749
median1,907
std7,306
q1926.632
q33,130
iqr2,203
skew3.948
kurtosis15.416
n_outliers2
outlier_rate0.071
zero_rate0.000