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

CREATE TABLE owid_endemic_invertebrates (
  "country" VARCHAR,
  "year" INTEGER,
  "fw_crabs_total_endemics" INTEGER  -- Fw Crabs, Total Endemics,
  "fw_crabs_threatened_endemics" INTEGER  -- Fw Crabs, Threatened Endemics,
  "fw_crabs_ex_and_ew_endemics" INTEGER  -- Fw Crabs, Ex, And, Ew Endemics,
  "fw_crayfish_total_endemics" INTEGER  -- Fw Crayfish, Total Endemics,
  "fw_crayfish_threatened_endemics" INTEGER  -- Fw Crayfish, Threatened Endemics,
  "fw_crayfish_ex_and_ew_endemics" INTEGER  -- Fw Crayfish, Ex, And, Ew Endemics,
  "lobsters_total_endemics" INTEGER  -- Lobsters, Total Endemics,
  "lobsters_threatened_endemics" INTEGER  -- Lobsters, Threatened Endemics,
  "lobsters_ex_and_ew_endemics" INTEGER  -- Lobsters, Ex, And, Ew Endemics,
  "dragonflies_and_damselflies_total_endemics" VARCHAR  -- Dragonflies, And, Damselflies, Total Endemics,
  "dragonflies_and_damselflies_threatened_endemics" VARCHAR  -- Dragonflies, And, Damselflies, Threatened Endemics,
  "dragonflies_and_damselflies_ex_and_ew_endemics" INTEGER  -- Dragonflies, And, Damselflies, Ex, And, Ew Endemics,
  "abalones_total_endemics" VARCHAR  -- Abalones, Total Endemics,
  "abalones_threatened_endemics" VARCHAR  -- Abalones, Threatened Endemics,
  "abalones_ex_and_ew_endemics" INTEGER  -- Abalones, Ex, And, Ew Endemics,
  "reef_forming_corals_total_endemics" INTEGER  -- Reef Forming Corals, Total Endemics,
  "reef_forming_corals_threatened_endemics" INTEGER  -- Reef Forming Corals, Threatened Endemics,
  "reef_forming_corals_ex_and_ew_endemics" INTEGER  -- Reef Forming Corals, Ex, And, Ew Endemics
);