Landslides After Rainfall, 2007-2016

Location and cause of landslide events around the world

@kaggle.nasa_landslide_events

Table List

1 table(211.4 KB)

Catalog

@kaggle.nasa_landslide_events.catalog

211.4 KB
1693 rows
23 columns

id Id	date Date	time Time	continent_code Continent Code	country_name Country Name	country_code Country Code	state_province State/province	population Population	city_town City/town	distance Distance	location_description Location Description	latitude Latitude	longitude Longitude	geolocation Geolocation	hazard_type Hazard Type	landslide_type Landslide Type	landslide_size Landslide Size	trigger Trigger	storm_name Storm Name	fatalities Fatalities	source_name Source Name	source_link Source Link
34	Fri Mar 02 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Night	nan	United States	US	Virginia	16000	Cherry Hill	3.40765	Unknown	38.6009	-77.2682	(38.600900000000003, -77.268199999999993)	Landslide	Landslide	Small	Rain	nan		NBC 4 news	http://www.nbc4.com/news/11186871/detail.html
42	Thu Mar 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	United States	US	Ohio	17288	New Philadelphia	3.33522	nan	40.5175	-81.4305	(40.517499999999998, -81.430499999999995)	Landslide	Landslide	Small	Rain	nan		Canton Rep.com	http://www.cantonrep.com/index.php?ID=345054&Category=9&subCategoryID=0
56	Fri Apr 06 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	United States	US	Pennsylvania	15930	Wilkinsburg	2.91977	Urban area	40.4377	-79.916	(40.4377, -79.915999999999997)	Landslide	Landslide	Small	Rain	nan		The Pittsburgh Channel.com	https://web.archive.org/web/20080423132842/http://www.thepittsburghchannel.com/news/11846833/detail.html
59	Sat Apr 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	Canada	CA	Quebec	42786	Châteauguay	2.98682	Above river	45.3226	-73.7771	(45.322600000000001, -73.777100000000004)	Landslide	Riverbank collapse	Small	Rain	nan		Le Soleil	http://www.hebdos.net/lsc/edition162007/articles.asp?article_id=166976
61	Sun Apr 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	United States	US	Kentucky	6903	Pikeville	5.66542	Below road	37.4325	-82.4931	(37.432499999999997, -82.493099999999998)	Landslide	Landslide	Small	Downpour	nan		Matthew Crawford (KGS)	nan
64	Fri Apr 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	United States	US	Kentucky	6903	Pikeville	0.23715	nan	37.4814	-82.5186	(37.481400000000001, -82.518600000000006)	Landslide	Landslide	Small	Rain	nan		Applalachain news-express	http://www.news-expressky.com/articles/2007/04/19/top_story/01mudslide.txt
67	Tue Apr 24 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	United States	US	South Dakota	2540	Dakota Dunes	2.48033	nan	42.4941	-96.4576	(42.494100000000003, -96.457599999999999)	Landslide	Landslide	Small	Rain	nan		Sioux City Journnal	http://www.siouxcityjournal.com/articles/2007/04/25/news/top/02a92f1defdd220f862572c800126dfc.txt
77	Mon May 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	SA	Colombia	CO	Risaralda	440118	Pereira	0.62022	nan	4.8081	-75.6941	(4.8080999999999996, -75.694100000000006)	Landslide	Mudslide	Large	Rain	nan	13	Reuters - AlertNet.org	http://www.reuters.com/news/video/videoStory?videoId=53594&feedType=RSS&rpc=23
105	Wed Jun 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	SA	Ecuador	EC	Zamora-Chinchipe	15276	Zamora	0.47714	nan	-4.065	-78.951	(-4.0650000000000004, -78.950999999999993)	Landslide	Landslide	Medium	Downpour	nan		Red Cross - Field reports	https://www-secure.ifrc.org/dmis/prepare/view_report.asp?ReportID=2908
106	Wed Jun 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	SA	Ecuador	EC	Loja	117796	Loja	0.35649	nan	-3.99	-79.205	(-3.99, -79.204999999999998)	Landslide	Landslide	Medium	Downpour	nan		Red Cross - Field reports	https://www-secure.ifrc.org/dmis/prepare/view_report.asp?ReportID=2908


CREATE TABLE catalog (
  "id" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "continent_code" VARCHAR,
  "country_name" VARCHAR,
  "country_code" VARCHAR,
  "state_province" VARCHAR,
  "population" BIGINT,
  "city_town" VARCHAR,
  "distance" DOUBLE,
  "location_description" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geolocation" VARCHAR,
  "hazard_type" VARCHAR,
  "landslide_type" VARCHAR,
  "landslide_size" VARCHAR,
  "trigger" VARCHAR,
  "storm_name" VARCHAR,
  "injuries" DOUBLE,
  "fatalities" DOUBLE,
  "source_name" VARCHAR,
  "source_link" VARCHAR
);