Premier League Player's Stats

@kaggle.sophieg_premier_league_players_stats

Table List

5 tables(1.08 MB)

Events

Fixtures

Fixture Stats

Players

Teams

Teams

@kaggle.sophieg_premier_league_players_stats.teams

10.87 KB
20 rows
13 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	5	1350	1365	1370	1370	1330	1360	1
1	7	2	Aston Villa	AVL	4	1160	1285	1140	1220	1180	1350	2
2	91	3	Bournemouth	BOU	3	1100	1100	1055	1130	1145	1075	127
3	94	4	Brentford	BRE	3	1100	1100	1110	1055	1090	1150	130
4	36	5	Brighton	BHA	3	1100	1210	1070	1180	1135	1240	131
5	90	6	Burnley	BUR	2	1045	1050	1050	1050	1040	1050	43
6	8	7	Chelsea	CHE	3	1125	1190	1080	1150	1170	1230	4
7	31	8	Crystal Palace	CRY	3	1070	1100	1080	1120	1060	1085	6
8	11	9	Everton	EVE	3	1095	1100	1125	1125	1065	1080	7
9	54	10	Fulham	FUL	3	1055	1175	1050	1180	1060	1170	34


CREATE TABLE teams (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "short_name" VARCHAR,
  "strength" DOUBLE,
  "strength_overall_home" DOUBLE,
  "strength_overall_away" DOUBLE,
  "strength_attack_home" DOUBLE,
  "strength_attack_away" DOUBLE,
  "strength_defence_home" DOUBLE,
  "strength_defence_away" DOUBLE,
  "pulse_id" BIGINT
);