Earthquake Magnitude, Damage And Impact
Modeling earthquake richter and impacts
@kaggle.arashnic_earthquake_magnitude_damage_and_impact
Modeling earthquake richter and impacts
@kaggle.arashnic_earthquake_magnitude_damage_and_impact
CREATE TABLE n__building_damage_assessment (
"building_id" BIGINT,
"district_id" BIGINT,
"vdcmun_id" BIGINT,
"ward_id" BIGINT,
"damage_overall_collapse" VARCHAR,
"damage_overall_leaning" VARCHAR,
"damage_overall_adjacent_building_risk" VARCHAR,
"damage_foundation_severe" VARCHAR,
"damage_foundation_moderate" VARCHAR,
"damage_foundation_insignificant" VARCHAR,
"damage_roof_severe" VARCHAR,
"damage_roof_moderate" VARCHAR,
"damage_roof_insignificant" VARCHAR,
"damage_corner_separation_severe" VARCHAR,
"damage_corner_separation_moderate" VARCHAR,
"damage_corner_separation_insignificant" VARCHAR,
"damage_diagonal_cracking_severe" VARCHAR,
"damage_diagonal_cracking_moderate" VARCHAR,
"damage_diagonal_cracking_insignificant" VARCHAR,
"damage_in_plane_failure_severe" VARCHAR,
"damage_in_plane_failure_moderate" VARCHAR,
"damage_in_plane_failure_insignificant" VARCHAR,
"damage_out_of_plane_failure_severe" VARCHAR,
"damage_out_of_plane_failure_moderate" VARCHAR,
"damage_out_of_plane_failure_insignificant" VARCHAR,
"damage_out_of_plane_failure_walls_ncfr_severe" VARCHAR,
"damage_out_of_plane_failure_walls_ncfr_moderate" VARCHAR,
"damage_out_of_plane_failure_walls_ncfr_insignificant" VARCHAR,
"damage_gable_failure_severe" VARCHAR,
"damage_gable_failure_moderate" VARCHAR,
"damage_gable_failure_insignificant" VARCHAR,
"damage_delamination_failure_severe" VARCHAR,
"damage_delamination_failure_moderate" VARCHAR,
"damage_delamination_failure_insignificant" VARCHAR,
"damage_column_failure_severe" VARCHAR,
"damage_column_failure_moderate" VARCHAR,
"damage_column_failure_insignificant" VARCHAR,
"damage_beam_failure_severe" VARCHAR,
"damage_beam_failure_moderate" VARCHAR,
"damage_beam_failure_insignificant" VARCHAR,
"damage_infill_partition_failure_severe" VARCHAR,
"damage_infill_partition_failure_moderate" VARCHAR,
"damage_infill_partition_failure_insignificant" VARCHAR,
"damage_staircase_severe" VARCHAR,
"damage_staircase_moderate" VARCHAR,
"damage_staircase_insignificant" VARCHAR,
"damage_parapet_severe" VARCHAR,
"damage_parapet_moderate" VARCHAR,
"damage_parapet_insignificant" VARCHAR,
"damage_cladding_glazing_severe" VARCHAR,
"damage_cladding_glazing_moderate" VARCHAR,
"damage_cladding_glazing_insignificant" VARCHAR,
"area_assesed" VARCHAR,
"damage_grade" VARCHAR,
"technical_solution_proposed" VARCHAR,
"has_repair_started" DOUBLE,
"has_damage_foundation" DOUBLE,
"has_damage_roof" DOUBLE,
"has_damage_corner_separation" DOUBLE,
"has_damage_diagonal_cracking" DOUBLE,
"has_damage_in_plane_failure" DOUBLE,
"has_damage_out_of_plane_failure" DOUBLE,
"has_damage_out_of_plane_walls_ncfr_failure" DOUBLE,
"has_damage_gable_failure" DOUBLE,
"has_damage_delamination_failure" DOUBLE,
"has_damage_column_failure" DOUBLE,
"has_damage_beam_failure" DOUBLE,
"has_damage_infill_partition_failure" DOUBLE,
"has_damage_staircase" DOUBLE,
"has_damage_parapet" DOUBLE,
"has_damage_cladding_glazing" DOUBLE,
"has_geotechnical_risk" DOUBLE,
"has_geotechnical_risk_land_settlement" BIGINT,
"has_geotechnical_risk_fault_crack" BIGINT,
"has_geotechnical_risk_liquefaction" BIGINT,
"has_geotechnical_risk_landslide" BIGINT,
"has_geotechnical_risk_rock_fall" BIGINT,
"has_geotechnical_risk_flood" BIGINT,
"has_geotechnical_risk_other" BIGINT
);
CREATE TABLE n__building_ownership_and_use (
"building_id" BIGINT,
"district_id" BIGINT,
"vdcmun_id" BIGINT,
"ward_id" BIGINT,
"legal_ownership_status" VARCHAR,
"count_families" DOUBLE,
"has_secondary_use" DOUBLE,
"has_secondary_use_agriculture" BIGINT,
"has_secondary_use_hotel" BIGINT,
"has_secondary_use_rental" BIGINT,
"has_secondary_use_institution" BIGINT,
"has_secondary_use_school" BIGINT,
"has_secondary_use_industry" BIGINT,
"has_secondary_use_health_post" BIGINT,
"has_secondary_use_gov_office" BIGINT,
"has_secondary_use_use_police" BIGINT,
"has_secondary_use_other" BIGINT
);
CREATE TABLE n__building_structure (
"building_id" BIGINT,
"district_id" BIGINT,
"vdcmun_id" BIGINT,
"ward_id" BIGINT,
"count_floors_pre_eq" BIGINT,
"count_floors_post_eq" BIGINT,
"age_building" BIGINT,
"plinth_area_sq_ft" BIGINT,
"height_ft_pre_eq" BIGINT,
"height_ft_post_eq" BIGINT,
"land_surface_condition" VARCHAR,
"foundation_type" VARCHAR,
"roof_type" VARCHAR,
"ground_floor_type" VARCHAR,
"other_floor_type" VARCHAR,
"position" VARCHAR,
"plan_configuration" VARCHAR,
"has_superstructure_adobe_mud" BIGINT,
"has_superstructure_mud_mortar_stone" BIGINT,
"has_superstructure_stone_flag" BIGINT,
"has_superstructure_cement_mortar_stone" BIGINT,
"has_superstructure_mud_mortar_brick" BIGINT,
"has_superstructure_cement_mortar_brick" BIGINT,
"has_superstructure_timber" BIGINT,
"has_superstructure_bamboo" BIGINT,
"has_superstructure_rc_non_engineered" BIGINT,
"has_superstructure_rc_engineered" BIGINT,
"has_superstructure_other" BIGINT,
"condition_post_eq" VARCHAR,
"damage_grade" VARCHAR,
"technical_solution_proposed" VARCHAR
);
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
);
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
);
CREATE TABLE n__household_resources (
"household_id" BIGINT,
"district_id" BIGINT,
"vdcmun_id" BIGINT,
"ward_id" BIGINT,
"source_water_pre_eq" VARCHAR,
"source_water_post_eq" VARCHAR,
"source_cooking_fuel_pre_eq" VARCHAR,
"source_cooking_fuel_post_eq" VARCHAR,
"source_light_pre_eq" VARCHAR,
"source_light_post_eq" VARCHAR,
"type_toilet_pre_eq" VARCHAR,
"type_toilet_post_eq" VARCHAR,
"has_asset_land_pre_eq" BIGINT,
"has_asset_tv_pre_eq" BIGINT,
"has_asset_cable_pre_eq" BIGINT,
"has_asset_computer_pre_eq" BIGINT,
"has_asset_internet_pre_eq" BIGINT,
"has_asset_telephone_pre_eq" BIGINT,
"has_asset_mobile_phone_pre_eq" BIGINT,
"has_asset_fridge_pre_eq" BIGINT,
"has_asset_motorcycle_pre_eq" BIGINT,
"has_asset_four_wheeler_family_use_pre_eq" BIGINT,
"has_asset_four_wheeler_commercial_use_pre_eq" BIGINT,
"has_asset_none_pre_eq" BIGINT,
"has_asset_land_post_eq" BIGINT,
"has_asset_tv_post_eq" BIGINT,
"has_asset_cable_post_eq" BIGINT,
"has_asset_computer_post_eq" BIGINT,
"has_asset_internet_post_eq" BIGINT,
"has_asset_telephone_post_eq" BIGINT,
"has_asset_mobile_phone_post_eq" BIGINT,
"has_asset_fridge_post_eq" BIGINT,
"has_asset_motorcycle_post_eq" BIGINT,
"has_asset_four_wheeler_family_use_post_eq" BIGINT,
"has_asset_four_wheeler_commercial_post_eq" BIGINT,
"has_asset_none_post_eq" BIGINT
);
CREATE TABLE n__individual_demographics (
"individual_id" BIGINT,
"district_id" BIGINT,
"vdcmun_id" BIGINT,
"ward_id" BIGINT,
"gender_individual" VARCHAR,
"age_individual" BIGINT,
"presence_in_household" VARCHAR,
"disability_individual" VARCHAR,
"has_registered_birth" DOUBLE,
"education_level_individual" VARCHAR,
"marital_status_individual" VARCHAR
);
CREATE TABLE mapping (
"individual_id" BIGINT,
"household_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE ward_vdcmun_district_name_mapping (
"ward_id" BIGINT,
"vdcmun_id" BIGINT,
"vdcmun_name" VARCHAR,
"district_id" BIGINT,
"district_name" VARCHAR
);
Anyone who has the link will be able to view this.