History Of War (UCDP, 2023)
@owid.ucdp
@owid.ucdp
CREATE TABLE owid_ucdp_1 (
"year" INTEGER,
"region" VARCHAR,
"conflict_type" VARCHAR,
"number_deaths_ongoing_conflicts" UINTEGER,
"number_deaths_ongoing_conflicts_high" UINTEGER,
"number_deaths_ongoing_conflicts_low" UINTEGER,
"number_ongoing_conflicts" INTEGER,
"number_new_conflicts" INTEGER,
"number_ongoing_conflicts_per_country" FLOAT,
"number_ongoing_conflicts_per_country_pair" FLOAT,
"number_new_conflicts_per_country" FLOAT,
"number_new_conflicts_per_country_pair" FLOAT,
"number_deaths_ongoing_conflicts_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_high_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_low_per_capita" FLOAT
);
CREATE TABLE owid_ucdp_2 (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"number_deaths_ongoing_conflicts" UINTEGER,
"number_deaths_ongoing_conflicts_high" UINTEGER,
"number_deaths_ongoing_conflicts_low" UINTEGER,
"number_deaths_ongoing_conflicts_civilians" UINTEGER,
"number_deaths_ongoing_conflicts_unknown" INTEGER,
"number_deaths_ongoing_conflicts_combatants" UINTEGER,
"number_ongoing_conflicts" INTEGER,
"number_new_conflicts" INTEGER,
"number_ongoing_conflicts_per_country" FLOAT,
"number_ongoing_conflicts_per_country_pair" FLOAT,
"number_new_conflicts_per_country" FLOAT,
"number_new_conflicts_per_country_pair" FLOAT,
"number_deaths_ongoing_conflicts_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_high_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_low_per_capita" FLOAT
);
CREATE TABLE owid_ucdp_country_1 (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"participated_in_conflict" INTEGER,
"number_participants" INTEGER
);
CREATE TABLE owid_ucdp_country_2 (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"participated_in_conflict" INTEGER,
"number_participants" INTEGER
);
CREATE TABLE owid_ucdp_locations_1 (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"is_location_of_conflict" INTEGER,
"number_deaths" UINTEGER,
"number_deaths_low" UINTEGER,
"number_deaths_high" UINTEGER,
"death_rate" FLOAT,
"death_rate_low" FLOAT,
"death_rate_high" FLOAT,
"number_locations" INTEGER
);
CREATE TABLE owid_ucdp_locations_2 (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"is_location_of_conflict" INTEGER,
"number_locations" INTEGER
);
Anyone who has the link will be able to view this.