Conflicts In Central Africa
Conflict events in Central Africa
@kaggle.thedevastator_conflict_events_in_the_central_african_republic
Conflict events in Central Africa
@kaggle.thedevastator_conflict_events_in_the_central_african_republic
CREATE TABLE conflict_data_for_central_african_republic_1 (
"index" BIGINT,
"id" DOUBLE,
"year" VARCHAR,
"active_year" DOUBLE,
"start_year" VARCHAR,
"end_year" VARCHAR,
"type_of_violence" DOUBLE,
"conflict_new_id" DOUBLE,
"conflict_name" VARCHAR,
"dyad_new_id" DOUBLE,
"dyad_name" VARCHAR,
"side_a_new_id" DOUBLE,
"gwnoa" DOUBLE,
"side_a" VARCHAR,
"side_b_new_id" DOUBLE,
"gwnob" VARCHAR,
"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,
"adm_1" VARCHAR,
"adm_2" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"geom_wkt" VARCHAR,
"priogrid_gid" DOUBLE,
"country" VARCHAR,
"country_id" DOUBLE,
"iso3" VARCHAR,
"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,
"low" DOUBLE,
"best" VARCHAR,
"high" DOUBLE
);
CREATE TABLE quickcharts_conflict_data_for_central_african_republic_2 (
"index" BIGINT,
"end_year" VARCHAR,
"adm_1" VARCHAR,
"best" VARCHAR
);
Anyone who has the link will be able to view this.