Fantasy Premier League

Posts and comments from r/FantasyPL subreddit

@kaggle.gpreda_fantasy_premier_league

Table List

1 table(6.93 MB)

Reddit Fpl

@kaggle.gpreda_fantasy_premier_league.reddit_fpl

6.93 MB
50954 rows
8 columns

title Title	score Score	id Id	url Url	comms_num Comms Num	created Created	body Body	timestamp Timestamp
/r/FantasyPL UNOFFICIAL WhatsApp Group - 7th Year Running Open Invitation (Top 50k Rank Only)	4	o66qbv	https://www.reddit.com/r/FantasyPL/comments/o66qbv/rfantasypl_unofficial_whatsapp_group_7th_year/		1624456452	Hey all, So almost seven years ago, I created a Whatsapp Group for /r/FantasyPL and it worked out to be a great success, we've all formed close connections and have made friends from all around the world. We had over 120 members this year and since it has narrowed down to about 80 active members. …	Wed Jun 23 2021 16:54:12 GMT+0000 (Coordinated Universal Time)
Is there any way to see league position history week by week for mini leagues?	2	njcxlt	https://www.reddit.com/r/FantasyPL/comments/njcxlt/is_there_any_way_to_see_league_position_history/	4	1621820882	nan	Mon May 24 2021 04:48:02 GMT+0000 (Coordinated Universal Time)
Aston Villa XI [23.05.2021][GW38] vs CHE	17	nj8ds3	https://i.imgur.com/hB1Sa39.jpg	10	1621807395	nan	Mon May 24 2021 01:03:15 GMT+0000 (Coordinated Universal Time)
Crystal Palace XI [23.05.2021][GW38] vs LIV	18	nj8dj7	https://i.imgur.com/fkI5lQh.png	6	1621807372	nan	Mon May 24 2021 01:02:52 GMT+0000 (Coordinated Universal Time)
Burnley XI [23.05.2021][GW38] vs SHU	17	nj8d6y	https://i.imgur.com/8TieTnS.png	14	1621807341	nan	Mon May 24 2021 01:02:21 GMT+0000 (Coordinated Universal Time)
West Ham United XI [23.05.2021][GW38] vs SOU	27	nj8czd	https://i.imgur.com/YWJc6po.png	9	1621807324	nan	Mon May 24 2021 01:02:04 GMT+0000 (Coordinated Universal Time)
Newcastle United XI [23.05.2021][GW38] vs FUL	22	nj8cui	https://i.imgur.com/BDLTRot.jpg	10	1621807313	nan	Mon May 24 2021 01:01:53 GMT+0000 (Coordinated Universal Time)
Leeds United XI [23.05.2021][GW38] vs WBA	68	nj8co0	https://i.imgur.com/z0REISm.png	74	1621807299	nan	Mon May 24 2021 01:01:39 GMT+0000 (Coordinated Universal Time)
Arsenal XI [23.05.2021][GW38] vs BHA	25	nj8chz	https://i.imgur.com/FDCk4Np.png	14	1621807287	nan	Mon May 24 2021 01:01:27 GMT+0000 (Coordinated Universal Time)
Leicester City XI [23.05.2021][GW38] vs TOT	24	nj8cdi	https://i.imgur.com/nwchgXf.png	8	1621807277	nan	Mon May 24 2021 01:01:17 GMT+0000 (Coordinated Universal Time)


CREATE TABLE reddit_fpl (
  "title" VARCHAR,
  "score" BIGINT,
  "id" VARCHAR,
  "url" VARCHAR,
  "comms_num" BIGINT,
  "created" DOUBLE,
  "body" VARCHAR,
  "timestamp" TIMESTAMP
);