CREATE TABLE n_1970_2021_disasters_xlsx_emdat_data (
"dis_no" VARCHAR,
"year" BIGINT,
"seq" BIGINT,
"glide" VARCHAR,
"disaster_group" VARCHAR,
"disaster_subgroup" VARCHAR,
"disaster_type" VARCHAR,
"disaster_subtype" VARCHAR,
"disaster_subsubtype" VARCHAR,
"event_name" VARCHAR,
"country" VARCHAR,
"iso" VARCHAR,
"region" VARCHAR,
"continent" VARCHAR,
"location" VARCHAR,
"origin" VARCHAR,
"associated_dis" VARCHAR,
"associated_dis2" VARCHAR,
"ofda_response" VARCHAR,
"appeal" VARCHAR,
"declaration" VARCHAR,
"aid_contribution" DOUBLE,
"dis_mag_value" DOUBLE,
"dis_mag_scale" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"local_time" VARCHAR,
"river_basin" VARCHAR,
"start_year" BIGINT,
"start_month" DOUBLE,
"start_day" DOUBLE,
"end_year" BIGINT,
"end_month" DOUBLE,
"end_day" DOUBLE,
"total_deaths" DOUBLE,
"no_injured" DOUBLE,
"no_affected" DOUBLE,
"no_homeless" DOUBLE,
"total_affected" DOUBLE,
"reconstruction_costs_000_us" DOUBLE,
"insured_damages_000_us" DOUBLE,
"total_damages_000_us" DOUBLE,
"cpi" DOUBLE,
"adm_level" VARCHAR,
"admin1_code" VARCHAR,
"admin2_code" VARCHAR,
"geo_locations" VARCHAR
);