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

Chelseafc

@kaggle.yash161101_reddit_premier_league_big_four.chelseafc

170.17 KB
859 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
	Daily Discussion Thread	7	qodo35	chelseafc	https://www.reddit.com/r/chelseafc/comments/qodo35/daily_discussion_thread/	26	\#Daily Discussion Thread Please use this thread to discuss anything and everything! This covers ticket and general matchday questions (pubs, transport, etc), club tactics/formations, player social media, football around the globe, rivals and other competitions, and everything else that comes to …	1636246812
1	[Post-Match Survey] Player Ratings \| Chelsea 1 - 1 Burnley \| English Premier League \| 06-11-2021	32	qo4qfk	chelseafc	https://forms.gle/Uo7xJQn2EdEkJT8n8	15	nan	1636218878
2	Tuchel giving it the big one in front of Dyche	587	qo32tj	chelseafc	https://v.redd.it/eth15qjmyzx71	48	nan	1636213963
3	Reece can do it all and deserves more love outside of the Chelsea fanbase	131	qoc310	chelseafc	https://www.reddit.com/r/chelseafc/comments/qoc310/reece_can_do_it_all_and_deserves_more_love/	37	i feel he is extraordinarily underrated outside of chelsea circles. transfermkt values him at $49.5 m, just barely more than Luke Shaw and WELL behind Cancelo and TAA - who i think are perfectly fine comparisons for James perhaps i’m wearing my blue tinted glasses when i watch him play, but I feel…	1636241591
4	What a cross. What a goal 🔥	413	qo3rxq	chelseafc	https://v.redd.it/y75zfs3p40y71	8	nan	1636215999
5	The future of Chelsea Football Club… 🌟	1215	qnxbn8	chelseafc	https://i.redd.it/fg29i0we9yx71.jpg	114	nan	1636193371
6	Chelsea kit concepts	167	qo85nh	chelseafc	https://www.reddit.com/gallery/qo85nh	39	nan	1636229282
7	Ladies and gentlemen it’s match day	434	qo08x5	chelseafc	https://v.redd.it/hhb7vcly8zx71	19	nan	1636205333
8	KTBFFH!	232	qo3693	chelseafc	https://i.redd.it/f7ez3knizzx71.jpg	15	nan	1636214257
9	Hazard won 123 points for us in the Premier League, which is the most in that time and he’s won the 3rd most points ITW	441	qnyy2z	chelseafc	https://www.reddit.com/gallery/qnyy2z	36	nan	1636200598


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