Dataset: Fifa Worldcup 2022 Results

About this Dataset

Fifa Worldcup 2022 Results

Context

The biggest festival on planet earth is back again after 4 years. A total of 32 teams will compete with each other to own the Fifa World Cup 2022 Trophy for 29 days, from 20 No20 November 2022 to 18 December 2022. It takes place in Qatar.

Content

Get the results of every match of Fifa World Cup 2022 Qatar. For every match there are 2 records, the first record is for the team 1 and the second record is for the team 2.

Source:

The data is directly collected from the Fifa official website.

What to do?

Do some EDA or statistical analysis.

Details about the Dataset:

There is a total of 38 columns in this dataset. And the records will update daily basis until the festival will end.

Note: In the dataset, there are 5 columns that are about the channels' position. Channels is the name given to certain areas of the pitch, created by the space between players and groups of players. And to know more about the reception, you can get the details from here.

Column Name	Details
Sl. No:	Serial number.
Match No.:	The match number which was held in Fifa World Cup 2022 Qatar.
Team:	The country/team name
Against:	Opponent country team name
Group:	In which group, the team belongs to
Goal:	How many goals this team had done
Possession (%):	Possession is physical control of the ball or other implements of play by one team, which typically gives that team the opportunity to score.
Inside Penalty Area:	How much goals have done from the penalty area.
Outside Penalty Area:	How much goals have done from outside the penalty area.
Assists:	Assist is a contribution by a player which helps to score a goal.
Total Attempts:	Total attempts at goal by the team.
On Target:	Total attempts at goal which are on target.
Off Target:	Total attempts at goal which are off target.
Target in Penalty:	Total attempts at goal have done from the penalty area.
Target from Outside:	Total attempts at goal have done from outside of the penalty area.
Left Channel:	Left channel.
Left Inside Channel:	Left inside channel.
Central Channel:	Central channel.
Right Inside Channel:	Right inside channel.
Right Channel:	Right channel.
Receptions MD:	Receptions Between Midfield and Defensive Lines.
Receptions D:	Receptions Between Defensive Lines.
Attempted Line Breaks:	Total attempted line breaks.
Completed Line Breaks:	Total successful line breaks.
Attempted Defensive Line Breaks:	Total attempted defensive line breaks.
Completed Defensive Line Breaks:	Total successful defensive line breaks.
Yellow Cards:	Total yellow cards the team got.
Red Cards:	Total red cards the team got.
Fouls Against:	Total fouls.
Offsides:	Total offsides.
Passes:	Total passes have done.
Passes Completed:	Total successful passes during the match.
Crosses:	Total crosses have done.
Crosses Completed:	Total successful crosses have done.
Corners:	How much corners this team got during the match.
Free Kicks:	How much free kicks this team got during the match.
Penalties Scored:	How much this team has done penalty goals.
Pts:	How much points got this team. Collected from the result table.

Happy coding.

Tables

Fifa Worldcup 2022

@kaggle.sayanroy729_fifa_worldcup_2022_results.fifa_worldcup_2022

34.72 KB
128 rows
38 columns


CREATE TABLE fifa_worldcup_2022 (
  "sl_no" BIGINT,
  "match_no" BIGINT,
  "team" VARCHAR,
  "against" VARCHAR,
  "group" VARCHAR,
  "goal" BIGINT,
  "possession" BIGINT,
  "inside_penalty_area" BIGINT,
  "outside_penalty_area" BIGINT,
  "assists" BIGINT,
  "total_attempts" BIGINT,
  "on_target" BIGINT,
  "off_target" BIGINT,
  "target_in_penalty" BIGINT,
  "target_from_outside" BIGINT,
  "left_channel" BIGINT,
  "left_inside_channel" BIGINT,
  "central_channel" BIGINT,
  "right_inside_channel" BIGINT,
  "right_channel" BIGINT,
  "receptions_md" BIGINT,
  "receptions_d" BIGINT,
  "attempted_line_breaks" BIGINT,
  "completed_line_breaks" BIGINT,
  "attempted_defensive_line_breaks" BIGINT,
  "completed_defensive_line_breaks" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "fouls_against" BIGINT,
  "offsides" BIGINT,
  "passes" BIGINT,
  "passes_completed" BIGINT,
  "crosses" BIGINT,
  "crosses_completed" BIGINT,
  "corners" BIGINT,
  "free_kicks" BIGINT,
  "penalties_scored" BIGINT,
  "pts" BIGINT
);