Baselight

Resilient To Disasters

but investment is needed to save more lives progress doesn’t reverse

@kaggle.willianoliveiragibin_resilient_to_disasters

Natural Disasters New
@kaggle.willianoliveiragibin_resilient_to_disasters.natural_disasters_new

  • 22.42 KB
  • 3068 rows
  • 10 columns
country_name

Country Name

year

Year

number_of_deaths_from_drought

Number Of Deaths From Drought

number_of_people_injured_from_drought

Number Of People Injured From Drought

number_of_people_affected_from_drought

Number Of People Affected From Drought

number_of_people_left_homeless_from_drought

Number Of People Left Homeless From Drought

number_of_total_people_affected_by_drought

Number Of Total People Affected By Drought

reconstruction_costs_from_drought

Reconstruction Costs From Drought

insured_damages_against_drought

Insured Damages Against Drought

total_economic_damages_from_drought

Total Economic Damages From Drought

Afghanistan1900
Africa19001100
Albania1900
Algeria1900
American Samoa1900
Angola1900
Anguilla1900
Antigua and Barbuda1900
Argentina1900
Armenia1900

CREATE TABLE natural_disasters_new (
  "country_name" VARCHAR,
  "year" BIGINT,
  "number_of_deaths_from_drought" DOUBLE,
  "number_of_people_injured_from_drought" DOUBLE,
  "number_of_people_affected_from_drought" DOUBLE,
  "number_of_people_left_homeless_from_drought" DOUBLE,
  "number_of_total_people_affected_by_drought" DOUBLE,
  "reconstruction_costs_from_drought" BIGINT,
  "insured_damages_against_drought" BIGINT,
  "total_economic_damages_from_drought" DOUBLE
);

Share link

Anyone who has the link will be able to view this.