Reddit Premier League - Big Four

r/RedDevils, r/Chelseafc, r/LiverpoolFC & r/Gunners subreddit posts

@kaggle.yash161101_reddit_premier_league_big_four

Table List

4 tables(733.11 KB)

Arsenal

Chelseafc

Liverpoolfc

Manu

Arsenal

@kaggle.yash161101_reddit_premier_league_big_four.arsenal

165.88 KB
865 rows
9 columns

unnamed_0 Unnamed: 0	title Title	score Score	id Id	subreddit Subreddit	url Url	num_comments Num Comments	body Body	created Created
	Pre-match Thread: Arsenal v Watford	82	qnrw4o	Gunners	https://www.reddit.com/r/Gunners/comments/qnrw4o/prematch_thread_arsenal_v_watford/	159	Competition: Premier League, Matchday 11 Venue: Emirates Stadium Kickoff: Sunday 7-November-2021 2:00pm GMT \| [Time Zone converter](https://timee.io/20211107T1400?tl=Watford%20%28H%29%202021.22) Referee: Kevin Friend. Assistants: Adrian Holmes, Simon Beck. Fourth official:…	1636169704
1	November 06, 2021 Daily Discussion & Transfers Thread	33	qnvo7b	Gunners	https://www.reddit.com/r/Gunners/comments/qnvo7b/november_06_2021_daily_discussion_transfers_thread/	378	Use this thread for general daily football discussion. This thread can also be used to discuss Transfer rumours and to post Tier 4 sources. As this may fill up please sort by new to try and avoid constantly repeating the same question. Join our [Discord](https://discord.gg/gunners) for live discu…	1636185602
2	What a way to spend £80 million	1548	qo3u2t	Gunners	https://i.redd.it/hbwfwtn750y71.jpg	212	nan	1636216172
3	Bruno Fernandes with his priorities straight	769	qo7uzn	Gunners	https://i.redd.it/8jm7adgi51y71.png	41	nan	1636228401
4	Wholesome, And Another Addition To The Papa Wengz Bot	360	qo7t5o	Gunners	https://i.redd.it/8rxqh9a451y71.jpg	19	nan	1636228246
5	Arsenal U23's have just scored 3 times in injury time to come from 3-0 down to equalise...	874	qo22jr	Gunners	https://i.gyazo.com/518b13897ab88c296de83f16ae59fcc0.png	23	nan	1636210891
6	Three extra time goals and a massive comeback by the u23 lads!	457	qo2mms	Gunners	https://i.redd.it/mdecnt1juzx71.jpg	17	nan	1636212578
7	Xhaka back on the grass (Credit: @now.arsenal on twitter)	377	qo3o4y	Gunners	https://i.redd.it/ava76nfs30y71.jpg	79	nan	1636215691
8	Found these beauties when moving - match day programmes from Wenger’s last home game, sealed.	134	qoa514	Gunners	https://i.imgur.com/lyoHO1l.jpg	13	nan	1636235427
9	Ranieri’s (awful) record vs us in his managerial career. Let’s hope this continues tomorrow	285	qo4vnv	Gunners	https://i.redd.it/kzosx35ke0y71.jpg	28	nan	1636219313


CREATE TABLE arsenal (
  "unnamed_0" BIGINT,
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "subreddit" VARCHAR,
  "url" VARCHAR,
  "num_comments" BIGINT,
  "body" VARCHAR,
  "created" DOUBLE
);