Ukraine War

Reddit Posts and Comments Dataset on the Ukraine War

@kaggle.sinatavakoli_ukraine_war

Table List

6 tables(3.55 MB)

Nodes

Words

Original Data

@kaggle.sinatavakoli_ukraine_war.original_data

170.3 KB
10000 rows
12 columns

unnamed_0 Unnamed: 0	subreddit Subreddit	selftext Selftext	author_fullname Author Fullname	title Title	upvote_ratio Upvote Ratio	ups Ups	created Created	created_utc Created Utc	num_comments Num Comments	author Author	id Id
	NonCredibleDefense	nan	t2_4dfoopu9	Damn...we blinked and missed the T-34 stage of the war.	0.79	10398	1666899284	1666899284	738	doooompatrol	yf13ra
1	ukraine	nan	t2_3so708z2	Finnish🇫🇮 volunteer sends greetings home from somewhere 🇺🇦	0.9	2100	1680237180	1680237180	57	Vivarevo	127a6ew
2	UkrainianConflict	nan	t2_p5qo3hyf	Massive #HIMARS strikes 60km from the front in #Starobilsk which is an important logistical point for #Svatove and northern #Luhansk. This is the first strike ive witnessed this deep on this axis. Maybe transferred firepower from #Kherson #Ukraine #UkraineWar	0.79	834	1668658529	1668658529	41	Orcasystems99	yxg7ub
3	europe	This megathread is meant for discussion of the current Russo-Ukrainian War, also known as the Russian invasion of Ukraine. Please read our [current rules](https://www.reddit.com/r/europe/wiki/community_rules), but also the extended rules below. # News sources: - [The Guardian](https://www…	t2_ojkhp	War in Ukraine Megathread LIII	0.75	578	1680552369	1680552369	8232	ModeratorsOfEurope	12aw2q2
4	europe	This megathread is meant for discussion of the current Russo-Ukrainian War, also known as the Russian invasion of Ukraine. Please read our [current rules](https://www.reddit.com/r/europe/wiki/community_rules), but also the extended rules below. # News sources: - [The Guardian](https://www.…	t2_ojkhp	War in Ukraine Megathread L	0.76	424	1673994766	1673994766	9524	ModeratorsOfEurope	10eps9y
5	europe	This is a special megathread. One year ago, Russia invaded Ukraine, but Ukraine has prevailed. - [As shown in this Reuters Infographics special](https://www.reuters.com/graphics/UKRAINE-CRISIS/ANNIVERSARY-SURVIVAL/movaklxlmva/), at one point, the Russian Army were at the doorsteps of Kyiv, Ukra…	t2_ojkhp	War in Ukraine Megathread LII	0.77	412	1677155569	1677155569	8276	ModeratorsOfEurope	119wltg
6	Cursedgunimages	What the hell is this russian creation !! #ukrainewar	t2_bzvw07i7	Wtf	0.77	372	1669302510	1669302510	15	BackgroundGold3503	z3mb0m
7	europe	This megathread is meant for discussion of the current Russo-Ukrainian War, also known as the Russian invasion of Ukraine. Please read our [current rules](https://www.reddit.com/r/europe/wiki/community_rules), but also the extended rules below. # News sources: - [The Guardian](https://www…	t2_ojkhp	War in Ukraine Megathread LV (55)	0.74	350	1688284803	1688284803	4457	ModeratorsOfEurope	14oijq5
8	europe	This megathread is meant for discussion of the current Russo-Ukrainian War, also known as the Russian invasion of Ukraine. Please read our [current rules](https://www.reddit.com/r/europe/wiki/community_rules), but also the extended rules below. # News sources: - [The Guardian](https://www.…	t2_ojkhp	War in Ukraine Megathread XLIX	0.77	340	1670886881	1670886881	8921	ModeratorsOfEurope	zkf1p4
9	europe	This megathread is meant for discussion of the current Russo-Ukrainian War, also known as the Russian invasion of Ukraine. Please read our [current rules](https://www.reddit.com/r/europe/wiki/community_rules), but also the extended rules below. # News sources: - [The Guardian](https://www.…	t2_ojkhp	War in Ukraine Megathread XLVIII	0.77	339	1668809766	1668809766	6148	ModeratorsOfEurope	yyw744


CREATE TABLE original_data (
  "unnamed_0" BIGINT,
  "subreddit" VARCHAR,
  "selftext" VARCHAR,
  "author_fullname" VARCHAR,
  "title" VARCHAR,
  "upvote_ratio" DOUBLE,
  "ups" BIGINT,
  "created" BIGINT,
  "created_utc" BIGINT,
  "num_comments" BIGINT,
  "author" VARCHAR,
  "id" VARCHAR
);