The Climate Change Twitter Dataset

15 million tweets spanning over 13 years.

@kaggle.deffro_the_climate_change_twitter_dataset

Table List

2 tables(349.12 MB)

Disasters

@kaggle.deffro_the_climate_change_twitter_dataset.disasters

434.57 KB
4913 rows
17 columns

disaster_type Disaster Type	disaster_subtype Disaster Subtype	disaster_group Disaster Group	disaster_subgroup Disaster Subgroup	event_name Event Name	origin Origin	country Country	location Location	latitude Latitude	longitude Longitude	start_date Start Date	end_date End Date	total_deaths Total Deaths	no_affected No Affected	total_damages_000_us Total Damages (\u0027000 US$)	cpi CPI
Earthquake	Ground movement	Natural	Geophysical	nan	nan	Japan	Nanao, Wajima districts (Isikawa province), Niigata, Toyama provinces	37.336	136.588	Sun Mar 25 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 25 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	1		250000	81.10165893
Storm	Tropical cyclone	Natural	Meteorological	Indhala	nan	Madagascar	Diana, Sava, Sofia, Analanjirofo provinces	-14.84	49.94	Thu Mar 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	80	203182	240000	81.10165893
Flood	Flash flood	Natural	Hydrological	nan	Storms and heavy rains	Australia	Gosford, Dungog, Newcastle, Wyong, Port Stephens, Maitland, Cessnock districts (New South Wales province)	-32.87	151.38	Fri Jun 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	9	5000	1300000	81.10165893
Flood	Riverine flood	Natural	Hydrological	nan	Heavy rains	Haiti	Ferrier village (Fort Liberte district, Nord Est province), Ouanaminthe district (Nord Est province), Abricot village (Jeremie district, Grande Anse province)	19.41	-71.78	Mon Mar 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 30 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	14	15000		81.10165893
Flood	Riverine flood	Natural	Hydrological	nan	Heavy rains	Argentina	Tucuman, Santiago del Estero, Salta, Formosa provinces			Thu Jan 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	5	60000	30000	81.10165893
Flood	Riverine flood	Natural	Hydrological	nan	Heavy rain and snowmelt	Afghanistan	Badghis, Uruzgan, Hilmand, Hirat, Ghor, Nimroz provinces	33.25	64.89	Sun Mar 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	104	20000		81.10165893
Flood	Riverine flood	Natural	Hydrological	nan	Monsoonal rain	Bangladesh	Chittagong district (Chittagong province)	22.4	91.95	Mon Jun 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	120	80000	14000	81.10165893
Flood	Riverine flood	Natural	Hydrological	nan	Heavy rain due to El Nino	Bolivia (Plurinational State of)	Beni, Chuquisaca, Cochabamba, La Paz, Oruro, Pando, Potosi, Santa Cruz, Tarija provinces	-16.97	-61.96	Wed Jan 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	40	339495	90000	81.10165893
Flood	Flash flood	Natural	Hydrological	nan	Heavy rain	Brazil	Sumidouro municipality (Sumidouro district, Rio de Janeiro province), Nova Friburgo municipality (Nova Friburgo district, Rio de Janeiro province), Petropolis, Teresopolis, Queimados districts (Rio de Janeiro province), Jundiai district (Sao Paulo province), Minas Gerais, Espirito Santo provinces	-22.42	-44	Mon Jan 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	59	200000	125000	81.10165893
Volcanic activity	Ash fall	Natural	Geophysical	Nevado del Huila	nan	Colombia	Tierradentro town (Inza district, Cauca province), Paez Belalcázar, Avirama, Cohetando, Toez, Vitonco, Yosayo, Mosoco, San Jose, Lame, Suin, Chinas, Buco towns (Paez district, Cauca province), Caloto district (Cauca province) La Plata, Paicol, Iquira, Teruel, Tesalia and Nataga districts (Huila prov…	2.93	-76.03	Wed Apr 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		3000		81.10165893


CREATE TABLE disasters (
  "disaster_type" VARCHAR,
  "disaster_subtype" VARCHAR,
  "disaster_group" VARCHAR,
  "disaster_subgroup" VARCHAR,
  "event_name" VARCHAR,
  "origin" VARCHAR,
  "country" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "total_deaths" DOUBLE,
  "no_affected" DOUBLE,
  "reconstruction_costs_000_us" DOUBLE,
  "total_damages_000_us" DOUBLE,
  "cpi" DOUBLE
);