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

Liverpoolfc

@kaggle.yash161101_reddit_premier_league_big_four.liverpoolfc

169.25 KB
784 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, West Ham United v Liverpool; 07/11/2021, KO: 16:30	84	qo5ixg	LiverpoolFC	https://www.reddit.com/r/LiverpoolFC/comments/qo5ixg/prematch_thread_west_ham_united_v_liverpool/	96	Pre-Match thread, West Ham United v Liverpool Premier League matchday 11 Venue: [London Stadium](https://en.wikipedia.org/wiki/London_Stadium) Referee: Craig Pawson. Assistants: Lee Betts, Adam Nunn. Fourth official: Andre Marriner. VAR: Stuart Attwell. Assistant VAR: Constant…	1636221283
1	Daily Discussion - November 05, 2021	35	qn4lsf	LiverpoolFC	https://www.reddit.com/r/LiverpoolFC/comments/qn4lsf/daily_discussion_november_05_2021/	359	\- [Recent Match Threads](https://www.reddit.com/r/LiverpoolFC/?f=flair_name%3A%22Post%20Match%22) \- [Full FAQs](https://www.reddit.com/r/LiverpoolFC/wiki/faq) \- [Buying Tickets](https://redd.it/8u0612) \- [Guide for new fans](https://www.reddit.com/r/LiverpoolFC/wiki/newfans) \- [Where is sho…	1636092011
2	Last time at West Ham Millie wasn't expecting Klopp to sub him out which lead to this funny interaction between him and the gaffer	2142	qo4rkm	LiverpoolFC	https://v.redd.it/0hzs9kwfd0y71	52	nan	1636218970
3	Wishing John Barnes who turns 58 today an amazing birthday.	91	qoff0p	LiverpoolFC	https://i.redd.it/93ld7fii63y71.jpg	10	nan	1636252928
4	Woodburn got 2 for Hearts today	301	qo7px8	LiverpoolFC	https://i.redd.it/ty5vldua41y71.jpg	16	nan	1636227969
5	Jordan Henderson the pass master set for new milestone at Liverpool \| Liverpool \| The Observer	117	qob053	LiverpoolFC	https://www.theguardian.com/football/2021/nov/06/jordan-henderson-the-pass-master-set-for-new-milestone-at-liverpool	18	nan	1636238142
6	the greek scousers instagram story	1359	qnwjrv	LiverpoolFC	https://i.redd.it/g03buajeyxx71.png	37	nan	1636189731
7	Our big (little) Shaq tries to catch the crossbar but ends up falling straight into the net instead 😅	359	qo2eiw	LiverpoolFC	https://mobile.twitter.com/angelllliiiii/status/1456773845696798720?s=21	22	nan	1636211868
8	Andy Robertson doesn't care about your opinion	450	qnxk8j	LiverpoolFC	https://www.youtube.com/watch?v=4c-RqoD9U5I	32	nan	1636194533
9	There is massive similarities to be found when you compare the 8 seasons Liverpool had before Klopp joined, the 8 Arsenal had before Wenger left and the 8 Man United have had since Ferguson retired (... well, except for one notable outlier in the 'net spend' category)	27	qodo23	LiverpoolFC	https://i.redd.it/3m7wwjmbo2y71.jpg	4	nan	1636246810


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