FIFA World Cup 2022 Match Data

Comprehensive match data from the FIFA World Cup 2022

@kaggle.swaptr_fifa_world_cup_2022_match_data

Table List

1 table(47.57 KB)

Data

@kaggle.swaptr_fifa_world_cup_2022_match_data.data

47.57 KB
64 rows
53 columns

match Match	dayofweek Dayofweek	match_time Match Time	home_team Home Team	away_team Away Team	home_xg Home Xg	away_xg Away Xg	score Score	attendance Attendance	venue Venue	referee Referee	home_formation Home Formation	away_formation Away Formation	home_captain Home Captain	away_captain Away Captain	home_manager Home Manager	away_manager Away Manager	home_possession Home Possession	away_possession Away Possession	home_completed_passes Home Completed Passes	home_attempted_pases Home Attempted Pases	away_completed_passes Away Completed Passes	away_attempted_pases Away Attempted Pases	home_sot Home Sot	away_sot Away Sot	home_total_shots Home Total Shots	away_total_shots Away Total Shots	home_saves Home Saves	away_saves Away Saves	home_fouls Home Fouls	away_fouls Away Fouls	home_corners Home Corners	away_corners Away Corners	home_crosses Home Crosses	away_crosses Away Crosses	home_touches Home Touches	away_touches Away Touches	home_tackles Home Tackles	away_tackles Away Tackles	home_interceptions Home Interceptions	away_interceptions Away Interceptions	home_aerials_won Home Aerials Won	away_aerials_won Away Aerials Won	home_clearances Home Clearances	away_clearances Away Clearances	home_offsides Home Offsides	away_offsides Away Offsides	home_gks Home Gks	away_gks Away Gks	home_throw_ins Home Throw Ins	away_throw_ins Away Throw Ins	home_long_balls Home Long Balls	away_long_balls Away Long Balls
1	Sun	Sun Nov 20 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	Qatar	Ecuador	0.3	1.2	0–2	67372	Al Bayt Stadium	Daniele Orsato	5-3-2	4-4-2	Hassan Al-Haydos	Enner Valencia	Félix Sánchez	Gustavo Alfaro	47	53	377	469	430	522		2	5	5	1		15	15	1	3	8	14	549	601	10	14	2	12	14	13	18	7	3	4	4	7	20	17	51	70
2	Mon	Mon Nov 21 2022 16:00:00 GMT+0000 (Coordinated Universal Time)	England	IR Iran	2.1	1.4	6–2	45334	Khalifa International Stadium	Raphael Claus	4-2-3-1	5-4-1	Harry Kane	Ehsan Hajsafi	Gareth Southgate	Carlos Queiroz	77	23	740	838	162	248	7	2	13	7	1	1	9	14	8		21	8	922	341	13	12	7	16	10	10	4	23	2	2	5	5	18	17	87	50
3	Mon	Mon Nov 21 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	Senegal	Netherlands	0.9	0.7	0–2	41721	Al Thumama Stadium	Wilton Sampaio	4-2-3-1	3-4-1-2	Kalidou Koulibaly	Virgil van Dijk	Aliou Cissé	Louis van Gaal	46	54	333	427	387	494	4	3	15	10	1	4	13	13	6	7	19	25	531	573	14	10	10	6	22	20	32	16	2	1	6	10	17	28	64	66
4	Mon	Mon Nov 21 2022 22:00:00 GMT+0000 (Coordinated Universal Time)	United States	Wales	0.8	1.5	1–1	43418	Ahmed bin Ali Stadium	Abdulrahman Ibrahim Al Jassim	4-3-3	3-5-2	Tyler Adams	Gareth Bale	Gregg Berhalter	Rob Page	58	42	524	624	335	446	1	2	6	6	2		15	10	5	3	30	14	724	568	14	18	6	8	14	12	18	31	1	1	5	10	22	25	56	90
5	Tue	Tue Nov 22 2022 13:00:00 GMT+0000 (Coordinated Universal Time)	Argentina	Saudi Arabia	2.2	0.1	1–2	88012	Lusail Iconic Stadium	Slavko Vinčič	4-4-2	4-1-4-1	Lionel Messi	Salman Al-Faraj	Lionel Scaloni	Hervé Renard	69	31	546	659	195	294	5	2	14	3		5	7	21	9	2	23	10	753	411	17	18	9	14	16	7	11	26	10	1	3	9	24	13	55	59
6	Tue	Tue Nov 22 2022 16:00:00 GMT+0000 (Coordinated Universal Time)	Denmark	Tunisia	1.4	0.9	0–0	42925	Education City Stadium	César Arturo Ramos	3-5-2	3-4-3	Simon Kjær	Youssef Msakni	Kasper Hjulmand	Jalel Kadri	61	39	533	649	308	419	5	1	11	13	1	5	9	10	11	9	25	13	751	545	12	24	11	8	20	13	12	38	1	1	6	6	24	24	84	77
7	Tue	Tue Nov 22 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	Mexico	Poland	0.7	0.9	0–0	39369	Stadium 974	Chris Beath	4-3-3	4-1-4-1	Guillermo Ochoa	Robert Lewandowski	Tata Martino	Czesław Michniewicz	60	40	436	547	255	363	4	1	11	5	1	4	14	15	6	5	33	15	649	469	16	17	5	8	16	18	19	29	3		7	9	21	23	64	79
8	Tue	Tue Nov 22 2022 22:00:00 GMT+0000 (Coordinated Universal Time)	France	Australia	4	0.5	4–1	40875	Al Janoub Stadium	Victor Gomes	4-2-3-1	4-1-4-1	Hugo Lloris	Mathew Ryan	Didier Deschamps	Graham Arnold	62	38	678	768	391	473	6	1	23	4		2	5	11	8	1	27	6	870	563	20	13	12	9	16	8	6	23			8	10	17	21	60	53
9	Wed	Wed Nov 23 2022 13:00:00 GMT+0000 (Coordinated Universal Time)	Morocco	Croatia	0.4	0.5	0–0	59407	Al Bayt Stadium	Fernando Rapallini	4-3-3	4-3-3	Romain Saïss	Luka Modrić	Hoalid Regragui	Zlatko Dalić	36	64	298	384	581	693	2	1	8	5	1	2	16	11		5	8	18	502	783	21	17	13	10	14	12	21	11		1	4	5	22	27	47	57
10	Wed	Wed Nov 23 2022 16:00:00 GMT+0000 (Coordinated Universal Time)	Germany	Japan	3.1	1.5	1–2	42608	Khalifa International Stadium	Iván Barton	4-2-3-1	4-2-3-1	Manuel Neuer	Maya Yoshida	Hansi Flick	Hajime Moriyasu	74	26	727	836	204	298	8	4	25	12	2	8	6	14	6	6	25	11	932	440	11	29	3	6	21	12	4	38	4	4	8	10	33	12	64	64


