Premier League Player's Stats

@kaggle.sophieg_premier_league_players_stats

Table List

5 tables(1.08 MB)

Events

Fixtures

Fixture Stats

Players

Teams

Events

@kaggle.sophieg_premier_league_players_stats.events

20.17 KB
38 rows
21 columns

unnamed_0 Unnamed: 0	id Id	name Name	deadline_time Deadline Time	average_entry_score Average Entry Score	highest_scoring_entry Highest Scoring Entry	deadline_time_epoch Deadline Time Epoch	highest_score Highest Score	cup_leagues_created Cup Leagues Created	h2h_ko_matches_created H2h Ko Matches Created	chip_plays Chip Plays	most_selected Most Selected	most_transferred_in Most Transferred In	top_element Top Element	top_element_info Top Element Info	transfers_made Transfers Made	most_captained Most Captained	most_vice_captained Most Vice Captained
	1	Gameweek 1	2023-08-11T17:30:00Z	64	3383750	1691775000	127			[{'chip_name': 'bboost', 'num_played': 163222}, {'chip_name': '3xc', 'num_played': 287198}]	355	1	395	{'id': 395, 'points': 14}		355	19
1	2	Gameweek 2	2023-08-18T17:15:00Z	44	3338487	1692378900	120	true	true	[{'chip_name': 'bboost', 'num_played': 126778}, {'chip_name': 'freehit', 'num_played': 112568}, {'chip_name': 'wildcard', 'num_played': 244166}, {'chip_name': '3xc', 'num_played': 213828}]	355	195	108	{'id': 108, 'points': 16}	13130353	355	19
2	3	Gameweek 3	2023-08-25T17:30:00Z	44	9368956	1692984600	128	true	true	[{'chip_name': 'bboost', 'num_played': 124110}, {'chip_name': 'freehit', 'num_played': 111065}, {'chip_name': 'wildcard', 'num_played': 445328}, {'chip_name': '3xc', 'num_played': 245013}]	355	108	216	{'id': 216, 'points': 19}	17619532	355	19
3	4	Gameweek 4	2023-09-01T17:30:00Z	72	4354697	1693589400	148	true	true	[{'chip_name': 'bboost', 'num_played': 109196}, {'chip_name': 'freehit', 'num_played': 119294}, {'chip_name': 'wildcard', 'num_played': 406918}, {'chip_name': '3xc', 'num_played': 164388}]	355	216	516	{'id': 516, 'points': 20}	16035365	355	19
4	5	Gameweek 5	2023-09-16T10:00:00Z	44	6211182	1694858400	102	true	true	[{'chip_name': 'bboost', 'num_played': 96469}, {'chip_name': 'freehit', 'num_played': 81067}, {'chip_name': 'wildcard', 'num_played': 387941}, {'chip_name': '3xc', 'num_played': 123443}]	355	516	344	{'id': 344, 'points': 13}	14363988	355	19
5	6	Gameweek 6	2023-09-23T12:30:00Z	68	4494759	1695472200	142	true	true	[{'chip_name': 'bboost', 'num_played': 78528}, {'chip_name': 'freehit', 'num_played': 60517}, {'chip_name': 'wildcard', 'num_played': 283333}, {'chip_name': '3xc', 'num_played': 192955}]	355	343	430	{'id': 430, 'points': 18}	12109066	355	308
6	7	Gameweek 7	2023-09-30T10:00:00Z	49	9335002	1696068000	156	true	true	[{'chip_name': 'bboost', 'num_played': 79672}, {'chip_name': 'freehit', 'num_played': 141888}, {'chip_name': 'wildcard', 'num_played': 380176}, {'chip_name': '3xc', 'num_played': 90244}]	355	430	60	{'id': 60, 'points': 23}	15579302	355	308
7	8	Gameweek 8	2023-10-07T10:00:00Z	44	10068163	1696672800	120	true	true	[{'chip_name': 'bboost', 'num_played': 53401}, {'chip_name': 'freehit', 'num_played': 149680}, {'chip_name': 'wildcard', 'num_played': 675746}, {'chip_name': '3xc', 'num_played': 67206}]	355	516	216	{'id': 216, 'points': 16}	19444885	355	355
8	9	Gameweek 9	2023-10-21T10:00:00Z	67	6931177	1697882400	152	true	true	[{'chip_name': 'bboost', 'num_played': 50175}, {'chip_name': 'freehit', 'num_played': 67685}, {'chip_name': 'wildcard', 'num_played': 328588}, {'chip_name': '3xc', 'num_played': 56575}]	355	60	423	{'id': 423, 'points': 17}	11431916	355	308
9	10	Gameweek 10	2023-10-27T17:30:00Z	66	9895223	1698427800	134	true	true	[{'chip_name': 'bboost', 'num_played': 80903}, {'chip_name': 'freehit', 'num_played': 70004}, {'chip_name': 'wildcard', 'num_played': 328730}, {'chip_name': '3xc', 'num_played': 93361}]	355	60	13	{'id': 13, 'points': 17}	12428517	355	355


CREATE TABLE events (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "deadline_time" VARCHAR,
  "average_entry_score" DOUBLE,
  "highest_scoring_entry" DOUBLE,
  "deadline_time_epoch" BIGINT,
  "highest_score" DOUBLE,
  "is_previous" BOOLEAN,
  "is_current" BOOLEAN,
  "cup_leagues_created" BOOLEAN,
  "h2h_ko_matches_created" BOOLEAN,
  "ranked_count" DOUBLE,
  "chip_plays" VARCHAR,
  "most_selected" BIGINT,
  "most_transferred_in" BIGINT,
  "top_element" BIGINT,
  "top_element_info" VARCHAR,
  "transfers_made" BIGINT,
  "most_captained" BIGINT,
  "most_vice_captained" BIGINT
);