Ukraine/Russia Conflict Dataset

Use your data science skills to understand real world events!

@kaggle.kylegraupe_ukrainerussia_conflict_dataset

Table List

2 tables(5.42 MB)

Ukraineconflict

@kaggle.kylegraupe_ukrainerussia_conflict_dataset.ukraineconflict

5.09 MB
96082 rows
31 columns

event_id_cnty EVENT ID CNTY	event_date EVENT DATE	year YEAR	time_precision TIME PRECISION	disorder_type DISORDER TYPE	event_type EVENT TYPE	sub_event_type SUB EVENT TYPE	actor1 ACTOR1	assoc_actor_1 ASSOC ACTOR 1	inter1 INTER1	actor2 ACTOR2	assoc_actor_2 ASSOC ACTOR 2	inter2 INTER2	interaction INTERACTION	civilian_targeting CIVILIAN TARGETING	iso ISO	region REGION	country COUNTRY	admin1 ADMIN1	admin2 ADMIN2	admin3 ADMIN3	location LOCATION	latitude LATITUDE	longitude LONGITUDE	geo_precision GEO PRECISION	source SOURCE	source_scale SOURCE SCALE	notes NOTES	tags TAGS	timestamp TIMESTAMP
ROU448	20-May-2019	2019	1	Political violence	Violence against civilians	Attack	Police Forces of Romania (2016-2019) Coast Guard	nan	1	Civilians (Turkey)	Fishers (Turkey)	7	17	Civilian targeting	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	2	Deschide; Hurriyet Daily; News.ro; CNN; TRT Haber	National-International	On 20 May 2019, the Coast Guard of Romania fired at a Turkish fishing boat allegedly fishing in Romania's Exclusive Economic Zone (EEZ), 52 sea miles east of Costinesti [coded to Coast of Constanta]. Three Turkish fishers were reported to wounded.	nan	1649875498
ROU1885	28-March-2022	2022	1	Strategic developments	Strategic developments	Disrupted weapons use	Military Forces of Romania (2021-)	nan	1	Unidentified Military Forces	nan	8	18	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	Adevarul; G4media	National	Defusal: On 28 March 2022, Romanian minesweepers conducted a controlled detonation of a sea mine 70km away from the Midia port off the Coast of Constanta. The mine was most likely strayed from a location near Ukraine.	nan	1649184809
ROU1940	28-July-2022	2022	1	Demonstrations	Protests	Peaceful protest	Protesters (Romania)	Greenpeace	6	nan	nan		60	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	News.ro	National	On 28 July 2022, Greenpeace activists protested in front of an oil tanker off the Coast of Constanta, demanding a stop to the dependence on fossil fuels due to their effect on the climate.	crowd size=no report	1659462993
ROU1945	31-July-2022	2022	1	Strategic developments	Strategic developments	Disrupted weapons use	Military Forces of Romania (2021-)	nan	1	Unidentified Armed Group (International)	nan	3	13	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	Digi24	National	Defusal: On 31 July 2022, Romanian Naval Forces defused and destroyed a YAM sea mine off the Coast of Constanta. The mine likely came from the Northern Black Sea region from the Ukrainian coast.	nan	1660055880
ROU1947	04-August-2022	2022	1	Demonstrations	Protests	Peaceful protest	Protesters (Romania)	Greenpeace	6	nan	nan		60	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	News.ro	National	On 4 August 2022, Greenpeace activists protested in front of an oil tanker off the Coast of Constanta, demanding a stop to the dependence on fossil fuels due to their effect on the climate.	crowd size=no report	1660055882
ROU1961	08-September-2022	2022	1	Political violence	Explosions/Remote violence	Remote explosive/landmine/IED	Unidentified Military Forces	nan	8	Military Forces of Romania (2021-)	nan	1	18	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	G4media; RFE/RL; Adevarul; Balkan Insight; Digi24	National-International	On 8 September 2022, a sea mine of unknown origin hit the DM-29 minesweeping ship of the Romanian navy 46km off the Coast of Constanta, damaging it during a demining operation. No casualties.	nan	1663096246
ROU2026	10-December-2022	2022	1	Strategic developments	Strategic developments	Disrupted weapons use	Military Forces of Romania (2021-)	nan	1	Unidentified Military Forces	nan	8	18	nan	642	Europe	Romania	Constanta	nan	nan	Coast of Constanta	44.156	28.948	1	Agerpres; Deschide	National-International	Defusal: On 10 December 2022, the Romanian navy conducted a controlled detonation of a sea mine of unknown origin located off the Coast of Constanta.	nan	1673376402
ROU2045	16-January-2023	2023	1	Strategic developments	Strategic developments	Disrupted weapons use	Military Forces of Romania (2021-)	nan	1	Military Forces of Russia (2000-)	nan	8	18	nan	642	Europe	Romania	Constanta	Mihai Viteazu	nan	Canalul Periboina	44.611	28.929	2	Adevarul; News.ro	National	Defusal: On 16 January 2023, Romanian Naval Forces captured and disabled a part of a 57E6 Russian missile that was washed away by the sea near the Canalul Periboina.	nan	1674572555
TUR14260	16-November-2020	2020	2	Strategic developments	Strategic developments	Arrests	Military Forces of Turkey (2016-)	nan	1	Civilians (Afghanistan)	Refugees/IDPs (Afghanistan); Civilians (Syria); Refugees/IDPs (Syria); Civilians (Iran); Refugees/IDPs (Iran)	7	17	nan	792	Middle East	Turkey	Sinop	Sinop	nan	Coast of Sinop	42.039	35.224	2	Ihlas News Agency	National	Arrests: Around 16 November 2020 (as reported), 115 migrants attempting to cross the border illegally to Romania via boats were stopped off the coast of Sinop and detained by the Coast Guard Command of Turkish Army. The migrants were from Afghanistan, Syria and Iran.	nan	1606149144
TUR18570	03-November-2021	2021	1	Strategic developments	Strategic developments	Arrests	Military Forces of Turkey (2016-)	nan	1	Civilians (International)	Refugees/IDPs (International)	7	17	nan	792	Middle East	Turkey	Istanbul	Sile	nan	Coast of Sile	41.253	29.713	2	Ihlas News Agency; A Haber	National	On 3 November 2021, 40 migrants attempting to cross the border illegally on a boat were captured off the coast of Sile, Istanbul and detained by the Coast Guard Command of the Turkish army. The migrants were from Afghanistan, Iraq, Iran, Syria and Bangladesh.	nan	1636383675


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
);