IUCN Red List Summary Statistics - Total, Threatened And Extinct Vertebrate Species In Each Country

CREATE TABLE owid_endemic_vertebrates (
  "country" VARCHAR,
  "year" INTEGER,
  "mammals_total_endemics" INTEGER,
  "mammals_threatened_endemics" INTEGER,
  "mammals_ex_and_ew_endemics" INTEGER,
  "birds_total_endemics" INTEGER,
  "birds_threatened_endemics" INTEGER,
  "birds_ex_and_ew_endemics" INTEGER,
  "reptiles_total_endemics" INTEGER,
  "reptiles_threatened_endemics" INTEGER,
  "reptiles_ex_and_ew_endemics" INTEGER,
  "amphibians_total_endemics" INTEGER,
  "amphibians_threatened_endemics" INTEGER,
  "amphibians_ex_and_ew_endemics" INTEGER,
  "fw_fishes_total_endemics" INTEGER,
  "fw_fishes_threatened_endemics" INTEGER,
  "fw_fishes_ex_and_ew_endemics" INTEGER,
  "groupers_total_endemics" INTEGER,
  "groupers_threatened_endemics" INTEGER,
  "groupers_ex_and_ew_endemics" INTEGER,
  "herrings_anchovies_etc_total_endemics" INTEGER,
  "herrings_anchovies_etc_threatened_endemics" INTEGER,
  "herrings_anchovies_etc_ex_and_ew_endemics" INTEGER,
  "seahorses_and_pipefishes_total_endemics" INTEGER,
  "seahorses_and_pipefishes_threatened_endemics" INTEGER,
  "seahorses_and_pipefishes_ex_and_ew_endemics" INTEGER,
  "sturgeons_total_endemics" INTEGER,
  "sturgeons_threatened_endemics" INTEGER,
  "sturgeons_ex_and_ew_endemics" INTEGER,
  "wrasses_and_parrotfishes_total_endemics" INTEGER,
  "wrasses_and_parrotfishes_threatened_endemics" INTEGER,
  "wrasses_and_parrotfishes_ex_and_ew_endemics" INTEGER,
  "sharks_and_rays_total_endemics" INTEGER,
  "sharks_and_rays_threatened_endemics" INTEGER,
  "sharks_and_rays_ex_and_ew_endemics" INTEGER
);