Back to fileView metadata
Schema
Historical Tsunami Event Locations / historical-tsunami-event-locations- / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
75 columns
Features
2,637
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| YEAR | integer | No | 0 | — | — Range: -2000 to 2025Length: — | Examples: 2018, 1698, 177, 1978, 1980 Values: — |
| MONTH | float | Yes | 113 | — | — Range: 1 to 12Length: — | Examples: 7.0, 3.0, 8.0, 3.0, 7.0 Values: — |
| DAY | float | Yes | 197 | — | — Range: 1 to 31Length: — | Examples: 16.0, 11.0, 6.0, 29.0, 7.0 Values: — |
| HOUR | float | Yes | 1,072 | — | — Range: 0 to 23Length: — | Examples: 20.0, 15.0, 23.0, 5.0, 3.0 Values: — |
| MINUTE | float | Yes | 1,156 | — | — Range: 0 to 59Length: — | Examples: 17.0, 30.0, 32.0, 22.0, 7.0 Values: — |
| SECOND | float | Yes | 2,637 | — | — Range: —Length: — | Examples: — Values: — |
| DATE_STRING | string | No | 0 | — | — Range: —Length: 11 | Examples: 2018/01/23, 1698/05/14, 0177/??/??, 1978/11/29, 1980/05/12 Values: — |
| EVENT_DATE | string | Yes | 29 | — | — Range: —Length: 25 | Examples: 1542-12-10T00:00:00+00:00, 2021-02-13T00:00:00+00:00, 1722-10-01T00:00:00+00:00, 0103-01-01T00:00:00+00:00, 1928-04-25T00:00:00+00:00 Values: — |
| LATITUDE | float | No | 0 | — | — Range: -69.417 to 78.37Length: — | Examples: 56.004, 40.821, 38.0, 16.01, -14.464 Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -179.971 to 179.984Length: — | Examples: -149.166, 14.426, 15.0, -96.591, 167.902 Values: — |
| LOCATION_NAME | string | Yes | 1 | — | — Range: —Length: 35 | Examples: KII, KUMANANONADA, LAKE ONTARIO, ALBANIAN COASTS, PERU, NANKAIDO Values: — |
| AREA | string | Yes | 2,401 | — | — Range: —Length: 2 | Examples: GU, MO, WA, AK, HI Values: — |
| COUNTRY | string | No | 0 | — | — Range: —Length: 36 | Examples: USA, ITALY, ITALY, MEXICO, VANUATU Values: — |
| REGION_CODE | float | Yes | 1 | — | — Range: 30 to 89Length: — | Examples: 85.0, 82.0, 50.0, 89.0, 85.0 Values: — |
| REGION | string | Yes | 1 | — | — Range: —Length: 54 | Examples: Japan, New Caledonia, New Guinea, Solomon Is., Vanuatu, Mediterranean Sea, West Coast of South America, Japan Values: — |
| CAUSE_CODE | float | Yes | 2 | — | — Range: 0 to 10Length: — | Examples: 1.0, 0.0, 1.0, 1.0, 1.0 Values: — |
| CAUSE | string | Yes | 2 | — | — Range: —Length: 33 | Examples: Earthquake, Unknown, Earthquake, Earthquake, Earthquake Values: Earthquake, Earthquake and Landslide, Explosion, Landslide, Meteorological, Questionable Earthquake, Unknown, Volcano, Volcano and Earthquake, Volcano and Landslide, Volcano, Earthquake and Landslide |
| EVENT_VALIDITY_CODE | integer | No | 0 | — | — Range: -1 to 4Length: — | Examples: 4, 2, 2, 2, 3 Values: — |
| EVENT_VALIDITY | string | No | 0 | — | — Range: —Length: 31 | Examples: Definite Tsunami, Questionable Tsunami, Questionable Tsunami, Questionable Tsunami, Probable Tsunami Values: Definite Tsunami, Erroneous entry, Event that only caused a seiche, Probable Tsunami, Questionable Tsunami, Very Doubtful Tsunami |
| EQ_MAG_UNK | float | Yes | 2,524 | — | — Range: 4 to 9Length: — | Examples: 7.9, 7.0, 8.1, 6.4, 7.8 Values: — |
| EQ_MAG_MB | float | Yes | 2,200 | — | — Range: 3.4 to 7.9Length: — | Examples: 6.5, 6.7, 6.4, 6.2, 6.5 Values: — |
| EQ_MAG_MS | float | Yes | 1,240 | — | — Range: 3.2 to 8.8Length: — | Examples: 7.5, 6.4, 7.2, 7.6, 7.5 Values: — |
| EQ_MAG_MW | float | Yes | 1,962 | — | — Range: 4.6 to 9.5Length: — | Examples: 6.4, 7.9, 6.6, 6.3, 7.8 Values: — |
| EQ_MAG_ML | float | Yes | 2,596 | — | — Range: 4 to 7.7Length: — | Examples: 5.4, 5.5, 7.2, 5.9, 6.2 Values: — |
| EQ_MAG_MFA | float | Yes | 2,628 | — | — Range: 4.3 to 8.5Length: — | Examples: 6.5, 7.9, 8.4, 5.5, 6.2 Values: — |
| EQ_MAGNITUDE | float | Yes | 918 | — | — Range: 3.2 to 9.5Length: — | Examples: 8.0, 7.0, 8.2, 7.0, 7.3 Values: — |
| EQ_MAGNITUDE_RANK | float | Yes | 918 | — | — Range: 5 to 9Length: — | Examples: 8.0, 7.0, 8.0, 7.0, 7.0 Values: — |
| EQ_DEPTH | float | Yes | 1,556 | — | — Range: 0 to 600Length: — | Examples: 60.0, 17.0, 10.0, 37.0, 14.0 Values: — |
| MAX_EVENT_RUNUP | float | Yes | 1,336 | — | — Range: 0 to 524.6Length: — | Examples: 1.5, 2.8, 4.0, 4.0, 2.44 Values: — |
| TS_MT_ABE | float | Yes | 2,635 | — | — Range: 8 to 8.1Length: — | Examples: 8.1, 8.0 Values: — |
| TS_MT_II | float | Yes | 1,926 | — | — Range: -4.64 to 8.4Length: — | Examples: 0.4, 2.2, 5.1, 1.0, 1.4 Values: — |
| TS_INTENSITY | float | Yes | 1,461 | — | — Range: -4.14 to 9Length: — | Examples: 3.0, 0.5, 2.0, -0.5, 1.0 Values: — |
| DAMAGE_MILLIONS_DOLLARS | float | Yes | 2,589 | — | — Range: 0.01 to 220136.6Length: — | Examples: 1.2, 0.075, 25.0, 4.2, 0.01 Values: — |
| DAMAGE_AMOUNT_ORDER | float | Yes | 1,981 | — | — Range: 1 to 4Length: — | Examples: 1.0, 1.0, 2.0, 2.0, 1.0 Values: — |
| DAMAGE_DESCRIPTION | string | Yes | 1,981 | — | — Range: —Length: 30 | Examples: Limited (<$1 million), Limited (<$1 million), Moderate (~$1 to $5 million), Moderate (~$1 to $5 million), Limited (<$1 million) Values: Extreme (~$25 million or more), Limited (<$1 million), Moderate (~$1 to $5 million), Severe (~>$5 to $24 million) |
| HOUSES_DESTROYED | float | Yes | 2,535 | — | — Range: 1 to 123661Length: — | Examples: 50.0, 1.0, 400.0, 3000.0, 1.0 Values: — |
| HOUSES_AMOUNT_ORDER | float | Yes | 2,353 | — | — Range: 1 to 4Length: — | Examples: 1.0, 4.0, 3.0, 1.0, 3.0 Values: — |
| HOUSES_DESCRIPTION | string | Yes | 2,353 | — | — Range: —Length: 32 | Examples: Few (~1 to 50 houses), Very Many (~1001 or more houses), Many (~101 to 1000 houses), Few (~1 to 50 houses), Many (~101 to 1000 houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses) |
| DEATHS | float | Yes | 2,376 | — | — Range: 1 to 227899Length: — | Examples: 208.0, 28.0, 1.0, 2282.0, 1.0 Values: — |
| DEATHS_AMOUNT_ORDER | float | No | 0 | — | — Range: 0 to 4Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| DEATHS_DESCRIPTION | string | Yes | 2,281 | — | — Range: —Length: 32 | Examples: Many (~101 to 1000 people), Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) |
| INJURIES | float | Yes | 2,563 | — | — Range: 1 to 31943Length: — | Examples: 1.0, 12000.0, 19.0, 1.0, 489.0 Values: — |
| INJURIES_AMOUNT_ORDER | float | Yes | 2,551 | — | — Range: 1 to 4Length: — | Examples: 1.0, 3.0, 1.0, 2.0, 1.0 Values: — |
| INJURIES_DESCRIPTION | string | Yes | 2,551 | — | — Range: —Length: 32 | Examples: Few (~1 to 50 people), Many (~101 to 1000 people), Few (~1 to 50 people), Some (~51 to 100 people), Few (~1 to 50 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) |
| MISSING | float | Yes | 2,631 | — | — Range: 2 to 667Length: — | Examples: 12.0, 667.0, 70.0, 10.0, 30.0 Values: — |
| MISSING_AMOUNT_ORDER | float | Yes | 2,630 | — | — Range: 1 to 3Length: — | Examples: 1.0, 3.0, 2.0, 1.0, 1.0 Values: — |
| MISSING_DESCRIPTION | string | Yes | 2,630 | — | — Range: —Length: 26 | Examples: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Few (~1 to 50 people), Few (~1 to 50 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people) |
| NUM_RUNUP | integer | No | 0 | — | — Range: 0 to 6421Length: — | Examples: 64, 5, 0, 1, 0 Values: — |
| DAMAGE_MILLIONS_DOLLARS_TOTAL | float | Yes | 2,464 | — | — Range: 0.005 to 220136.6Length: — | Examples: 8.0, 7200.0, 2.625, 812.0, 0.9 Values: — |
| DAMAGE_AMOUNT_ORDER_TOTAL | float | Yes | 1,312 | — | — Range: 1 to 4Length: — | Examples: 3.0, 1.0, 1.0, 3.0, 2.0 Values: — |
| DAMAGE_TOTAL_DESCRIPTION | string | Yes | 1,312 | — | — Range: —Length: 30 | Examples: Severe (~>$5 to $24 million), Limited (<$1 million), Limited (<$1 million), Severe (~>$5 to $24 million), Moderate (~$1 to $5 million) Values: Extreme (~$25 million or more), Limited (<$1 million), Moderate (~$1 to $5 million), Severe (~>$5 to $24 million) |
| HOUSES_DESTROYED_TOTAL | float | Yes | 2,368 | — | — Range: 1 to 5360000Length: — | Examples: 856.0, 123661.0, 422.0, 98.0, 93708.0 Values: — |
| HOUSES_AMOUNT_ORDER_TOTAL | float | Yes | 1,914 | — | — Range: 1 to 4Length: — | Examples: 3.0, 4.0, 4.0, 3.0, 1.0 Values: — |
| HOUSES_TOTAL_DESCRIPTION | string | Yes | 1,914 | — | — Range: —Length: 32 | Examples: Many (~101 to 1000 houses), Very Many (~1001 or more houses), Very Many (~1001 or more houses), Many (~101 to 1000 houses), Few (~1 to 50 houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses) |
| DEATHS_TOTAL | float | Yes | 1,965 | — | — Range: 1 to 316000Length: — | Examples: 560.0, 1.0, 5000.0, 23.0, 745.0 Values: — |
| DEATHS_AMOUNT_ORDER_TOTAL | float | Yes | 1,812 | — | — Range: 1 to 4Length: — | Examples: 1.0, 3.0, 3.0, 4.0, 4.0 Values: — |
| DEATHS_TOTAL_DESCRIPTION | string | Yes | 1,812 | — | — Range: —Length: 32 | Examples: Few (~1 to 50 people), Many (~101 to 1000 people), Many (~101 to 1000 people), Very Many (~1001 or more people), Very Many (~1001 or more people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) |
| INJURIES_TOTAL | float | Yes | 2,310 | — | — Range: 1 to 374171Length: — | Examples: 89.0, 1.0, 225.0, 12.0, 750.0 Values: — |
| INJURIES_AMOUNT_ORDER_TOTAL | float | Yes | 2,253 | — | — Range: 1 to 4Length: — | Examples: 3.0, 3.0, 3.0, 3.0, 1.0 Values: — |
| INJURIES_TOTAL_DESCRIPTION | string | Yes | 2,253 | — | — Range: —Length: 32 | Examples: Many (~101 to 1000 people), Many (~101 to 1000 people), Many (~101 to 1000 people), Many (~101 to 1000 people), Few (~1 to 50 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) |
| MISSING_TOTAL | float | Yes | 2,621 | — | — Range: 1 to 800Length: — | Examples: 30.0, 667.0, 2.0, 329.0, 12.0 Values: — |
| MISSING_AMOUNT_ORDER_TOTAL | float | Yes | 2,617 | — | — Range: 1 to 4Length: — | Examples: 1.0, 4.0, 2.0, 3.0, 1.0 Values: — |
| MISSING_TOTAL_DESCRIPTION | string | Yes | 2,617 | — | — Range: —Length: 32 | Examples: Few (~1 to 50 people), Very Many (~1001 or more people), Some (~51 to 100 people), Many (~101 to 1000 people), Few (~1 to 50 people) Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people) |
| HOUSES_DAMAGED | float | Yes | 2,620 | — | — Range: 1 to 280920Length: — | Examples: 238.0, 1.0, 6036.0, 22.0, 39191.0 Values: — |
| HOUSES_DAMAGED_AMOUNT_ORDER | float | Yes | 2,572 | — | — Range: 1 to 4Length: — | Examples: 4.0, 2.0, 1.0, 3.0, 1.0 Values: — |
| HOUSES_DAM_DESCRIPTION | string | Yes | 2,572 | — | — Range: —Length: 32 | Examples: Very Many (~1001 or more houses), Some (~51 to 100 houses), Few (~1 to 50 houses), Many (~101 to 1000 houses), Few (~1 to 50 houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses) |
| HOUSES_DAMAGED_TOTAL | float | Yes | 2,529 | — | — Range: 2 to 1474182Length: — | Examples: 24810.0, 3218.0, 39191.0, 26.0, 500.0 Values: — |
| HOUSES_DAM_AMOUNT_ORDER_TOTAL | float | Yes | 2,345 | — | — Range: 1 to 4Length: — | Examples: 3.0, 3.0, 3.0, 2.0, 4.0 Values: — |
| HOUSES_DAM_TOTAL_DESCRIPTION | string | Yes | 2,345 | — | — Range: —Length: 32 | Examples: Many (~101 to 1000 houses), Many (~101 to 1000 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses) Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses) |
| CAUSE_SYMBOL | float | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0.0, 1.0, 0.0, 0.0, 0.0 Values: — |
| URL | string | No | 0 | — | — Range: —Length: 92 | Examples: http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=5673, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=3141, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=3097, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=2109, http://www.ngdc.noaa.gov/nndc/struts/results?t=101650&s=9&d=99,91,95,93&nd=display&EQ_0=5965 Values: — |
| COMMENTS | string | Yes | 172 | — | — Range: —Length: 4000 | Examples: 1875. Maclay Coast, Hermit Island, New Guinea, 6 S, 147 E, magnitude 7-8, tsunami magnitude 2. A case of great sickness and mortality on the Island Lub or Hermit island), in 1875, after the inundation of some low islands of the group by a tidal wave has been communicated by me in a letter about the Island Lub, to the, Imp. Russ. Geogr. Soc. (Investiya of the Imp. Russ. Geogr. Soc., Vol. XV.) I have heard about a similar case which happened on the Island Mafia (or St. David's Island), some twenty or thirty years ago. (reference #99 and 12433), March 25, 1990. A 6.4 Ms (USGS) earthquake at 13:16 UT was followed by a second earthquake of Ms 7.0 (USGS) at 13:23 UT that was felt throughout Costa Rica, injured ten people slightly, and damaged about sixty buildings. Several landslides blocked roads for some time. A small seismic sea wave was reported from Quepos to Tambor. It was recorded with an amplitude of 30 cm at Quepos and was also recorded at Tampor. A rise of one meter was observed at Puntarenas. The earthquake and wave occurred at low tide. (reference #1315)
<p>Eyewitnesses suddenly reported an ascent of the level of the sea in Puntarenas, of approximately 1 meter, presumably associated to the arrival of the crest of the wave tidal wave to this port. (reference #273)</p>, On November 26 (or 16), 1705, an earthquake occurred in Arequipa and Arica, and the wave generated during that quake flooded and destroyed a large part of Arica. This information may refer to the earthquake and tsunami of November 24, 1604. (reference #415)
<P>Nov. 26, 1705 , Chile and Peru. Earthquake felt at Arequipa, Peru and Arica, Chile. Waves reported in the District of Arequipa. Arica was destroyed. (reference #39), <p>On September 2, 1992, a magnitude 7.2 Ms (USGS) earthquake at 00:16 UT off the Nicaragua coast <strong>killed at least 168 people, injured 489, and left more than 13,500 homeless</strong>. More than 40,000 people were affected with losses. The combined effects of the earthquake and tsunami destroyed at least <strong>1,500 homes</strong>, and 185 fishing boats were lost in the tsunami. The total damage was estimated at <strong>$20 to $30 million</strong>. (reference #1315)</p><p>Most of the casualties and damage were caused by a tsunami affecting the west coasts of Nicaragua and Costa Rica, reaching heights of up to 8 meters [...] Maximum wave heights (in cm. peak-to-trough) at selected tide stations were as follows: 111 at Baltra Island, 83 at Easter Island, 28 at Socorro Island, 18 at La Libertad, Ecuador, 10 at Valparaiso, Chile and 10 at Hilo, Hawaii. (reference #1053)</p><p>Reference #273 lists <strong>170 fatalities.</strong></p>, <p>February 3, March 15, April 13, April 16 dates given, most likely March 15, 1924, [10:31]. 49 N, 142.5 E, Tatar Strait, magnitude 7.0, shallow depth. Great agitation in river according to Ulanov. Sieberg who gives 3 dates in Feb. and Apr. without explanations, says that great damage resulted from flood waves, but this appears to be an exaggeration. More likely to be a seiche than a tsunami. (reference #79)</p><p>1924. At the time of the so-called Uglegorsk earthquake of 1924, with its intensity of M 6-3/4 and its epicenter in the Tatar Strait on the west coast of Sakhalin, as reported by Ulanov (1932), "the water in the river became terribly agitated." Apparently there remains a possibility of the occurrence, if not of a tsunami, then of some other disturbance of the level of the sea. (reference #413)</p><p><i>Reference #12345</i> lists two events on 15 March 1924 in Tartar Strait caused by earthquakes, both with validities 1 (very doubtful tsunami). (<i>accessed May 2024</i>)</p> Values: — |
| ID | integer | No | 0 | — | — Range: 1 to 6046Length: — | Examples: 5673, 3141, 3097, 2109, 5965 Values: — |
| MAP_SYMBOL | integer | No | 0 | — | — Range: 11 to 59Length: — | Examples: 14, 19, 17, 14, 15 Values: — |
Invalid geometry count: 0
Columns hash: 55d863807ebc376cbb3dbcae7bbef8606bb6e8476e75fe23e49b6c171e482a7f
