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, Total Endemics,
  "mammals_threatened_endemics" INTEGER  -- Mammals, Threatened Endemics,
  "mammals_ex_and_ew_endemics" INTEGER  -- Mammals, Ex, And, Ew Endemics,
  "birds_total_endemics" INTEGER  -- Birds, Total Endemics,
  "birds_threatened_endemics" INTEGER  -- Birds, Threatened Endemics,
  "birds_ex_and_ew_endemics" INTEGER  -- Birds, Ex, And, Ew Endemics,
  "reptiles_total_endemics" INTEGER  -- Reptiles, Total Endemics,
  "reptiles_threatened_endemics" INTEGER  -- Reptiles, Threatened Endemics,
  "reptiles_ex_and_ew_endemics" INTEGER  -- Reptiles, Ex, And, Ew Endemics,
  "amphibians_total_endemics" INTEGER  -- Amphibians, Total Endemics,
  "amphibians_threatened_endemics" INTEGER  -- Amphibians, Threatened Endemics,
  "amphibians_ex_and_ew_endemics" INTEGER  -- Amphibians, Ex, And, Ew Endemics,
  "fw_fishes_total_endemics" INTEGER  -- Fw Fishes, Total Endemics,
  "fw_fishes_threatened_endemics" INTEGER  -- Fw Fishes, Threatened Endemics,
  "fw_fishes_ex_and_ew_endemics" INTEGER  -- Fw Fishes, Ex, And, Ew Endemics,
  "groupers_total_endemics" INTEGER  -- Groupers, Total Endemics,
  "groupers_threatened_endemics" INTEGER  -- Groupers, Threatened Endemics,
  "groupers_ex_and_ew_endemics" INTEGER  -- Groupers, Ex, And, Ew Endemics,
  "herrings_anchovies_etc_total_endemics" INTEGER  -- Herrings, Anchovies, Etc, Total Endemics,
  "herrings_anchovies_etc_threatened_endemics" INTEGER  -- Herrings, Anchovies, Etc, Threatened Endemics,
  "herrings_anchovies_etc_ex_and_ew_endemics" INTEGER  -- Herrings, Anchovies, Etc, Ex, And, Ew Endemics,
  "seahorses_and_pipefishes_total_endemics" INTEGER  -- Seahorses, And, Pipefishes, Total Endemics,
  "seahorses_and_pipefishes_threatened_endemics" INTEGER  -- Seahorses, And, Pipefishes, Threatened Endemics,
  "seahorses_and_pipefishes_ex_and_ew_endemics" INTEGER  -- Seahorses, And, Pipefishes, Ex, And, Ew Endemics,
  "sturgeons_total_endemics" INTEGER  -- Sturgeons, Total Endemics,
  "sturgeons_threatened_endemics" INTEGER  -- Sturgeons, Threatened Endemics,
  "sturgeons_ex_and_ew_endemics" INTEGER  -- Sturgeons, Ex, And, Ew Endemics,
  "wrasses_and_parrotfishes_total_endemics" INTEGER  -- Wrasses, And, Parrotfishes, Total Endemics,
  "wrasses_and_parrotfishes_threatened_endemics" INTEGER  -- Wrasses, And, Parrotfishes, Threatened Endemics,
  "wrasses_and_parrotfishes_ex_and_ew_endemics" INTEGER  -- Wrasses, And, Parrotfishes, Ex, And, Ew Endemics,
  "sharks_and_rays_total_endemics" INTEGER  -- Sharks, And, Rays, Total Endemics,
  "sharks_and_rays_threatened_endemics" INTEGER  -- Sharks, And, Rays, Threatened Endemics,
  "sharks_and_rays_ex_and_ew_endemics" INTEGER  -- Sharks, And, Rays, Ex, And, Ew Endemics
);