States In Regions (Gleditsch)
@owid.gleditsch
@owid.gleditsch
CREATE TABLE owid_gleditsch_1 (
"id" INTEGER,
"start" VARCHAR,
"end" VARCHAR,
"iso" VARCHAR,
"country" VARCHAR
);
CREATE TABLE owid_gleditsch_2 (
"id" INTEGER,
"start" VARCHAR,
"end" VARCHAR,
"iso" VARCHAR,
"country" VARCHAR
);
CREATE TABLE owid_gleditsch_countries_1 (
"id" INTEGER,
"year" INTEGER,
"country" VARCHAR
);
CREATE TABLE owid_gleditsch_countries_2 (
"id" INTEGER,
"year" INTEGER,
"country" VARCHAR
);
CREATE TABLE owid_gleditsch_regions_1 (
"region" VARCHAR,
"year" INTEGER,
"number_countries" INTEGER,
"population" BIGINT
);
CREATE TABLE owid_gleditsch_regions_2 (
"region" VARCHAR,
"year" INTEGER,
"number_countries" INTEGER,
"population" BIGINT
);
Anyone who has the link will be able to view this.