Premier League Club Stats (All Seasons)

Stats of 20 clubs from 1992/1993 to current season

@kaggle.raman77768_premier_league_club_stats_all_seasons

Table List

1 table(26.94 KB)

Clubs

@kaggle.raman77768_premier_league_club_stats_all_seasons.clubs

26.94 KB
20 rows
34 columns

club Club	matches_played Matches.played	wins Wins	losses Losses	goals Goals	goals_conceded Goals.conceded	clean_sheets Clean.sheets	goals_per_match Goals.per.match	shots Shots	shots_on_target Shots.on.target	shooting_accuracy Shooting.accuracy	penalties_scored Penalties.scored	big_chances_created Big.chances.created	hit_woodwork Hit.woodwork	passes Passes	passes_per_match Passes.per.match	pass_accuracy Pass.accuracy	crosses Crosses	cross_accuracy Cross.accuracy	goals_conceded_per_match Goals.conceded.per.match	saves Saves	tackles Tackles	tackle_success Tackle.success	blocked_shots Blocked.shots	interceptions Interceptions	clearances Clearances	headed_clearance Headed.Clearance	aerial_battles_duels_won Aerial.Battles.Duels.Won	errors_leading_to_goal Errors.leading.to.goal	own_goals Own.goals	yellow_cards Yellow.cards	red_cards Red.cards	fouls Fouls	offsides Offsides
Arsenal	1076	579	223	1901	1061	411	1.77	8240	2985	36%	59	740	230	285840	265.65	84%	11610	21%	0.99	861	10542	72%	2134	8169	14366	5368	37726	115	41	1632	93	1473	1236
Aston-Villa	963	325	354	1158	1253	275	1.2	5018	1617	32%	37	288	111	151785	157.62	74%	9560	24%	1.3	463	8666	75%	1232	6396	14675	4680	29845	79	46	1430	57	828	960
Bournemouth	190	56	91	241	330	38	1.27	2216	746	34%	24	229	60	81190	427.32	78%	3343	22%	1.74	565	2854	66%	621	2313	5025	2588	13421	46	9	294	9	860	295
Brighton-and-Hove-Albion	114	27	51	108	168	26	0.95	1217	370	30%	11	121	22	46972	412.04	77%	2005	24%	1.47	352	1921	60%	317	1331	2710	1485	8399	12	8	171	8	686	259
Burnley	228	66	109	233	347	58	1.02	2406	776	32%	18	188	61	79179	347.28	70%	4401	24%	1.52	661	3602	68%	611	2919	7342	3732	17964	27	12	393	7	1019	526
Chelsea	1076	578	235	1839	1056	429	1.71	9114	3088	34%	72	618	205	277148	257.57	84%	11913	23%	0.98	634	10447	73%	2445	6781	13385	5087	36810	67	37	1687	78	1366	1317
Crystal-Palace	426	122	198	456	614	107	1.07	3108	992	32%	39	274	75	95498	224.17	74%	5249	23%	1.44	804	5085	70%	828	3988	7428	3955	21708	57	17	669	23	1524	471
Everton	1076	390	380	1401	1367	330	1.3	7120	2417	34%	50	530	169	219548	204.04	77%	12007	23%	1.27	761	10189	74%	1910	7222	17572	6242	37422	89	53	1641	96	1569	1150
Leicester-City	536	175	217	690	761	143	1.29	2889	985	34%	32	340	61	92718	172.98	75%	4707	21%	1.42	647	4385	68%	752	3379	5807	3040	18107	24	29	769	50	1340	403
Liverpool	1077	561	250	1859	1079	409	1.73	9034	3063	34%	69	666	263	278421	258.52	82%	12052	22%	1	584	11407	73%	2311	6814	14371	5082	36984	92	40	1339	59	1379	1219


CREATE TABLE clubs (
  "club" VARCHAR,
  "matches_played" BIGINT,
  "wins" BIGINT,
  "losses" BIGINT,
  "goals" BIGINT,
  "goals_conceded" BIGINT,
  "clean_sheets" BIGINT,
  "goals_per_match" DOUBLE,
  "shots" BIGINT,
  "shots_on_target" BIGINT,
  "shooting_accuracy" VARCHAR,
  "penalties_scored" BIGINT,
  "big_chances_created" BIGINT,
  "hit_woodwork" BIGINT,
  "passes" BIGINT,
  "passes_per_match" DOUBLE,
  "pass_accuracy" VARCHAR,
  "crosses" BIGINT,
  "cross_accuracy" VARCHAR,
  "goals_conceded_per_match" DOUBLE,
  "saves" BIGINT,
  "tackles" BIGINT,
  "tackle_success" VARCHAR,
  "blocked_shots" BIGINT,
  "interceptions" BIGINT,
  "clearances" BIGINT,
  "headed_clearance" BIGINT,
  "aerial_battles_duels_won" BIGINT,
  "errors_leading_to_goal" BIGINT,
  "own_goals" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "fouls" BIGINT,
  "offsides" BIGINT
);