datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Every magnitude 2.5+ earthquake recorded worldwide in the first half of 2025.

466 earthquakes1 tableJan 2025 – Jun 2025

what to watch for

Tricky rows

Events that are not earthquakes (mining explosions, explosions, other)5 rows
Different magnitude scales in one column (mb, ml, md, mww, …): not directly comparable6 rows
Events with no “Did You Feel It?” reports (felt_reports empty)374 rows
Events with no station count29 rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

events466 rows · 25 columns · CSV

One earthquake (or other ground-shaking event, such as a mine blast).

In your code: data/events.csv

event_idtextkey
USGS event ID
time_msinteger
When it happened, as milliseconds since 1 January 1970 (UTC)
time_utctimestamp
When it happened, UTC
updated_utctimestamp
When USGS last updated the event, UTC
magnitudedecimal
Magnitude
mag_typetext
Magnitude scale (mb, ml, md, mww, …)
placetext · can be empty
Description of the location
latitudedecimal
Latitude, degrees
longitudedecimal
Longitude, degrees
depth_kmdecimal
Depth, km below the surface
event_typetext
earthquake, mining explosion, explosion, …
statustext
reviewed or automatic
tsunamiinteger
1 when a tsunami message was issued for an oceanic event
significanceinteger
How significant USGS rates it (0–1000+)
felt_reportsinteger · can be empty
Number of “Did You Feel It?” reports
cdidecimal · can be empty
Strongest shaking people reported (1–10)
mmidecimal · can be empty
Strongest shaking measured by instruments (1–10)
alerttext · can be empty
Impact alert: green, yellow, orange or red
networktext
Seismic network that reported it
stationsinteger · can be empty
Number of seismic stations used
min_distance_degdecimal · can be empty
Distance to the nearest station, degrees
rmsdecimal · can be empty
How well the location fits the measurements, seconds (smaller is better)
gap_degdecimal · can be empty
Largest gap in station coverage around the quake, degrees
titletext
Title as shown by USGS
urltext
USGS event page

data/earthquakes.geojson466 records · GeoJSON

One earthquake (or other ground-shaking event, such as a mine blast).

In your code: data/earthquakes.geojson

data/api/3 JSON files

One earthquake (or other ground-shaking event, such as a mine blast). The same records split across files, as an API or a log writer produces them.