Reto 2: grafica de histogramas agrupados y apilados, para todos las longitudes de deslizamiento de los pueblos de Canadá y USA
Carlos Daniel Rodriguez
Universidad del Nortelibrary(readr)
library(knitr)
df <- read_csv("https://raw.githubusercontent.com/lihkir/AnalisisEstadisticoUN/main/Data/catalog.csv")## Rows: 1693 Columns: 23## -- Column specification --------------------------------------------------------
## Delimiter: ","
## chr (16): date, time, continent_code, country_name, country_code, state/prov...
## dbl (7): id, population, distance, latitude, longitude, injuries, fatalities##
## i Use `spec()` to retrieve the full column specification for this data.
## i Specify the column types or set `show_col_types = FALSE` to quiet this message.knitr::kable(head(df))| id | date | time | continent_code | country_name | country_code | state/province | population | city/town | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 3/2/07 | Night | NA | United States | US | Virginia | 16000 | Cherry Hill | 3.40765 | Unknown | 38.6009 | -77.2682 | (38.600900000000003, -77.268199999999993) | Landslide | Landslide | Small | Rain | NA | NA | NA | NBC 4 news | http://www.nbc4.com/news/11186871/detail.html |
| 42 | 3/22/07 | NA | NA | United States | US | Ohio | 17288 | New Philadelphia | 3.33522 | NA | 40.5175 | -81.4305 | (40.517499999999998, -81.430499999999995) | Landslide | Landslide | Small | Rain | NA | NA | NA | Canton Rep.com | http://www.cantonrep.com/index.php?ID=345054&Category=9&subCategoryID=0 |
| 56 | 4/6/07 | NA | NA | United States | US | Pennsylvania | 15930 | Wilkinsburg | 2.91977 | Urban area | 40.4377 | -79.9160 | (40.4377, -79.915999999999997) | Landslide | Landslide | Small | Rain | NA | NA | NA | The Pittsburgh Channel.com | https://web.archive.org/web/20080423132842/http://www.thepittsburghchannel.com/news/11846833/detail.html |
| 59 | 4/14/07 | NA | NA | Canada | CA | Quebec | 42786 | Châteauguay | 2.98682 | Above river | 45.3226 | -73.7771 | (45.322600000000001, -73.777100000000004) | Landslide | Riverbank collapse | Small | Rain | NA | NA | NA | Le Soleil | http://www.hebdos.net/lsc/edition162007/articles.asp?article_id=166976 |
| 61 | 4/15/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 5.66542 | Below road | 37.4325 | -82.4931 | (37.432499999999997, -82.493099999999998) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | Matthew Crawford (KGS) | NA |
| 64 | 4/20/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 0.23715 | NA | 37.4814 | -82.5186 | (37.481400000000001, -82.518600000000006) | Landslide | Landslide | Small | Rain | NA | NA | NA | Applalachain news-express | http://www.news-expressky.com/articles/2007/04/19/top_story/01mudslide.txt |
Gráfico de barras agrupados y apilados
- grafica de histogramas agrupados y apilados, para todos las longitudes de deslizamiento de los pueblos de USA
library(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unioncolnames(df)[7] <- "state"
colnames(df)[9] <- "city"
df_US <- subset(df, country_name == "United States")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 3/2/07 | Night | NA | United States | US | Virginia | 16000 | Cherry Hill | 3.40765 | Unknown | 38.6009 | -77.2682 | (38.600900000000003, -77.268199999999993) | Landslide | Landslide | Small | Rain | NA | NA | NA | NBC 4 news | http://www.nbc4.com/news/11186871/detail.html |
| 42 | 3/22/07 | NA | NA | United States | US | Ohio | 17288 | New Philadelphia | 3.33522 | NA | 40.5175 | -81.4305 | (40.517499999999998, -81.430499999999995) | Landslide | Landslide | Small | Rain | NA | NA | NA | Canton Rep.com | http://www.cantonrep.com/index.php?ID=345054&Category=9&subCategoryID=0 |
| 56 | 4/6/07 | NA | NA | United States | US | Pennsylvania | 15930 | Wilkinsburg | 2.91977 | Urban area | 40.4377 | -79.9160 | (40.4377, -79.915999999999997) | Landslide | Landslide | Small | Rain | NA | NA | NA | The Pittsburgh Channel.com | https://web.archive.org/web/20080423132842/http://www.thepittsburghchannel.com/news/11846833/detail.html |
| 61 | 4/15/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 5.66542 | Below road | 37.4325 | -82.4931 | (37.432499999999997, -82.493099999999998) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | Matthew Crawford (KGS) | NA |
| 64 | 4/20/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 0.23715 | NA | 37.4814 | -82.5186 | (37.481400000000001, -82.518600000000006) | Landslide | Landslide | Small | Rain | NA | NA | NA | Applalachain news-express | http://www.news-expressky.com/articles/2007/04/19/top_story/01mudslide.txt |
| 67 | 4/24/07 | NA | NA | United States | US | South Dakota | 2540 | Dakota Dunes | 2.48033 | NA | 42.4941 | -96.4576 | (42.494100000000003, -96.457599999999999) | Landslide | Landslide | Small | Rain | NA | NA | NA | Sioux City Journnal | http://www.siouxcityjournal.com/articles/2007/04/25/news/top/02a92f1defdd220f862572c800126dfc.txt |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=state, y=distance, x=country_name)) +
geom_bar(position="dodge", stat="identity")## Warning: Removed 1 rows containing missing values (geom_bar).
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=state, y=distance, x=country_name)) +
geom_bar(position="stack", stat="identity")## Warning: Removed 1 rows containing missing values (position_stack).
library(dplyr)
df_US <- subset(df, state == "Alabama")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1182 | 9/21/09 | NA | NA | United States | US | Alabama | 3485 | Livingston | 26.97874 | NA | 32.8040 | -88.3108 | (32.804000000000002, -88.3108) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.tuscaloosanews.com/article/20090922/NEWS/909219939/1007?Title=6-dead-others-missing-after-Southeast-flooding |
| 1591 | 3/25/10 | Early morning | NA | United States | US | Alabama | 2264 | Good Hope | 22.45613 | NA | 34.0844 | -87.1040 | (34.084400000000002, -87.103999999999999) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://www.thepittsburghchannel.com/allegheny/22812683/detail.html |
| 3227 | 3/15/11 | NA | NA | United States | US | Alabama | 12548 | Jacksonville | 1.79927 | NA | 33.7975 | -85.7620 | (33.797499999999999, -85.762) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | NA |
| 4072 | 11/30/11 | 4:30:00 | NA | United States | US | Alabama | 14770 | Scottsboro | 0.64281 | NA | 34.6781 | -86.0343 | (34.678100000000001, -86.034300000000002) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://thedailysentinel.com/news/article_01e21378-1b60-11e1-9234-001cc4c03286.html |
| 5245 | 8/1/13 | Early morning | NA | United States | US | Alabama | 15326 | Fairhope | 0.73828 | NA | 30.5279 | -87.9085 | (30.527899999999999, -87.908500000000004) | Landslide | Landslide | Small | Rain | NA | NA | 0 | www.local15tv.com | http://www.local15tv.com/template/cgi-bin/archived.pl?type=basic&file=/shared/news/features/top-stories/stories/archive/2013/08/cS7WWUwb.xml#.UtBBHvRDt8E |
| 5345 | 8/17/13 | NA | NA | United States | US | Alabama | 9015 | Andalusia | 1.69766 | NA | 31.3077 | -86.5011 | (31.307700000000001, -86.501099999999994) | Landslide | Landslide | Small | Tropical cyclone | Utor | NA | NA | www.andalusiastarnews.com | http://www.andalusiastarnews.com/2013/08/24/kudos-to-volunteers-employees/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Arizona")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1434 | 1/21/10 | 22:00:00 | NA | United States | US | Arizona | 1424 | Tonto Basin | 16.48124 | NA | 33.8342 | -111.4726 | (33.834200000000003, -111.4726) | Landslide | Complex | Small | Downpour | NA | NA | 0 | NA | http://www.paysonroundup.com/news/2010/jan/21/storm_update/ |
| 1441 | 1/22/10 | NA | NA | United States | US | Arizona | 2633 | Cordes Lakes | 12.98377 | NA | 34.1933 | -112.1327 | (34.193300000000001, -112.1327) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.mercurynews.com/breaking-news/ci_14252829?nclick_check=1 |
| 2101 | 7/20/10 | NA | NA | United States | US | Arizona | 65870 | Flagstaff | 11.50738 | NA | 35.2902 | -111.5932 | (35.290199999999999, -111.5932) | Landslide | Debris flow | Medium | Downpour | NA | NA | 0 | NA | http://www.nagalandpost.com/ShowStory.aspx?npoststoryiden=UzEwMjg5OTY%3D-LvoR7D2GhjI%3D |
| 2487 | 9/22/10 | 6:00:00 | NA | United States | US | Arizona | 1424 | Tonto Basin | 1.86032 | NA | 33.8468 | -111.2858 | (33.846800000000002, -111.28579999999999) | Landslide | Complex | Medium | Downpour | NA | NA | 0 | NA | http://www.azfamily.com/traffic/DPS-says-State-Route-188-closed-due-to-mudslide-103532784.html |
| 3758 | 7/10/11 | NA | NA | United States | US | Arizona | 43888 | Sierra Vista | 12.28777 | NA | 31.4891 | -110.4081 | (31.489100000000001, -110.4081) | Landslide | Debris flow | Medium | Downpour | NA | NA | 0 | NA | http://www.azein.gov/azein/Lists/Announcements/DispForm.aspx?ID=1947 |
| 3761 | 7/11/11 | NA | NA | United States | US | Arizona | 43888 | Sierra Vista | 9.92245 | NA | 31.4733 | -110.3475 | (31.473299999999998, -110.3475) | Landslide | Landslide | Large | Downpour | NA | NA | 0 | NA | http://sierravista-fthuachuca.kold.com/news/hereford-home-survives-wildfire-cant-avoid-mudslide/54678 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Arkansas")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 597 | 6/20/08 | NA | NA | United States | US | Arkansas | 466 | Jasper | 30.98796 | Above road | 35.7885 | -92.9331 | (35.788499999999999, -92.933099999999996) | Landslide | Mudslide | Small | Rain | NA | NA | NA | THV11 | http://archive.thv11.com/news/article/67840/0/Richland-Creek-Recreation-Area-Closed-Due-To-Mudslide |
| 3417 | 4/25/11 | Night | NA | United States | US | Arkansas | 1084 | Midway | 6.74198 | NA | 36.4461 | -92.4623 | (36.446100000000001, -92.462299999999999) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://ozarksfirst.com/fulltext?nxd_id=445297 |
| 4474 | 8/14/12 | NA | NA | United States | US | Arkansas | 466 | Jasper | 5.06464 | NA | 35.9631 | -93.1774 | (35.963099999999997, -93.177400000000006) | Landslide | Landslide | Medium | Downpour | NA | NA | NA | NA | http://www.todaysthv.com/news/article/222096/2/Landslide-in-Newton-County-causes-highway-to-close |
| 6918 | 3/20/15 | NA | NA | United States | US | Arkansas | 12943 | Harrison | 10.15474 | Below road | 36.1807 | -93.2030 | (36.180700000000002, -93.203000000000003) | Landslide | Landslide | Small | Unknown | NA | 0 | 0 | Harrison Daily | http://harrisondaily.com/news/gaither-landslide-requires-repairs-road-power-lines-shifting/article_23d6cc8c-d267-11e4-9d8d-b72de67f3d1c.html#user-comment-area |
| 6956 | 6/16/15 | Morning | NA | United States | US | Arkansas | 3684 | Ozark | 25.20737 | Natural slope | 35.7131 | -93.8001 | (35.713099999999997, -93.8001) | Landslide | Landslide | Small | Continuous rain | NA | 0 | 0 | 5 News KFSM | http://5newsonline.com/2015/06/16/highway-23-in-franklin-county-closed-due-to-landslide/ |
| 7064 | 5/10/15 | NA | NA | United States | US | Arkansas | 1012 | Coal Hill | 7.09417 | Above road | 35.5008 | -93.6821 | (35.500799999999998, -93.682100000000005) | Landslide | Landslide | Small | Downpour | NA | 0 | 0 | 5 News | http://5newsonline.com/2015/05/10/i-40-lane-closed-due-to-landslide-in-johnson-county/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "California")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 376 | 11/30/07 | NA | NA | United States | US | California | 3117 | Rancho Santa Fe | 6.48824 | NA | 33.0409 | -117.1378 | (33.040900000000001, -117.1378) | Landslide | Debris flow | Small | Rain | NA | NA | NA | Signon San Diego.com | http://www.signonsandiego.com/news/metro/20071130-1627-bn30rain6.html |
| 414 | 1/6/08 | NA | NA | United States | US | California | 42808 | La Jolla | 8.13382 | NA | 32.8008 | -117.2070 | (32.800800000000002, -117.20699999999999) | Landslide | Landslide | Small | Rain | NA | NA | NA | NA | http://weblog.signonsandiego.com/news/breaking/2008/01/rain_causes_a_landslide_in_san.html |
| 418 | 1/7/08 | NA | NA | United States | US | California | 59518 | Encinitas | 3.23702 | NA | 33.0643 | -117.3042 | (33.064300000000003, -117.30419999999999) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NA | http://www.signonsandiego.com/news/metro/20080108-9999-1m8weather.html |
| 436 | 1/28/08 | 19:30:00 | NA | United States | US | California | 42808 | La Jolla | 1.15586 | NA | 32.8464 | -117.2619 | (32.846400000000003, -117.2619) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NA | http://www.nbcsandiego.com/mostpopular/15160664/detail.html |
| 693 | 8/7/08 | NA | NA | United States | US | California | 20292 | Ramona | 3.32897 | NA | 33.0470 | -116.8330 | (33.046999999999997, -116.833) | Landslide | Complex | Small | Downpour | NA | NA | NA | NA | http://www.signonsandiego.com/news/metro/20080808-9999-1m8weather.html |
| 908 | 11/26/08 | NA | NA | United States | US | California | 9277 | Valley Center | 14.43770 | NA | 33.3000 | -116.9135 | (33.299999999999997, -116.9135) | Landslide | Debris flow | Medium | Rain | NA | NA | NA | NA | http://www.sandiego6.com/news/local/story/People-and-Pets-Trapped-in-Car-by-Debris-Flow/-hzY7l0XwECXzE2pbJhIOw.cspx |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Colorado")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185 | 8/14/07 | NA | NA | United States | US | Colorado | 2475 | Meeker | 10.87949 | NA | 39.9425 | -107.8818 | (39.942500000000003, -107.8818) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | Telluride Daily Planet | http://www.telluridegateway.com/articles/2007/08/16/news/news02.txt |
| 238 | 9/6/07 | NA | NA | United States | US | Colorado | 12088 | Steamboat Springs | 2.63588 | NA | 40.4613 | -106.8295 | (40.461300000000001, -106.8295) | Landslide | Mudslide | Small | Rain | NA | NA | NA | Craigdailypress.com | http://www.craigdailypress.com/news/2007/sep/08/news_mudslide/ |
| 268 | 9/17/07 | NA | NA | United States | US | Colorado | 4518 | New Castle | 4.25758 | NA | 39.5542 | -107.5798 | (39.554200000000002, -107.57980000000001) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | KJCT news | http://kjct8.com/Global/story.asp?S=7085534 |
| 499 | 4/13/08 | NA | NA | United States | US | Colorado | 6447 | Avon | 3.03321 | NA | 39.6250 | -106.4879 | (39.625, -106.4879) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.vaildaily.com/article/20080428/NEWS/280292121 |
| 555 | 5/28/08 | NA | NA | United States | US | Colorado | 6658 | Aspen | 20.14967 | NA | 39.3707 | -106.7839 | (39.370699999999999, -106.7839) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.aspentimes.com/article/20080529/NEWS/719766231/0/FRONTPAGE |
| 643 | 7/13/08 | NA | NA | United States | US | Colorado | 16887 | Durango | 2.94432 | NA | 37.2500 | -107.8700 | (37.25, -107.87) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://durangoherald.com/asp-bin/article_generation.asp?article_type=news&article_path=/news/08/news080713_7.htm |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Connecticut")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1454 | 1/25/10 | 13:40:00 | NA | United States | US | Connecticut | 1212 | Canaan | 10.75115 | NA | 41.9953 | -73.2068 | (41.9953, -73.206800000000001) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.courant.com/news/breaking/hc-norfolk-mudslide-0125,0,7632324.story |
| 1601 | 3/30/10 | 15:00:00 | NA | United States | US | Connecticut | 47648 | Middletown | 1.40994 | NA | 41.5663 | -72.6667 | (41.566299999999998, -72.666700000000006) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://wvgazette.com/Outdoors/Recreation/201003230724 |
| 3176 | 3/6/11 | NA | NA | United States | US | Connecticut | 9549 | Bethel | 2.63291 | NA | 41.3484 | -73.4226 | (41.348399999999998, -73.422600000000003) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.ctpost.com/news/article/Metro-North-service-derailed-on-first-day-back-on-1045889.php |
| 3177 | 3/7/11 | 2:00:00 | NA | United States | US | Connecticut | 28142 | New Milford | NA | NA | NA | NA | NA | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.newstimes.com/local/article/New-Milford-Kent-hit-hard-by-flooding-1046004.php |
| 4907 | 6/7/13 | NA | NA | United States | US | Connecticut | 3554 | Old Mystic | 0.78631 | NA | 41.3860 | -71.9558 | (41.386000000000003, -71.955799999999996) | Landslide | Mudslide | Small | Tropical cyclone | Andrea | NA | 0 | stonington.patch.com | http://stonington.patch.com/groups/weather-/p/flooding-and-mudslide-from-storm-in-mystic-pawcatuck-and-old-mystic |
| 5967 | 3/20/14 | Morning | NA | United States | US | Connecticut | 51384 | Stratford | 0.76857 | Above road | 41.2008 | -73.1157 | (41.200800000000001, -73.115700000000004) | Landslide | Mudslide | Small | Continuous rain | NA | 0 | 0 | News 12 Connecticut | http://connecticut.news12.com/news/mudslide-blocks-part-of-ferry-boulevard-in-stratford-1.7448756 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")## Warning: Removed 1 rows containing missing values (geom_bar).
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")## Warning: Removed 1 rows containing missing values (position_stack).
library(dplyr)
df_US <- subset(df, state == "Florida")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3825 | 7/21/11 | NA | NA | United States | US | Florida | 2768 | Williston | 3.75018 | NA | 29.3879 | -82.4854 | (29.387899999999998, -82.485399999999998) | Landslide | Landslide | Medium | Rain | NA | NA | 0 | NA | http://www.carrollconews.com/story/1748404.html |
| 4830 | 4/30/13 | 21:00:00 | NA | United States | US | Florida | 28742 | Clermont | 0.39179 | NA | 28.5529 | -81.7737 | (28.552900000000001, -81.773700000000005) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | www.wftv.com | http://www.wftv.com/news/news/local/clermont-home-filled-3-feet-mud-after-heavy-rain/nXdM4/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Georgia")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1180 | 9/20/09 | NA | NA | United States | US | Georgia | 3410 | Cleveland | 15.92157 | NA | 34.6768 | -83.9076 | (34.6768, -83.907600000000002) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | NA |
| 1183 | 9/21/09 | NA | NA | United States | US | Georgia | 5802 | Stone Mountain | 2.07317 | NA | 33.8232 | -84.1569 | (33.8232, -84.156899999999993) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | http://www.examiner.com/x-3958-Atlanta-Northside-Family--Parenting-Examiner~y2009m9d21-Heavy-rain-flooding-in-Atlanta-causes-school-closings-mudslide-and-closed-roads |
| 1184 | 9/21/09 | Early morning | NA | United States | US | Georgia | 1602 | Lookout Mountain | 0.80279 | Above road | 34.9770 | -85.3665 | (34.976999999999997, -85.366500000000002) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | NA | http://www.timesfreepress.com/news/2009/sep/21/crews-clearing-mudslide-covenant-college/?breakingnews |
| 1194 | 9/26/09 | NA | NA | United States | US | Georgia | 2301 | Trenton | 1.12077 | NA | 34.8695 | -85.5210 | (34.869500000000002, -85.521000000000001) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.wsbtv.com/weather/21124942/detail.html |
| 2086 | 7/16/10 | Late evening | NA | United States | US | Georgia | 9432 | Jefferson | 7.58207 | NA | 34.1538 | -83.6417 | (34.153799999999997, -83.6417) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://mdn.mainichi.jp/mdnnews/news/20100716p2a00m0na045000c.html |
| 4868 | 5/19/13 | NA | NA | United States | US | Georgia | 2536 | Dawsonville | 12.44051 | NA | 34.3426 | -84.0226 | (34.342599999999997, -84.022599999999997) | Landslide | Landslide | Medium | Rain | NA | NA | NA | mableton.11alive.com | http://mableton.11alive.com/news/news/256562-weekend-storms-result-flooding-mudslide |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Idaho")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 236 | 9/5/07 | NA | NA | United States | US | Idaho | 2689 | Ketchum | 4.51471 | NA | 43.6846 | -114.4194 | (43.684600000000003, -114.4194) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | NA | NA |
| 659 | 7/22/08 | NA | NA | United States | US | Idaho | 2991 | McCall | 29.97781 | NA | 44.9300 | -115.7200 | (44.93, -115.72) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.670kboi.com/Article.asp?id=805380&spid=18042 |
| 660 | 7/22/08 | NA | NA | United States | US | Idaho | 3112 | Salmon | 25.30277 | NA | 44.9800 | -114.0600 | (44.98, -114.06) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://georgia-skywarn.blogspot.com/2008/07/kmso-230038-preliminary-local-storm.html |
| 800 | 9/20/08 | NA | NA | United States | US | Idaho | 1406 | Sun Valley | 1.58679 | NA | 43.7000 | -114.3710 | (43.7, -114.371) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | http://www.mtexpress.com/vu_breaking_story.php?bid=5914 |
| 1040 | 6/21/09 | 18:00:00 | NA | United States | US | Idaho | 2689 | Ketchum | 1.27144 | NA | 43.6883 | -114.3755 | (43.688299999999998, -114.3755) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.magicvalley.com/articles/2009/06/24/news/local_state/164790.txt |
| 3015 | 1/16/11 | NA | NA | United States | US | Idaho | 485 | Idaho City | 34.46887 | NA | 44.0967 | -116.0504 | (44.096699999999998, -116.0504) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.kboi2.com/news/local/113880644.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Illinois")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 491 | 4/1/08 | NA | NA | United States | US | Illinois | 8465 | Jerseyville | 18.72748 | NA | 38.9716 | -90.4312 | (38.971600000000002, -90.431200000000004) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NA | http://www.etrucker.com/apps/news/article.asp?id=68018 |
| 1307 | 11/17/09 | NA | NA | United States | US | Illinois | 27865 | Alton | 1.54044 | NA | 38.8980 | -90.1993 | (38.898000000000003, -90.199299999999994) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.thetelegraph.com/news/park-33219-street-down.html |
| 3550 | 5/28/11 | 3:00:00 | NA | United States | US | Illinois | 27865 | Alton | 1.71596 | Bluff | 38.8994 | -90.2006 | (38.8994, -90.200599999999994) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | St. Louis Post-Dispatch | http://www.stltoday.com/news/local/metro/article_05b458a2-8962-11e0-b4df-001a4bcf6878.html |
| 4810 | 4/18/13 | 10:00:00 | NA | United States | US | Illinois | 1427 | Granville | 2.12940 | NA | 41.2581 | -89.2025 | (41.258099999999999, -89.202500000000001) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | newstrib.com | http://newstrib.com/main.asp?SectionID=2&SubSectionID=27&ArticleID=28289 |
| 4811 | 4/18/13 | NA | NA | United States | US | Illinois | 23402 | East Peoria | 2.39991 | Urban area | 40.6535 | -89.5556 | (40.653500000000001, -89.555599999999998) | Landslide | Mudslide | Small | Rain | NA | NA | NA | www.indianasnewscenter.com | http://www.indianasnewscenter.com/news/top-news/203610501.html |
| 4884 | 5/29/13 | Early morning | NA | United States | US | Illinois | 40633 | Quincy | 2.38934 | NA | 39.9141 | -91.4110 | (39.914099999999998, -91.411000000000001) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | www.youtube.com | http://www.youtube.com/watch?v=_wyFzUcJwvI |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Indiana")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 386 | 12/8/07 | NA | NA | United States | US | Indiana | 5042 | Lawrenceburg | 2.66572 | NA | 39.1010 | -84.8220 | (39.100999999999999, -84.822000000000003) | Landslide | Landslide | Medium | Rain | NA | NA | NA | Kentucky Post.com | http://news.nky.com/apps/pbcs.dll/article?AID=/AE/20071210/NEWS02/712100367/1011/news0103 |
| 577 | 6/7/08 | NA | NA | United States | US | Indiana | 11828 | Martinsville | 0.63962 | NA | 39.4279 | -86.4209 | (39.427900000000001, -86.420900000000003) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.wishtv.com/global/story.asp?s=8455933 |
| 2007 | 6/21/10 | NA | NA | United States | US | Indiana | 67140 | Lafayette | 6.08613 | NA | 40.4250 | -86.8044 | (40.424999999999997, -86.804400000000001) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.wlfi.com/dpp/news/local/effects-of-mondays-storms-linger |
| 3635 | 6/20/11 | Morning | NA | United States | US | Indiana | 1712 | Southport | 2.61312 | NA | 39.6416 | -86.1251 | (39.641599999999997, -86.125100000000003) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.wishtv.com/dpp/news/local/marion_county/wall-collapse-mudslide-leaves-family-homeless |
| 7165 | NA | 12:15 | NA | United States | US | Indiana | 2085 | Rockport | 8.43158 | Above road | 39.8690 | -87.1816 | (39.869, -87.181600000000003) | Landslide | Landslide | Small | Rain | NA | 0 | 0 | WTHITV10 | http://wthitv.com/2015/04/09/parke-county-sheriffs-office-reported-mudslide-on-u-s-41-thursday-afternoon/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Lowa")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Kansas")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4282 | 3/22/12 | Early morning | NA | United States | US | Kansas | 6731 | Roeland Park | 2.32126 | NA | 39.0545 | -94.6478 | (39.054499999999997, -94.647800000000004) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://fox4kc.com/2012/03/22/driver-punctures-tire-in-kck-mudslide/ |
| 7042 | NA | Morning | NA | United States | US | Kansas | 857 | Oregon | 14.54524 | Above road | 39.9892 | -95.3153 | (39.989199999999997, -95.315299999999993) | Landslide | Mudslide | Small | Downpour | NA | 0 | 0 | KSNT | http://ksnt.com/2015/05/26/update-flooded-roadways/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Kentucky")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61 | 4/15/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 5.66542 | Below road | 37.4325 | -82.4931 | (37.432499999999997, -82.493099999999998) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | Matthew Crawford (KGS) | NA |
| 64 | 4/20/07 | NA | NA | United States | US | Kentucky | 6903 | Pikeville | 0.23715 | NA | 37.4814 | -82.5186 | (37.481400000000001, -82.518600000000006) | Landslide | Landslide | Small | Rain | NA | NA | NA | Applalachain news-express | http://www.news-expressky.com/articles/2007/04/19/top_story/01mudslide.txt |
| 487 | 3/28/08 | NA | NA | United States | US | Kentucky | 4407 | Ludlow | 2.26622 | NA | 39.1072 | -84.5657 | (39.107199999999999, -84.565700000000007) | Landslide | Landslide | Small | Rain | NA | NA | NA | NA | http://news.enquirer.com/apps/pbcs.dll/article?AID=/20080328/NEWS01/303280087 |
| 546 | 5/20/08 | NA | NA | United States | US | Kentucky | 5723 | Fort Wright | 0.90111 | NA | 39.0447 | -84.5289 | (39.044699999999999, -84.528899999999993) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.kypost.com/news/local/story.aspx?content_id=e4bc2ce5-40ee-4956-8c26-fdcda7fb53d9 |
| 1022 | 5/8/09 | NA | NA | United States | US | Kentucky | 777 | Hindman | 15.41975 | NA | 37.4514 | -82.8836 | (37.4514, -82.883600000000001) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | Matthew Crawford (KGS) | NA |
| 1023 | 5/8/09 | NA | NA | United States | US | Kentucky | 2231 | Jackson | 9.34774 | NA | 37.5495 | -83.4892 | (37.549500000000002, -83.489199999999997) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | Matthew Crawford (KGS) | NA |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Maine")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1606 | 3/30/10 | NA | NA | United States | US | Maine | 7794 | Winslow | 0.76489 | NA | 44.5407 | -69.6250 | (44.540700000000001, -69.625) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.messenger.com.ge/issues/2065_march_17_2010/2065_liana.html |
| 6058 | 6/15/14 | 8:00:00 | NA | United States | US | Maine | 1097 | Wiscasset | 9.00019 | Unknown | 44.0765 | -69.6188 | (44.076500000000003, -69.618799999999993) | Landslide | Landslide | Small | Continuous rain | NA | 0 | 0 | Wiscasset Newspaper | http://www.wiscassetnewspaper.com/article/landslide-alna/35358 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Maryland")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2530 | 10/1/10 | Afternoon | NA | United States | US | Maryland | 10519 | Chesapeake Ranch Estates | 2.52659 | NA | 38.3558 | -76.3915 | (38.355800000000002, -76.391499999999994) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.washingtonpost.com/wp-dyn/content/article/2010/10/08/AR2010100806839.html |
| 3379 | 4/17/11 | 10:00:00 | NA | United States | US | Maryland | 6170 | Thurmont | 3.50924 | NA | 39.6526 | -77.4274 | (39.6526, -77.427400000000006) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.herald-mail.com/news/local/hm-md-550-in-thurmont-area-remains-closed-due-to-mudslide-20110419,0,5636540.story |
| 6003 | 4/30/14 | 16:00:00 | NA | United States | US | Maryland | 620961 | Baltimore | 5.94285 | Retaining wall | 39.3194 | -76.6163 | (39.319400000000002, -76.616299999999995) | Landslide | Landslide | Medium | Downpour | NA | 0 | 0 | The Washington Post | http://www.washingtonpost.com/local/street-collapses-in-baltimore-washing-away-cars/2014/04/30/89f6dcfa-d0b0-11e3-a6b1-45c4dffb85a6_story.html |
| 6006 | 5/1/14 | NA | NA | United States | US | Maryland | 1116 | Charlestown | 4.24402 | Below road | 39.2902 | -76.6651 | (39.290199999999999, -76.665099999999995) | Landslide | Mudslide | Small | Rain | NA | 0 | 0 | WBALTV | http://www.wbaltv.com/news/mudslide-reported-at-baltimore-cemetery/25772494#!Vwt2L |
| 6278 | 5/15/14 | NA | NA | United States | US | Maryland | 23717 | Fort Washington | 2.15609 | Above road | 38.6987 | -77.0008 | (38.698700000000002, -77.000799999999998) | Landslide | Mudslide | Small | Downpour | NA | 0 | 0 | WUSA | http://www.wusa9.com/story/news/local/fort-washington/2014/09/25/fort-washington-mudslide-residents-warned-prepare-for-no-access-to-homes-in-2015/16228171/ |
| 6585 | 5/11/08 | 5:45 | NA | United States | US | Maryland | 19096 | Camp Springs | 1.87540 | Above river | 38.8162 | -76.9216 | (38.816200000000002, -76.921599999999998) | Landslide | Other | Medium | Continuous rain | NA | 0 | 0 | Hazard Mitigation Plan | http://www.princegeorgescountymd.gov/sites/Sustainable/Services/FloodManagement/Documents/PG-Laurel_HazardMitPlan.pdf |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Massachusetts")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 779 | 9/6/08 | NA | NA | United States | US | Massachusetts | 39880 | Holyoke | 2.84100 | NA | 42.2280 | -72.6290 | (42.228000000000002, -72.629000000000005) | Landslide | Mudslide | Medium | Tropical cyclone | Hurricane Hannah | NA | NA | NA | http://www.cbs3springfield.com/news/local/27976049.html |
| 1568 | 3/14/10 | NA | NA | United States | US | Massachusetts | 2717 | Topsfield | 1.03712 | NA | 42.6428 | -70.9390 | (42.642800000000001, -70.938999999999993) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.salemnews.com/punews/local_story_074003455.html |
| 1575 | 3/15/10 | 2:00:00 | NA | United States | US | Massachusetts | 7389 | Clinton | 1.25138 | NA | 42.4135 | -71.6974 | (42.413499999999999, -71.697400000000002) | Landslide | Mudslide | Small | Rain | NA | NA | 0 | NA | http://www.telegram.com/article/20100319/COULTER01/3190328/1189/coulter |
| 1576 | 3/15/10 | 19:00:00 | NA | United States | US | Massachusetts | 5918 | Walpole | 2.73316 | NA | 42.1433 | -71.2165 | (42.143300000000004, -71.216499999999996) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.wickedlocal.com/walpole/news/x427971816/Landslide-destroys-storage-building |
| 3178 | 3/7/11 | 5:00:00 | NA | United States | US | Massachusetts | 19753 | Greenfield | 0.81961 | NA | 42.5804 | -72.6018 | (42.580399999999997, -72.601799999999997) | Landslide | Mudslide | Medium | Rain | NA | NA | 0 | WGGB | http://www.wggb.com/Global/story.asp?S=14204808 |
| 5566 | 9/30/13 | NA | NA | United States | US | Massachusetts | 19030 | Southbridge | 2.82925 | NA | 42.1004 | -72.0295 | (42.1004, -72.029499999999999) | Landslide | Landslide | Medium | Continuous rain | NA | NA | 0 | www.telegram.com | http://www.telegram.com/article/20131005/NEWS/310059919/1116 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Michigan")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3538 | 5/25/11 | NA | NA | United States | US | Michigan | 113934 | Ann Arbor | 1.89658 | NA | 42.2939 | -83.7342 | (42.293900000000001, -83.734200000000001) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.detnews.com/article/20110526/METRO/105260465/1361/Ann-Arbor-mudslide-amid-heavy-rains-causes--significant--damage |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Minnesota")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187 | 8/18/07 | NA | NA | United States | US | Minnesota | 2868 | Caledonia | 22.31062 | NA | 43.5960 | -91.2256 | (43.595999999999997, -91.2256) | Landslide | Landslide | Medium | Rain | NA | NA | NA | The Sun Times | http://www.suntimes.com/news/nation/516414,19flooding.article |
| 189 | 8/18/07 | NA | NA | United States | US | Minnesota | 106769 | Rochester | 0.99990 | NA | 44.0304 | -92.4671 | (44.0304, -92.467100000000002) | Landslide | Mudslide | Small | Rain | NA | NA | NA | Post bulletin.com | http://www.postbulletin.com/newsmanager/templates/localnews_story.asp?a=304463&z=2 |
| 509 | 4/25/08 | NA | NA | United States | US | Minnesota | 27592 | Winona | 1.72940 | NA | 44.0344 | -91.6396 | (44.034399999999998, -91.639600000000002) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.winonadailynews.com/articles/2008/04/26/news/04mud26.txt |
| 2010 | 6/23/10 | Morning | NA | United States | US | Minnesota | 2868 | Caledonia | 18.20633 | NA | 43.6229 | -91.2718 | (43.622900000000001, -91.271799999999999) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.wxow.com/Global/story.asp?S=12694849 |
| 4364 | 5/24/12 | NA | NA | United States | US | Minnesota | 9552 | Arden Hills | 0.13052 | NA | 45.0514 | -93.1569 | (45.051400000000001, -93.156899999999993) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://minnesota.cbslocal.com/2012/05/24/heavy-rain-mudslide-slows-twin-cities-commute/ |
| 4872 | 5/22/13 | 1:13 | NA | United States | US | Minnesota | 19540 | West Saint Paul | 1.89742 | Bluff | 44.9179 | -93.1255 | (44.917900000000003, -93.125500000000002) | Landslide | Rockfall | Medium | Rain | NA | 2 | 2 | www.cbsnews.com | http://www.cbsnews.com/8301-201_162-57585821/minn-park-landslide-leaves-1-child-dead-1-missing/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Mississippi")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1367 | 12/18/09 | NA | NA | United States | US | Mississippi | 2175 | Purvis | 17.40130 | NA | 31.1345 | -89.2276 | (31.134499999999999, -89.227599999999995) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.clarionledger.com/article/20091219/NEWS/912190329/1001/RSS01 |
| 7129 | 4/20/15 | NA | NA | United States | US | Mississippi | 9486 | D’Iberville | 0.98037 | Above river | 30.4273 | -88.8807 | (30.427299999999999, -88.880700000000004) | Landslide | landslide | Small | Continuous rain | NA | 0 | 0 | WXXV25 | http://www.wxxv25.com/news/local/story/Landslide-In-Biloxi/3tJErH3uVUG8-9fsT9c0-Q.cspx |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Missouri")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1017 | 5/4/09 | NA | NA | United States | US | Missouri | 17916 | Hannibal | 1.93676 | NA | 39.7230 | -91.3708 | (39.722999999999999, -91.370800000000003) | Landslide | Landslide | Small | Continuous rain | NA | NA | 0 | NA | http://www.wgem.com/global/story.asp?s=10301250 |
| 1357 | 12/12/09 | NA | NA | United States | US | Missouri | 3364 | Louisiana | 7.60154 | NA | 39.4052 | -90.9836 | (39.405200000000001, -90.983599999999996) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://www.koamtv.com/Global/story.asp?S=11679374 |
| 1859 | 5/14/10 | 5:00:00 | NA | United States | US | Missouri | 4208 | North Kansas City | 5.24463 | NA | 39.1550 | -94.5107 | (39.155000000000001, -94.5107) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.kctv5.com/traffic/23551215/detail.html |
| 3182 | 3/8/11 | 5:00:00 | NA | United States | US | Missouri | 35517 | Wildwood | 2.41198 | Below road | 38.5678 | -90.6426 | (38.567799999999998, -90.642600000000002) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | Eureka-Wildwood Patch | http://eureka-wildwood.patch.com/articles/section-of-missouri-route-109-caving-with-mudslide |
| 3408 | 4/25/11 | NA | NA | United States | US | Missouri | 4426 | Hollister | 8.78605 | NA | 36.5989 | -93.3097 | (36.5989, -93.309700000000007) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.kspr.com/news/local/kspr-mudslide-closes-us-165-at-table-rock-dam-20110425,0,4109014.story |
| 3441 | 4/30/11 | NA | NA | United States | US | Missouri | 2184 | Willow Springs | 13.48426 | NA | 36.9118 | -92.0833 | (36.911799999999999, -92.083299999999994) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://www.news-leader.com/article/20110501/NEWS01/110501008/1007/Slide-causes-road-closure-near-Noblett-Lake |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Montana")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5124 | 7/17/13 | NA | NA | United States | US | Montana | 1271 | West Yellowstone | 51.55941 | NA | 45.0432 | -110.732 | (45.043199999999999, -110.732) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | www.kbzk.com | http://www.kbzk.com/news/crews-work-to-clear-highway-89-yellowstone-s-north-entrance-re-opens/#!prettyPhoto/0/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Nevada")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1956 | 6/7/10 | NA | NA | United States | US | Nevada | 12361 | Spring Creek | 16.13996 | NA | 40.6553 | -115.4195 | (40.655299999999997, -115.4195) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://e-pao.net/GP.asp?src=3..100610.jun10 |
| 2873 | 12/20/10 | NA | NA | United States | US | Nevada | 24085 | Summerlin South | 19.35795 | NA | 36.0185 | -115.5073 | (36.018500000000003, -115.5073) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://pvtimes.com/news/soaked-storm-drenches-valley-mudslide-closes-160-at-mountain-springs/ |
| 5083 | 7/12/13 | Afternoon | NA | United States | US | Nevada | 24085 | Summerlin South | 30.37462 | NA | 36.2629 | -115.6158 | (36.262900000000002, -115.61579999999999) | Landslide | Debris flow | Medium | Rain | NA | NA | 0 | www.lasvegassun.com | http://www.lasvegassun.com/news/2013/jul/12/rain-lets-crews-attack-mount-charleston-wildfire-n/ |
| 5350 | 8/18/13 | Afternoon | NA | United States | US | Nevada | 24085 | Summerlin South | 23.60286 | NA | 36.2423 | -115.5421 | (36.2423, -115.5421) | Landslide | Debris flow | Medium | Downpour | NA | NA | 0 | www.mynews3.com | http://www.mynews3.com/content/news/story/Kyle-Canyon-debris-flows-wildfire/9j4oCNRJjEiUUG6WT6IVeA.cspx |
| 5351 | 8/18/13 | Afternoon | NA | United States | US | Nevada | 36441 | Pahrump | 31.00660 | NA | 36.2566 | -115.6442 | (36.256599999999999, -115.6442) | Landslide | Debris flow | Medium | Downpour | NA | NA | 0 | www.mynews3.com | http://www.mynews3.com/content/news/story/Kyle-Canyon-debris-flows-wildfire/9j4oCNRJjEiUUG6WT6IVeA.cspx |
| 5420 | 8/30/13 | Night | NA | United States | US | Nevada | 36441 | Pahrump | 18.54588 | NA | 36.1054 | -115.8215 | (36.105400000000003, -115.8215) | Landslide | Mudslide | Medium | Rain | NA | NA | 0 | elkodaily.com | http://elkodaily.com/news/mud-slide-closes-highway-between-vegas-pahrump/article_61f2079c-127a-11e3-8525-001a4bcf887a.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "New Hampshire")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 514 | 4/29/08 | NA | NA | United States | US | New Hampshire | 1813 | Newbury | 0.08548 | NA | 43.3207 | -72.0358 | (43.320700000000002, -72.035799999999995) | Landslide | Rockfall | Small | Rain | NA | NA | NA | NA | http://www.unionleader.com/article.aspx?headline=Rockslide,+mudslide+close+sections+of+state+roads&articleId=1f07d044-00a9-48f0-a52c-2e5086228171 |
| 515 | 4/29/08 | NA | NA | United States | US | New Hampshire | 1142 | Whitefield | 8.19938 | NA | 44.4175 | -71.6923 | (44.417499999999997, -71.692300000000003) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.unionleader.com/article.aspx?headline=Rockslide,+mudslide+close+sections+of+state+roads&articleId=1f07d044-00a9-48f0-a52c-2e5086228171 |
| 691 | 8/6/08 | NA | NA | United States | US | New Hampshire | 1126 | Woodsville | 5.61303 | NA | 44.1460 | -71.9677 | (44.146000000000001, -71.967699999999994) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.necn.com/Boston/New-England/Mudslide-closes-stretch-of-112-in-NH-/1218116094.html |
| 1608 | 3/31/10 | Evening | NA | United States | US | New Hampshire | 1108 | Greenville | 0.29408 | NA | 42.7679 | -71.8158 | (42.767899999999997, -71.815799999999996) | Landslide | Landslide | Medium | Rain | NA | NA | 0 | NA | http://www.focus-fen.net/index.php?id=n213309 |
| 2529 | 10/1/10 | 9:30:00 | NA | United States | US | New Hampshire | 1126 | Woodsville | 5.48538 | NA | 44.1473 | -71.9691 | (44.147300000000001, -71.969099999999997) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.wmur.com/weather/25237221/detail.html |
| 4599 | 10/30/12 | NA | NA | United States | US | New Hampshire | 1213 | Woodstock | 14.34429 | NA | 44.1009 | -71.6322 | (44.100900000000003, -71.632199999999997) | Landslide | Landslide | Medium | Tropical cyclone | Hurricane Sandy | NA | 1 | NA | http://www.wcax.com/story/19960080/storm-blamed-for-nh-mudslide-death |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "New Jersey")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 617 | 6/29/08 | NA | NA | United States | US | New Jersey | 34457 | Orange | 3.31974 | NA | 40.7800 | -74.2700 | (40.78, -74.27) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://oshaunderground.blogspot.com/2008/06/another-trench-collapse-we-missed-in.html |
| 1565 | 3/13/10 | Night | NA | United States | US | New Jersey | 9916 | Lake Mohawk | 4.41013 | NA | 41.0469 | -74.6236 | (41.046900000000001, -74.623599999999996) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.nj.com/news/index.ssf/2010/03/rain_mostly_over_but_rising_pa.html |
| 1569 | 3/14/10 | NA | NA | United States | US | New Jersey | 2410 | Ogdensburg | 0.77081 | NA | 41.0752 | -74.5894 | (41.075200000000002, -74.589399999999998) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.nj.com/news/index.ssf/2010/03/rain_mostly_over_but_rising_pa.html |
| 3368 | 4/16/11 | NA | NA | United States | US | New Jersey | 50005 | Hoboken | 0.84845 | NA | 40.7443 | -74.0424 | (40.744300000000003, -74.042400000000001) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.nj.com/hudson/index.ssf/2011/04/storm_causes_mudslide_at_338_o.html |
| 3926 | 8/15/11 | NA | NA | United States | US | New Jersey | 4933 | Highland Lake | 5.27337 | NA | 41.1838 | -74.5187 | (41.183799999999998, -74.518699999999995) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.myfoxny.com/dpp/news/flooding-and-landslide-in-new-jersey-20110815 |
| 3966 | 9/8/11 | NA | NA | United States | US | New Jersey | 2681 | Belvidere | 0.07578 | NA | 40.8305 | -75.0776 | (40.830500000000001, -75.077600000000004) | Landslide | Mudslide | Small | Rain | NA | NA | 0 | NA | http://www.channel6newsonline.com/2011/09/mudslide-in-belvidere-nj-leads-to-house-collapse/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "New Mexico")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 228 | 9/3/07 | NA | NA | United States | US | New Mexico | 1788 | Jemez Pueblo | 12.89915 | NA | 35.7297 | -106.7130 | (35.729700000000001, -106.71299999999999) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | NA | NA |
| 629 | 7/5/08 | NA | NA | United States | US | New Mexico | 13753 | Las Vegas | 15.17455 | NA | 35.4600 | -105.1900 | (35.46, -105.19) | Landslide | Debris flow | Medium | Downpour | NA | NA | NA | NA | http://www.koat.com/news/16799769/detail.html |
| 686 | 8/4/08 | NA | NA | United States | US | New Mexico | 1788 | Jemez Pueblo | 12.68493 | NA | 35.7279 | -106.7150 | (35.727899999999998, -106.715) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.krqe.com/global/story.asp?s=8787183 |
| 2124 | 7/23/10 | NA | NA | United States | US | New Mexico | 9051 | Socorro | 25.68212 | NA | 33.9917 | -107.1577 | (33.991700000000002, -107.15770000000001) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.kob.com/article/stories/S1666497.shtml?cat=504 |
| 3852 | 7/27/11 | NA | NA | United States | US | New Mexico | 1297 | Hurley | 17.95414 | NA | 32.6209 | -107.9645 | (32.620899999999999, -107.9645) | Landslide | Debris flow | Small | Downpour | NA | NA | 0 | NA | http://www.youtube.com/watch?v=XvknaGRbBFg |
| 5059 | 7/8/13 | 15:00:00 | NA | United States | US | New Mexico | 1770 | Questa | 21.76837 | NA | 36.7025 | -105.3514 | (36.702500000000001, -105.3514) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | www.sangrechronicle.com | http://www.sangrechronicle.com/articles/2013/07/08/news/doc51db2e0d5781a072636483.txt |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "New York")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 476 | 3/9/08 | NA | NA | United States | US | New York | 2620 | Green Island | 4.36125 | NA | 42.7404 | -73.6385 | (42.740400000000001, -73.638499999999993) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://www.fox23news.com/news/local/story.aspx?content_id=6b16c1c8-1f16-48e4-a04a-7b8ba04d8f39 |
| 590 | 6/16/08 | NA | NA | United States | US | New York | 1031 | Hancock | 4.46079 | NA | 41.9420 | -75.2291 | (41.942, -75.229100000000003) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://news10now.com/content/all_news/118296/mudslide-closes-part-of-delaware-county-road/Default.aspx |
| 1595 | 3/26/10 | 23:30:00 | NA | United States | US | New York | 1113 | Worcester | 7.59235 | NA | 42.5435 | -74.8163 | (42.543500000000002, -74.816299999999998) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.kcby.com/news/local/87512322.html |
| 1602 | 3/30/10 | NA | NA | United States | US | New York | 7612 | Sound Beach | 0.94386 | NA | 40.9647 | -72.9684 | (40.964700000000001, -72.968400000000003) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.dglobe.com/event/article/id/33900/group/News/ |
| 1603 | 3/30/10 | 7:19:00 | NA | United States | US | New York | 195976 | Yonkers | 3.28687 | NA | 40.9040 | -73.9141 | (40.904000000000003, -73.914100000000005) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.salemnews.com/punews/local_story_074003455.html |
| 2028 | 6/28/10 | 12:00:00 | NA | United States | US | New York | 10545 | Canandaigua | 8.27871 | NA | 42.8004 | -77.3018 | (42.800400000000003, -77.3018) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.mpnnow.com/features/x1876469337/Flooding-closes-a-portion-of-West-Lake-Road?img=3 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "North Carolina")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 751 | 8/26/08 | NA | NA | United States | US | North Carolina | 1192 | Lake Lure | 0.85349 | NA | 35.4213 | -82.2000 | (35.421300000000002, -82.2) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.wspa.com/spa/news/local/article/restaurant_caked_with_mud_from_slide_in_lake_lure/7712/ |
| 757 | 8/28/08 | NA | NA | United States | US | North Carolina | 1192 | Lake Lure | 5.17876 | NA | 35.4437 | -82.2585 | (35.4437, -82.258499999999998) | Landslide | Mudslide | Small | Tropical cyclone | Tropical Storm Fay | NA | NA | NA | http://www.citizen-times.com/apps/pbcs.dll/article?AID=200880828087 |
| 958 | 1/7/09 | 1:41:00 | NA | United States | US | North Carolina | 1150 | Maggie Valley | 2.71542 | NA | 35.5070 | -83.0710 | (35.506999999999998, -83.070999999999998) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | NA |
| 1026 | 5/17/09 | NA | NA | United States | US | North Carolina | 18228 | Lenoir | 9.72793 | NA | 35.9993 | -81.5640 | (35.999299999999998, -81.563999999999993) | Landslide | Mudslide | Small | Downpour | NA | NA | 1 | NA | http://www.wcnc.com/news/local/stories/wcnc-051709-sjf-ncweather.120f9025.html |
| 1039 | 6/19/09 | NA | NA | United States | US | North Carolina | 3776 | Hudson | 10.33560 | NA | 35.9100 | -81.4100 | (35.909999999999997, -81.41) | Landslide | Rockfall | Medium | Downpour | NA | NA | 0 | NA | http://www.wsoctv.com/news/19804230/detail.html |
| 1185 | 9/21/09 | NA | NA | United States | US | North Carolina | 7609 | Brevard | 3.61918 | NA | 35.2594 | -82.7102 | (35.259399999999999, -82.7102) | Landslide | Landslide | Small | Downpour | NA | NA | NA | NA | http://www.wral.com/news/state/story/6050495/ |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Ohio")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 3/22/07 | NA | NA | United States | US | Ohio | 17288 | New Philadelphia | 3.33522 | NA | 40.5175 | -81.4305 | (40.517499999999998, -81.430499999999995) | Landslide | Landslide | Small | Rain | NA | NA | NA | Canton Rep.com | http://www.cantonrep.com/index.php?ID=345054&Category=9&subCategoryID=0 |
| 479 | 3/14/08 | NA | NA | United States | US | Ohio | 5091 | Toronto | 1.02992 | NA | 40.4634 | -80.6130 | (40.4634, -80.613) | Landslide | Mudslide | Small | Rain | NA | NA | NA | NA | http://www.wtov9.com/news/15606654/detail.html |
| 480 | 3/16/08 | NA | NA | United States | US | Ohio | 4741 | Mount Carmel | 1.17753 | NA | 39.0960 | -84.2992 | (39.095999999999997, -84.299199999999999) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://www.wlwt.com/news/15618502/detail.html |
| 485 | 3/24/08 | NA | NA | United States | US | Ohio | 3541 | Wellsville | 7.05134 | NA | 40.5573 | -80.7070 | (40.557299999999998, -80.706999999999994) | Landslide | Landslide | Small | Rain | NA | NA | NA | NA | http://www.wtov9.com/news/15690351/detail.html |
| 1567 | 3/14/10 | 16:30:00 | NA | United States | US | Ohio | 6397 | Jackson | 13.05284 | NA | 38.9632 | -82.7353 | (38.963200000000001, -82.735299999999995) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.dglobe.com/event/article/id/33900/group/News/ |
| 1584 | 3/21/10 | Overnight | NA | United States | US | Ohio | 1311 | Salineville | 10.58008 | NA | 40.5399 | -80.9000 | (40.539900000000003, -80.900000000000006) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.geotimes.ge/index.php?m=home&newsid=20770 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Oklahoma")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6952 | 6/18/15 | NA | NA | United States | US | Oklahoma | 2739 | Longtown | 19.40495 | Below road | 35.1087 | -95.6457 | (35.108699999999999, -95.645700000000005) | Landslide | Mudslide | Small | Continuous rain | NA | 0 | 0 | McAlester News-Capital | http://www.mcalesternews.com/news/local_news/heavy-rains-bring-mudslide-highway-closure/article_37f53eb3-0afb-56a8-b9fd-30ab091d9367.html |
| 6954 | 6/18/15 | 6:45 | NA | United States | US | Oklahoma | 2683 | Davis | 7.00621 | Above road | 34.4406 | -97.1280 | (34.440600000000003, -97.128) | Landslide | Landslide | Small | Tropical cyclone | Tropical Storm Bill | 0 | 0 | ABC | http://www.kltv.com/story/29356021/major-oklahoma-texas-highway-partly-reopened-after-landslide |
| 7025 | 5/29/15 | NA | NA | United States | US | Oklahoma | 39223 | Muskogee | 12.21464 | Natural slope | 35.6601 | -95.2882 | (35.6601, -95.288200000000003) | Landslide | Mudslide | Small | Downpour | NA | 0 | 0 | Muskogee Phoenix | http://www.muskogeephoenix.com/news/local_news/mudslide-traps-woman-at-home/article_eec1e4f0-5355-58fa-8d81-993d17a08f87.html |
| 7046 | 5/23/15 | NA | NA | United States | US | Oklahoma | 1114 | Talihina | 33.62663 | Unknown | 34.5208 | -95.2859 | (34.520800000000001, -95.285899999999998) | Landslide | Landslide | Small | Flooding | NA | 0 | 0 | News9 | http://www.news9.com/story/29142048/landslide-causes-road-closure-in-pushmataha-county |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Oregon")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5859 | 2/11/14 | NA | NA | United States | US | Oregon | 1081 | Joseph | 22.16606 | Unknown | 45.1623 | -117.3062 | (45.162300000000002, -117.3062) | Landslide | Snow avalanche | Large | unknown | NA | 2 | 2 | Oregon Alive The Oregonian | http://www.oregonlive.com/news/index.ssf/2014/02/i-84_landslide_watch_crews_to.html#http://www.oregonlive.com/news/index.ssf/2014/02/i-84_landslide_watch_crews_to.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Pennsylvania")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56 | 4/6/07 | NA | NA | United States | US | Pennsylvania | 15930 | Wilkinsburg | 2.91977 | Urban area | 40.4377 | -79.9160 | (40.4377, -79.915999999999997) | Landslide | Landslide | Small | Rain | NA | NA | NA | The Pittsburgh Channel.com | https://web.archive.org/web/20080423132842/http://www.thepittsburghchannel.com/news/11846833/detail.html |
| 396 | 12/16/07 | NA | NA | United States | US | Pennsylvania | 3174 | Trafford | 0.27058 | NA | 40.3875 | -79.7569 | (40.387500000000003, -79.756900000000002) | Landslide | Landslide | Medium | Rain | NA | NA | 3 | Pittsburgh Post Gazette | http://www.post-gazette.com/pg/07352/842521-59.stm |
| 403 | 1/1/08 | NA | NA | United States | US | Pennsylvania | 4020 | Level Green | 0.03251 | Above road | 40.3916 | -79.7320 | (40.391599999999997, -79.731999999999999) | Landslide | Landslide | Small | Rain | NA | NA | NA | Pittsburgh Post-Gazette | http://www.post-gazette.com/pg/08003/846290-56.stm |
| 446 | 2/5/08 | NA | NA | United States | US | Pennsylvania | 1728 | Wickerham Manor-Fisher | 1.09139 | NA | 40.1833 | -79.8965 | (40.183300000000003, -79.896500000000003) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NA | http://www.thepittsburghchannel.com/news/15240317/detail.html |
| 449 | 2/9/08 | NA | NA | United States | US | Pennsylvania | 3451 | Etna | 1.23232 | NA | 40.4934 | -79.9458 | (40.493400000000001, -79.945800000000006) | Landslide | Landslide | Small | Rain | NA | NA | NA | NA | http://www.wpxi.com/news/15262927/detail.html |
| 469 | 3/4/08 | NA | NA | United States | US | Pennsylvania | 3165 | Homestead | 2.97055 | NA | 40.4278 | -79.9321 | (40.427799999999998, -79.932100000000005) | Landslide | Landslide | Medium | Rain | NA | NA | 0 | NA | http://www.pittsburghlive.com/x/pittsburghtrib/news/cityregion/s_555576.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "South Carolina")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1467 | 2/4/10 | 7:00:00 | NA | United States | US | South Carolina | 13905 | Clemson | 4.34093 | NA | 34.6998 | -82.8804 | (34.699800000000003, -82.880399999999995) | Landslide | Rockfall | Small | Rain | NA | NA | 0 | NA | http://www.wyff4.com/news/22461410/detail.html |
| 4871 | 5/22/13 | 21:30:00 | NA | United States | US | South Carolina | 1312 | Tigerville | 7.92482 | NA | 35.0972 | -82.4480 | (35.097200000000001, -82.447999999999993) | Landslide | Landslide | Medium | Rain | NA | NA | NA | www.wspa.com | http://www.wspa.com/story/22401714/mudslide-shuts-down-greenville-county-road-motorists-urged-to-use-caution |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "South Dakota")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67 | 4/24/07 | NA | NA | United States | US | South Dakota | 2540 | Dakota Dunes | 2.48033 | NA | 42.4941 | -96.4576 | (42.494100000000003, -96.457599999999999) | Landslide | Landslide | Small | Rain | NA | NA | NA | Sioux City Journnal | http://www.siouxcityjournal.com/articles/2007/04/25/news/top/02a92f1defdd220f862572c800126dfc.txt |
| 4893 | 6/1/13 | NA | NA | United States | US | South Dakota | 3124 | Lead | 1.39751 | NA | 44.3507 | -103.7826 | (44.350700000000003, -103.7826) | Landslide | Mudslide | Small | Rain | NA | NA | 0 | rapidcityjournal.com | http://rapidcityjournal.com/news/rain-causes-mudslide-in-lead/article_842c7803-acd9-53da-9626-6e4e112f47b6.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Tennessee")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 947 | 12/22/08 | Early morning | NA | United States | US | Tennessee | 5934 | Kingston | 2.61361 | NA | 35.9000 | -84.5255 | (35.9, -84.525499999999994) | Landslide | Lahar | Medium | Dam embankment collapse | NA | NA | NA | NA | http://www.volunteertv.com/news/headlines/36605729.html |
| 1000 | 4/8/09 | Early morning | NA | United States | US | Tennessee | 2845 | Sale Creek | 11.51020 | NA | 35.3561 | -85.2314 | (35.356099999999998, -85.231399999999994) | Landslide | Rockfall | Small | Rain | NA | NA | 0 | NA | http://www.waff.com/global/story.asp?s=10149683&ClientType=Printable |
| 1195 | 9/26/09 | NA | NA | United States | US | Tennessee | 3944 | Gatlinburg | 4.11813 | NA | 35.7102 | -83.5554 | (35.7102, -83.555400000000006) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | http://www.wbir.com/news/local/story.aspx?storyid=100222&provider=gnews |
| 1294 | 11/11/09 | NA | NA | United States | US | Tennessee | 20979 | East Ridge | 2.60684 | NA | 35.0376 | -85.2550 | (35.037599999999998, -85.254999999999995) | Landslide | Mudslide | Medium | Rain | NA | NA | 0 | NA | http://geology.com/news/2009/tennessee-rockslide-spectacular-video.shtml |
| 1353 | 12/9/09 | NA | NA | United States | US | Tennessee | 167674 | Chattanooga | 5.97545 | NA | 35.0672 | -85.3697 | (35.0672, -85.369699999999995) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | NA |
| 1354 | 12/9/09 | NA | NA | United States | US | Tennessee | 7554 | Signal Mountain | 2.05274 | NA | 35.1052 | -85.3361 | (35.105200000000004, -85.336100000000002) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | NA |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Texas")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109 | 7/1/07 | NA | NA | United States | US | Texas | 42409 | Haltom City | 0.03668 | NA | 32.7995 | -97.2688 | (32.799500000000002, -97.268799999999999) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NBC5i.com | http://www.nbc5i.com/news/13604036/detail.html |
| 138 | 7/24/07 | NA | NA | United States | US | Texas | 175396 | Grand Prairie | 5.66936 | NA | 32.7883 | -97.0317 | (32.7883, -97.031700000000001) | Landslide | Landslide | Small | Rain | NA | NA | NA | Trinity River Authority - Grand Prarie Times | http://www.gptimes.com/?story_20070627130646_story&pg7pg&storycat_GrandPrairie0_storycat |
| 1155 | 9/11/09 | NA | NA | United States | US | Texas | 4529 | Sparks | 1.34835 | NA | 31.6632 | -106.2307 | (31.6632, -106.2307) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.kvia.com/Global/story.asp?S=11118845 |
| 1256 | 10/12/09 | NA | NA | United States | US | Texas | 45028 | Cedar Hill | 6.20618 | NA | 32.5383 | -96.9854 | (32.5383, -96.985399999999998) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://www.nbcdfw.com/news/local-beat/Dallas-Backyard-Slips-Away-in-Landslide-64328652.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Utah")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 695 | 8/7/08 | NA | NA | United States | US | Utah | 7979 | Mapleton | 5.66291 | NA | 40.0800 | -111.5900 | (40.08, -111.59) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://deseretnews.com/article/1,5143,700249181,00.html |
| 698 | 8/8/08 | NA | NA | United States | US | Utah | 1270 | East Carbon City | 67.58127 | NA | 38.9749 | -110.1500 | (38.974899999999998, -110.15) | Landslide | Landslide | Small | Rain | NA | NA | NA | NA | NA |
| 1001 | 4/11/09 | 11:30:00 | NA | United States | US | Utah | 112488 | Provo | 3.35726 | NA | 40.2544 | -111.6296 | (40.254399999999997, -111.6296) | Landslide | Rockfall | Small | Downpour | NA | NA | 0 | NA | http://geology.utah.gov/utahgeo/hazards/landslide/provorock0409/index.htm |
| 1006 | 4/14/09 | Night | NA | United States | US | Utah | 33433 | Cottonwood Heights | 1.90486 | Above road | 40.6235 | -111.7443 | (40.6235, -111.7443) | Landslide | Rockfall | Small | Rain | NA | NA | 0 | KSL | http://www.ksl.com/?nid=148&sid=6163231 |
| 1007 | 4/15/09 | Morning | NA | United States | US | Utah | 20816 | East Millcreek | 1.68712 | NA | 40.7118 | -111.7980 | (40.711799999999997, -111.798) | Landslide | Rockfall | Small | Rain | NA | NA | 0 | NA | http://www.ksl.com/?nid=148&sid=6163231 |
| 1008 | 4/15/09 | Morning | NA | United States | US | Utah | 10062 | Canyon Rim | 8.13917 | Above road | 40.7676 | -111.7669 | (40.767600000000002, -111.76690000000001) | Landslide | Rockfall | Small | Rain | NA | NA | 0 | KSL | http://www.ksl.com/?nid=148&sid=6163231 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Vermont")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3463 | 5/4/11 | Morning | NA | United States | US | Vermont | 2386 | Swanton | 5.80477 | NA | 44.9378 | -73.0562 | (44.937800000000003, -73.056200000000004) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | NA |
| 3464 | 5/4/11 | 2:00:00 | NA | United States | US | Vermont | 2386 | Swanton | 5.93705 | Above river | 44.9344 | -73.0510 | (44.934399999999997, -73.051000000000002) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | WCAX | http://www.wcax.com/story/14568957/massive-mud-slide-hits-franklin-county |
| 3466 | 5/5/11 | NA | NA | United States | US | Vermont | 9052 | Barre | 6.58098 | NA | 44.2553 | -72.4875 | (44.255299999999998, -72.487499999999997) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.wcax.com/story/14582255/mudslide-in-east-montpelier |
| 3551 | 5/29/11 | 12:00:00 | NA | United States | US | Vermont | 9052 | Barre | 0.65528 | NA | 44.1921 | -72.4975 | (44.192100000000003, -72.497500000000002) | Landslide | Landslide | Small | Downpour | NA | NA | 0 | NA | http://www.wcax.com/story/14748017/saturated-soil-leads-to-barre-landslide |
| 3555 | 5/30/11 | Early morning | NA | United States | US | Vermont | 9052 | Barre | 1.15359 | NA | 44.1900 | -72.4914 | (44.19, -72.491399999999999) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://vtdigger.org/2011/05/31/welch-flood-relief-for-private-companies-and-homeowners-not-likely/ |
| 4961 | 6/18/13 | NA | NA | United States | US | Vermont | 1162 | Williamstown | 8.90467 | NA | 44.1047 | -72.4328 | (44.104700000000001, -72.4328) | Landslide | Landslide | Small | Rain | NA | NA | 0 | www.wcax.com | http://www.wcax.com/story/22626175/crews-clear-landslide-in-washington-vt |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Virginia")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 3/2/07 | Night | NA | United States | US | Virginia | 16000 | Cherry Hill | 3.40765 | Unknown | 38.6009 | -77.2682 | (38.600900000000003, -77.268199999999993) | Landslide | Landslide | Small | Rain | NA | NA | NA | NBC 4 news | http://www.nbc4.com/news/11186871/detail.html |
| 530 | 5/9/08 | NA | NA | United States | US | Virginia | 1698 | Chatmoss | 8.27691 | NA | 36.6619 | -79.7199 | (36.661900000000003, -79.719899999999996) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | http://www.accuweather.com/news-top-headline.asp?partner=accuweather&traveler=0&date=2008-05-09_07:17&month=5&year=2008 |
| 1003 | 4/13/09 | Early morning | NA | United States | US | Virginia | 1463 | East Lexington | 10.60458 | NA | 37.8826 | -79.3838 | (37.882599999999996, -79.383799999999994) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | NA |
| 1010 | 4/20/09 | Morning | NA | United States | US | Virginia | 1463 | East Lexington | 13.41471 | NA | 37.9137 | -79.4305 | (37.913699999999999, -79.430499999999995) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | NA |
| 1828 | 5/3/10 | NA | NA | United States | US | Virginia | 1414 | Clintwood | 21.45604 | NA | 37.3212 | -82.3434 | (37.321199999999997, -82.343400000000003) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.thelevisalazer.com/2010/05/03/high-waters-cover-18-roads-in-lawrence-county-school-delayed-2-hours/ |
| 2451 | 9/19/10 | Night | NA | United States | US | Virginia | 11285 | Madison Heights | 1.20498 | NA | 37.4204 | -79.1200 | (37.420400000000001, -79.12) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.wset.com/Global/story.asp?S=13201662 |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "West Virginia")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 197 | 8/20/07 | NA | NA | United States | US | West Virginia | 1526 | Glendale | 3.49200 | NA | 39.9580 | -80.7935 | (39.957999999999998, -80.793499999999995) | Landslide | Mudslide | Small | Rain | NA | NA | NA | WTOV9.com | http://www.wtov9.com/news/13943449/detail.html |
| 532 | 5/12/08 | NA | NA | United States | US | West Virginia | 1638 | Montgomery | 7.85746 | NA | 38.1362 | -81.2584 | (38.136200000000002, -81.258399999999995) | Landslide | Rockfall | Small | Rain | NA | NA | NA | NA | http://www.dailymail.com/policebrfs/200805130171 |
| 633 | 7/9/08 | NA | NA | United States | US | West Virginia | 3191 | Williamson | 2.20331 | NA | 37.6600 | -82.2600 | (37.659999999999997, -82.26) | Landslide | Landslide | Small | Downpour | NA | NA | NA | NA | http://www.williamsondailynews.com/articles/2008/07/10/news/doc4876054ea8630150941191.txt |
| 634 | 7/9/08 | NA | NA | United States | US | West Virginia | 51400 | Charleston | 3.05313 | NA | 38.3400 | -81.6000 | (38.340000000000003, -81.599999999999994) | Landslide | Mudslide | Small | Downpour | NA | NA | NA | NA | http://www.wsaz.com/charleston/headlines/24272584.html |
| 1033 | 5/30/09 | NA | NA | United States | US | West Virginia | 1142 | Hamlin | 11.50494 | NA | 38.1761 | -82.0843 | (38.176099999999998, -82.084299999999999) | Landslide | Mudslide | Small | Unknown | NA | NA | 0 | NA | http://wvgazette.com/News/200905300356 |
| 1562 | 3/12/10 | NA | NA | United States | US | West Virginia | 1260 | Belle | 0.02907 | NA | 38.2323 | -81.5377 | (38.232300000000002, -81.537700000000001) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | NA | http://www.accuweather.com/blogs/news/story/26113/midatlantic-flooding-turns-dea.asp |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Wisconsin")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193 | 8/19/07 | NA | NA | United States | US | Wisconsin | 51320 | La Crosse | 13.62525 | NA | 43.6796 | -91.2194 | (43.679600000000001, -91.219399999999993) | Landslide | Complex | Medium | Rain | NA | NA | NA | LaCrosse Tribune.com | http://www.lacrossetribune.com/articles/2007/08/20/news/03hwy35.txt |
| 194 | 8/19/07 | NA | NA | United States | US | Wisconsin | 51320 | La Crosse | 12.91337 | NA | 43.6890 | -91.2806 | (43.689, -91.280600000000007) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | FOX news | http://www.fox23news.com/news/national/story.aspx?content_id=1461f8d9-26cc-4316-9924-59f5baeaba9c |
| 498 | 4/11/08 | NA | NA | United States | US | Wisconsin | 2200 | Westby | 0.62955 | NA | 43.6516 | -90.8570 | (43.651600000000002, -90.856999999999999) | Landslide | Landslide | Medium | Unknown | NA | NA | NA | NA | http://www.westbytimes.com/articles/2008/04/16/news/01story.txt |
| 649 | 7/16/08 | NA | NA | United States | US | Wisconsin | 1887 | Brice Prairie | 6.28666 | NA | 43.8900 | -91.3400 | (43.89, -91.34) | Landslide | Mudslide | Small | Flooding | NA | NA | NA | NA | http://news.postbulletin.com/newsmanager/templates/localnews_story.asp?z=2&a=352286 |
| 1116 | 8/20/09 | NA | NA | United States | US | Wisconsin | 5911 | Prairie du Chien | 3.41664 | NA | 43.0421 | -91.1811 | (43.042099999999998, -91.181100000000001) | Landslide | Landslide | Small | Rain | NA | NA | 0 | NA | http://www.wcfcourier.com/articles/2009/08/19/news/breaking_news/doc4a8c3c7b2b76d130081282.txt |
| 1557 | 3/11/10 | 18:15:00 | NA | United States | US | Wisconsin | 2133 | Saint Croix Falls | 3.90084 | NA | 45.3853 | -92.6751 | (45.385300000000001, -92.6751) | Landslide | Mudslide | Small | Downpour | NA | NA | 0 | NA | http://www.startribune.com/local/87416017.html?elr=KArksi8cyaiUHK:uUiD3aPc:_Yyc:aU7DYaGEP7vDEh7P:DiUs |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_US <- subset(df, state == "Wyoming")
knitr::kable(head(df_US))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188 | 8/18/07 | NA | NA | United States | US | Wyoming | 9520 | Cody | 64.74594 | NA | 44.4659 | -109.8662 | (44.465899999999998, -109.86620000000001) | Landslide | Landslide | Small | Rain | NA | NA | NA | Billings Gazette | http://www.billingsgazette.net/articles/2007/08/19/news/wyoming/38-mudslide.txt |
| 235 | 9/5/07 | NA | NA | United States | US | Wyoming | 1176 | Hoback | 9.42463 | NA | 43.2046 | -110.8317 | (43.204599999999999, -110.8317) | Landslide | Landslide | Medium | Rain | NA | NA | NA | NA | NA |
| 3554 | 5/30/11 | NA | NA | United States | US | Wyoming | 1182 | Sundance | 7.07507 | NA | 44.4648 | -104.4111 | (44.464799999999997, -104.4111) | Landslide | Mudslide | Small | Unknown | NA | NA | 0 | NA | http://www.9news.com/news/local/article/200937/346/Teton-County-highway-reopens-after-landslide-?odyssey=mod%7Cnewswell%7Ctext%7CFRONTPAGE%7Ct |
| 3744 | 7/7/11 | NA | NA | United States | US | Wyoming | 17444 | Sheridan | 6.32702 | NA | 44.7448 | -106.9249 | (44.744799999999998, -106.92489999999999) | Landslide | Landslide | Medium | Rain | NA | NA | 0 | NA | http://www.buffalobulletin.com/articles/2011/07/13/news/local_news/doc4e1dc52c96a19490307621.txt |
| 3755 | 7/9/11 | NA | NA | United States | US | Wyoming | 17444 | Sheridan | 0.00178 | NA | 44.7972 | -106.9562 | (44.797199999999997, -106.9562) | Landslide | Landslide | Medium | Rain | NA | NA | 0 | NA | http://www.newstimes.com/news/article/Landslides-lead-to-detours-on-westbound-I-90-1459351.php |
| 4470 | 8/12/12 | NA | NA | United States | US | Wyoming | 9520 | Cody | 72.64680 | NA | 44.5259 | -109.9704 | (44.5259, -109.9704) | Landslide | Mudslide | Medium | Downpour | NA | NA | NA | NA | http://www.codyenterprise.com/news/local/article_e5fea5ca-e591-11e1-8d36-0019bb2963f4.html |
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_US, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
Gráfico de barras agrupado y apilados
- grafica de histogramas agrupados y apilados, para todas las longitudes de deslizamiento de los pueblos de Canadá
library(dplyr)
colnames(df)[7] <- "state"
colnames(df)[9] <- "city"
df_CA <- subset(df, country_name == "Canada")
knitr::kable(head(df_CA))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59 | 4/14/07 | NA | NA | Canada | CA | Quebec | 42786 | Châteauguay | 2.98682 | Above river | 45.3226 | -73.7771 | (45.322600000000001, -73.777100000000004) | Landslide | Riverbank collapse | Small | Rain | NA | NA | NA | Le Soleil | http://www.hebdos.net/lsc/edition162007/articles.asp?article_id=166976 |
| 119 | 7/8/07 | NA | NA | Canada | CA | Ontario | 812129 | Ottawa | 1.74759 | NA | 45.4257 | -75.6896 | (45.425699999999999, -75.689599999999999) | Landslide | Landslide | Small | Unknown | NA | NA | NA | NA | http://www.cfra.com/headlines/index.asp?cat=1&nid=50672 |
| 2085 | 7/16/10 | 6:00:00 | NA | Canada | CA | Ontario | 33232 | Ancaster | 5.11510 | Above road | 43.2453 | -79.9367 | (43.2453, -79.936700000000002) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | Hamilton Spectator | http://www.thespec.com/news-story/2163626-mudslide-causes-four-vehicle-crash-on-highway-403/ |
| 2490 | 9/23/10 | 23:00:00 | NA | Canada | CA | Quebec | 17016 | Saint-Lazare | 3.16544 | NA | 45.3717 | -74.1359 | (45.371699999999997, -74.135900000000007) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://www.torontosun.com/news/canada/2010/09/24/15463551.html |
| 4710 | 1/13/13 | NA | NA | Canada | CA | Ontario | 115760 | Guelph | 12.17933 | NA | 43.6187 | -80.1432 | (43.618699999999997, -80.143199999999993) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | www.lfpress.com | http://www.lfpress.com/2013/01/14/ministry-of-the-environment-investigating-mudslide-in-rockwood-near-guelph |
| 6404 | 11/28/14 | 8:30 | NA | Canada | CA | Ontario | 519949 | Hamilton | 4.79449 | Above road | 43.2804 | -79.8919 | (43.2804, -79.891900000000007) | Landslide | Landslide | Small | Unknown | NA | 0 | 0 | Hamilton Spectator | http://www.thespec.com/news-story/5161560--landslide-closes-lanes-of-toronto-bound-hwy-403-at-york-blvd-/ |
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=state, y=distance, x=country_name)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_CA <- subset(df, state == "Nova Scotia")
knitr::kable(head(df_CA))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7137 | 4/17/15 | 17:00 | NA | Canada | CA | Nova Scotia | 2052 | Digby | 11.62624 | Below road | 44.5644 | -65.6362 | (44.564399999999999, -65.636200000000002) | Landslide | NA | NA | Unknown | NA | 0 | 0 | The Digby County Courier | http://www.digbycourier.ca/News/Local/2015-04-17/article-4115847/Bear-River-landslide-has-closed-River-Road-completely/1 |
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_CA <- subset(df, state == "Ontario")
knitr::kable(head(df_CA))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119 | 7/8/07 | NA | NA | Canada | CA | Ontario | 812129 | Ottawa | 1.74759 | NA | 45.4257 | -75.6896 | (45.425699999999999, -75.689599999999999) | Landslide | Landslide | Small | Unknown | NA | NA | NA | NA | http://www.cfra.com/headlines/index.asp?cat=1&nid=50672 |
| 2085 | 7/16/10 | 6:00:00 | NA | Canada | CA | Ontario | 33232 | Ancaster | 5.11510 | Above road | 43.2453 | -79.9367 | (43.2453, -79.936700000000002) | Landslide | Mudslide | Medium | Downpour | NA | NA | 0 | Hamilton Spectator | http://www.thespec.com/news-story/2163626-mudslide-causes-four-vehicle-crash-on-highway-403/ |
| 4710 | 1/13/13 | NA | NA | Canada | CA | Ontario | 115760 | Guelph | 12.17933 | NA | 43.6187 | -80.1432 | (43.618699999999997, -80.143199999999993) | Landslide | Mudslide | Medium | Rain | NA | NA | NA | www.lfpress.com | http://www.lfpress.com/2013/01/14/ministry-of-the-environment-investigating-mudslide-in-rockwood-near-guelph |
| 6404 | 11/28/14 | 8:30 | NA | Canada | CA | Ontario | 519949 | Hamilton | 4.79449 | Above road | 43.2804 | -79.8919 | (43.2804, -79.891900000000007) | Landslide | Landslide | Small | Unknown | NA | 0 | 0 | Hamilton Spectator | http://www.thespec.com/news-story/5161560--landslide-closes-lanes-of-toronto-bound-hwy-403-at-york-blvd-/ |
| 7055 | 5/19/15 | NA | NA | Canada | CA | Ontario | 22625 | Owen Sound | 1.84109 | Natural slope | 44.5687 | -80.9204 | (44.5687, -80.920400000000001) | Landslide | Mudslide | Small | Unknown | NA | 0 | 0 | Bay Shore Broadcasting | http://www.bayshorebroadcasting.ca/news_item.php?NewsID=75091 |
| 7526 | 2/24/16 | Morning | NA | Canada | CA | Ontario | 519949 | Hamilton | 2.00473 | Above road | 43.2372 | -79.8324 | (43.237200000000001, -79.832400000000007) | Landslide | Rockfall | Small | Freeze thaw | NA | 0 | 0 | Hamilton Spectator | http://www.thespec.com/news-story/6341970-falling-rock-closes-sherman-access/ |
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")
library(dplyr)
df_CA <- subset(df, state == "Quebec")
knitr::kable(head(df_CA))| id | date | time | continent_code | country_name | country_code | state | population | city | distance | location_description | latitude | longitude | geolocation | hazard_type | landslide_type | landslide_size | trigger | storm_name | injuries | fatalities | source_name | source_link |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59 | 4/14/07 | NA | NA | Canada | CA | Quebec | 42786 | Châteauguay | 2.98682 | Above river | 45.3226 | -73.7771 | (45.322600000000001, -73.777100000000004) | Landslide | Riverbank collapse | Small | Rain | NA | NA | NA | Le Soleil | http://www.hebdos.net/lsc/edition162007/articles.asp?article_id=166976 |
| 2490 | 9/23/10 | 23:00:00 | NA | Canada | CA | Quebec | 17016 | Saint-Lazare | 3.16544 | NA | 45.3717 | -74.1359 | (45.371699999999997, -74.135900000000007) | Landslide | Landslide | Medium | Downpour | NA | NA | 0 | NA | http://www.torontosun.com/news/canada/2010/09/24/15463551.html |
| 6603 | 12/25/14 | NA | NA | Canada | CA | Quebec | 3805 | Sutton | 4.33884 | Deforested slope | 45.1058 | -72.5613 | (45.105800000000002, -72.561300000000003) | Landslide | Landslide | Small | Unknown | NA | 0 | 0 | CBC | http://www.cbc.ca/news/canada/montreal/mount-sutton-landslide-in-parking-lot-prompts-concerns-for-safety-1.2884882 |
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="dodge", stat="identity")
library(ggplot2)
library(dplyr)
ggplot(df_CA, aes(fill=city, y=distance, x=state)) +
geom_bar(position="stack", stat="identity")