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)
349
Tsunami Alerts
0
Avg Magnitude
1.63
Largest Event
M5.2
Silver Table Version
v70
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 (71 versions total)
VersionOperationTimestamp
v70 VACUUM END 2026-09-10 00:30:14 UTC
v69 VACUUM START 2026-09-10 00:30:14 UTC
v68 DELETE 2026-09-10 00:30:14 UTC
v67 MERGE 2026-09-10 00:30:14 UTC
v66 VACUUM END 2026-09-09 08:56:18 UTC
v65 VACUUM START 2026-09-09 08:56:18 UTC
v64 DELETE 2026-09-09 08:56:18 UTC
v63 MERGE 2026-09-09 08:56:18 UTC

No magnitude revisions detected between the last two versions.

All tracked events (interactive)
Date & Time (UTC) 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-09-10 00:30 UTC