Dataset: Regions Data (OWID, 2023)

About this Dataset

Regions Data (OWID, 2023)

Region definitions and other useful data like alternative region names, historical region successors, and sub-region members.

Tables

Regions

@owid.regions.owid_regions

51.68 KB
334 rows
24 columns


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
);