Ukraine/Russia Conflict Dataset
Use your data science skills to understand real world events!
@kaggle.kylegraupe_ukrainerussia_conflict_dataset
Conflict Data Ukr
@kaggle.kylegraupe_ukrainerussia_conflict_dataset.conflict_data_ukr
- 342.37 KB
- 2990 rows
- 50 columns
idId | relidRelid | yearYear | active_yearActive Year | code_statusCode Status | type_of_violenceType Of Violence | conflict_dset_idConflict Dset Id | conflict_new_idConflict New Id | conflict_nameConflict Name | dyad_dset_idDyad Dset Id | dyad_new_idDyad New Id | dyad_nameDyad Name | side_a_dset_idSide A Dset Id | side_a_new_idSide A New Id | side_aSide A | side_b_dset_idSide B Dset Id | side_b_new_idSide B New Id | side_bSide B | number_of_sourcesNumber Of Sources | source_articleSource Article | source_officeSource Office | source_dateSource Date | source_headlineSource Headline | source_originalSource Original | where_precWhere Prec | where_coordinatesWhere Coordinates | where_descriptionWhere Description | adm_1Adm 1 | adm_2Adm 2 | latitudeLatitude | longitudeLongitude | geom_wktGeom Wkt | priogrid_gidPriogrid Gid | countryCountry | iso3Iso3 | country_idCountry Id | regionRegion | event_clarityEvent Clarity | date_precDate Prec | date_startDate Start | date_endDate End | deaths_aDeaths A | deaths_bDeaths B | deaths_civiliansDeaths Civilians | deaths_unknownDeaths Unknown | bestBest | highHigh | lowLow | gwnoaGwnoa | gwnobGwnob |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| nan | #date+year | nan | nan | nan | #group+name+first | #group+name+second | #meta+source | nan | nan | #description | nan | #loc+name | nan | #adm1+name | #adm2+name | #geo+lat | #geo+lon | nan | #country+name | #country+code | #region+name | #date+start | #date+end | #affected+killed | |||||||||||||||||||||||||
| 147997 | UKR-2014-1-14085-0 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 5 | "Agence France Presse,2014-01-22,Police disperse Kiev protest, activists say one shot dead";"Agence France Presse,2014-01-22,Two activists shot dead during Ukraine protests: prosecutors sjw/ma/dh";"Agence France Presse,2014-01-22,Two shot dead as Ukraine police storm Kiev protest";"Agence France Pre… | Agence France Presse;Agence France Presse;Agence France Presse;Agence France Presse;Agence France Presse | 2014-01-22;2014-01-22;2014-01-22;2014-01-22;2014-01-25 | Police disperse Kiev protest, activists say one shot dead;Two activists shot dead during Ukraine protests: prosecutors sjw/ma/dh;Two shot dead as Ukraine police storm Kiev protest;Five dead as Ukraine police launch assault on protesters;One more Ukrainian protester dies of wounds in hospital: offici… | Maidan protesters, General Prosecutor of Ukraine | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-01-22 00:00:00.000 | 2014-01-22 00:00:00.000 | 5 | 5 | 5 | 5 | 369 | ||||
| 149221 | UKR-2014-1-14085-1 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 1 | "Reuters News,2014-01-27,Dead man found hanging on Kiev's Independence Square - police" | Reuters News | 2014-01-27 | Dead man found hanging on Kiev's Independence Square - police | Ukrainian police | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-01-27 00:00:00.000 | 2014-01-27 00:00:00.000 | 1 | 1 | 1 | 1 | 369 | ||||
| 149248 | UKR-2014-1-14085-3 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 9 | "Reuters News,2014-02-18,UKRAINE PARLIAMENTARY DEPUTY SAYS ON FACEBOOK THAT THREE DEAD BODIES OF PROTESTERS ARE IN A BUILDING CLOSE TO PARLIAMENT";"Reuters Pictures,2014-02-19,A wounded person lies on the ground after clashes in central Kiev";"Reuters News,2014-02-18,Ukraine police battle protesters… | Reuters News;Reuters Pictures;Reuters News;Agence France Presse;Associated Press Newswires;Reuters News;Reuters News;Agence France Presse;Agence France Presse | 2014-02-18;2014-02-19;2014-02-18;2014-02-19;2014-02-19;2014-02-20;2014-02-19;2014-02-19;2014-02-19 | UKRAINE PARLIAMENTARY DEPUTY SAYS ON FACEBOOK THAT THREE DEAD BODIES OF PROTESTERS ARE IN A BUILDING CLOSE TO PARLIAMENT;A wounded person lies on the ground after clashes in central Kiev;Ukraine police battle protesters after nation's bloodiest day;Four protesters killed in police assault on Kiev ca… | Maidan representatives, police, news correspondents reporting from the site of the events, officials | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-02-18 00:00:00.000 | 2014-02-18 00:00:00.000 | 10 | 4 | 12 | 26 | 26 | 26 | 369 | ||
| 149249 | UKR-2014-1-14085-4 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 1 | "Agence France Presse,2014-02-20,Ukraine death toll rises to 28: ministry" | Agence France Presse | 2014-02-20 | Ukraine death toll rises to 28: ministry | Ukraine's health ministry | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 2 | 2 | 2014-02-18 00:00:00.000 | 2014-02-20 00:00:00.000 | 2 | 2 | 2 | 2 | 369 | ||||
| 149251 | UKR-2014-1-14085-6 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 1 | "Reuters News,2014-02-22,WRAPUP 9-Ukraine parliament removes Yanukovich, who flees Kiev in "coup"" | Reuters News | 2014-02-22 | WRAPUP 9-Ukraine parliament removes Yanukovich, who flees Kiev in "coup" | nan | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 2 | 2 | 2014-02-18 00:00:00.000 | 2014-02-21 00:00:00.000 | 6 | 6 | 6 | 6 | 369 | ||||
| 149250 | UKR-2014-1-14085-5 | 2014 | 1 | Clear | 1 | 13219 | 13219 | Ukraine: Government | 14085 | 14085 | Government of Ukraine - Maidan | 61 | 61 | Government of Ukraine | 5817 | 5817 | Maidan | 8 | "Agence France Presse,2014-02-21,Ukraine rivals sign deal to end crisis";"Agence France Presse,2014-02-21,Three days of deadly unrest in Ukraine";"ITAR-TASS World Service,2014-02-20,Two police commandoes die in fire at riot police base in Ukraine’s Lvov";"Agence France Presse,2014-02-20,At least 67 … | Agence France Presse;Agence France Presse;ITAR-TASS World Service;Agence France Presse;Agence France Presse;Reuters News;ITAR-TASS World Service;BBC News | 2014-02-21;2014-02-21;2014-02-20;2014-02-20;2014-02-20;2014-02-20;2014-02-20;2014-04-03 | Ukraine rivals sign deal to end crisis;Three days of deadly unrest in Ukraine;Two police commandoes die in fire at riot police base in Ukraine’s Lvov;At least 67 killed in this week's Kiev clashes: authorities;Dozens dead on Ukraine's deadliest day;WRAPUP 9-Ukraine truce shattered, death toll hits 6… | Maidan, police, city hall, reporters transmitting from the site, Ministry of health, new authorities | 1 | Kiev city | Kiev/Kyiv city (Maidan Nezalezhnosti protest camp) | Kiev Special Republican city | nan | 50.450000 | 30.523330 | POINT (30.52333 50.45) | 202022 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-02-20 00:00:00.000 | 2014-02-20 00:00:00.000 | 2 | 46 | 48 | 67 | 48 | 369 | |||
| 153030 | UKR-2014-2-14113-1 | 2014 | 1 | Clear | 2 | 14113 | 13240 | Supporters of independence for Eastern Ukraine - Supporters of Ukrainian unity | 14113 | 14113 | Supporters of independence for Eastern Ukraine - Supporters of Ukrainian unity | 5837 | 5837 | Supporters of independence for Eastern Ukraine | 5836 | 5836 | Supporters of Ukrainian unity | 4 | "Agence France Presse,2014-05-02,Death toll from Odessa violence rises to 3: police";"BBC,2014-05-06,How did Odessa's fire happen?";"Office of the United Nations High Commissioner for Human Rights,2014-06-15,Report on the human rights situation in Ukraine 15 June 2014";"Reuters News,2014-05-03,FACTB… | Agence France Presse;BBC;Office of the United Nations High Commissioner for Human Rights;Reuters News | 2014-05-02;2014-05-06;2014-06-15;2014-05-03 | Death toll from Odessa violence rises to 3: police;How did Odessa's fire happen?;Report on the human rights situation in Ukraine 15 June 2014;FACTBOX-Ukraine says groups from Moldova's Transdniestria stir unrest in Odessa | Ukrainian authorities | 1 | Odessa town | Odessa town | Odessa oblast | Odessa City municipality | 46.466667 | 30.733333 | POINT (30.733333 46.466667) | 196262 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-05-02 00:00:00.000 | 2014-05-02 00:00:00.000 | 45 | 45 | 45 | 45 | |||||
| 149866 | UKR-2014-1-14124-0 | 2014 | 1 | Clear | 1 | 13246 | 13246 | Ukraine: Donetsk | 14124 | 14124 | Government of Ukraine - DPR | 61 | 61 | Government of Ukraine | 5840 | 5840 | DPR | 3 | "Reuters News,2014-04-13,One Ukrainian state security officer killed, 5 others wounded - interior minister";"Agence France Presse,2014-04-13,Ukraine in bloody battle to oust pro-Russian gunmen";"MemoryBook,2021-04-27,Slavyansk" | Reuters News;Agence France Presse;MemoryBook | 2014-04-13;2014-04-13;2021-04-27 | One Ukrainian state security officer killed, 5 others wounded - interior minister;Ukraine in bloody battle to oust pro-Russian gunmen;Slavyansk | Ukraine interior minister; MemoryBook | 1 | Sloviansk town | Sloviansk town | Donetsk oblast | Sloviansk raion | 48.853333 | 37.625000 | POINT (37.625 48.853333) | 199876 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-04-13 00:00:00.000 | 2014-04-13 00:00:00.000 | 1 | 2 | 3 | 3 | 3 | 369 | |||
| 149868 | UKR-2014-1-14124-1 | 2014 | 1 | Clear | 1 | 13246 | 13246 | Ukraine: Donetsk | 14124 | 14124 | Government of Ukraine - DPR | 61 | 61 | Government of Ukraine | 5840 | 5840 | DPR | 1 | "Agence France Presse,2014-04-13,Ukraine in bloody battle to oust pro-Russian gunmen" | Agence France Presse | 2014-04-13 | Ukraine in bloody battle to oust pro-Russian gunmen | Donetsk People's Republic spokesmen | 5 | M03 road between Sloviansk and Artemivsk town | stretch of the road connecting Slavyansk and the town of Artemivsk | Donetsk oblast | nan | 48.776492 | 37.778737 | POINT (37.778737 48.776492) | 199876 | Ukraine | UKR | 369 | Europe | 1 | 1 | 2014-04-13 00:00:00.000 | 2014-04-13 00:00:00.000 | 1 | 1 | 1 | 1 | 369 |
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
);