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

Matchday Results

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.matchday_results

16.6 KB
380 rows
11 columns

unnamed_0 Unnamed: 0	fixture_id Fixture.id	fixture_date Fixture.date	teams_home_id Teams.home.id	teams_home_name Teams.home.name	teams_home_winner Teams.home.winner	teams_away_id Teams.away.id	teams_away_name Teams.away.name	teams_away_winner Teams.away.winner	goals_home Goals.home	goals_away Goals.away
	592141	2021-01-12T20:15:00+00:00	44	Burnley	False	33	Manchester United	True		1
1	592142	2020-09-12T14:00:00+00:00	52	Crystal Palace	True	41	Southampton	False	1
2	592143	2020-09-12T11:30:00+00:00	36	Fulham	False	42	Arsenal	True		3
3	592144	2020-09-12T16:30:00+00:00	40	Liverpool	True	63	Leeds	False	4	3
4	592145	2021-01-20T18:00:00+00:00	50	Manchester City	True	66	Aston Villa	False	2
5	592146	2020-09-13T15:30:00+00:00	47	Tottenham	False	45	Everton	True		1
6	592147	2020-09-13T13:00:00+00:00	60	West Brom	False	46	Leicester	True		3
7	592148	2020-09-12T19:00:00+00:00	48	West Ham	False	34	Newcastle	True		2
8	592149	2020-09-14T19:15:00+00:00	51	Brighton	False	49	Chelsea	True	1	3
9	592150	2020-09-14T17:00:00+00:00	62	Sheffield Utd	False	39	Wolves	True		2


CREATE TABLE matchday_results (
  "unnamed_0" BIGINT,
  "fixture_id" BIGINT,
  "fixture_date" VARCHAR,
  "teams_home_id" BIGINT,
  "teams_home_name" VARCHAR,
  "teams_home_winner" VARCHAR,
  "teams_away_id" BIGINT,
  "teams_away_name" VARCHAR,
  "teams_away_winner" VARCHAR,
  "goals_home" BIGINT,
  "goals_away" BIGINT
);