Football Match Statistics

This dataset contains 25 years of football match statistics from 18 leagues.

@kaggle.gokhanergul_football_match_statistics

Table List

1 table(6.26 MB)

Football

@kaggle.gokhanergul_football_match_statistics.football

6.26 MB
95384 rows
91 columns

country Country	league League	home_team Home Team	away_team Away Team	home_score Home Score	away_score Away Score	season_year Season Year	date_day Date Day	date_hour Date Hour	first_half First Half	second_half Second Half	home_team_goals_current_time Home Team Goals Current Time	home_team_goals_current_score Home Team Goals Current Score	home_team_goals Home Team Goals	home_team_goals_assist Home Team Goals Assist	away_team_goals_current_time Away Team Goals Current Time	away_team_goals_current_score Away Team Goals Current Score	away_team_goals Away Team Goals	away_team_goals_assist Away Team Goals Assist	home_team_yellow_card_current_time Home Team Yellow Card Current Time	home_team_yellow_card Home Team Yellow Card	home_team_yellow_card_why Home Team Yellow Card Why	away_team_yellow_card_current_time Away Team Yellow Card Current Time	away_team_yellow_card Away Team Yellow Card	away_team_yellow_card_why Away Team Yellow Card Why	home_team_red_card_current_time Home Team Red Card Current Time	home_team_red_card Home Team Red Card	home_team_red_card_why Home Team Red Card Why	away_team_red_card_current_time Away Team Red Card Current Time	away_team_red_card Away Team Red Card	away_team_red_card_why Away Team Red Card Why	home_team_substitutions_current_time Home Team Substitutions Current Time	home_team_substitutions Home Team Substitutions	home_team_substitutions_with Home Team Substitutions With	home_team_substitution_why Home Team Substitution Why	away_team_substitutions_current_time Away Team Substitutions Current Time	away_team_substitutions Away Team Substitutions	away_team_substitutions_with Away Team Substitutions With	away_team_substitution_why Away Team Substitution Why	expected_goals_xg_home Expected Goals Xg Home	expected_goals_xg_host Expected Goals Xg Host	ball_possession_home Ball Possession Home	ball_possession_host Ball Possession Host	goal_attempts_home Goal Attempts Home	goal_attempts_host Goal Attempts Host	shots_on_goal_home Shots On Goal Home	shots_on_goal_host Shots On Goal Host	shots_off_goal_home Shots Off Goal Home	shots_off_goal_host Shots Off Goal Host	blocked_shots_home Blocked Shots Home	blocked_shots_host Blocked Shots Host	free_kicks_home Free Kicks Home	free_kicks_host Free Kicks Host	corner_kicks_home Corner Kicks Home	corner_kicks_host Corner Kicks Host	offsides_home Offsides Home	offsides_host Offsides Host	throw_ins_home Throw Ins Home	throw_ins_host Throw Ins Host	goalkeeper_saves_home Goalkeeper Saves Home	goalkeeper_saves_host Goalkeeper Saves Host	fouls_home Fouls Home	fouls_host Fouls Host	red_cards_host Red Cards Host	yellow_cards_home Yellow Cards Home	yellow_cards_host Yellow Cards Host	total_passes_home Total Passes Home	total_passes_host Total Passes Host	completed_passes_home Completed Passes Home	completed_passes_host Completed Passes Host	tackles_home Tackles Home	tackles_host Tackles Host	crosses_completed_home Crosses Completed Home	crosses_completed_host Crosses Completed Host	interceptions_home Interceptions Home	interceptions_host Interceptions Host	referee Referee	venue Venue	capacity Capacity	attendance Attendance
Germany	Bundesliga	B. Monchengladbach	Werder Bremen	4	1	2024/2025	3.11	19:30	3 - 0	1 - 1	["11'", "12'", "45'", "66'"]	['1 - 0', '2 - 0', '3 - 0', '4 - 0']	['Plea A.', 'Friedl M.', 'Honorat F.', 'Stoger K.']	['(Kleindienst T.)', '(Own goal)', '(Kleindienst T.)', '(Kleindienst T.)']	["75'"]	['4 - 1']	['Topp K.']	['(Ducksch M.)']	["79'"]	['Itakura K.']	['(Roughing)']	["19'", "22'", "53'"]	['Agu F.', 'Weiser M.', 'Lynen S.']	['(Roughing)', '(Foul)', '(Foul)']	nan	nan	nan	["82'"]	['Weiser M.']	['(Foul)']	["63'", "71'", "71'", "77'", "77'"]	['Stoger K.', 'Neuhaus F.', 'Cvancara T.', 'Chiarodia F. C.', 'Ngoumou N.']	['Plea A.', 'Hack R.', 'Kleindienst T.', 'Ullrich L.', 'Honorat F.']	['-', '-', '-', '-', '-']	["46'", "46'", "46'", "68'", "81'"]	['Veljkovic M.', 'Jung A.', 'Kohn D.', 'Topp K.', 'Burke O.']	['Malatini J.', 'Pieper A.', 'Agu F.', 'Njinmah J.', 'Bittencourt L.']	['-', '-', '-', '-', '-']	2.39	1.46	47%	53%	16	15	8	5	7	5	1	5	10	12	7	7	2	1	20	20	4	4	12	10	1	1	4	479	549	395	453	90.0	99.0	5	7	12	11	Dankert B. (Ger)	Borussia-Park (Mönchengladbach)	54 042	54 042
Germany	Bundesliga	Freiburg	Mainz	0	0	2024/2025	3.11	17:30	0 - 0	0 - 0	nan	nan	nan	nan	nan	nan	nan	nan	["90+2'"]	['Sildillia K.']	['(Roughing)']	["44'", "70'"]	['Lee Jae-Sung', 'Bell S.']	['(Foul)', '(Roughing)']	nan	nan	nan	nan	nan	nan	["66'", "66'", "66'", "72'", "88'"]	['Hofler N.', 'Weisshaupt N.', 'Rosenfelder M.', 'Gregoritsch M.', 'Sildillia K.']	['Eggestein M.', 'Grifo V.', 'Lienhart P.', 'Adamu J.', 'Doan R.']	['-', '-', '-', '-', '-']	["46'", "74'", "90'", "90+3'"]	['Sieb A.', 'Hong Hyun-Seok', 'Widmer S.', 'Veratschnig N.']	['Burkardt J.', 'Amiri N.', 'Caci A.', 'Nebel P.']	['-', '-', '-', '-']	0.77	0.53	51%	49%	10	9	2	2	3	5	5	2	12	9	8	4	2	2	22	18	2	2	9	12		1	2	471	443	377	362	83.0	87.0	3	3	8	15	Brand B. (Ger)	Europa-Park Stadion (Freiburg)	34 700	34 400
Germany	Bundesliga	Dortmund	RB Leipzig	2	1	2024/2025	2.11	20:30	1 - 1	1 - 0	["30'", "65'"]	['1 - 1', '2 - 1']	['Beier M.', 'Guirassy S.']	['(Nmecha F.)', '(Beier M.)']	["27'"]	['0 - 1']	['Sesko B.']	['(Openda L.)']	["21'", "34'", "90+7'"]	['Beier M.', 'Bensebaini R.', 'Azhil A.']	['(Foul)', '(Roughing)', '(Foul)']	["8'", "35'", "40'", "81'"]	['Baumgartner C.', 'Henrichs B.', 'Geertruida L.', 'Kampl K.']	['(Holding)', '(Holding)', '(Roughing)', '(Roughing)']	nan	nan	nan	nan	nan	nan	["67'", "79'", "90+4'"]	['Azhil A.', 'Malen D.', 'Campbell C.']	['Sabitzer M.', 'Gittens J.', 'Beier M.']	['(Injury)', '-', '-']	["64'", "64'", "70'", "70'", "82'"]	['Elmas E.', 'Kampl K.', 'Poulsen Y.', 'Bitshiabu E.', 'Ouedraogo A.']	['Baumgartner C.', 'Haidara A.', 'Sesko B.', 'Henrichs B.', 'Nusa A.']	['-', '-', '-', '-', '-']	2.71	0.41	56%	44%	19	7	7	3	5	1	7	3	12	11	4		2	2	36	13	2	5	11	12		3	4	528	418	424	321	97.0	109.0	6	1	8	8	Stieler T. (Ger)	Signal Iduna Park (Dortmund)	81 365	81 365
Germany	Bundesliga	Bayern Munich	Union Berlin	3	0	2024/2025	2.11	17:30	2 - 0	1 - 0	["15'", "43'", "51'"]	['1 - 0', '2 - 0', '3 - 0']	['Kane H.', 'Coman K.', 'Kane H.']	['(Penalty)', '(Kane H.)', '(Coman K.)']	nan	nan	nan	nan	nan	nan	nan	["31'", "84'"]	['Kemlein A.', 'Khedira R.']	['(Holding)', '(Tripping)']	nan	nan	nan	nan	nan	nan	["69'", "69'", "69'", "74'", "80'"]	['Goretzka L.', 'Sane L.', 'Dier E.', 'Muller T.', 'Aznou A.']	['Kim Min-Jae', 'Olise M.', 'Palhinha J.', 'Musiala J.', 'Davies A.']	['-', '-', '-', '-', '-']	["60'", "60'", "69'", "69'", "80'"]	['Vertessen Y.', 'Skarke T.', 'Schafer A.', 'Haberer J.', 'Roussillon J.']	['Hollerbach B.', 'Siebatcheu J.', 'Kemlein A.', 'Jeong Woo-Yeong', 'Vogt K.']	['-', '-', '-', '-', '-']	2.48	0.5	77%	23%	16	8	7	1	4	3	5	4	9	2	7	4	1	3	16	18	1	4	2	9			2	866	244	794	169	104.0	79.0	3	4	6	11	Jollenbeck M. (Ger)	Allianz Arena (Munich)	75 024	75 000
Germany	Bundesliga	Eintracht Frankfurt	Bochum	7	2	2024/2025	2.11	17:30	4 - 1	3 - 1	["9'", "18'", "20'", "32'", "61'", "66'", "69'"]	['1 - 0', '2 - 0', '3 - 0', '4 - 0', '5 - 2', '6 - 2', '7 - 2']	['Ekitike H.', 'Marmoush O.', 'Knauff A.', 'Brown N.', 'Dahoud M.', 'Uzun C. Y.', 'Ekitike H.']	['(Marmoush O.)', '-', '-', '(Collins N.)', '(Skhiri E.)', '(Marmoush O.)', '(Dahoud M.)']	["35'", "51'"]	['4 - 1', '4 - 2']	['de Wit D.', 'Hofmann P.']	['(Masovic E.)', '(Passlack F.)']	["50'"]	['Knauff A.']	['(Holding)']	["38'", "77'"]	['Ordets I.', 'Hofmann P.']	['(Tripping)', '(Delay of game)']	nan	nan	nan	nan	nan	nan	["65'", "73'", "73'", "73'", "82'"]	['Uzun C. Y.', 'Matanovic I.', 'Larsson H.', 'Chandler T.', 'Amenda A.']	['Bahoya J.', 'Marmoush O.', 'Skhiri E.', 'Koch R.', 'Tuta']	['-', '-', '-', '-', '-']	["32'", "46'", "46'", "67'", "82'"]	['Holtmann G.', 'Oermann T.', 'Bero M.', 'Gamboa C.', 'Daschner L.']	['Wittek M.', 'Miyoshi K.', 'Broschinski M.', 'Passlack F.', 'Hofmann P.']	['-', '-', '-', '-', '(Injury)']	1.97	1.66	65%	35%	18	11	9	8	3	3	6		15	6	5	2		1	13	22	6	2	6	15		1	2	594	324	500	223	137.0	103.0	6	5	11	5	Schlager D. (Ger)	Deutsche Bank Park (Frankfurt)	58 000	58 000
Germany	Bundesliga	Hoffenheim	St. Pauli	0	2	2024/2025	2.11	17:30	0 - 1	0 - 1	nan	nan	nan	nan	["20'", "90+3'"]	['0 - 1', '0 - 2']	['Afolayan O.', 'Albers A.']	['(Irvine J.)', '(Irvine J.)']	nan	nan	nan	["64'", "70'"]	['Guilavogui M.', 'Blessin A.']	['(Holding)', '(Not on pitch)']	nan	nan	nan	nan	nan	nan	["46'", "66'", "66'", "85'", "85'"]	['Tabakovic H.', 'Berisha M.', 'Jurasek D.', 'Kaderabek P.', 'Bruun Larsen J.']	['Hlozek A.', 'Bulter M.', 'Prass A.', 'Arthur Chaves', 'Gendrey V.']	['-', '-', '-', '-', '-']	["50'", "80'", "88'", "88'"]	['Ritzka L.', 'Wagner R.', 'Dzwigala A.', 'Albers A.']	['Treu P.', 'Afolayan O.', 'Saliakas M.', 'Eggestein J.']	['-', '-', '-', '-']	1.16	0.82	68%	32%	12	7	6	3	3	1	3	3	10	10	7	2	2		37	21	1	6	10	10			2	631	295	525	219	106.0	103.0	7	2	8	15	Stegemann S. (Ger)	PreZero Arena (Sinsheim)	30 150	26 199
Germany	Bundesliga	Holstein Kiel	Heidenheim	1	0	2024/2025	2.11	17:30	1 - 0	0 - 0	["28'"]	['1 - 0']	['Erras P.']	['(Geschwill M.)']	nan	nan	nan	nan	["35'", "38'", "59'", "84'"]	['Gigovic A.', 'Remberg N.', 'Porath F.', 'Knudsen M.']	['(Unsportsmanlike conduct)', '(Tripping)', '(Foul)', '(Foul)']	["17'", "33'", "67'", "70'", "76'"]	['Siersleben T.', 'Gimber B.', 'Mainka P.', 'Schoppner J.', 'Pieringer M.']	['(Foul)', '(Foul)', '(Unsportsmanlike conduct)', '(Foul)', '(Tripping)']	nan	nan	nan	nan	nan	nan	["46'", "46'", "78'", "78'", "85'"]	['Rosenboom L.', 'Porath F.', 'Schulz M.', 'Komenda M.', 'Pichler B.']	['Becker T.', 'Gigovic A.', 'Skrzybski S.', 'Puchacz T.', 'Harres P.']	['-', '-', '-', '-', '-']	["46'", "74'", "74'", "85'", "85'"]	['Honsak M.', 'Kaufmann M.', 'Breunig M.', 'Beck A.', 'Conteh S.']	['Siersleben T.', 'Gimber B.', 'Dorsch N.', 'Wanner P.', 'Pieringer M.']	['-', '-', '-', '-', '-']	1.76	1	46%	54%	11	17	6	4	4	9	1	4	14	16	5	6	1		16	35	4	5	16	14		4	5	318	400	242	304	91.0	96.0	3	9	8	12	Willenborg F. (Ger)	Holstein-Stadion (Kiel)	15 034	14 000
Germany	Bundesliga	Wolfsburg	Augsburg	1	1	2024/2025	2.11	17:30	0 - 1	1 - 0	["82'"]	['1 - 1']	['Amoura M.']	['(Maehle J.)']	["34'"]	['0 - 1']	['Tietz P.']	['(Schlotterbeck K.)']	["88'"]	['Amoura M.']	['(Roughing)']	["74'", "77'", "87'"]	['Matsima C.', 'Rexhbecaj E.', 'Essende S.']	['(Roughing)', '(Delay of game, misses next match)', '(Foul)']	nan	nan	nan	nan	nan	nan	["57'", "57'", "68'", "80'", "80'"]	['Behrens K.', 'Majer L.', 'Gerhardt Y.', 'Nmecha L.', 'Kaminski J.']	['Fischer K.', 'Wind J.', 'Majer L.', 'Tomas T.', 'Baku R.']	['-', '-', '(Injury)', '-', '-']	["66'", "66'", "77'", "77'"]	['Essende S.', 'Kabadayi Y.', 'Koudossou H.', 'Maier A.']	['Tietz P.', 'Claude-Maurice A.', 'Wolf M.', 'Rexhbecaj E.']	['-', '-', '-', '-']	1.3	0.36	70%	30%	18	3	6	1	5	2	7		14	7	8	1		1	22	20		5	7	14		1	3	626	254	533	182	94.0	111.0	5		5	10	Brych F. (Ger)	Volkswagen Arena (Wolfsburg)	28 917	25 000
Germany	Bundesliga	Bayer Leverkusen	Stuttgart	0	0	2024/2025	1.11	22:30	0 - 0	0 - 0	nan	nan	nan	nan	nan	nan	nan	nan	["30'", "42'", "51'"]	['Andrich R.', 'Mukiele N.', 'Xhaka G.']	['(Roughing)', '(Roughing)', '(Unsportsmanlike conduct)']	["52'", "56'", "68'", "69'"]	['Karazor A.', 'Millot E.', 'Chase A.', 'Stiller A.']	['(Holding)', '(Unsportsmanlike conduct)', '(Unsportsmanlike conduct)', '(Unsportsmanlike conduct)']	nan	nan	nan	nan	nan	nan	["54'", "86'", "86'", "86'"]	['Hofmann J.', 'Tella N.', 'Palacios E.', 'Schick P.']	['Mukiele N.', 'Frimpong J.', 'Andrich R.', 'Boniface V.']	['(Injury)', '-', '-', '-']	["8'", "58'", "58'", "80'", "80'"]	['Rieder F.', 'Hendriks R.', 'Fuhrich C.', 'Demirovic E.', 'Al Dakhil A.']	['Leweling J.', 'Mittelstadt M.', 'Rieder F.', 'Toure E. B.', 'Millot E.']	['(Injury)', '-', '-', '-', '-']	2.19	0.28	52%	48%	19	4	5	1	9	2	5	1	14	13	10	2	9		18	9	1	5	13	14		3	4	426	408	373	350	111.0	100.0	9		8	10	Siebert D. (Ger)	BayArena (Leverkusen)	30 210	30 210
Germany	Bundesliga	Heidenheim	Hoffenheim	0	0	2024/2025	27.1	21:30	0 - 0	0 - 0	nan	nan	nan	nan	nan	nan	nan	nan	["32'"]	['Pieringer M.']	['(Tripping)']	["33'", "90'"]	['Stach A.', 'Berisha M.']	['(Roughing)', '(Tripping)']	nan	nan	nan	nan	nan	nan	["70'", "70'", "84'"]	['Breunig M.', 'Conteh S.', 'Beck A.']	['Pieringer M.', 'Dorsch N.', 'Wanner P.']	['-', '-', '-']	["58'", "58'", "67'", "83'", "83'"]	['Tohumcu U.', 'Kaderabek P.', 'Berisha M.', 'Samassekou D.', 'Arthur Chaves']	['Grillitsch F.', 'Gendrey V.', 'Bulter M.', 'Bischof T.', 'Nsoki S.']	['-', '-', '-', '-', '-']	1.29	0.56	47%	53%	17	12	3	4	12	3	2	5	16	12	7	3			25	21	4	3	12	16		1	2	360	443	290	355	nan	nan	2	3	5	10	Dingert C. (Ger)	Voith-Arena (Heidenheim)	15 000	15 000


