Public Environmental Data PartnersHIFLD Next
Back to file

Schema

Historical Significant Earthquake Locations / historical-significant-earthquake-locations / v1.0.0

View metadata

Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.

Columns
67 columns
Features
6,555
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
YEARintegerNo0——
Range: -2150 to 2008Length: —
Examples: 1383, 2001, 2006, 1927, 1616
Values: —
MONTHfloatYes333——
Range: 1 to 12Length: —
Examples: 10.0, 8.0, 10.0, 1.0, 3.0
Values: —
DAYfloatYes444——
Range: 1 to 31Length: —
Examples: 7.0, 2.0, 7.0, 21.0, 20.0
Values: —
HOURfloatYes1,732——
Range: 0 to 23Length: —
Examples: 21.0, 8.0, 14.0, 7.0, 19.0
Values: —
MINUTEfloatYes1,932——
Range: 0 to 59Length: —
Examples: 53.0, 45.0, 9.0, 18.0, 0.0
Values: —
SECONDfloatYes5,000——
Range: —Length: —
Examples: —
Values: —
DATE_STRINGstringNo0——
Range: —Length: 11
Examples: 1383/08/06, 2001/10/27, 2006/12/12, 1927/09/24, 1616/09/09
Values: —
LATITUDEfloatNo0——
Range: -62.877 to 66.416Length: —
Examples: 39.2, 26.316, 18.901, 44.4, 38.1
Values: —
LONGITUDEfloatNo0——
Range: -179.984 to 180Length: —
Examples: 26.2, 100.648, 98.916, 34.3, 142.0
Values: —
LOCATION_NAMEstringNo0——
Range: —Length: 52
Examples: TURKEY, CHINA: YUNNAN PROVINCE: YONGSHENG, THAILAND: MAE RIM, UKRAINE: CRIMEA: SEBASTOPOL, JAPAN: HONSHU: MIYAGI PREFECTURE
Values: —
AREAstringYes4,738——
Range: —Length: 3
Examples: CA, CA, CA, CA, CA
Values: —
COUNTRYstringNo0——
Range: —Length: 44
Examples: TURKEY, CHINA, THAILAND, UKRAINE, JAPAN
Values: —
REGION_CODEintegerNo0——
Range: 10 to 170Length: —
Examples: 140, 30, 60, 110, 30
Values: —
REGIONstringNo0——
Range: —Length: 32
Examples: Middle East, East Asia, S. and SE. Asia and Indian Ocean, Eastern Europe, East Asia
Values: Antarctica, Atlantic Ocean, Bering Sea, Caribbean, Central America, Central Asia and Caucasus, Central and South Pacific, Central, Western and S. Africa, East Asia, Eastern Europe, Kamchatka and Kuril Islands, Middle East, North America and Hawaii, Northern Africa, Northern and Western Europe, S. and SE. Asia and Indian Ocean, South America, Southern Europe
EQ_DEPTHfloatYes2,480——
Range: 0 to 651Length: —
Examples: 219.0, 10.0, 53.0, 15.0, 4.0
Values: —
EQ_MAG_UNKfloatYes4,211——
Range: 3.5 to 8.8Length: —
Examples: 7.9, 6.3, 5.7, 7.5, 5.6
Values: —
EQ_MAG_MBfloatYes3,562——
Range: 3.2 to 8.2Length: —
Examples: 7.7, 6.4, 5.3, 5.2, 5.7
Values: —
EQ_MAG_MSfloatYes2,459——
Range: 3.5 to 9.1Length: —
Examples: 6.0, 7.8, 6.3, 5.1, 7.0
Values: —
EQ_MAG_MWfloatYes4,029——
Range: 4 to 9.5Length: —
Examples: 6.9, 5.3, 6.7, 5.1, 5.9
Values: —
EQ_MAG_MLfloatYes4,846——
Range: 1.6 to 8Length: —
Examples: 6.3, 5.1, 4.2, 6.4, 7.7
Values: —
EQ_MAG_MFAfloatYes4,987——
Range: 4.3 to 8.5Length: —
Examples: 7.9, 4.3, 8.4, 5.5, 7.4
Values: —
EQ_MAGNITUDEfloatYes1,534——
Range: 1.6 to 9.5Length: —
Examples: 5.8, 6.0, 7.8, 6.2, 6.8
Values: —
EQ_MAGNITUDE_RANKfloatYes1,534——
Range: 3 to 9Length: —
Examples: 5.0, 6.0, 7.0, 6.0, 6.0
Values: —
INTENSITYstringYes2,460——
Range: —Length: 2
Examples: 9, 8, 11, 10, 10
Values: 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9
DAMAGE_MILLIONS_DOLLARSfloatYes4,569——
Range: 0.013 to 100000Length: —
Examples: 134.0, 500.0, 3.0, 5.0, 0.2
Values: —
DAMAGE_AMOUNT_ORDERfloatYes1,359——
Range: 1 to 4Length: —
Examples: 2.0, 3.0, 3.0, 3.0, 2.0
Values: —
DAMAGE_DESCRIPTIONstringYes1,359——
Range: —Length: 30
Examples: Moderate (~$1 to $5 million), Severe (~>$5 to $24 million), Severe (~>$5 to $24 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)
DEATHSfloatYes3,277——
Range: 1 to 830000Length: —
Examples: 2.0, 50.0, 43.0, 40000.0, 11.0
Values: —
DEATHS_AMOUNT_ORDERfloatYes2,888——
Range: 0 to 4Length: —
Examples: 1.0, 1.0, 1.0, 4.0, 3.0
Values: —
DEATHS_DESCRIPTIONstringYes2,888——
Range: —Length: 32
Examples: Few (~1 to 50 people), Few (~1 to 50 people), Few (~1 to 50 people), Very Many (~1001 or more people), Many (~101 to 1000 people)
Values: Few (~1 to 50 people), Many (~101 to 1000 people), None, Some (~51 to 100 people), Very Many (~1001 or more people)
INJURIESfloatYes4,105——
Range: 1 to 799000Length: —
Examples: 200.0, 30.0, 16.0, 200.0, 36.0
Values: —
INJURIES_AMOUNT_ORDERfloatYes3,921——
Range: 1 to 4Length: —
Examples: 1.0, 3.0, 3.0, 1.0, 1.0
Values: —
INJURIES_DESCRIPTIONstringYes3,921——
Range: —Length: 32
Examples: Few (~1 to 50 people), Many (~101 to 1000 people), Many (~101 to 1000 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), Very Many (~1001 or more people)
MISSINGfloatYes4,994——
Range: 4 to 800Length: —
Examples: 800.0, 200.0, 4.0, 700.0, 30.0
Values: —
MISSING_AMOUNT_ORDERfloatYes4,992——
Range: 1 to 4Length: —
Examples: 2.0, 4.0, 1.0, 3.0, 1.0
Values: —
MISSING_DESCRIPTIONstringYes4,992——
Range: —Length: 32
Examples: Some (~51 to 100 people), Very Many (~1001 or more people), Few (~1 to 50 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_DESTROYEDfloatYes4,405——
Range: 1 to 5360000Length: —
Examples: 3000.0, 100000.0, 2000.0, 101.0, 400.0
Values: —
HOUSES_AMOUNT_ORDERfloatYes3,638——
Range: 0 to 4Length: —
Examples: 2.0, 3.0, 1.0, 2.0, 3.0
Values: —
HOUSES_DESCRIPTIONstringYes3,638——
Range: —Length: 32
Examples: Some (~51 to 100 houses), Many (~101 to 1000 houses), Few (~1 to 50 houses), Some (~51 to 100 houses), Many (~101 to 1000 houses)
Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), None, Some (~51 to 100 houses), Very Many (~1001 or more houses)
HOUSES_DAMAGEDfloatYes4,748——
Range: 1 to 5360000Length: —
Examples: 90.0, 15.0, 2230.0, 1110.0, 50.0
Values: —
HOUSES_DAMAGED_AMOUNT_ORDERfloatYes4,422——
Range: 1 to 4Length: —
Examples: 2.0, 2.0, 3.0, 3.0, 2.0
Values: —
HOUSES_DAM_DESCRIPTIONstringYes4,422——
Range: —Length: 32
Examples: Some (~51 to 100 houses), Some (~51 to 100 houses), Many (~101 to 1000 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses)
Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses)
DAMAGE_MILLIONS_DOLLARS_TOTALfloatYes4,585——
Range: 0.01 to 100000Length: —
Examples: 12.0, 5.0, 1.0, 285.5, 170.4
Values: —
DAMAGE_AMOUNT_ORDER_TOTALfloatYes2,187——
Range: 1 to 4Length: —
Examples: 1.0, 4.0, 2.0, 2.0, 4.0
Values: —
DAMAGE_TOTAL_DESCRIPTIONstringYes2,187——
Range: —Length: 30
Examples: Limited (<$1 million), Extreme (~$25 million or more), Moderate (~$1 to $5 million), Moderate (~$1 to $5 million), Extreme (~$25 million or more)
Values: Extreme (~$25 million or more), Limited (<$1 million), Moderate (~$1 to $5 million), Severe (~>$5 to $24 million)
DEATHS_TOTALfloatYes3,435——
Range: 1 to 830000Length: —
Examples: 118.0, 1.0, 37.0, 3800.0, 745.0
Values: —
DEATHS_AMOUNT_ORDER_TOTALfloatYes3,153——
Range: 1 to 4Length: —
Examples: 1.0, 3.0, 2.0, 1.0, 4.0
Values: —
DEATHS_TOTAL_DESCRIPTIONstringYes3,153——
Range: —Length: 32
Examples: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Few (~1 to 50 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_TOTALfloatYes4,088——
Range: 1 to 799000Length: —
Examples: 6.0, 5.0, 150.0, 1.0, 586.0
Values: —
INJURIES_AMOUNT_ORDER_TOTALfloatYes3,900——
Range: 1 to 4Length: —
Examples: 4.0, 4.0, 1.0, 3.0, 3.0
Values: —
INJURIES_TOTAL_DESCRIPTIONstringYes3,900——
Range: —Length: 32
Examples: Very Many (~1001 or more people), Very Many (~1001 or more people), Few (~1 to 50 people), Many (~101 to 1000 people), Many (~101 to 1000 people)
Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people)
MISSING_TOTALfloatYes4,991——
Range: 1 to 1755Length: —
Examples: 800.0, 200.0, 100.0, 1.0, 1755.0
Values: —
MISSING_AMOUNT_ORDER_TOTALfloatYes4,988——
Range: 1 to 4Length: —
Examples: 1.0, 4.0, 1.0, 3.0, 2.0
Values: —
MISSING_TOTAL_DESCRIPTIONstringYes4,988——
Range: —Length: 32
Examples: Few (~1 to 50 people), Very Many (~1001 or more people), Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people)
Values: Few (~1 to 50 people), Many (~101 to 1000 people), Some (~51 to 100 people), Very Many (~1001 or more people)
HOUSES_DESTROYED_TOTALfloatYes4,376——
Range: 1 to 5360000Length: —
Examples: 37000.0, 15000.0, 5500.0, 2992.0, 3000.0
Values: —
HOUSES_AMOUNT_ORDER_TOTALfloatYes3,562——
Range: 1 to 4Length: —
Examples: 3.0, 2.0, 3.0, 4.0, 3.0
Values: —
HOUSES_TOTAL_DESCRIPTIONstringYes3,562——
Range: —Length: 32
Examples: Many (~101 to 1000 houses), Some (~51 to 100 houses), Many (~101 to 1000 houses), Very Many (~1001 or more 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)
HOUSES_DAMAGED_TOTALfloatYes4,799——
Range: 2 to 21000000Length: —
Examples: 100.0, 20.0, 5000.0, 6036.0, 180.0
Values: —
HOUSES_DAM_AMOUNT_ORDER_TOTALfloatYes4,515——
Range: 1 to 4Length: —
Examples: 3.0, 4.0, 4.0, 1.0, 2.0
Values: —
HOUSES_DAM_TOT_DESCRIPTIONstringYes4,515——
Range: —Length: 32
Examples: Many (~101 to 1000 houses), Very Many (~1001 or more houses), Very Many (~1001 or more houses), Few (~1 to 50 houses), Some (~51 to 100 houses)
Values: Few (~1 to 50 houses), Many (~101 to 1000 houses), Some (~51 to 100 houses), Very Many (~1001 or more houses)
FLAG_TSUNAMIstringYes3,492——
Range: —Length: 1
Examples: 1, 1, 1, 1, 1
Values: 1
FLAG_VOL_EVENTstringYes4,946——
Range: —Length: 1
Examples: 1, 1, 1, 1, 1
Values: 1
COMMENTSstringYes1,487——
Range: —Length: 3999
Examples: <p>Note: this event was <strong>not</strong> from an earthquake but a landslide on Dona Juana volcano.</p><p>This landslide has not been the last in a series of disasters recorded in the seismic history of Colombia. (reference #1118)</p>, Reference #1055 lists earthquake in December 1037, China (Shansi), Taichou [Jiangsu Province], 759 lives lost, Pingchou, now Taiyuan, 1890 lives lost and Hsinchou, 19,742 lives lost, intensity III which corresponds to an earthquake which destroyed towns and devastated districts. (possibly January 24, 1038)., September 15, 1911, 13:10 UTC, 20 S, 72 W, magnitude 7.3 MS. (reference #1206), May 1, 1769. Baghdad. During a damaging thunderstorm a number of shocks were felt in the city. (reference #1117) <P>1769, Baghdad. Strong, 2,000 houses destroyed. Intensity VII. (reference #1222) <P>May 1, 1769, Turkey, Baghdad. Intensity III which corresponds to an earthquake which destroyed towns and devastated districts. Partly hurricane. (reference #1055) <P>May 1, 1769, 2 p.m., Baghdad. Several shocks. Accompanied by a terrible hurricane. 2000 (or according to others, 4000) houses were thrown down. (reference #1879) <P>May 1, 1769, Baghdad, intensity VII. (reference #3437), Reference #1053 lists damage (VIII) and landslides occurred throughout the Papua New Guinea highland. Submarine cables from Madang to Guam were damaged. Preliminary estimate at damage approximately $0.5 million damage. <P> Reference #1250 lists 8 villages affected, damage to dwellings and telecommunications, 1000 homeless.
Values: —
URLstringNo0——
Range: —Length: 76
Examples: https://www.ngdc.noaa.gov/hazel/view/hazards/earthquake/event-more-info/564, https://www.ngdc.noaa.gov/hazel/view/hazards/earthquake/event-more-info/5611, https://www.ngdc.noaa.gov/hazel/view/hazards/earthquake/event-more-info/7441, https://www.ngdc.noaa.gov/hazel/view/hazards/earthquake/event-more-info/6509, https://www.ngdc.noaa.gov/hazel/view/hazards/earthquake/event-more-info/877
Values: —
IDintegerNo0——
Range: 1 to 7897Length: —
Examples: 564, 5611, 7441, 6509, 877
Values: —
DRAWING_ORDERintegerNo0——
Range: 13 to 59Length: —
Examples: 19, 26, 17, 16, 14
Values: —
Invalid geometry count: 0
Columns hash: 4995a439724488be38654c46d7bb871b42854ec595ec280e3401f886fc8edbad