Premier League Player's Stats

@kaggle.sophieg_premier_league_players_stats

Table List

5 tables(1.08 MB)

Events

Fixtures

Fixture Stats

Players

Teams

Fixture Stats

@kaggle.sophieg_premier_league_players_stats.fixture_stats

668.94 KB
29725 rows
37 columns

unnamed_0 Unnamed: 0	element Element	fixture Fixture	opponent_team Opponent Team	was_home Was Home	kickoff_time Kickoff Time	team_h_score Team H Score	team_a_score Team A Score	round Round	value Value	transfers_balance Transfers Balance	selected Selected	transfers_in Transfers In	transfers_out Transfers Out
	1	2	16	true	2023-08-12 12:00:00+00:00	2	1	1	45		59090
1	1	12	8		2023-08-21 19:00:00+00:00		1	2	45	-4744	63768	4959	9703
2	1	21	10	true	2023-08-26 14:00:00+00:00	2	2	3	45	-7682	58109	2507	10189
3	1	31	14	true	2023-09-03 15:30:00+00:00	3	1	4	44	-9696	49814	2558	12254
4	1	43	9		2023-09-17 15:30:00+00:00		1	5	44	-12786	37048		12786
5	1	51	18	true	2023-09-24 13:00:00+00:00	2	2	6	44	-4527	32878		4527
6	1	62	3		2023-09-30 14:00:00+00:00		4	7	44	-3132	29679		3132
7	1	71	13	true	2023-10-08 15:30:00+00:00	1		8	44	-2349	27390		2349
8	1	84	7		2023-10-21 16:30:00+00:00	2	2	9	44	-1453	26039		1453
9	1	91	17	true	2023-10-28 14:00:00+00:00	5		10	44	-1085	24948		1085


CREATE TABLE fixture_stats (
  "unnamed_0" BIGINT,
  "element" BIGINT,
  "fixture" BIGINT,
  "opponent_team" BIGINT,
  "total_points" DOUBLE,
  "was_home" BOOLEAN,
  "kickoff_time" VARCHAR,
  "team_h_score" DOUBLE,
  "team_a_score" DOUBLE,
  "round" BIGINT,
  "minutes" DOUBLE,
  "goals_scored" DOUBLE,
  "assists" DOUBLE,
  "clean_sheets" DOUBLE,
  "goals_conceded" DOUBLE,
  "own_goals" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_missed" DOUBLE,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "saves" DOUBLE,
  "bonus" DOUBLE,
  "bps" DOUBLE,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" DOUBLE,
  "ict_index" DOUBLE,
  "starts" DOUBLE,
  "expected_goals" DOUBLE,
  "expected_assists" DOUBLE,
  "expected_goal_involvements" DOUBLE,
  "expected_goals_conceded" DOUBLE,
  "value" BIGINT,
  "transfers_balance" BIGINT,
  "selected" BIGINT,
  "transfers_in" BIGINT,
  "transfers_out" BIGINT
);