Crowdsourced Aurora Sightings and Ground Reports

Name: Crowdsourced Aurora Sightings and Ground Reports
Creator: Aurorasaurus
License: Creative Commons Attribution Non Commercial 4.0 International

One row per citizen-submitted aurora ground report from the Aurorasaurus web observation feed. The table covers reports from 2014-10-01 through 2026-06-22 in the profiled run, with server-assigned report ids, observation timestamps, latitude and longitude, country and state labels, positive or negative sighting status, and optional visual condition fields. All profiled rows have valid coordinates; optional sky, height, activity, and comment fields are incomplete because they depend on what observers entered.

aurorasaurus-web-observations·24 columns·2.7 MB·Creative Commons Attribution Non Commercial 4.0 International·updated 11d ago

Source: Aurorasaurus · connector code

Schema

report_id	BIGINT
observed_at	TIMESTAMP
report_time_start	TIMESTAMP
report_time_end	TIMESTAMP
latitude	DOUBLE
longitude	DOUBLE
country	VARCHAR
state	VARCHAR
saw_aurora	BOOLEAN
sky	VARCHAR
sky_other	VARCHAR
colors	VARCHAR
colors_other	VARCHAR
types	VARCHAR
types_other	VARCHAR
activities	VARCHAR
activities_other	VARCHAR
height	VARCHAR
height_other	VARCHAR
ongoing	BOOLEAN
valid	BOOLEAN
verified	JSON
verified_type	JSON
comment	VARCHAR

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"aurorasaurus-web-observations\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.