saturn

/home/coolhand/html/datavis/data_trove/data/quirky/aurora.json 300 rows sample n=300 seed 42 2026-05-01T16:55:47+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/quirky/aurora.json
Total rows300
Profiled sample300
Columns8
Generated2026-05-01T16:55:47+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 captures 300 minute-by-minute aurora and solar wind observations starting 2026-01-20, with 8 columns covering geomagnetic indices (kp_index, estimated_kp, intensity), solar wind conditions (speed, density), and a categorical activity label. The activity field is heavily skewed toward 'Moderate Storm' (172 of 300, ~57%), with only 8 'Quiet' readings — worth a closer look since this dominates the storyline. The kp_index and intensity columns are left-skewed and pile up at their max values (median equals max), with ~15% flagged as low-side outliers, suggesting the sample is a sustained storm period rather than a balanced range. Solar wind speed is also unusually elevated (min 881, max 1051 km/s), reinforcing that this is a storm-window snapshot rather than typical conditions.

time_tag high anthropic:claude-opus-4-7

This is an ISO-8601 timestamp column at minute resolution, with all 300 values unique (entropy_ratio 1.0) and zero nulls. The visible top values form a contiguous one-minute sequence starting 2026-01-20T00:06:00, consistent with a regular time index rather than event timestamps. Cardinality equals row count, so it acts as a row key over time.

kp_index high anthropic:claude-opus-4-7

Numeric column on a small 0-6 integer scale with only 7 distinct values, consistent with a Kp geomagnetic index reading. The distribution is heavily concentrated at the high end (median and Q3 both 6.0, mean 5.09) and strongly left-skewed (skew -1.68), with 46 low-side outliers flagged (15.3%). No nulls, and zeros are rare (1.3%).

estimated_kp high anthropic:claude-opus-4-7

This looks like an estimated Kp geomagnetic index value, bounded between 0.0 and 6.33 across 300 rows with only 18 unique values, consistent with the discrete third-step Kp scale. The distribution is heavily left-skewed (skew -1.30) with the median pinned at the maximum 6.33 and Q3 also at 6.33, meaning at least half the rows sit at the ceiling. 18 low-side outliers (6% rate) and a near-zero zero_rate (0.67%) confirm a long thin tail toward quiet conditions.

activity high anthropic:claude-opus-4-7

Categorical descriptor of geomagnetic or space-weather activity level, with 5 ordered classes from 'Quiet' to 'Moderate Storm'. The distribution is heavily skewed toward storm conditions: 'Moderate Storm' alone accounts for 57.3% (172/300) of rows, while 'Quiet' appears just 8 times, suggesting the dataset is filtered to disturbed periods rather than representing typical activity. Entropy ratio of 0.73 confirms moderate concentration on the top class.

intensity high anthropic:claude-opus-4-7

Numeric 'intensity' column bounded between 0.0 and 0.667 with only 7 unique values across 300 rows, suggesting a discretised or quantised measurement rather than a continuous reading. Distribution is heavily left-skewed (skew -1.68) with median equal to the max (0.667), and 46 rows (15.3%) flagged as outliers on the low end. The handful of zeros (1.3%) and the ceiling at 0.667 hint at a capped or normalised score.

solar_wind_time high anthropic:claude-opus-4-7

This column is a minute-resolution timestamp of solar wind observations, all falling on 2026-01-20 with values like '2026-01-20 03:58:00.000'. With 299 unique values across 300 rows and entropy ratio 0.9997, it is effectively a per-row time index; only '2026-01-20 03:58:00.000' repeats (twice). No nulls, but the long_tail alert reflects this near-unique structure rather than meaningful categories.

solar_wind_speed high anthropic:claude-opus-4-7

Numeric measurements of solar wind speed across 300 records, all populated and tightly clustered between 881.6 and 1051.3 with a mean of 955.79 and median of 940.15. The distribution is mildly right-skewed (0.45) and platykurtic (kurtosis -1.32), suggesting a flatter-than-normal spread with no outliers flagged. With 266 unique values out of 300, the column behaves as a continuous physical feature rather than a categorical one.

solar_wind_density high anthropic:claude-opus-4-7

This is a numeric feature capturing solar wind density, fully populated across 300 rows with 215 distinct values. The distribution is fairly symmetric (skew 0.26, kurtosis 0.12) with mean 3.10 and median 3.14, ranging from 0.23 to 8.32 and an IQR of 2.02. Only 2 outliers (0.67%) appear, so the column looks clean and well-behaved.

Numeric correlation

time_tag categorical

