Earthquake Magnitude, Damage And Impact

Modeling earthquake richter and impacts

@kaggle.arashnic_earthquake_magnitude_damage_and_impact

Table List

9 tables(97.68 MB)

N, Building Damage Assessment

N, Building Ownership And Use

N, Building Structure

N, Household Demographics

N, Household Earthquake Impact

N, Household Resources

N, Individual Demographics

Mapping

Ward Vdcmun District Name Mapping

N, Household Demographics

@kaggle.arashnic_earthquake_magnitude_damage_and_impact.n__household_demographics

6.39 MB
747365 rows
11 columns

household_id Household Id	district_id District Id	vdcmun_id Vdcmun Id	ward_id Ward Id	gender_household_head Gender Household Head	age_household_head Age Household Head	caste_household Caste Household	education_level_household_head Education Level Household Head	income_level_household Income Level Household	size_household Size Household
12010100001101	12	1207	120703	Male	31	Rai	Illiterate	Rs. 10 thousand	3
12010100002101	12	1207	120703	Female	62	Rai	Illiterate	Rs. 10 thousand	6
12010100003101	12	1207	120703	Male	51	Gharti/Bhujel	Illiterate	Rs. 10 thousand	13
12010100004101	12	1207	120703	Male	48	Gharti/Bhujel	Illiterate	Rs. 10 thousand	5
12010100005101	12	1207	120703	Male	70	Gharti/Bhujel	Illiterate	Rs. 10 thousand	8
12010100006101	12	1207	120703	Male	52	Gharti/Bhujel	Illiterate	Rs. 10 thousand	6
12010100007101	12	1207	120703	Male	27	Gharti/Bhujel	Class 5	Rs. 10-20 thousand	5
12010100008101	12	1207	120703	Male	31	Gharti/Bhujel	Class 4	Rs. 10 thousand	5
12010100009101	12	1207	120703	Male	44	Gharti/Bhujel	Illiterate	Rs. 10 thousand	9
12010100010101	12	1207	120703	Male	34	Gharti/Bhujel	Illiterate	Rs. 10 thousand	6


CREATE TABLE n__household_demographics (
  "household_id" BIGINT,
  "district_id" BIGINT,
  "vdcmun_id" BIGINT,
  "ward_id" BIGINT,
  "gender_household_head" VARCHAR,
  "age_household_head" DOUBLE,
  "caste_household" VARCHAR,
  "education_level_household_head" VARCHAR,
  "income_level_household" VARCHAR,
  "size_household" DOUBLE,
  "is_bank_account_present_in_household" DOUBLE
);