Premier League 2020-21 Season Stats

all 38 matchday stats about premier league season 2020-21

@kaggle.afnanurrahim_premier_league_2020_21_season_stats

Table List

3 tables(68.25 KB)

Away Teams Stats

Home Teams Stats

Matchday Results

Home Teams Stats

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.home_teams_stats

25.88 KB
380 rows
20 columns

unnamed_0 Unnamed: 0	fixture_id Fixture Id	home_team_id Home Team Id	home_team_name Home Team Name	shots_on_goal Shots On Goal	shots_off_goal Shots Off Goal	total_shots Total Shots	blocked_shots Blocked Shots	shots_insidebox Shots Insidebox	shots_outsidebox Shots Outsidebox	fouls Fouls	corner_kicks Corner Kicks	offsides Offsides	ball_possession Ball Possession	yellow_cards Yellow Cards	goalkeeper_saves Goalkeeper Saves	total_passes Total Passes	passes_accurate Passes Accurate	passes Passes %
	592141	44	Burnley		6	11	5	6	5	15	3	3	37%	1	6	334	220	66%
1	592142	52	Crystal Palace	3	2	5		5		14	7	4	29%	2	5	236	121	51%
2	592143	36	Fulham	2	2	5	1	1	4	12	2	2	45%	2	2	523	461	88%
3	592144	40	Liverpool	6	3	22	13	17	5	9	9	2	48%	1		432	328	76%
4	592145	50	Manchester City	9	7	28	12	20	8	10	16	3	69%		4	628	553	88%
5	592146	47	Tottenham	5	1	9	3	8	1	15	5		51%	1	3	552	470	85%
6	592147	60	West Brom	1	3	7	3	3	4	12	2	4	35%	1	4	336	255	76%
7	592148	48	West Ham	3	5	15	7	10	5	13	8	2	58%	2		474	393	83%
8	592149	51	Brighton	3	6	13	4	7	6	8	4		52%	1	2	507	414	82%
9	592150	62	Sheffield Utd	2	5	9	2	8	1	13	12	4	55%	2	2	460	373	81%


CREATE TABLE home_teams_stats (
  "unnamed_0" BIGINT,
  "fixture_id" BIGINT,
  "home_team_id" BIGINT,
  "home_team_name" VARCHAR,
  "shots_on_goal" DOUBLE,
  "shots_off_goal" DOUBLE,
  "total_shots" BIGINT,
  "blocked_shots" DOUBLE,
  "shots_insidebox" DOUBLE,
  "shots_outsidebox" DOUBLE,
  "fouls" BIGINT,
  "corner_kicks" DOUBLE,
  "offsides" DOUBLE,
  "ball_possession" VARCHAR,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "goalkeeper_saves" DOUBLE,
  "total_passes" BIGINT,
  "passes_accurate" BIGINT,
  "passes" VARCHAR
);