Baselight
Sign In

Earthquakes

Significant historical and recent earthquakes

@kaggle.christostripodis_earthquakes

About this Dataset

Earthquakes

Earthquakes are truly frightening and destructive forces of nature.

While studying SQL (BigQuery) I wanted to create a dataset for my fellow Kagglers.

Try to use the dataset to create some interesting visuals or make a model that predicts the number of deaths or damage caused by an earthquake.

Tables

Earthquake

@kaggle.christostripodis_earthquakes.earthquake
  • 154.73 KB
  • 4483 rows
  • 18 columns
Loading...
 

CREATE TABLE earthquake (
  "year" BIGINT,
  "hour" DOUBLE,
  "focal_depth" DOUBLE,
  "eq_primary" DOUBLE,
  "eq_mag_mw" DOUBLE,
  "eq_mag_ms" DOUBLE,
  "eq_mag_mb" DOUBLE,
  "eq_mag_ml" DOUBLE,
  "eq_mag_mfa" DOUBLE,
  "eq_mag_unk" DOUBLE,
  "intensity" DOUBLE,
  "country" VARCHAR,
  "state" VARCHAR,
  "location_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "total_deaths" DOUBLE,
  "total_damage_millions_dollars" DOUBLE
);