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

About this Dataset

FIFA World Cup

Context

The FIFA World Cup is a global football competition contested by the various football-playing nations of the world. It is contested every four years and is the most prestigious and important trophy in the sport of football.

Content

The World Cups dataset show all information about all the World Cups in the history, while the World Cup Matches dataset shows all the results from the matches contested as part of the cups.

Acknowledgements

This data is courtesy of the FIFA World Cup Archive website.

Inspiration

Can you predict who will win the next World Cup?

Tables

Worldcupmatches

@kaggle.abecklas_fifa_world_cup.worldcupmatches

67.47 kB
4,572 rows
20 columns

CREATE TABLE worldcupmatches (
  "year" DOUBLE,
  "datetime" VARCHAR,
  "stage" VARCHAR,
  "stadium" VARCHAR,
  "city" VARCHAR,
  "home_team_name" VARCHAR,
  "home_team_goals" DOUBLE,
  "away_team_goals" DOUBLE,
  "away_team_name" VARCHAR,
  "win_conditions" VARCHAR,
  "attendance" DOUBLE,
  "half_time_home_goals" DOUBLE,
  "half_time_away_goals" DOUBLE,
  "referee" VARCHAR,
  "assistant_1" VARCHAR,
  "assistant_2" VARCHAR,
  "roundid" DOUBLE,
  "matchid" DOUBLE,
  "home_team_initials" VARCHAR,
  "away_team_initials" VARCHAR
);

Worldcupplayers

@kaggle.abecklas_fifa_world_cup.worldcupplayers

250.13 kB
37,784 rows
9 columns

CREATE TABLE worldcupplayers (
  "roundid" BIGINT,
  "matchid" BIGINT,
  "team_initials" VARCHAR,
  "coach_name" VARCHAR,
  "line_up" VARCHAR,
  "shirt_number" BIGINT,
  "player_name" VARCHAR,
  "position" VARCHAR,
  "event" VARCHAR
);

Worldcups

@kaggle.abecklas_fifa_world_cup.worldcups

8.31 kB
20 rows
10 columns

CREATE TABLE worldcups (
  "year" BIGINT,
  "country" VARCHAR,
  "winner" VARCHAR,
  "runners_up" VARCHAR,
  "third" VARCHAR,
  "fourth" VARCHAR,
  "goalsscored" BIGINT,
  "qualifiedteams" BIGINT,
  "matchesplayed" BIGINT,
  "attendance" VARCHAR
);