Earthquakes In Indonesia
List of earthquakes recorded by Indonesia's BMKG and U.S. Geological Survey.
@kaggle.kekavigi_earthquakes_in_indonesia
List of earthquakes recorded by Indonesia's BMKG and U.S. Geological Survey.
@kaggle.kekavigi_earthquakes_in_indonesia
This datasets is taken from the Earthquake Repository managed by BMKG (an Indonesian non-departmental government agency), and Earthquake Catalog managed by U.S. Geological Survey.
BMKG changed their site and database design in early 2023, and this resulted in two different datasets. The new dataset (katalog_gempa_v2.tsv) is taken from the Preliminary Earthquake Catalog which includes focal mechanism data (if any). It contains earthquake event data from 1 Nov 2008 to 20 Sep 2025, but may not be accurate for some of the last earthquake events recorded. There are 37 variables in this dataset, each with a descriptive name. This new catalog also contains sensor location dataset (katalog_sensor.tsv), butmeaning of the variables within it isn't documented.
On the other hand, the old dataset (katalog_gempa.csv) contains earthquake event data from 1 Nov 2008 to 26 Jan 2023. The variables collected in this dataset are:
tgl: date of the eventot: timestamp of the eventlat: latitude of the event epicenter (degree), ranging from 6N to 11Slon: longitude of the event epicenter (degree), ranging from 142E to 94Edepth: depth of the event (km)mag: magnitude of the event, ranging from 1 up to 9.5remark: Flinn-Engdahl regions of the eventdip1, strike1, rake1, dip2, strike2, and rake2 values are not empty.The source code and raw HTML data for the both dataset can be accessed at github.com/kekavigi/repo-gempa.
Each earthquake event is converted from the previous GeoJSON format (see this example) into SQL tables: the ‘event’ table contains earthquake event information, the phase_data table contains phase data from the earthquake (if available for that earthquake), etc., and the content table contains links to supporting external files that can be downloaded. Take a look at this notebook which contains a brief exploration of this dataset, and/or this documentation to learn the meaning of variables and seismic products.
CREATE TABLE katalog_gempa (
  "tgl" TIMESTAMP,
  "ot" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "depth" BIGINT,
  "mag" DOUBLE,
  "remark" VARCHAR,
  "strike1" DOUBLE,
  "dip1" DOUBLE,
  "rake1" DOUBLE,
  "strike2" DOUBLE,
  "dip2" DOUBLE,
  "rake2" DOUBLE
);Anyone who has the link will be able to view this.