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

Away Teams Stats

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.away_teams_stats

25.77 KB
380 rows
20 columns

unnamed_0 Unnamed: 0	fixture_id Fixture Id	away_team_id Away Team Id	away_team_name Away 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	33	Manchester United	7	2	13	4	9	4	13	4	2	63%	2		566	475	84%
1	592142	41	Southampton	5	3	9	1	7	2	11	3		71%	1	2	580	458	79%
2	592143	42	Arsenal	6	4	13	3	9	4	12	3	2	55%	2	2	626	562	90%
3	592144	63	Leeds	3	1	6	2	4	2	6		5	52%		3	459	347	76%
4	592145	66	Aston Villa	4	4	11	3	6	5	9	2	1	31%	2	7	285	207	73%
5	592146	45	Everton	4	7	15	4	10	5	7	3	1	49%		5	529	450	85%
6	592147	46	Leicester	7	3	13	3	11	2	9	5	3	65%	1	1	604	511	85%
7	592148	34	Newcastle	2	7	15	6	10	5	7	7	4	42%	2	3	342	266	78%
8	592149	49	Chelsea	5	2	10	3	7	3	13	3	3	48%		2	465	387	83%
9	592150	39	Wolves	4	5	11	2	7	4	7	5		45%	1	1	391	307	79%


CREATE TABLE away_teams_stats (
  "unnamed_0" BIGINT,
  "fixture_id" BIGINT,
  "away_team_id" BIGINT,
  "away_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
);