CREATE TABLE football (
  "country" VARCHAR,
  "league" VARCHAR,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" VARCHAR,
  "away_score" VARCHAR,
  "season_year" VARCHAR,
  "date_day" DOUBLE,
  "date_hour" VARCHAR,
  "first_half" VARCHAR,
  "second_half" VARCHAR,
  "home_team_goals_current_time" VARCHAR,
  "home_team_goals_current_score" VARCHAR,
  "home_team_goals" VARCHAR,
  "home_team_goals_assist" VARCHAR,
  "away_team_goals_current_time" VARCHAR,
  "away_team_goals_current_score" VARCHAR,
  "away_team_goals" VARCHAR,
  "away_team_goals_assist" VARCHAR,
  "home_team_yellow_card_current_time" VARCHAR,
  "home_team_yellow_card" VARCHAR,
  "home_team_yellow_card_why" VARCHAR,
  "away_team_yellow_card_current_time" VARCHAR,
  "away_team_yellow_card" VARCHAR,
  "away_team_yellow_card_why" VARCHAR,
  "home_team_red_card_current_time" VARCHAR,
  "home_team_red_card" VARCHAR,
  "home_team_red_card_why" VARCHAR,
  "away_team_red_card_current_time" VARCHAR,
  "away_team_red_card" VARCHAR,
  "away_team_red_card_why" VARCHAR,
  "home_team_substitutions_current_time" VARCHAR,
  "home_team_substitutions" VARCHAR,
  "home_team_substitutions_with" VARCHAR,
  "home_team_substitution_why" VARCHAR,
  "away_team_substitutions_current_time" VARCHAR,
  "away_team_substitutions" VARCHAR,
  "away_team_substitutions_with" VARCHAR,
  "away_team_substitution_why" VARCHAR,
  "expected_goals_xg_home" DOUBLE,
  "expected_goals_xg_host" DOUBLE,
  "ball_possession_home" VARCHAR,
  "ball_possession_host" VARCHAR,
  "goal_attempts_home" DOUBLE,
  "goal_attempts_host" DOUBLE,
  "shots_on_goal_home" DOUBLE,
  "shots_on_goal_host" DOUBLE,
  "shots_off_goal_home" DOUBLE,
  "shots_off_goal_host" DOUBLE,
  "blocked_shots_home" DOUBLE,
  "blocked_shots_host" DOUBLE,
  "free_kicks_home" DOUBLE,
  "free_kicks_host" DOUBLE,
  "corner_kicks_home" DOUBLE,
  "corner_kicks_host" DOUBLE,
  "offsides_home" DOUBLE,
  "offsides_host" DOUBLE,
  "throw_ins_home" DOUBLE,
  "throw_ins_host" DOUBLE,
  "goalkeeper_saves_home" DOUBLE,
  "goalkeeper_saves_host" DOUBLE,
  "fouls_home" DOUBLE,
  "fouls_host" DOUBLE,
  "red_cards_home" DOUBLE,
  "red_cards_host" DOUBLE,
  "yellow_cards_home" DOUBLE,
  "yellow_cards_host" DOUBLE,
  "total_passes_home" DOUBLE,
  "total_passes_host" DOUBLE,
  "completed_passes_home" DOUBLE,
  "completed_passes_host" DOUBLE,
  "tackles_home" VARCHAR,
  "tackles_host" VARCHAR,
  "crosses_completed_home" DOUBLE,
  "crosses_completed_host" DOUBLE,
  "interceptions_home" DOUBLE,
  "interceptions_host" DOUBLE,
  "attacks_home" DOUBLE,
  "attacks_host" DOUBLE,
  "dangerous_attacks_home" DOUBLE,
  "dangerous_attacks_host" DOUBLE,
  "distance_covered_km_home" DOUBLE,
  "distance_covered_km_host" DOUBLE,
  "clearances_completed_home" DOUBLE,
  "clearances_completed_host" DOUBLE,
  "pass_success_per_home" DOUBLE,
  "pass_success_per_host" DOUBLE,
  "referee" VARCHAR,
  "venue" VARCHAR,
  "capacity" VARCHAR,
  "attendance" VARCHAR
);