Live Earthquakes Delta Lake
USGS Earthquake API · Bronze/Silver/Gold medallion pipeline · real ACID MERGE upserts + time travel via delta-rs · self-managed VPS
Raw snapshots retained 3 days, active earthquakes shown for 26 hours (matching USGS's own rolling feed window) — older data is deleted and vacuumed automatically to keep this light on disk.
Refreshed every 5 min
Active Earthquakes (26h)
407
Tsunami Alerts
0
Avg Magnitude
1.78
Largest Event
M7.7
Silver Table Version
v58
Recent earthquakes (colored and sized by magnitude)
Magnitude distribution
Top regions by event count
Delta Lake internals — ACID transactions in practice

Every ingestion cycle either creates the Silver table or runs a real MERGE against it: matched earthquake IDs get updated in place, new ones get inserted — the same semantics as MERGE INTO in Databricks SQL, just via the open-source delta-rs engine instead of a Spark cluster. Every commit is an immutable version you can query with VERSION AS OF.

Commit history (59 versions total)
VersionOperationTimestamp
v58 VACUUM END 2026-08-15 08:33:10 UTC
v57 VACUUM START 2026-08-15 08:33:10 UTC
v56 DELETE 2026-08-15 08:33:10 UTC
v55 MERGE 2026-08-15 08:33:10 UTC
v54 MERGE 2026-08-14 13:53:17 UTC
v53 MERGE 2026-08-14 13:48:13 UTC
v52 MERGE 2026-08-14 13:43:07 UTC
v51 MERGE 2026-08-14 13:37:58 UTC

No magnitude revisions detected between the last two versions.

All tracked events (interactive)
Place Region Magnitude Significance Tsunami Depth (km)
Architecture: USGS Earthquake API → Python ingestion (systemd timer, every 5 min) → Delta Lake Bronze (raw, append-only) → Silver (MERGE upsert, deduped latest state) → Gold (aggregated summary + region rollups) → static site generator (systemd timer) → this page. Last generated: 2026-08-15 09:02 UTC