Number Of Species In Each IUCN Red List Category By Kingdom And Class.
@owid.iucn_number_each_status
@owid.iucn_number_each_status
CREATE TABLE owid_iucn_number_each_status_1 (
"country" VARCHAR,
"year" INTEGER,
"ex" INTEGER,
"ew" INTEGER,
"subtotal_explusew" INTEGER -- Subtotal, Explusew,
"cr_pe" INTEGER -- Cr, Pe,
"cr_pew" INTEGER -- Cr, Pew,
"subtotal_explusewplus_cr_pe_pluscr_pew" INTEGER -- Subtotal, Explusewplus Cr, Pe, Pluscr, Pew,
"cr" INTEGER,
"en" INTEGER,
"vu" INTEGER,
"subtotal_threatened_spp" INTEGER -- Subtotal, Threatened Spp,
"lr_cd" INTEGER,
"nt_or_lr_nt" INTEGER,
"lc_or_lr_lc" UINTEGER,
"dd" INTEGER,
"total" UINTEGER
);CREATE TABLE owid_iucn_number_each_status_2 (
"country" VARCHAR,
"year" INTEGER,
"ex" INTEGER,
"ew" INTEGER,
"subtotal_explusew" INTEGER -- Subtotal, Explusew,
"cr_pe" INTEGER -- Cr, Pe,
"cr_pew" INTEGER -- Cr, Pew,
"subtotal_explusewplus_cr_pe_pluscr_pew" INTEGER -- Subtotal, Explusewplus Cr, Pe, Pluscr, Pew,
"cr" INTEGER,
"en" INTEGER,
"vu" INTEGER,
"subtotal_threatened_spp" INTEGER -- Subtotal, Threatened Spp,
"lr_cd" INTEGER,
"nt_or_lr_nt" INTEGER,
"lc_or_lr_lc" UINTEGER,
"dd" INTEGER,
"total" UINTEGER
);Anyone who has the link will be able to view this.