CREATE TABLE data (
  "match" BIGINT,
  "dayofweek" VARCHAR,
  "match_time" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_xg" DOUBLE,
  "away_xg" DOUBLE,
  "score" VARCHAR,
  "attendance" BIGINT,
  "venue" VARCHAR,
  "referee" VARCHAR,
  "home_formation" VARCHAR,
  "away_formation" VARCHAR,
  "home_captain" VARCHAR,
  "away_captain" VARCHAR,
  "home_manager" VARCHAR,
  "away_manager" VARCHAR,
  "home_possession" BIGINT,
  "away_possession" BIGINT,
  "home_completed_passes" BIGINT,
  "home_attempted_pases" BIGINT,
  "away_completed_passes" BIGINT,
  "away_attempted_pases" BIGINT,
  "home_sot" BIGINT,
  "away_sot" BIGINT,
  "home_total_shots" BIGINT,
  "away_total_shots" BIGINT,
  "home_saves" BIGINT,
  "away_saves" BIGINT,
  "home_fouls" BIGINT,
  "away_fouls" BIGINT,
  "home_corners" BIGINT,
  "away_corners" BIGINT,
  "home_crosses" BIGINT,
  "away_crosses" BIGINT,
  "home_touches" BIGINT,
  "away_touches" BIGINT,
  "home_tackles" BIGINT,
  "away_tackles" BIGINT,
  "home_interceptions" BIGINT,
  "away_interceptions" BIGINT,
  "home_aerials_won" BIGINT,
  "away_aerials_won" BIGINT,
  "home_clearances" BIGINT,
  "away_clearances" BIGINT,
  "home_offsides" BIGINT,
  "away_offsides" BIGINT,
  "home_gks" BIGINT,
  "away_gks" BIGINT,
  "home_throw_ins" BIGINT,
  "away_throw_ins" BIGINT,
  "home_long_balls" BIGINT,
  "away_long_balls" BIGINT
);