Earthquake data (USGS)

Name: Earthquake data (USGS)
Creator: U.S. Geological Survey
License: https://www.usa.gov/government-works

2,013 × 10rows × columns in the file

Updated 3 November 2026. Real data: U.S. Geological Survey, Earthquake Hazards Program, real-time feed 2.5_month.csv.

CSV XLSX JSON SQL

textnumberdateyes/no

Rows2,013in the file

Columns10with a data dictionary below

Dates2026-10-04 – 2026-11-03range in the file

LicencePublic domainU.S. government work

What is in it

Real events from the U.S. Geological Survey's public feed: time, location, depth, magnitude and the nearest named place. Good for maps, histograms and time series.

A snapshot of the 30 days before 2026-11-03. USGS revises events after review, so a fresh download from USGS will differ.

First rows

point at a column to light it up

time_utcdate	latitudenumber	longitudenumber	depth_kmnumber	magnitudenumber	mag_typetext	placetext	event_typetext	review_statustext	usgs_idtext
2026-11-03 21:34:08	39.3319	73.3673	10	5.2	mww	97 km ESE of Kyzyl-Eshme, Kyrgyzstan	earthquake	reviewed	us7000tvtj
2026-11-03 19:35:51	32.409	-115.15783333333	15.52	2.5	ml	7 km NNE of Delta, B.C., MX	earthquake	reviewed	ci41572136
2026-11-03 19:18:10	32.4135	-115.16233333333	16.29	2.95	ml	7 km NNE of Delta, B.C., MX	earthquake	reviewed	ci41572104
2026-11-03 18:27:31	32.430833333333	-115.17966666667	15.59	4.8869503562808	mw	9 km N of Delta, B.C., MX	earthquake	reviewed	ci41572064
2026-11-03 18:21:13	-35.5195	78.3027	10	5.2	mb	Mid-Indian Ridge	earthquake	reviewed	us7000tvs3
2026-11-03 18:17:13	32.409166666667	-115.1595	27.15	3.37822	mlr	7 km NNE of Delta, B.C., MX	earthquake	reviewed	ci41572056
2026-11-03 18:11:58	60.987	-150.717	60.3	2.9	ml	7 km NNW of Point Possession, Alaska	earthquake	automatic	aka2026vupcsv
2026-11-03 17:28:41	60.269	-153.087	155.8	2.5	ml	68 km E of Port Alsworth, Alaska	earthquake	automatic	aka2026vunrap
2026-11-03 17:07:50	29.1514	60.4194	10	4.1	mb	57 km SW of Zahedan, Iran	earthquake	reviewed	us7000tvpc
2026-11-03 16:48:57	51.4315	-175.9592	35	3.6	ml	67 km SE of Adak, Alaska	earthquake	reviewed	us7000tvsl

Events by magnitude band

events in the file

Show as a table

magnitude	value
2.5-2.9	586
3.0-3.9	284
4.0-4.9	936
5.0-5.9	185
6.0+	22

Source: U.S. Geological Survey, Earthquake Hazards Program, real-time feed 2.5_month.csv.

Data dictionary

Column	Type	Meaning
time_utc	datetime	Origin time, UTC (YYYY-MM-DD HH:MM:SS)
latitude	decimal	Degrees north (negative = south)
longitude	decimal	Degrees east (negative = west)
depth_km	decimal	Depth below the surface, km
magnitude	decimal	Magnitude
mag_type	text	Magnitude scale (mb, ml, mww, md ...)
place	text	Nearest named place as written by USGS
event_type	text	earthquake, quarry blast, explosion ...
review_status	text	reviewed or automatic
usgs_id	text	USGS event id

Practice questions

answers checked in SQL and in Python

How many events are in the file, and how many are magnitude 5.0 or more?

2,013 events; 207 at M5.0+

Excel

=COUNTIF(E:E,">=5")

SQL

SELECT COUNT(*), SUM(magnitude >= 5) FROM earthquakes_last_30d

File: earthquakes-last-30-days

What was the largest event?

M7.7, 10 km WSW of Pitaloza Arriba, Panama (2026-10-09 17:56:05 UTC)

SQL

SELECT magnitude, place, time_utc FROM earthquakes_last_30d ORDER BY magnitude DESC, time_utc LIMIT 1

File: earthquakes-last-30-days

Average depth of events, in km?

57.7 km

SQL

SELECT ROUND(AVG(depth_km),1) FROM earthquakes_last_30d

File: earthquakes-last-30-days