Ukraine/Russia Conflict Dataset
Use your data science skills to understand real world events!
@kaggle.kylegraupe_ukrainerussia_conflict_dataset
Use your data science skills to understand real world events!
@kaggle.kylegraupe_ukrainerussia_conflict_dataset
CREATE TABLE conflict_data_ukr (
"id" DOUBLE,
"relid" VARCHAR,
"year" VARCHAR,
"active_year" DOUBLE,
"code_status" VARCHAR,
"type_of_violence" DOUBLE,
"conflict_dset_id" DOUBLE,
"conflict_new_id" DOUBLE,
"conflict_name" VARCHAR,
"dyad_dset_id" DOUBLE,
"dyad_new_id" DOUBLE,
"dyad_name" VARCHAR,
"side_a_dset_id" DOUBLE,
"side_a_new_id" DOUBLE,
"side_a" VARCHAR,
"side_b_dset_id" DOUBLE,
"side_b_new_id" DOUBLE,
"side_b" VARCHAR,
"number_of_sources" DOUBLE,
"source_article" VARCHAR,
"source_office" VARCHAR,
"source_date" VARCHAR,
"source_headline" VARCHAR,
"source_original" VARCHAR,
"where_prec" DOUBLE,
"where_coordinates" VARCHAR,
"where_description" VARCHAR,
"adm_1" VARCHAR,
"adm_2" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"geom_wkt" VARCHAR,
"priogrid_gid" DOUBLE,
"country" VARCHAR,
"iso3" VARCHAR,
"country_id" DOUBLE,
"region" VARCHAR,
"event_clarity" DOUBLE,
"date_prec" DOUBLE,
"date_start" VARCHAR,
"date_end" VARCHAR,
"deaths_a" DOUBLE,
"deaths_b" DOUBLE,
"deaths_civilians" DOUBLE,
"deaths_unknown" DOUBLE,
"best" VARCHAR,
"high" DOUBLE,
"low" DOUBLE,
"gwnoa" DOUBLE,
"gwnob" VARCHAR
);
CREATE TABLE ukraineconflict (
"event_id_cnty" VARCHAR,
"event_date" VARCHAR,
"year" BIGINT,
"time_precision" BIGINT,
"disorder_type" VARCHAR,
"event_type" VARCHAR,
"sub_event_type" VARCHAR,
"actor1" VARCHAR,
"assoc_actor_1" VARCHAR,
"inter1" BIGINT,
"actor2" VARCHAR,
"assoc_actor_2" VARCHAR,
"inter2" BIGINT,
"interaction" BIGINT,
"civilian_targeting" VARCHAR,
"iso" BIGINT,
"region" VARCHAR,
"country" VARCHAR,
"admin1" VARCHAR,
"admin2" VARCHAR,
"admin3" VARCHAR,
"location" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"geo_precision" BIGINT,
"source" VARCHAR,
"source_scale" VARCHAR,
"notes" VARCHAR,
"fatalities" BIGINT,
"tags" VARCHAR,
"timestamp" BIGINT
);
Anyone who has the link will be able to view this.