300 singleton categories
rows300
null0 (0.0%)
unique300
top_value2026-01-20T00:06:00
top_rate3.33e-03
cardinality300
entropy8.229
entropy_ratio1.000
Top values (rank 1–20)
  1. 2026-01-20T00:06:00 — 1
  2. 2026-01-20T00:07:00 — 1
  3. 2026-01-20T00:08:00 — 1
  4. 2026-01-20T00:09:00 — 1
  5. 2026-01-20T00:10:00 — 1
  6. 2026-01-20T00:11:00 — 1
  7. 2026-01-20T00:12:00 — 1
  8. 2026-01-20T00:13:00 — 1
  9. 2026-01-20T00:14:00 — 1
  10. 2026-01-20T00:15:00 — 1
  11. 2026-01-20T00:16:00 — 1
  12. 2026-01-20T00:17:00 — 1
  13. 2026-01-20T00:18:00 — 1
  14. 2026-01-20T00:19:00 — 1
  15. 2026-01-20T00:20:00 — 1
  16. 2026-01-20T00:21:00 — 1
  17. 2026-01-20T00:22:00 — 1
  18. 2026-01-20T00:23:00 — 1
  19. 2026-01-20T00:24:00 — 1
  20. 2026-01-20T00:25:00 — 1

kp_index numeric

15.3% rows beyond 1.5 IQR
rows300
null0 (0.0%)
unique7
min0.000
max6.000
mean5.090
median6.000
std1.396
q15.000
q36.000
iqr1.000
skew-1.683
kurtosis2.149
n_outliers46
outlier_rate0.153
zero_rate0.013

estimated_kp numeric

6.0% rows beyond 1.5 IQR
rows300
null0 (0.0%)
unique18
min0.000
max6.330
mean5.183
median6.330
std1.538
q14.670
q36.330
iqr1.660
skew-1.295
kurtosis0.948
n_outliers18
outlier_rate0.060
zero_rate6.67e-03

activity categorical

rows300
null0 (0.0%)
unique5
top_valueModerate Storm
top_rate0.573
cardinality5
entropy1.690
entropy_ratio0.728
Top values (rank 1–20)
  1. Moderate Storm — 172
  2. Minor Storm — 65
  3. Unsettled — 38
  4. Active — 17
  5. Quiet — 8

intensity numeric

15.3% rows beyond 1.5 IQR
rows300
null0 (0.0%)
unique7
min0.000
max0.667
mean0.566
median0.667
std0.155
q10.556
q30.667
iqr0.111
skew-1.682
kurtosis2.139
n_outliers46
outlier_rate0.153
zero_rate0.013

solar_wind_time categorical

298 singleton categories
rows300
null0 (0.0%)
unique299
top_value2026-01-20 03:58:00.000
top_rate6.67e-03
cardinality299
entropy8.222
entropy_ratio1.000
Top values (rank 1–20)
  1. 2026-01-20 03:58:00.000 — 2
  2. 2026-01-20 00:06:00.000 — 1
  3. 2026-01-20 00:07:00.000 — 1
  4. 2026-01-20 00:08:00.000 — 1
  5. 2026-01-20 00:09:00.000 — 1
  6. 2026-01-20 00:10:00.000 — 1
  7. 2026-01-20 00:11:00.000 — 1
  8. 2026-01-20 00:12:00.000 — 1
  9. 2026-01-20 00:13:00.000 — 1
  10. 2026-01-20 00:14:00.000 — 1
  11. 2026-01-20 00:15:00.000 — 1
  12. 2026-01-20 00:16:00.000 — 1
  13. 2026-01-20 00:17:00.000 — 1
  14. 2026-01-20 00:18:00.000 — 1
  15. 2026-01-20 00:19:00.000 — 1
  16. 2026-01-20 00:20:00.000 — 1
  17. 2026-01-20 00:21:00.000 — 1
  18. 2026-01-20 00:22:00.000 — 1
  19. 2026-01-20 00:23:00.000 — 1
  20. 2026-01-20 00:24:00.000 — 1

solar_wind_speed numeric

rows300
null0 (0.0%)
unique266
min881.600
max1,051
mean955.792
median940.150
std51.978
q1908.550
q31,008
iqr99.800
skew0.451
kurtosis-1.323
n_outliers0
outlier_rate0.000
zero_rate0.000

solar_wind_density numeric

rows300
null0 (0.0%)
unique215
min0.230
max8.320
mean3.103
median3.140
std1.344
q12.090
q34.110
iqr2.020
skew0.255
kurtosis0.117
n_outliers2
outlier_rate6.67e-03
zero_rate0.000