States In Regions (ISD)
@owid.isd
@owid.isd
CREATE TABLE owid_isd (
"cownum" INTEGER,
"start" VARCHAR,
"end" VARCHAR,
"cowid" VARCHAR,
"statename" VARCHAR,
"othername" VARCHAR,
"isd_category" INTEGER,
"region" INTEGER,
"start_am" INTEGER,
"estart" INTEGER,
"estart_am" INTEGER,
"declare" INTEGER,
"decdate" VARCHAR,
"population" UINTEGER,
"popdate" INTEGER,
"popam" INTEGER,
"populationhigh" UINTEGER,
"populationlow" UINTEGER,
"starttype" INTEGER,
"starttype_am" INTEGER,
"startsettle" INTEGER,
"end_am" INTEGER,
"endtype" INTEGER,
"endtype_am" INTEGER,
"endsettle" INTEGER,
"sovereignty_am" INTEGER,
"eurodip" INTEGER,
"borders" INTEGER,
"borders_am" INTEGER,
"latitude" VARCHAR,
"longitude" VARCHAR,
"viostart" INTEGER,
"viostart_am" INTEGER,
"vioend" INTEGER,
"vioend_am" INTEGER
);
CREATE TABLE owid_isd_countries (
"id" INTEGER,
"year" INTEGER,
"country" VARCHAR
);
CREATE TABLE owid_isd_regions (
"region" VARCHAR,
"year" INTEGER,
"number_countries" INTEGER,
"population" BIGINT
);
Anyone who has the link will be able to view this.