Premier League Player's Stats

@kaggle.sophieg_premier_league_players_stats

Table List

5 tables(1.08 MB)

Events

Fixtures

Fixture Stats

Players

Teams

Fixtures

@kaggle.sophieg_premier_league_players_stats.fixtures

165.01 KB
380 rows
19 columns

unnamed_0 Unnamed: 0	code Code	event Event	finished Finished	finished_provisional Finished Provisional	id Id	kickoff_time Kickoff Time	minutes Minutes	started Started	team_a Team A	team_a_score Team A Score	team_h Team H	team_h_score Team H Score	stats Stats	team_h_difficulty Team H Difficulty	team_a_difficulty Team A Difficulty	pulse_id Pulse Id	end_time End Time
	2367538	1	true	true	1	2023-08-11 19:00:00+00:00	90	true	13	3	6		[{'identifier': 'goals_scored', 'a': [{'value': 2, 'element': 355}, {'value': 1, 'element': 365}], 'h': []}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 343}, {'value': 1, 'element': 365}], 'h': []}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': []…	5	2	93321	2023-08-11 20:30:00+00:00
1	2367540	1	true	true	2	2023-08-12 12:00:00+00:00	90	true	16	1	1	2	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 437}], 'h': [{'value': 1, 'element': 13}, {'value': 1, 'element': 19}]}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 378}], 'h': [{'value': 1, 'element': 12}, {'value': 1, 'element': 20}]}, {'identifier': 'own_goals', 'a': [],…	2	5	93322	2023-08-12 13:30:00+00:00
2	2367539	1	true	true	3	2023-08-12 14:00:00+00:00	90	true	19	1	3	1	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 526}], 'h': [{'value': 1, 'element': 85}]}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 542}], 'h': [{'value': 1, 'element': 82}]}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': [], 'h':…	2	2	93323	2023-08-12 15:30:00+00:00
3	2367541	1	true	true	4	2023-08-12 14:00:00+00:00	90	true	12	1	5	4	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 326}], 'h': [{'value': 1, 'element': 122}, {'value': 1, 'element': 132}, {'value': 1, 'element': 135}, {'value': 1, 'element': 140}]}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 631}], 'h': [{'value': 1, 'element': 131}, {'va…	2	3	93324	2023-08-12 15:30:00+00:00
4	2367542	1	true	true	5	2023-08-12 14:00:00+00:00	90	true	10	1	9		[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 270}], 'h': []}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 267}], 'h': []}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': [], 'h': []}, {'identifier': 'penalties_missed', 'a': [], 'h':…	2	2	93325	2023-08-12 15:30:00+00:00
5	2367544	1	true	true	7	2023-08-12 14:00:00+00:00	90	true	8	1	17		[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 225}], 'h': []}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 221}], 'h': []}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': [], 'h': []}, {'identifier': 'penalties_missed', 'a': [], 'h':…	2	2	93327	2023-08-12 15:30:00+00:00
6	2367543	1	true	true	6	2023-08-12 16:30:00+00:00	90	true	2	1	15	5	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 599}], 'h': [{'value': 2, 'element': 415}, {'value': 1, 'element': 429}, {'value': 1, 'element': 433}, {'value': 1, 'element': 603}]}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 60}], 'h': [{'value': 1, 'element': 405}, {'val…	3	4	93326	2023-08-12 18:00:00+00:00
7	2367545	1	true	true	8	2023-08-13 13:00:00+00:00	90	true	18	2	4	2	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 497}, {'value': 1, 'element': 511}], 'h': [{'value': 1, 'element': 108}, {'value': 1, 'element': 119}]}, {'identifier': 'assists', 'a': [{'value': 2, 'element': 504}], 'h': [{'value': 1, 'element': 103}, {'value': 1, 'element': 106}]}, {'…	3	2	93328	2023-08-13 14:30:00+00:00
8	2367546	1	true	true	9	2023-08-13 15:30:00+00:00	90	true	11	1	7	1	[{'identifier': 'goals_scored', 'a': [{'value': 1, 'element': 303}], 'h': [{'value': 1, 'element': 611}]}, {'identifier': 'assists', 'a': [{'value': 1, 'element': 308}], 'h': [{'value': 1, 'element': 195}]}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': [], 'h…	4	3	93329	2023-08-13 17:00:00+00:00
9	2367547	1	true	true	10	2023-08-14 19:00:00+00:00	90	true	20		14	1	[{'identifier': 'goals_scored', 'a': [], 'h': [{'value': 1, 'element': 395}]}, {'identifier': 'assists', 'a': [], 'h': [{'value': 1, 'element': 401}]}, {'identifier': 'own_goals', 'a': [], 'h': []}, {'identifier': 'penalties_saved', 'a': [], 'h': []}, {'identifier': 'penalties_missed', 'a': [], 'h':…	2	4	93330	2023-08-14 20:30:00+00:00


CREATE TABLE fixtures (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "event" BIGINT,
  "finished" BOOLEAN,
  "finished_provisional" BOOLEAN,
  "id" BIGINT,
  "kickoff_time" VARCHAR,
  "minutes" DOUBLE,
  "provisional_start_time" BOOLEAN,
  "started" BOOLEAN,
  "team_a" BIGINT,
  "team_a_score" DOUBLE,
  "team_h" BIGINT,
  "team_h_score" DOUBLE,
  "stats" VARCHAR,
  "team_h_difficulty" DOUBLE,
  "team_a_difficulty" DOUBLE,
  "pulse_id" BIGINT,
  "end_time" VARCHAR
);