Name: FIFA World Cup
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FIFA World Cup

As we count down to the start of the FIFA World Cup in Qatar on November 20, this new dataset covers every single World Cup match played in its history from Uruguay in 1930 to Russia in 2018.

The wcmatches dataset contains every football match played in the World Cup. Columns inside the dataset include city from which city was the match being played in, outcome which team claimed victory or did the match result in a draw, win_condition showing if the winning side need added extra time of penalties to win the game.

It also includes a summary of each World Cup held, the cups dataset contains columns winners, games, goals_scored, and more.

Analysis ideas

Find out which teams have the most wins
Figure out the best teams for offense and defense by goals per game
Predict the 2022 FIFA World Cup winner

Tables

Wcmatches

@kaggle.evangower_fifa_world_cup.wcmatches

26.36 kB
900 rows
15 columns

CREATE TABLE wcmatches (
  "year" BIGINT,
  "country" VARCHAR,
  "city" VARCHAR,
  "stage" VARCHAR,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "outcome" VARCHAR,
  "win_conditions" VARCHAR,
  "winning_team" VARCHAR,
  "losing_team" VARCHAR,
  "date" TIMESTAMP,
  "month" VARCHAR,
  "dayofweek" VARCHAR
);

Worldcups

@kaggle.evangower_fifa_world_cup.worldcups

8.2 kB
21 rows
10 columns

CREATE TABLE worldcups (
  "year" BIGINT,
  "host" VARCHAR,
  "winner" VARCHAR,
  "second" VARCHAR,
  "third" VARCHAR,
  "fourth" VARCHAR,
  "goals_scored" BIGINT,
  "teams" BIGINT,
  "games" BIGINT,
  "attendance" BIGINT
);