EPL 2022: Player Statistics (historic & Current)

Data to be used for fantasy prediction & analysis

@kaggle.slythe_epl_2022_player_statistics_historic_current

Table List

4 tables(295.65 KB)

Player Current Stats

Player Hist Stats

Player Upcoming Fixtures

Teams

Teams

@kaggle.slythe_epl_2022_player_statistics_historic_current.teams

15.97 KB
20 rows
22 columns

unnamed_0 Unnamed: 0	code Code	id Id	name Name	short_name Short Name	strength Strength	strength_overall_home Strength Overall Home	strength_overall_away Strength Overall Away	strength_attack_home Strength Attack Home	strength_attack_away Strength Attack Away	strength_defence_home Strength Defence Home	strength_defence_away Strength Defence Away	pulse_id Pulse Id
	3	1	Arsenal	ARS	4	1200	1270	1160	1230	1160	1240	1
1	7	2	Aston Villa	AVL	3	1090	1100	1110	1110	1070	1090	2
2	91	3	Bournemouth	BOU	2	1050	1070	1070	1110	1040	1070	127
3	94	4	Brentford	BRE	3	1100	1150	1100	1150	1140	1170	130
4	36	5	Brighton	BHA	3	1140	1140	1170	1160	1150	1170	131
5	8	6	Chelsea	CHE	4	1210	1230	1230	1220	1200	1210	4
6	31	7	Crystal Palace	CRY	3	1090	1150	1090	1180	1080	1160	6
7	11	8	Everton	EVE	3	1080	1100	1090	1090	1090	1110	7
8	54	9	Fulham	FUL	3	1070	1090	1090	1090	1100	1120	34
9	13	10	Leicester	LEI	3	1100	1100	1070	1080	1150	1100	26


CREATE TABLE teams (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "draw" BIGINT,
  "form" VARCHAR,
  "id" BIGINT,
  "loss" BIGINT,
  "name" VARCHAR,
  "played" BIGINT,
  "points" BIGINT,
  "position" BIGINT,
  "short_name" VARCHAR,
  "strength" BIGINT,
  "team_division" VARCHAR,
  "unavailable" BOOLEAN,
  "win" BIGINT,
  "strength_overall_home" BIGINT,
  "strength_overall_away" BIGINT,
  "strength_attack_home" BIGINT,
  "strength_attack_away" BIGINT,
  "strength_defence_home" BIGINT,
  "strength_defence_away" BIGINT,
  "pulse_id" BIGINT
);