Regions Data (OWID, 2023)
@owid.regions
@owid.regions
CREATE TABLE owid_regions (
"code" VARCHAR,
"name" VARCHAR,
"region_type" VARCHAR,
"members" VARCHAR,
"aliases" VARCHAR,
"related" VARCHAR,
"is_historical" BOOLEAN,
"end_year" INTEGER,
"successors" VARCHAR,
"short_name" VARCHAR,
"defined_by" VARCHAR,
"cow_code" INTEGER,
"cow_letter" VARCHAR,
"imf_code" INTEGER,
"iso_alpha2" VARCHAR,
"iso_alpha3" VARCHAR,
"kansas_code" VARCHAR,
"legacy_country_id" INTEGER,
"legacy_entity_id" UINTEGER,
"marc_code" VARCHAR,
"ncd_code" VARCHAR,
"penn_code" VARCHAR,
"unctad_code" VARCHAR,
"wikidata_code" VARCHAR
);
Anyone who has the link will be able to view this.