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 Earthquake Impact

@kaggle.arashnic_earthquake_magnitude_damage_and_impact.n__household_earthquake_impact

5.8 MB
747365 rows
28 columns

household_id Household Id	district_id District Id	vdcmun_id Vdcmun Id	ward_id Ward Id	shelter_condition_household_post_eq Shelter Condition Household Post Eq	residence_household_pre_eq Residence Household Pre Eq	residence_household_post_eq Residence Household Post Eq	household_eq_id_type Household Eq Id Type	has_education_drop_occurred_last_12_months Has Education Drop Occurred Last 12 Months	count_education_drop_last_12_months Count Education Drop Last 12 Months	residence_district_household_head_pre_eq Residence District Household Head Pre Eq	residence_district_household_head_post_eq Residence District Household Head Post Eq	is_recipient_rahat_15k Is Recipient Rahat 15k	is_recipient_rahat_10k Is Recipient Rahat 10k	is_recipient_rahat_none Is Recipient Rahat None
12010100001101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	ID Card for Total Destruction	1	1	nan	nan	1	1
12010100002101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	Have not received ID Card			nan	nan			1
12010100003101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	Have not received ID Card			nan	nan			1
12010100004101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	Have not received ID Card			nan	nan			1
12010100005101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	Have not received ID Card			nan	nan			1
12010100006101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	ID Card for Total Destruction			nan	nan	1	1
12010100007101	12	1207	120703	Temporary shelter	This VDC/Municipality	This VDC/Municipality	Have not received ID Card	1	1	nan	nan			1
12010100008101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	ID Card for Total Destruction			nan	nan	1	1
12010100009101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	ID Card for Total Destruction	1	5	nan	nan	1	1
12010100010101	12	1207	120703	Staying in their own house	This VDC/Municipality	This VDC/Municipality	ID Card for Total Destruction	1	3	nan	nan	1	1


CREATE TABLE n__household_earthquake_impact (
  "household_id" BIGINT,
  "district_id" BIGINT,
  "vdcmun_id" BIGINT,
  "ward_id" BIGINT,
  "shelter_condition_household_post_eq" VARCHAR,
  "residence_household_pre_eq" VARCHAR,
  "residence_household_post_eq" VARCHAR,
  "household_eq_id_type" VARCHAR,
  "has_death_occurred_last_12_months" DOUBLE,
  "count_death_last_12_months" DOUBLE,
  "has_injury_loss_occurred_last_12_months" DOUBLE,
  "count_injury_loss_last_12_months" DOUBLE,
  "has_education_drop_occurred_last_12_months" DOUBLE,
  "count_education_drop_last_12_months" DOUBLE,
  "has_pregnancy_treatment_drop_occurred_last_12_months" DOUBLE,
  "count_pregnancy_treatment_drop_last_12_months" DOUBLE,
  "has_vaccination_drop_occurred_last_12_months" DOUBLE,
  "count_vaccination_drop_last_12_months" DOUBLE,
  "has_occupation_change_occurred_last_12_months" DOUBLE,
  "count_occupation_change_last_12_months" DOUBLE,
  "residence_district_household_head_pre_eq" VARCHAR,
  "residence_district_household_head_post_eq" VARCHAR,
  "is_recipient_rahat_15k" BIGINT,
  "is_recipient_rahat_10k" BIGINT,
  "is_recipient_rahat_200k" BIGINT,
  "is_recipient_rahat_social_security_3k" BIGINT,
  "is_recipient_rahat_none" BIGINT,
  "is_ineligible_rahat" BIGINT
);