Biodiversity Habitat Loss (Williams Et Al. 2021)

CREATE TABLE owid_habitat_loss (
  "country" VARCHAR,
  "year" INTEGER,
  "all_species_number" INTEGER,
  "amphibian_species_number" INTEGER,
  "bau_change_cropland_km2" FLOAT,
  "bau_change_pct" FLOAT,
  "bau_habitat_loss_all" FLOAT,
  "bau_habitat_loss_amphibians" FLOAT,
  "bau_habitat_loss_birds" FLOAT,
  "bau_habitat_loss_mammals" FLOAT,
  "bird_species_number" INTEGER,
  "combined_change_cropland_km2" FLOAT,
  "combined_change_pct" FLOAT,
  "combined_habitat_loss_all" FLOAT,
  "combined_habitat_loss_amphibians" FLOAT,
  "combined_habitat_loss_birds" FLOAT,
  "combined_habitat_loss_mammals" FLOAT,
  "countries_losing_25_species" INTEGER,
  "diets_change_cropland_km2" FLOAT,
  "diets_change_pct" FLOAT,
  "diets_habitat_loss_all" FLOAT,
  "diets_habitat_loss_amphibians" FLOAT,
  "diets_habitat_loss_birds" FLOAT,
  "diets_habitat_loss_mammals" FLOAT,
  "mammal_species_number" INTEGER,
  "species_losing_more_25pct" INTEGER,
  "species_losing_more_25pct_combined" INTEGER,
  "species_losing_more_25pct_yields" INTEGER,
  "species_losing_more_50pct" INTEGER,
  "species_losing_more_50pct_combined" INTEGER,
  "species_losing_more_50pct_yields" INTEGER,
  "species_losing_more_75pct" INTEGER,
  "species_losing_more_75pct_combined" INTEGER,
  "species_losing_more_75pct_yields" INTEGER,
  "species_losing_more_90pct" INTEGER,
  "species_losing_more_90pct_combined" INTEGER,
  "species_losing_more_90pct_yields" INTEGER,
  "trade_change_cropland_km2" FLOAT,
  "trade_change_pct" FLOAT,
  "trade_habitat_loss_all" FLOAT,
  "trade_habitat_loss_amphibians" FLOAT,
  "trade_habitat_loss_birds" FLOAT,
  "trade_habitat_loss_mammals" FLOAT,
  "waste_change_cropland_km2" FLOAT,
  "waste_change_pct" FLOAT,
  "waste_habitat_loss_all" FLOAT,
  "waste_habitat_loss_amphibians" FLOAT,
  "waste_habitat_loss_birds" FLOAT,
  "waste_habitat_loss_mammals" FLOAT,
  "yields_change_cropland_km2" FLOAT,
  "yields_change_pct" FLOAT,
  "yields_habitat_loss_all" FLOAT,
  "yields_habitat_loss_amphibians" FLOAT,
  "yields_habitat_loss_birds" FLOAT,
  "yields_habitat_loss_mammals" FLOAT
);