{ "metadata": { "name": "", "signature": "sha256:0670812d7c4a11fbe15de599c9629adc02d7583e031b82eb88cb59ca25cafc02" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Importing an HTML table into pandas\n", "\n", "- **Author:** [Chris Albon](http://www.chrisalbon.com/), [@ChrisAlbon](https://twitter.com/chrisalbon)\n", "- **Date:** -\n", "- **Repo:** [Python 3 code snippets for data science](https://github.com/chrisalbon/code_py)\n", "- **Note:**" ] }, { "cell_type": "code", "collapsed": false, "input": [ "# Import the required module\n", "import pandas as pd" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 46 }, { "cell_type": "code", "collapsed": false, "input": [ "# Create a variable with the url to the website contain the html table\n", "url = \"http://floodobservatory.colorado.edu/Archives/MasterListrev.htm\"" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 47 }, { "cell_type": "code", "collapsed": false, "input": [ "# Read the html table into pandas\n", "data = pd.read_html(url, header=0)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 48 }, { "cell_type": "markdown", "metadata": {}, "source": [ "The resulting data will be a list of dataframe objects" ] }, { "cell_type": "code", "collapsed": false, "input": [ "# View the data\n", "data" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 49, "text": [ "[ Register # Annual DFO # (discontinued) Glide # \\\n", " 0 4163 NaN 0 \n", " 1 4162 NaN 0 \n", " 2 4161 NaN 0 \n", " 3 4160 NaN 0 \n", " 4 4159 NaN 0 \n", " 5 4158 NaN 0 \n", " 6 4157 NaN 0 \n", " 7 4156 NaN 0 \n", " 8 4155 NaN 0 \n", " 9 4154 NaN 0 \n", " 10 4153 NaN 0 \n", " 11 4152 NaN 0 \n", " 12 4151 NaN 0 \n", " 13 4150 NaN 0 \n", " 14 4149 NaN 0 \n", " 15 4148 NaN TC-2014-000071-MEX \n", " 16 4147 NaN 0 \n", " 17 4146 NaN 0 \n", " 18 4145 NaN FL-2014-000070-LKA \n", " 19 4144 NaN 0 \n", " 20 4143 NaN FL-2014-000062-CHN \n", " 21 4142 NaN FL-2014-000063-TJK \n", " 22 4141 NaN 0 \n", " 23 4140 NaN 0 \n", " 24 4139 NaN 0 \n", " 25 4138 NaN FF-2014-000059-SRB \n", " 26 4137 NaN 0 \n", " 27 4136 NaN FF-2014-000060-AFG \n", " 28 4135 NaN 0 \n", " 29 4134 NaN 0 \n", " 30 4133 NaN 0 \n", " 31 4132 NaN FL-2014-000045-SLB \n", " 32 4131 NaN FL-2014-000038-ZAF \n", " 33 4130 NaN 0 \n", " 34 4129 NaN 0 \n", " 35 4128 NaN 0 \n", " 36 4127 NaN FL-2014-000030-PRY \n", " 37 4126 NaN 0 \n", " 38 4125 NaN 0 \n", " 39 4124 NaN SS-2014-000032-MHL \n", " 40 4123 NaN 0 \n", " 41 4122 NaN 0 \n", " 42 4121 NaN 0 \n", " 43 4120 NaN 0 \n", " 44 4119 NaN 0 \n", " 45 4118 NaN 0 \n", " 46 4117 NaN FL-2014-000008-BOL \n", " 47 4116 NaN 0 \n", " 48 4115 NaN 0 \n", " 49 4114 NaN FL-2013-000159-LCA \n", " 50 4113 NaN FL-2013-000157-BRA \n", " 51 4112 NaN 0 \n", " 52 4111 NaN 0 \n", " 53 4110 NaN FL-2013-000149-THA \n", " 54 4109 NaN 0 \n", " 55 4108 NaN 0 \n", " 56 4107 NaN FL-2013-000148-MYS \n", " 57 4106 NaN 0 \n", " 58 4105 NaN FL-2013-000141-SOM \n", " 59 4104 NaN 0 \n", " ... ... ... \n", " \n", " Country Other Nations Affected \\\n", " 0 Brazil Uruguay NaN NaN \n", " 1 Nepal 0 NaN NaN \n", " 2 Bangladesh 0 NaN NaN \n", " 3 USA 0 NaN NaN \n", " 4 Brazil 0 NaN NaN \n", " 5 Sudan 0 NaN NaN \n", " 6 New Zealand 0 NaN NaN \n", " 7 Thailand 0 NaN NaN \n", " 8 China 0 NaN NaN \n", " 9 India 0 NaN NaN \n", " 10 Philippines 0 NaN NaN \n", " 11 USA 0 NaN NaN \n", " 12 Bulgaria 0 NaN NaN \n", " 13 Paraguay Brazil NaN NaN \n", " 14 Russia 0 NaN NaN \n", " 15 Mexico Guatamala NaN NaN \n", " 16 Iran 0 NaN NaN \n", " 17 China 0 NaN NaN \n", " 18 Sri Lanka 0 NaN NaN \n", " 19 Afghanistan 0 NaN NaN \n", " 20 China 0 NaN NaN \n", " 21 Tajikistan 0 NaN NaN \n", " 22 Italy 0 NaN NaN \n", " 23 Tanzania 0 NaN NaN \n", " 24 Serbia Bosnia NaN NaN \n", " 25 Romania Bulgaria NaN NaN \n", " 26 Tanzania 0 NaN NaN \n", " 27 Afghanistan 0 NaN NaN \n", " 28 USA 0 NaN NaN \n", " 29 USA 0 NaN NaN \n", " 30 Argentina 0 NaN NaN \n", " 31 Solomon Islands 0 NaN NaN \n", " 32 South Africa Namibia NaN NaN \n", " 33 Australia 0 NaN NaN \n", " 34 USA 0 NaN NaN \n", " 35 Zimbawe 0 NaN NaN \n", " 36 Paraguay 0 NaN NaN \n", " 37 Burundi 0 NaN NaN \n", " 38 New Zealand 0 NaN NaN \n", " 39 USA 0 NaN NaN \n", " 40 Mozambique 0 NaN NaN \n", " 41 France Italy NaN NaN \n", " 42 Indonesia 0 NaN NaN \n", " 43 Australia 0 NaN NaN \n", " 44 Zimbawe 0 NaN NaN \n", " 45 Zimbawe 0 NaN NaN \n", " 46 Bolivia 0 NaN NaN \n", " 47 Peru 0 NaN NaN \n", " 48 USA 0 NaN NaN \n", " 49 Saint Vincent St. Lucia NaN NaN \n", " 50 Brazil 0 NaN NaN \n", " 51 Indonesia 0 NaN NaN \n", " 52 United Kingdom Ireland NaN NaN \n", " 53 Thailand 0 NaN NaN \n", " 54 Cuba 0 NaN NaN \n", " 55 Niger 0 NaN NaN \n", " 56 Malaysia 0 NaN NaN \n", " 57 United Kingdom Germany NaN NaN \n", " 58 Somalia 0 NaN NaN \n", " 59 Saudi Arabia 0 NaN NaN \n", " ... ... ... ... \n", " \n", " Detailed Locations (click on active links to access inundation extents) \\\n", " 0 State of Rio Grande do Sul; Uruguay River \n", " 1 Sindhupalchok, Lalitpur and Chitwan districts ... \n", " 2 Bhola District in the Division of Barisal, Ban... \n", " 3 Mendenhall Lake and River, Juneau, Alaska \n", " 4 Amazonas State; Northwestern Brazil; Careiro d... \n", " 5 Sinja locality in the eastern Sudan state of S... \n", " 6 North Island, Hikurangi Swamp area, north of W... \n", " 7 Rayong, Chiang Rai, and Trang \n", " 8 Southern China; Hunan, Jiangxi provinces; Gua... \n", " 9 Assam \n", " 10 Southern Philippine province of Maguindanao \n", " 11 South Dakota, Iowa, Illinois, Missouri, Minnesota \n", " 12 Eastern Bulgaria; Varna district of Asparuhov;... \n", " 13 Southern Brazil, Parana State; Paraguay River ... \n", " 14 Altai region, Khakassia Republic, and Altai R... \n", " 15 Chiapas, SE Mexico.W Guatamala \n", " 16 Khorasan, Mazandaran and Semnan provinces \n", " 17 Southern China, Guangdong Province \n", " 18 Western districts of Sri Lanka \n", " 19 Baghlan provinc \n", " 20 Hunan Province, including Guiyang, Shenzhen ci... \n", " 21 Khatlon Province, Rudaki and Vahdat districts,... \n", " 22 Marche region of central Italy \n", " 23 Rufiji District in Coast Region \n", " 24 Bosnia,Serbia, Croatia \n", " 25 Bulgaria, Serbia, southern Romania \n", " 26 Dar es Salaam region \n", " 27 Northwestern Afghanistan; Jowzjan Province, pr... \n", " 28 Gulf Coast; Northeast Atlantic Coast \n", " 29 Southern Alabama, southern Mississippi \n", " 30 Western province of Neuquenr \n", " 31 Honiara \n", " 32 SADC region, Zambezi River \n", " 33 Southeast and Central Queensland; Yeppoon area... \n", " 34 Southern Mississippi, Wilkinson County \n", " 35 Tokwe-Mukosi \n", " 36 Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio \n", " 37 Bujumbura \n", " 38 Christchurch, including Avon River \n", " 39 Majuro \n", " 40 Johannesburg , Kliptown, Soweto; eastern South... \n", " 41 Southeastern France, western France, Pisa, Lig... \n", " 42 Jakarta, Tangerang \n", " 43 Top End, Northern Territory \n", " 44 Communities downstream of the Tokwe-Mukrosi Da... \n", " 45 Muzarabani \n", " 46 La Paz, Beni, Santa Cruz and Cochabamba; Beni... \n", " 47 Southern Andean Cusco region \n", " 48 Nelson and Carroll Counties, Kentucky \n", " 49 Saint Vincent and the Grenadines, St. Lucia \n", " 50 Southeast states of Minas Gerais and Espirito ... \n", " 51 North Sumatras Langkat district \n", " 52 Central and southern Scotland, Wales, Ireland,... \n", " 53 Southeast provinces; Nakhon Si Thammarat, Song... \n", " 54 Havana \n", " 55 South-east Niger, Komadougou River \n", " 56 Kuala Lumpur, east coast states of Pahang and ... \n", " 57 Eastern England coast, northern European coast \n", " 58 Northeast Puntland \n", " 59 Riyadh, other parts of the Kingdom including n... \n", " ... \n", " \n", " Validation (post event #3503) Began Ended Duration in Days \\\n", " 0 News 2014-07-03 2014-07-14 12 \n", " 1 News 2014-07-01 2014-07-14 14 \n", " 2 News 2014-07-13 2014-07-14 2 \n", " 3 News 2014-07-11 2014-07-14 4 \n", " 4 News 2014-05-22 2014-07-14 54 \n", " 5 News 2014-07-07 2014-07-14 8 \n", " 6 News 2014-07-05 2014-07-14 10 \n", " 7 News 2014-07-11 2014-07-14 4 \n", " 8 News 2014-06-05 2014-06-25 21 \n", " 9 News 2014-06-23 2014-06-25 3 \n", " 10 News 2014-06-17 2014-06-25 9 \n", " 11 News 2014-06-10 2014-07-14 35 \n", " 12 News 2014-06-19 2014-06-25 7 \n", " 13 News 2014-06-03 2014-07-14 42 \n", " 14 News 2014-06-04 2014-06-10 7 \n", " 15 News 2014-06-01 2014-06-10 10 \n", " 16 News 2014-06-01 2014-06-10 10 \n", " 17 News 2014-05-30 2014-06-10 12 \n", " 18 News 2014-06-04 2014-06-10 7 \n", " 19 News 2014-06-03 2014-06-10 8 \n", " 20 News 2014-05-12 2014-05-16 5 \n", " 21 News 2014-05-10 2014-05-16 7 \n", " 22 News 2014-05-02 2014-05-10 9 \n", " 23 News 2014-05-10 2014-05-16 7 \n", " 24 News 2014-05-12 2014-05-16 5 \n", " 25 News 2014-04-17 2014-05-01 15 \n", " 26 News 2014-04-18 2014-05-01 14 \n", " 27 News 2014-04-20 2014-05-16 27 \n", " 28 News 2014-04-30 2014-05-01 2 \n", " 29 News 2014-04-01 2014-04-08 8 \n", " 30 News 2014-04-01 2014-04-08 8 \n", " 31 News 2014-04-01 2014-04-08 8 \n", " 32 News 2014-03-01 2014-03-30 30 \n", " 33 News 2014-03-24 2014-03-30 7 \n", " 34 News 2014-03-25 2014-03-30 6 \n", " 35 News 2014-02-01 2014-03-30 58 \n", " 36 News 2014-02-25 2014-03-10 14 \n", " 37 News 2014-02-19 2014-03-10 20 \n", " 38 News 2014-03-03 2014-03-10 8 \n", " 39 News 2014-03-03 2014-03-10 8 \n", " 40 News 2014-02-24 2014-03-10 15 \n", " 41 News 2014-01-20 2014-02-07 19 \n", " 42 News 2014-01-08 2014-02-07 31 \n", " 43 News 2014-02-02 2014-02-07 6 \n", " 44 News 2014-01-15 2014-02-07 24 \n", " 45 News 2014-01-15 2014-02-07 24 \n", " 46 News 2014-01-10 2014-05-01 112 \n", " 47 News 2014-01-01 2014-01-04 4 \n", " 48 News 2013-12-22 2014-01-04 14 \n", " 49 News 2013-12-26 2014-01-04 10 \n", " 50 News 2013-12-23 2014-01-04 13 \n", " 51 News 2013-12-29 2014-01-04 7 \n", " 52 News 2013-12-27 2014-02-07 43 \n", " 53 News 2013-11-20 2013-12-08 19 \n", " 54 News 2013-12-01 2013-12-08 8 \n", " 55 News 2013-11-03 2013-12-08 36 \n", " 56 News 2013-12-01 2013-12-08 8 \n", " 57 News 2013-12-05 2013-12-08 4 \n", " 58 News 2013-11-08 2013-11-19 12 \n", " 59 News 2013-11-18 2013-11-19 2 \n", " ... ... ... ... \n", " \n", " Dead Displaced Damage (USD) Main cause Severity * \\\n", " 0 10 50000 NaN Heavy Rain 2.0 \n", " 1 16 2400 NaN Torrential Rain 1.5 \n", " 2 0 30000 NaN Heavy Rain and High Tide 1.5 \n", " 3 0 0 NaN J\u00f6kulhlaup 1.0 \n", " 4 0 0 NaN Heavy Rain 2.0 \n", " 5 0 42400 NaN Heavy Rain 1.5 \n", " 6 0 0 NaN Heavy Rain 1.0 \n", " 7 0 500 NaN Heavy Rain 1.0 \n", " 8 14 337000 NaN Monsoonal Rain 1.0 \n", " 9 0 10000 NaN Monsoonal Ran 1.0 \n", " 10 0 35000 NaN Heavy Rain 1.0 \n", " 11 0 600 NaN Heavy Rain 2.0 \n", " 12 12 2000 NaN Torrential Rain 2.0 \n", " 13 9 265000 NaN Heay Rain 2.0 \n", " 14 70 3000 NaN Torrential Rain 1.5 \n", " 15 22 25000 NaN Monsoonal Rain 1.5 \n", " 16 37 440000 NaN Monsoonal Rain 1.5 \n", " 17 6 500 NaN Heavy Rain 1.0 \n", " 18 5 16000 NaN Tropical Storm Boris 1.5 \n", " 19 0 300 NaN Heavy Rain 1.5 \n", " 20 1 10000 NaN Heavy Rain 2.0 \n", " 21 0 425 NaN Heavy Rain 1.5 \n", " 22 2 250 NaN Torrential Rain 1.5 \n", " 23 0 22000 NaN Heavy Rain 1.0 \n", " 24 3 4000 NaN Heavy Rain 2.0 \n", " 25 0 640 NaN Torrential Rain 1.5 \n", " 26 41 0 NaN Torrential Rain 1.5 \n", " 27 123 6000 NaN Torrential Rain 1.5 \n", " 28 1 200 NaN Torrential Rain 2.0 \n", " 29 2 300 NaN heavy Rain 1.5 \n", " 30 0 2000 NaN Heavy Rain 1.5 \n", " 31 23 10000 NaN Heavy Rain 2.0 \n", " 32 37 3528 NaN Heavy Rain 1.5 \n", " 33 1 0 NaN Torrential Rain 1.5 \n", " 34 0 200 NaN Heavy Rain 1.5 \n", " 35 0 4000 NaN Dam Break 1.0 \n", " 36 0 2000 NaN Heavy Rain 1.0 \n", " 37 69 20000 NaN Torrential Rain 2.0 \n", " 38 0 80 NaN Heavy Rain 2.0 \n", " 39 0 900 NaN Storm Surge 1.5 \n", " 40 4 20000 NaN Heavy Rain 1.0 \n", " 41 4 1000 NaN Heavy Rain 1.5 \n", " 42 23 20000 NaN Heavy Rain 1.5 \n", " 43 0 0 NaN Tropical Storm Fletcher 1.0 \n", " 44 0 4000 NaN Heavy Rain 1.5 \n", " 45 0 0 NaN Heavy Rain 1.5 \n", " 46 60 84000 NaN Heavy Rain 2.0 \n", " 47 0 300 NaN Heavy Rain 1.0 \n", " 48 5 0 NaN Heavy Rain 1.0 \n", " 49 11 0 NaN Heavy Rain 1.0 \n", " 50 45 60000 NaN Heavy Rain 2.0 \n", " 51 0 4500 NaN Heavy Rain 1.0 \n", " 52 0 200 NaN Heavy Rain 1.5 \n", " 53 23 15254 NaN Monsoonal Rain 1.5 \n", " 54 2 227 NaN Torrential Rain 1.0 \n", " 55 0 1000 NaN Heavy Rain 1.0 \n", " 56 1 19000 NaN Monsoonal Rain 1.5 \n", " 57 8 4000 NaN Storm Surge 2.0 \n", " 58 100 0 NaN Tropical Storm 1.5 \n", " 59 15 121 NaN Torrential Rain 1.5 \n", " ... ... ... ... ... \n", " \n", " Affected sq km Magnitude (M)** Centroid X \n", " 0 44866.4600 6.0 -58.02560 ... \n", " 1 11578.7700 5.4 84.62070 ... \n", " 2 217.5290 2.8 90.54980 ... \n", " 3 2950.8200 4.1 -134.44600 ... \n", " 4 256564.5700 7.4 -59.55970 ... \n", " 5 137141.2800 6.2 33.08000 ... \n", " 6 8581.2400 4.9 174.06800 ... \n", " 7 15921.6300 4.8 99.73900 ... \n", " 8 377101.6300 6.9 112.35800 ... \n", " 9 49220.5300 5.2 94.71600 ... \n", " 10 15356.3100 5.1 124.73000 ... \n", " 11 418317.1300 7.5 -94.79440 ... \n", " 12 24415.4200 5.5 27.04260 ... \n", " 13 554605.2500 7.7 -53.54700 ... \n", " 14 1829701.4000 7.3 94.36960 ... \n", " 15 113685.4300 6.2 -94.02740 ... \n", " 16 305525.2500 6.7 57.25440 ... \n", " 17 45994.3000 5.7 113.34200 ... \n", " 18 10337.4700 5.0 80.16680 ... \n", " 19 44203.9300 5.7 68.01780 ... \n", " 20 205001.2700 6.3 111.46700 ... \n", " 21 41719.4600 5.6 69.37870 ... \n", " 22 11256.3300 5.2 13.01300 ... \n", " 23 22249.3400 5.2 38.94420 ... \n", " 24 115747.6900 6.1 19.22360 ... \n", " 25 87430.6900 6.3 24.49400 ... \n", " 26 18498.3900 5.6 38.96890 ... \n", " 27 83722.3400 6.5 66.43420 ... \n", " 28 260469.8100 6.0 -84.94650 ... \n", " 29 82418.5600 6.0 -87.61880 ... \n", " 30 69876.7800 5.9 -70.29840 ... \n", " 31 5480.7500 4.9 160.34200 ... \n", " 32 1037639.2000 7.7 25.60740 ... \n", " 33 250162.1200 6.4 150.11700 ... \n", " 34 53220.7900 5.7 -89.12820 ... \n", " 35 17205.6400 6.0 31.34790 ... \n", " 36 6829.5700 5.0 -57.58330 ... \n", " 37 3237.4200 5.1 29.64990 ... \n", " 38 1015.8400 4.2 172.61300 ... \n", " 39 34.8366 2.6 168.72900 ... \n", " 40 481907.8800 6.9 31.54590 ... \n", " 41 82989.4500 6.4 7.09930 ... \n", " 42 35769.2200 6.2 107.70600 ... \n", " 43 426979.8400 6.4 131.73200 ... \n", " 44 72462.2300 6.4 28.92310 ... \n", " 45 142586.1000 6.7 30.85310 ... \n", " 46 381576.6500 7.9 -64.01350 ... \n", " 47 74144.6600 5.5 -71.52320 ... \n", " 48 16069.9100 5.4 -86.78990 ... \n", " 49 830.2320 3.9 -60.98860 ... \n", " 50 314284.9100 6.9 -41.94230 ... \n", " 51 22524.6300 5.2 97.28930 ... \n", " 52 126149.7900 6.9 -1.51144 ... \n", " 53 38676.7100 6.0 100.39500 ... \n", " 54 7627.3000 4.8 -81.39580 ... \n", " 55 65791.1400 6.4 13.20170 ... \n", " 56 106697.5300 6.1 102.36200 ... \n", " 57 51279.6000 5.6 7.53306 ... \n", " 58 181848.0200 6.5 57.42760 ... \n", " 59 361386.8400 6.0 44.80840 ... \n", " ... ... ... \n", " \n", " [276 rows x 29 columns]]" ] } ], "prompt_number": 49 }, { "cell_type": "code", "collapsed": false, "input": [ "# Select the first (and in this case only) dataframe object\n", "data[0]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Register #Annual DFO # (discontinued)Glide #CountryOtherNationsAffectedDetailed Locations (click on active links to access inundation extents)Validation (post event #3503)BeganEndedDuration in DaysDeadDisplacedDamage (USD)Main causeSeverity *Affected sq kmMagnitude (M)**Centroid X
0 4163NaN 0 Brazil UruguayNaNNaN State of Rio Grande do Sul; Uruguay River News2014-07-032014-07-14 12 10 50000NaN Heavy Rain 2.0 44866.4600 6.0 -58.02560...
1 4162NaN 0 Nepal 0NaNNaN Sindhupalchok, Lalitpur and Chitwan districts ... News2014-07-012014-07-14 14 16 2400NaN Torrential Rain 1.5 11578.7700 5.4 84.62070...
2 4161NaN 0 Bangladesh 0NaNNaN Bhola District in the Division of Barisal, Ban... News2014-07-132014-07-14 2 0 30000NaN Heavy Rain and High Tide 1.5 217.5290 2.8 90.54980...
3 4160NaN 0 USA 0NaNNaN Mendenhall Lake and River, Juneau, Alaska News2014-07-112014-07-14 4 0 0NaN J\u00f6kulhlaup 1.0 2950.8200 4.1-134.44600...
4 4159NaN 0 Brazil 0NaNNaN Amazonas State; Northwestern Brazil; Careiro d... News2014-05-222014-07-14 54 0 0NaN Heavy Rain 2.0 256564.5700 7.4 -59.55970...
5 4158NaN 0 Sudan 0NaNNaN Sinja locality in the eastern Sudan state of S... News2014-07-072014-07-14 8 0 42400NaN Heavy Rain 1.5 137141.2800 6.2 33.08000...
6 4157NaN 0 New Zealand 0NaNNaN North Island, Hikurangi Swamp area, north of W... News2014-07-052014-07-14 10 0 0NaN Heavy Rain 1.0 8581.2400 4.9 174.06800...
7 4156NaN 0 Thailand 0NaNNaN Rayong, Chiang Rai, and Trang News2014-07-112014-07-14 4 0 500NaN Heavy Rain 1.0 15921.6300 4.8 99.73900...
8 4155NaN 0 China 0NaNNaN Southern China; Hunan, Jiangxi provinces; Gua... News2014-06-052014-06-25 21 14 337000NaN Monsoonal Rain 1.0 377101.6300 6.9 112.35800...
9 4154NaN 0 India 0NaNNaN Assam News2014-06-232014-06-25 3 0 10000NaN Monsoonal Ran 1.0 49220.5300 5.2 94.71600...
10 4153NaN 0 Philippines 0NaNNaN Southern Philippine province of Maguindanao News2014-06-172014-06-25 9 0 35000NaN Heavy Rain 1.0 15356.3100 5.1 124.73000...
11 4152NaN 0 USA 0NaNNaN South Dakota, Iowa, Illinois, Missouri, Minnesota News2014-06-102014-07-14 35 0 600NaN Heavy Rain 2.0 418317.1300 7.5 -94.79440...
12 4151NaN 0 Bulgaria 0NaNNaN Eastern Bulgaria; Varna district of Asparuhov;... News2014-06-192014-06-25 7 12 2000NaN Torrential Rain 2.0 24415.4200 5.5 27.04260...
13 4150NaN 0 Paraguay BrazilNaNNaN Southern Brazil, Parana State; Paraguay River ... News2014-06-032014-07-14 42 9 265000NaN Heay Rain 2.0 554605.2500 7.7 -53.54700...
14 4149NaN 0 Russia 0NaNNaN Altai region, Khakassia Republic, and Altai R... News2014-06-042014-06-10 7 70 3000NaN Torrential Rain 1.5 1829701.4000 7.3 94.36960...
15 4148NaN TC-2014-000071-MEX Mexico GuatamalaNaNNaN Chiapas, SE Mexico.W Guatamala News2014-06-012014-06-10 10 22 25000NaN Monsoonal Rain 1.5 113685.4300 6.2 -94.02740...
16 4147NaN 0 Iran 0NaNNaN Khorasan, Mazandaran and Semnan provinces News2014-06-012014-06-10 10 37 440000NaN Monsoonal Rain 1.5 305525.2500 6.7 57.25440...
17 4146NaN 0 China 0NaNNaN Southern China, Guangdong Province News2014-05-302014-06-10 12 6 500NaN Heavy Rain 1.0 45994.3000 5.7 113.34200...
18 4145NaN FL-2014-000070-LKA Sri Lanka 0NaNNaN Western districts of Sri Lanka News2014-06-042014-06-10 7 5 16000NaN Tropical Storm Boris 1.5 10337.4700 5.0 80.16680...
19 4144NaN 0 Afghanistan 0NaNNaN Baghlan provinc News2014-06-032014-06-10 8 0 300NaN Heavy Rain 1.5 44203.9300 5.7 68.01780...
20 4143NaN FL-2014-000062-CHN China 0NaNNaN Hunan Province, including Guiyang, Shenzhen ci... News2014-05-122014-05-16 5 1 10000NaN Heavy Rain 2.0 205001.2700 6.3 111.46700...
21 4142NaN FL-2014-000063-TJK Tajikistan 0NaNNaN Khatlon Province, Rudaki and Vahdat districts,... News2014-05-102014-05-16 7 0 425NaN Heavy Rain 1.5 41719.4600 5.6 69.37870...
22 4141NaN 0 Italy 0NaNNaN Marche region of central Italy News2014-05-022014-05-10 9 2 250NaN Torrential Rain 1.5 11256.3300 5.2 13.01300...
23 4140NaN 0 Tanzania 0NaNNaN Rufiji District in Coast Region News2014-05-102014-05-16 7 0 22000NaN Heavy Rain 1.0 22249.3400 5.2 38.94420...
24 4139NaN 0 Serbia BosniaNaNNaN Bosnia,Serbia, Croatia News2014-05-122014-05-16 5 3 4000NaN Heavy Rain 2.0 115747.6900 6.1 19.22360...
25 4138NaN FF-2014-000059-SRB Romania BulgariaNaNNaN Bulgaria, Serbia, southern Romania News2014-04-172014-05-01 15 0 640NaN Torrential Rain 1.5 87430.6900 6.3 24.49400...
26 4137NaN 0 Tanzania 0NaNNaN Dar es Salaam region News2014-04-182014-05-01 14 41 0NaN Torrential Rain 1.5 18498.3900 5.6 38.96890...
27 4136NaN FF-2014-000060-AFG Afghanistan 0NaNNaN Northwestern Afghanistan; Jowzjan Province, pr... News2014-04-202014-05-16 27 123 6000NaN Torrential Rain 1.5 83722.3400 6.5 66.43420...
28 4135NaN 0 USA 0NaNNaN Gulf Coast; Northeast Atlantic Coast News2014-04-302014-05-01 2 1 200NaN Torrential Rain 2.0 260469.8100 6.0 -84.94650...
29 4134NaN 0 USA 0NaNNaN Southern Alabama, southern Mississippi News2014-04-012014-04-08 8 2 300NaN heavy Rain 1.5 82418.5600 6.0 -87.61880...
30 4133NaN 0 Argentina 0NaNNaN Western province of Neuquenr News2014-04-012014-04-08 8 0 2000NaN Heavy Rain 1.5 69876.7800 5.9 -70.29840...
31 4132NaN FL-2014-000045-SLB Solomon Islands 0NaNNaN Honiara News2014-04-012014-04-08 8 23 10000NaN Heavy Rain 2.0 5480.7500 4.9 160.34200...
32 4131NaN FL-2014-000038-ZAF South Africa NamibiaNaNNaN SADC region, Zambezi River News2014-03-012014-03-30 30 37 3528NaN Heavy Rain 1.5 1037639.2000 7.7 25.60740...
33 4130NaN 0 Australia 0NaNNaN Southeast and Central Queensland; Yeppoon area... News2014-03-242014-03-30 7 1 0NaN Torrential Rain 1.5 250162.1200 6.4 150.11700...
34 4129NaN 0 USA 0NaNNaN Southern Mississippi, Wilkinson County News2014-03-252014-03-30 6 0 200NaN Heavy Rain 1.5 53220.7900 5.7 -89.12820...
35 4128NaN 0 Zimbawe 0NaNNaN Tokwe-Mukosi News2014-02-012014-03-30 58 0 4000NaN Dam Break 1.0 17205.6400 6.0 31.34790...
36 4127NaN FL-2014-000030-PRY Paraguay 0NaNNaN Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio News2014-02-252014-03-10 14 0 2000NaN Heavy Rain 1.0 6829.5700 5.0 -57.58330...
37 4126NaN 0 Burundi 0NaNNaN Bujumbura News2014-02-192014-03-10 20 69 20000NaN Torrential Rain 2.0 3237.4200 5.1 29.64990...
38 4125NaN 0 New Zealand 0NaNNaN Christchurch, including Avon River News2014-03-032014-03-10 8 0 80NaN Heavy Rain 2.0 1015.8400 4.2 172.61300...
39 4124NaN SS-2014-000032-MHL USA 0NaNNaN Majuro News2014-03-032014-03-10 8 0 900NaN Storm Surge 1.5 34.8366 2.6 168.72900...
40 4123NaN 0 Mozambique 0NaNNaN Johannesburg , Kliptown, Soweto; eastern South... News2014-02-242014-03-10 15 4 20000NaN Heavy Rain 1.0 481907.8800 6.9 31.54590...
41 4122NaN 0 France ItalyNaNNaN Southeastern France, western France, Pisa, Lig... News2014-01-202014-02-07 19 4 1000NaN Heavy Rain 1.5 82989.4500 6.4 7.09930...
42 4121NaN 0 Indonesia 0NaNNaN Jakarta, Tangerang News2014-01-082014-02-07 31 23 20000NaN Heavy Rain 1.5 35769.2200 6.2 107.70600...
43 4120NaN 0 Australia 0NaNNaN Top End, Northern Territory News2014-02-022014-02-07 6 0 0NaN Tropical Storm Fletcher 1.0 426979.8400 6.4 131.73200...
44 4119NaN 0 Zimbawe 0NaNNaN Communities downstream of the Tokwe-Mukrosi Da... News2014-01-152014-02-07 24 0 4000NaN Heavy Rain 1.5 72462.2300 6.4 28.92310...
45 4118NaN 0 Zimbawe 0NaNNaN Muzarabani News2014-01-152014-02-07 24 0 0NaN Heavy Rain 1.5 142586.1000 6.7 30.85310...
46 4117NaN FL-2014-000008-BOL Bolivia 0NaNNaN La Paz, Beni, Santa Cruz and Cochabamba; Beni... News2014-01-102014-05-01 112 60 84000NaN Heavy Rain 2.0 381576.6500 7.9 -64.01350...
47 4116NaN 0 Peru 0NaNNaN Southern Andean Cusco region News2014-01-012014-01-04 4 0 300NaN Heavy Rain 1.0 74144.6600 5.5 -71.52320...
48 4115NaN 0 USA 0NaNNaN Nelson and Carroll Counties, Kentucky News2013-12-222014-01-04 14 5 0NaN Heavy Rain 1.0 16069.9100 5.4 -86.78990...
49 4114NaN FL-2013-000159-LCA Saint Vincent St. LuciaNaNNaN Saint Vincent and the Grenadines, St. Lucia News2013-12-262014-01-04 10 11 0NaN Heavy Rain 1.0 830.2320 3.9 -60.98860...
50 4113NaN FL-2013-000157-BRA Brazil 0NaNNaN Southeast states of Minas Gerais and Espirito ... News2013-12-232014-01-04 13 45 60000NaN Heavy Rain 2.0 314284.9100 6.9 -41.94230...
51 4112NaN 0 Indonesia 0NaNNaN North Sumatras Langkat district News2013-12-292014-01-04 7 0 4500NaN Heavy Rain 1.0 22524.6300 5.2 97.28930...
52 4111NaN 0 United Kingdom IrelandNaNNaN Central and southern Scotland, Wales, Ireland,... News2013-12-272014-02-07 43 0 200NaN Heavy Rain 1.5 126149.7900 6.9 -1.51144...
53 4110NaN FL-2013-000149-THA Thailand 0NaNNaN Southeast provinces; Nakhon Si Thammarat, Song... News2013-11-202013-12-08 19 23 15254NaN Monsoonal Rain 1.5 38676.7100 6.0 100.39500...
54 4109NaN 0 Cuba 0NaNNaN Havana News2013-12-012013-12-08 8 2 227NaN Torrential Rain 1.0 7627.3000 4.8 -81.39580...
55 4108NaN 0 Niger 0NaNNaN South-east Niger, Komadougou River News2013-11-032013-12-08 36 0 1000NaN Heavy Rain 1.0 65791.1400 6.4 13.20170...
56 4107NaN FL-2013-000148-MYS Malaysia 0NaNNaN Kuala Lumpur, east coast states of Pahang and ... News2013-12-012013-12-08 8 1 19000NaN Monsoonal Rain 1.5 106697.5300 6.1 102.36200...
57 4106NaN 0 United Kingdom GermanyNaNNaN Eastern England coast, northern European coast News2013-12-052013-12-08 4 8 4000NaN Storm Surge 2.0 51279.6000 5.6 7.53306...
58 4105NaN FL-2013-000141-SOM Somalia 0NaNNaN Northeast Puntland News2013-11-082013-11-19 12 100 0NaN Tropical Storm 1.5 181848.0200 6.5 57.42760...
59 4104NaN 0 Saudi Arabia 0NaNNaN Riyadh, other parts of the Kingdom including n... News2013-11-182013-11-19 2 15 121NaN Torrential Rain 1.5 361386.8400 6.0 44.80840...
............................................................
\n", "

276 rows \u00d7 29 columns

\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 50, "text": [ " Register # Annual DFO # (discontinued) Glide # \\\n", "0 4163 NaN 0 \n", "1 4162 NaN 0 \n", "2 4161 NaN 0 \n", "3 4160 NaN 0 \n", "4 4159 NaN 0 \n", "5 4158 NaN 0 \n", "6 4157 NaN 0 \n", "7 4156 NaN 0 \n", "8 4155 NaN 0 \n", "9 4154 NaN 0 \n", "10 4153 NaN 0 \n", "11 4152 NaN 0 \n", "12 4151 NaN 0 \n", "13 4150 NaN 0 \n", "14 4149 NaN 0 \n", "15 4148 NaN TC-2014-000071-MEX \n", "16 4147 NaN 0 \n", "17 4146 NaN 0 \n", "18 4145 NaN FL-2014-000070-LKA \n", "19 4144 NaN 0 \n", "20 4143 NaN FL-2014-000062-CHN \n", "21 4142 NaN FL-2014-000063-TJK \n", "22 4141 NaN 0 \n", "23 4140 NaN 0 \n", "24 4139 NaN 0 \n", "25 4138 NaN FF-2014-000059-SRB \n", "26 4137 NaN 0 \n", "27 4136 NaN FF-2014-000060-AFG \n", "28 4135 NaN 0 \n", "29 4134 NaN 0 \n", "30 4133 NaN 0 \n", "31 4132 NaN FL-2014-000045-SLB \n", "32 4131 NaN FL-2014-000038-ZAF \n", "33 4130 NaN 0 \n", "34 4129 NaN 0 \n", "35 4128 NaN 0 \n", "36 4127 NaN FL-2014-000030-PRY \n", "37 4126 NaN 0 \n", "38 4125 NaN 0 \n", "39 4124 NaN SS-2014-000032-MHL \n", "40 4123 NaN 0 \n", "41 4122 NaN 0 \n", "42 4121 NaN 0 \n", "43 4120 NaN 0 \n", "44 4119 NaN 0 \n", "45 4118 NaN 0 \n", "46 4117 NaN FL-2014-000008-BOL \n", "47 4116 NaN 0 \n", "48 4115 NaN 0 \n", "49 4114 NaN FL-2013-000159-LCA \n", "50 4113 NaN FL-2013-000157-BRA \n", "51 4112 NaN 0 \n", "52 4111 NaN 0 \n", "53 4110 NaN FL-2013-000149-THA \n", "54 4109 NaN 0 \n", "55 4108 NaN 0 \n", "56 4107 NaN FL-2013-000148-MYS \n", "57 4106 NaN 0 \n", "58 4105 NaN FL-2013-000141-SOM \n", "59 4104 NaN 0 \n", " ... ... ... \n", "\n", " Country Other Nations Affected \\\n", "0 Brazil Uruguay NaN NaN \n", "1 Nepal 0 NaN NaN \n", "2 Bangladesh 0 NaN NaN \n", "3 USA 0 NaN NaN \n", "4 Brazil 0 NaN NaN \n", "5 Sudan 0 NaN NaN \n", "6 New Zealand 0 NaN NaN \n", "7 Thailand 0 NaN NaN \n", "8 China 0 NaN NaN \n", "9 India 0 NaN NaN \n", "10 Philippines 0 NaN NaN \n", "11 USA 0 NaN NaN \n", "12 Bulgaria 0 NaN NaN \n", "13 Paraguay Brazil NaN NaN \n", "14 Russia 0 NaN NaN \n", "15 Mexico Guatamala NaN NaN \n", "16 Iran 0 NaN NaN \n", "17 China 0 NaN NaN \n", "18 Sri Lanka 0 NaN NaN \n", "19 Afghanistan 0 NaN NaN \n", "20 China 0 NaN NaN \n", "21 Tajikistan 0 NaN NaN \n", "22 Italy 0 NaN NaN \n", "23 Tanzania 0 NaN NaN \n", "24 Serbia Bosnia NaN NaN \n", "25 Romania Bulgaria NaN NaN \n", "26 Tanzania 0 NaN NaN \n", "27 Afghanistan 0 NaN NaN \n", "28 USA 0 NaN NaN \n", "29 USA 0 NaN NaN \n", "30 Argentina 0 NaN NaN \n", "31 Solomon Islands 0 NaN NaN \n", "32 South Africa Namibia NaN NaN \n", "33 Australia 0 NaN NaN \n", "34 USA 0 NaN NaN \n", "35 Zimbawe 0 NaN NaN \n", "36 Paraguay 0 NaN NaN \n", "37 Burundi 0 NaN NaN \n", "38 New Zealand 0 NaN NaN \n", "39 USA 0 NaN NaN \n", "40 Mozambique 0 NaN NaN \n", "41 France Italy NaN NaN \n", "42 Indonesia 0 NaN NaN \n", "43 Australia 0 NaN NaN \n", "44 Zimbawe 0 NaN NaN \n", "45 Zimbawe 0 NaN NaN \n", "46 Bolivia 0 NaN NaN \n", "47 Peru 0 NaN NaN \n", "48 USA 0 NaN NaN \n", "49 Saint Vincent St. Lucia NaN NaN \n", "50 Brazil 0 NaN NaN \n", "51 Indonesia 0 NaN NaN \n", "52 United Kingdom Ireland NaN NaN \n", "53 Thailand 0 NaN NaN \n", "54 Cuba 0 NaN NaN \n", "55 Niger 0 NaN NaN \n", "56 Malaysia 0 NaN NaN \n", "57 United Kingdom Germany NaN NaN \n", "58 Somalia 0 NaN NaN \n", "59 Saudi Arabia 0 NaN NaN \n", " ... ... ... ... \n", "\n", " Detailed Locations (click on active links to access inundation extents) \\\n", "0 State of Rio Grande do Sul; Uruguay River \n", "1 Sindhupalchok, Lalitpur and Chitwan districts ... \n", "2 Bhola District in the Division of Barisal, Ban... \n", "3 Mendenhall Lake and River, Juneau, Alaska \n", "4 Amazonas State; Northwestern Brazil; Careiro d... \n", "5 Sinja locality in the eastern Sudan state of S... \n", "6 North Island, Hikurangi Swamp area, north of W... \n", "7 Rayong, Chiang Rai, and Trang \n", "8 Southern China; Hunan, Jiangxi provinces; Gua... \n", "9 Assam \n", "10 Southern Philippine province of Maguindanao \n", "11 South Dakota, Iowa, Illinois, Missouri, Minnesota \n", "12 Eastern Bulgaria; Varna district of Asparuhov;... \n", "13 Southern Brazil, Parana State; Paraguay River ... \n", "14 Altai region, Khakassia Republic, and Altai R... \n", "15 Chiapas, SE Mexico.W Guatamala \n", "16 Khorasan, Mazandaran and Semnan provinces \n", "17 Southern China, Guangdong Province \n", "18 Western districts of Sri Lanka \n", "19 Baghlan provinc \n", "20 Hunan Province, including Guiyang, Shenzhen ci... \n", "21 Khatlon Province, Rudaki and Vahdat districts,... \n", "22 Marche region of central Italy \n", "23 Rufiji District in Coast Region \n", "24 Bosnia,Serbia, Croatia \n", "25 Bulgaria, Serbia, southern Romania \n", "26 Dar es Salaam region \n", "27 Northwestern Afghanistan; Jowzjan Province, pr... \n", "28 Gulf Coast; Northeast Atlantic Coast \n", "29 Southern Alabama, southern Mississippi \n", "30 Western province of Neuquenr \n", "31 Honiara \n", "32 SADC region, Zambezi River \n", "33 Southeast and Central Queensland; Yeppoon area... \n", "34 Southern Mississippi, Wilkinson County \n", "35 Tokwe-Mukosi \n", "36 Luque, Mariano Roque Alonso, Lambar\u00e9, and Limpio \n", "37 Bujumbura \n", "38 Christchurch, including Avon River \n", "39 Majuro \n", "40 Johannesburg , Kliptown, Soweto; eastern South... \n", "41 Southeastern France, western France, Pisa, Lig... \n", "42 Jakarta, Tangerang \n", "43 Top End, Northern Territory \n", "44 Communities downstream of the Tokwe-Mukrosi Da... \n", "45 Muzarabani \n", "46 La Paz, Beni, Santa Cruz and Cochabamba; Beni... \n", "47 Southern Andean Cusco region \n", "48 Nelson and Carroll Counties, Kentucky \n", "49 Saint Vincent and the Grenadines, St. Lucia \n", "50 Southeast states of Minas Gerais and Espirito ... \n", "51 North Sumatras Langkat district \n", "52 Central and southern Scotland, Wales, Ireland,... \n", "53 Southeast provinces; Nakhon Si Thammarat, Song... \n", "54 Havana \n", "55 South-east Niger, Komadougou River \n", "56 Kuala Lumpur, east coast states of Pahang and ... \n", "57 Eastern England coast, northern European coast \n", "58 Northeast Puntland \n", "59 Riyadh, other parts of the Kingdom including n... \n", " ... \n", "\n", " Validation (post event #3503) Began Ended Duration in Days \\\n", "0 News 2014-07-03 2014-07-14 12 \n", "1 News 2014-07-01 2014-07-14 14 \n", "2 News 2014-07-13 2014-07-14 2 \n", "3 News 2014-07-11 2014-07-14 4 \n", "4 News 2014-05-22 2014-07-14 54 \n", "5 News 2014-07-07 2014-07-14 8 \n", "6 News 2014-07-05 2014-07-14 10 \n", "7 News 2014-07-11 2014-07-14 4 \n", "8 News 2014-06-05 2014-06-25 21 \n", "9 News 2014-06-23 2014-06-25 3 \n", "10 News 2014-06-17 2014-06-25 9 \n", "11 News 2014-06-10 2014-07-14 35 \n", "12 News 2014-06-19 2014-06-25 7 \n", "13 News 2014-06-03 2014-07-14 42 \n", "14 News 2014-06-04 2014-06-10 7 \n", "15 News 2014-06-01 2014-06-10 10 \n", "16 News 2014-06-01 2014-06-10 10 \n", "17 News 2014-05-30 2014-06-10 12 \n", "18 News 2014-06-04 2014-06-10 7 \n", "19 News 2014-06-03 2014-06-10 8 \n", "20 News 2014-05-12 2014-05-16 5 \n", "21 News 2014-05-10 2014-05-16 7 \n", "22 News 2014-05-02 2014-05-10 9 \n", "23 News 2014-05-10 2014-05-16 7 \n", "24 News 2014-05-12 2014-05-16 5 \n", "25 News 2014-04-17 2014-05-01 15 \n", "26 News 2014-04-18 2014-05-01 14 \n", "27 News 2014-04-20 2014-05-16 27 \n", "28 News 2014-04-30 2014-05-01 2 \n", "29 News 2014-04-01 2014-04-08 8 \n", "30 News 2014-04-01 2014-04-08 8 \n", "31 News 2014-04-01 2014-04-08 8 \n", "32 News 2014-03-01 2014-03-30 30 \n", "33 News 2014-03-24 2014-03-30 7 \n", "34 News 2014-03-25 2014-03-30 6 \n", "35 News 2014-02-01 2014-03-30 58 \n", "36 News 2014-02-25 2014-03-10 14 \n", "37 News 2014-02-19 2014-03-10 20 \n", "38 News 2014-03-03 2014-03-10 8 \n", "39 News 2014-03-03 2014-03-10 8 \n", "40 News 2014-02-24 2014-03-10 15 \n", "41 News 2014-01-20 2014-02-07 19 \n", "42 News 2014-01-08 2014-02-07 31 \n", "43 News 2014-02-02 2014-02-07 6 \n", "44 News 2014-01-15 2014-02-07 24 \n", "45 News 2014-01-15 2014-02-07 24 \n", "46 News 2014-01-10 2014-05-01 112 \n", "47 News 2014-01-01 2014-01-04 4 \n", "48 News 2013-12-22 2014-01-04 14 \n", "49 News 2013-12-26 2014-01-04 10 \n", "50 News 2013-12-23 2014-01-04 13 \n", "51 News 2013-12-29 2014-01-04 7 \n", "52 News 2013-12-27 2014-02-07 43 \n", "53 News 2013-11-20 2013-12-08 19 \n", "54 News 2013-12-01 2013-12-08 8 \n", "55 News 2013-11-03 2013-12-08 36 \n", "56 News 2013-12-01 2013-12-08 8 \n", "57 News 2013-12-05 2013-12-08 4 \n", "58 News 2013-11-08 2013-11-19 12 \n", "59 News 2013-11-18 2013-11-19 2 \n", " ... ... ... ... \n", "\n", " Dead Displaced Damage (USD) Main cause Severity * \\\n", "0 10 50000 NaN Heavy Rain 2.0 \n", "1 16 2400 NaN Torrential Rain 1.5 \n", "2 0 30000 NaN Heavy Rain and High Tide 1.5 \n", "3 0 0 NaN J\u00f6kulhlaup 1.0 \n", "4 0 0 NaN Heavy Rain 2.0 \n", "5 0 42400 NaN Heavy Rain 1.5 \n", "6 0 0 NaN Heavy Rain 1.0 \n", "7 0 500 NaN Heavy Rain 1.0 \n", "8 14 337000 NaN Monsoonal Rain 1.0 \n", "9 0 10000 NaN Monsoonal Ran 1.0 \n", "10 0 35000 NaN Heavy Rain 1.0 \n", "11 0 600 NaN Heavy Rain 2.0 \n", "12 12 2000 NaN Torrential Rain 2.0 \n", "13 9 265000 NaN Heay Rain 2.0 \n", "14 70 3000 NaN Torrential Rain 1.5 \n", "15 22 25000 NaN Monsoonal Rain 1.5 \n", "16 37 440000 NaN Monsoonal Rain 1.5 \n", "17 6 500 NaN Heavy Rain 1.0 \n", "18 5 16000 NaN Tropical Storm Boris 1.5 \n", "19 0 300 NaN Heavy Rain 1.5 \n", "20 1 10000 NaN Heavy Rain 2.0 \n", "21 0 425 NaN Heavy Rain 1.5 \n", "22 2 250 NaN Torrential Rain 1.5 \n", "23 0 22000 NaN Heavy Rain 1.0 \n", "24 3 4000 NaN Heavy Rain 2.0 \n", "25 0 640 NaN Torrential Rain 1.5 \n", "26 41 0 NaN Torrential Rain 1.5 \n", "27 123 6000 NaN Torrential Rain 1.5 \n", "28 1 200 NaN Torrential Rain 2.0 \n", "29 2 300 NaN heavy Rain 1.5 \n", "30 0 2000 NaN Heavy Rain 1.5 \n", "31 23 10000 NaN Heavy Rain 2.0 \n", "32 37 3528 NaN Heavy Rain 1.5 \n", "33 1 0 NaN Torrential Rain 1.5 \n", "34 0 200 NaN Heavy Rain 1.5 \n", "35 0 4000 NaN Dam Break 1.0 \n", "36 0 2000 NaN Heavy Rain 1.0 \n", "37 69 20000 NaN Torrential Rain 2.0 \n", "38 0 80 NaN Heavy Rain 2.0 \n", "39 0 900 NaN Storm Surge 1.5 \n", "40 4 20000 NaN Heavy Rain 1.0 \n", "41 4 1000 NaN Heavy Rain 1.5 \n", "42 23 20000 NaN Heavy Rain 1.5 \n", "43 0 0 NaN Tropical Storm Fletcher 1.0 \n", "44 0 4000 NaN Heavy Rain 1.5 \n", "45 0 0 NaN Heavy Rain 1.5 \n", "46 60 84000 NaN Heavy Rain 2.0 \n", "47 0 300 NaN Heavy Rain 1.0 \n", "48 5 0 NaN Heavy Rain 1.0 \n", "49 11 0 NaN Heavy Rain 1.0 \n", "50 45 60000 NaN Heavy Rain 2.0 \n", "51 0 4500 NaN Heavy Rain 1.0 \n", "52 0 200 NaN Heavy Rain 1.5 \n", "53 23 15254 NaN Monsoonal Rain 1.5 \n", "54 2 227 NaN Torrential Rain 1.0 \n", "55 0 1000 NaN Heavy Rain 1.0 \n", "56 1 19000 NaN Monsoonal Rain 1.5 \n", "57 8 4000 NaN Storm Surge 2.0 \n", "58 100 0 NaN Tropical Storm 1.5 \n", "59 15 121 NaN Torrential Rain 1.5 \n", " ... ... ... ... ... \n", "\n", " Affected sq km Magnitude (M)** Centroid X \n", "0 44866.4600 6.0 -58.02560 ... \n", "1 11578.7700 5.4 84.62070 ... \n", "2 217.5290 2.8 90.54980 ... \n", "3 2950.8200 4.1 -134.44600 ... \n", "4 256564.5700 7.4 -59.55970 ... \n", "5 137141.2800 6.2 33.08000 ... \n", "6 8581.2400 4.9 174.06800 ... \n", "7 15921.6300 4.8 99.73900 ... \n", "8 377101.6300 6.9 112.35800 ... \n", "9 49220.5300 5.2 94.71600 ... \n", "10 15356.3100 5.1 124.73000 ... \n", "11 418317.1300 7.5 -94.79440 ... \n", "12 24415.4200 5.5 27.04260 ... \n", "13 554605.2500 7.7 -53.54700 ... \n", "14 1829701.4000 7.3 94.36960 ... \n", "15 113685.4300 6.2 -94.02740 ... \n", "16 305525.2500 6.7 57.25440 ... \n", "17 45994.3000 5.7 113.34200 ... \n", "18 10337.4700 5.0 80.16680 ... \n", "19 44203.9300 5.7 68.01780 ... \n", "20 205001.2700 6.3 111.46700 ... \n", "21 41719.4600 5.6 69.37870 ... \n", "22 11256.3300 5.2 13.01300 ... \n", "23 22249.3400 5.2 38.94420 ... \n", "24 115747.6900 6.1 19.22360 ... \n", "25 87430.6900 6.3 24.49400 ... \n", "26 18498.3900 5.6 38.96890 ... \n", "27 83722.3400 6.5 66.43420 ... \n", "28 260469.8100 6.0 -84.94650 ... \n", "29 82418.5600 6.0 -87.61880 ... \n", "30 69876.7800 5.9 -70.29840 ... \n", "31 5480.7500 4.9 160.34200 ... \n", "32 1037639.2000 7.7 25.60740 ... \n", "33 250162.1200 6.4 150.11700 ... \n", "34 53220.7900 5.7 -89.12820 ... \n", "35 17205.6400 6.0 31.34790 ... \n", "36 6829.5700 5.0 -57.58330 ... \n", "37 3237.4200 5.1 29.64990 ... \n", "38 1015.8400 4.2 172.61300 ... \n", "39 34.8366 2.6 168.72900 ... \n", "40 481907.8800 6.9 31.54590 ... \n", "41 82989.4500 6.4 7.09930 ... \n", "42 35769.2200 6.2 107.70600 ... \n", "43 426979.8400 6.4 131.73200 ... \n", "44 72462.2300 6.4 28.92310 ... \n", "45 142586.1000 6.7 30.85310 ... \n", "46 381576.6500 7.9 -64.01350 ... \n", "47 74144.6600 5.5 -71.52320 ... \n", "48 16069.9100 5.4 -86.78990 ... \n", "49 830.2320 3.9 -60.98860 ... \n", "50 314284.9100 6.9 -41.94230 ... \n", "51 22524.6300 5.2 97.28930 ... \n", "52 126149.7900 6.9 -1.51144 ... \n", "53 38676.7100 6.0 100.39500 ... \n", "54 7627.3000 4.8 -81.39580 ... \n", "55 65791.1400 6.4 13.20170 ... \n", "56 106697.5300 6.1 102.36200 ... \n", "57 51279.6000 5.6 7.53306 ... \n", "58 181848.0200 6.5 57.42760 ... \n", "59 361386.8400 6.0 44.80840 ... \n", " ... ... ... \n", "\n", "[276 rows x 29 columns]" ] } ], "prompt_number": 50 } ], "metadata": {} } ] }