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.
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 rows | 300 |
| Profiled sample | 300 |
| Columns | 8 |
| Generated | 2026-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.
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.
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%).
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.
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.
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.
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.
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.
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
Top values (rank 1–20)
- 2026-01-20T00:06:00 — 1
- 2026-01-20T00:07:00 — 1
- 2026-01-20T00:08:00 — 1
- 2026-01-20T00:09:00 — 1
- 2026-01-20T00:10:00 — 1
- 2026-01-20T00:11:00 — 1
- 2026-01-20T00:12:00 — 1
- 2026-01-20T00:13:00 — 1
- 2026-01-20T00:14:00 — 1
- 2026-01-20T00:15:00 — 1
- 2026-01-20T00:16:00 — 1
- 2026-01-20T00:17:00 — 1
- 2026-01-20T00:18:00 — 1
- 2026-01-20T00:19:00 — 1
- 2026-01-20T00:20:00 — 1
- 2026-01-20T00:21:00 — 1
- 2026-01-20T00:22:00 — 1
- 2026-01-20T00:23:00 — 1
- 2026-01-20T00:24:00 — 1
- 2026-01-20T00:25:00 — 1
kp_index numeric
estimated_kp numeric
activity categorical
Top values (rank 1–20)
- Moderate Storm — 172
- Minor Storm — 65
- Unsettled — 38
- Active — 17
- Quiet — 8
intensity numeric
solar_wind_time categorical
Top values (rank 1–20)
- 2026-01-20 03:58:00.000 — 2
- 2026-01-20 00:06:00.000 — 1
- 2026-01-20 00:07:00.000 — 1
- 2026-01-20 00:08:00.000 — 1
- 2026-01-20 00:09:00.000 — 1
- 2026-01-20 00:10:00.000 — 1
- 2026-01-20 00:11:00.000 — 1
- 2026-01-20 00:12:00.000 — 1
- 2026-01-20 00:13:00.000 — 1
- 2026-01-20 00:14:00.000 — 1
- 2026-01-20 00:15:00.000 — 1
- 2026-01-20 00:16:00.000 — 1
- 2026-01-20 00:17:00.000 — 1
- 2026-01-20 00:18:00.000 — 1
- 2026-01-20 00:19:00.000 — 1
- 2026-01-20 00:20:00.000 — 1
- 2026-01-20 00:21:00.000 — 1
- 2026-01-20 00:22:00.000 — 1
- 2026-01-20 00:23:00.000 — 1
- 2026-01-20 00:24:00.000 — 1