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

Manu

@kaggle.yash161101_reddit_premier_league_big_four.manu

227.81 KB
816 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
	[Post Match thread] Manchester United 0 - 2 Manchester City	244	qo1e3z	reddevils	https://www.reddit.com/r/reddevils/comments/qo1e3z/post_match_thread_manchester_united_0_2/	2983	[BBC Match Report](https://www.bbc.com/sport/football/59099962) [Solskjaer & Fernandes react to derby defeat \| Manchester United 0-2 Manchester City \| Premier League](https://www.youtube.com/watch?v=Yv505I1Zp6A) [Ole Gunnar Solskjaer \| Post Match Press Conference \| Manchester United 0-2 Manchester…	1636208954
1	Daily Discussion	22	qodo2l	reddevils	https://www.reddit.com/r/reddevils/comments/qodo2l/daily_discussion/	594	Daily discussion on Manchester United. BE CIVIL It has been mentioned, but the toxicity and abuse towards the sub, within the sub, and towards other subs has been too high. We as moderators have our share of blame in this, but we want to stress that this kind of behavior …	1636246812
2	#mufc approach: hope De Gea rescues them at one end and hope Ronaldo rescues them at the other. Neither hope transpired. Hopeless performance. No shape or belief. Can’t keep going on like this. Solskjaer came in, steadied the ship post-Jose but now they’re sinking. Time to go.	2345	qo1hw1	reddevils	https://twitter.com/henrywinter/status/1456991163152584704?s=20	251	nan	1636209261
3	Jamie Carragher on Twitter : "What a load of nonsense it is that because Jose/LVG failed at #ManUtd they shouldn’t look for a better manager. "	1461	qo2top	reddevils	https://twitter.com/Carra23/status/1457007939798065154?ref_src=twsrc%5Etfw%7Ctwcamp%5Etweetembed%7Ctwterm%5E1457007939798065154%7Ctwgr%5E%7Ctwcon%5Es1_&ref_url=https%3A%2F%2Fcafe.naver.com%2Fca-fe%2Fcafes%2F10799390%2Farticles%2F1327757%3Fpage%3D1boardtype%3DLreferrerAllArticles%3DtrueoldPath%3D2FAr…	224	nan	1636213174
4	David De Gea on Instagram: „I am hurt“	372	qo9n15	reddevils	https://www.instagram.com/p/CV8wchRM9qN/?utm_medium=copy_link	158	nan	1636233844
5	"I give up. They have been like this all season." Roy Keane can't hide his frustrations at Manchester United and believes if they don't do something drastic now there'll be another four or five goals to Manchester City	1527	qo0ape	reddevils	https://twitter.com/footballdaily/status/1456977212717027329?s=20	241	nan	1636205489
6	Henry Winter on Twitter: Fair play to Marcus Rashford for wanting to help the team. But he shouldn’t have been playing. Not trained since Wednesday, had the sweats post-flight from Bergamo (not Covid), sent home from training by doc, felt weak Thurs/Fri, met up with squad this a.m, came off bench.	916	qo2tht	reddevils	https://twitter.com/henrywinter/status/1457005602459238403	165	nan	1636213158
7	Bastian Schweinsteiger on Twitter: Passive @ManUtd vs active @ManCity. The idea of football couldn’t be more different. I wish United would be more active and not chasing the ball non stop - losing their energy. Take away the ball of Pep‘s team 😉 Come on Utd, you’re playing at #OldTrafford! #MUNMCI	1410	qo01ge	reddevils	https://twitter.com/bschweinsteiger/status/1456973033046876167?s=21	119	nan	1636204614
8	Happy birthday, David de Gea!	150	qodqw4	reddevils	https://i.redd.it/xydspne3p2y71.jpg	30	nan	1636247072
9	De Gea quite visibly frustrated after the game👀	661	qo44ib	reddevils	https://twitter.com/TheFergusonWay/status/1457024692317868037?t=Bulux7rj1bePFVRStgsT5A&s=19	155	nan	1636217041


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