WorldCups.ai

The WorldCups.ai Database

The WorldCups.ai Database, created by Josh Fjelstul, Ph.D., contains 27 datasets that cover every aspect of every World Cup (since 1930) — including the men's and women's tournaments. The database covers matches, players, goals, bookings, substitutions, managers, referees, stadiums, awards, and more. There are two versions of each table: a relational version and a curated version. The curated versions have relevant variables from other tables already merged in. See the documentation for details.
Read documentation

License

By downloading data from the the WorldCups.ai Database, you're agreeing to the terms of the CC-BY-SA 4.0 license, including an obgligation to correctly cite it. Please read the license carefully. You can use the data for personal projects, but not for commerical projects. Contact us to discuss a commercial license. See the documentation for more information.
Read license

Entity tables

These tables contain one record per entity, which are the basic units of observation — tournaments, confederations, teams, matches, players, managers, referees, stadiums, and awards
Tournaments
18 variables
30 observations
One observation per tournament. Includes the host country, the winner, the start and end dates of the tournament, and information about the format of each tournament.
Confederations
5 variables
6 observations
One observation per confederation. Records all FIFA confederations.
Teams
14 variables
88 observations
One observation per team. Includes the 3-letter ISO code for each country and information about each country's national federation and FIFA confederation.
Matches
38 variables
1,248 observations
One observation per match. Includes the stage, the location (country, city, stadium), the teams involved, the final score, the score margin, whether the match went to extra time, whether there was a penalty shootout, and the result.
Players
13 variables
10,401 observations
One observation per player. Includes name, birth date, and a link to their Wikipedia page. Does not include team, as a small number of players represent different countries in different tournaments.
Managers
7 variables
475 observations
One observation per manager. Includes name, home country, and a link to their Wikipedia page.
Referees
10 variables
493 observations
One observation per referee. Includes name, home country, confederation, and a link to their Wikipedia page.
Stadiums
8 variables
240 observations
One observation per stadium. Includes the country and city, the approximate capacity, and links to the Wikipedia pages for the city and the stadium.
Awards
5 variables
8 observations
One observation per award. Records all individual awards handed out to players, including the name of the award, the year it was first introduced, and a description.

Tournament tables

These tables describe how each tournament was organized and how each tournament progressed — which country hosted, which teams qualified, what the stages of the tournament were, what the groups were, what the final group standings were, what the final tournament standings were, and what awards were presented.
Host Countries
7 variables
31 observations
One observation per host country per tournament. A tournament can have multiple host countries. Includes the performance of each host country.
Tournament Stages
16 variables
155 observations
One observation per stage per tournament. Records the name of the stage, whether it is a group stage or knockout stage, dates, and counts of matches, teams, scheduled games, replays, walkovers, and playoffs.
Groups
7 variables
117 observations
One observation per group per group stage per tournament. Records the name of each group and the number of teams in the group.
Group Standings
19 variables
626 observations
One observation per team per group per group stage per tournament. Includes final position, matches played, wins, losses, draws, goals for and against, goal difference, points, and whether the team advanced.
Tournament Standings
7 variables
120 observations
One observation per position per tournament. Records the final rankings — the top four teams in each tournament.
Award Winners
12 variables
200 observations
One observation per player per award per tournament. Records all individual player awards, the player and team, and whether the award was shared.

Registration tables

These tables map teams, players, managers, and referees to tournaments — which teams qualified for each tournament, which players were registered in each squad, which managers were appointed to which teams, and which referees were appointed to each tournament
Qualified Teams
8 variables
625 observations
One observation per team per tournament. Records which teams qualified and how each team performed — the furthest stage reached.
Squads
14 variables
13,843 observations
One observation per player per team per tournament. Includes the name, position, and shirt number of each player (shirt numbers from 1954 onward).
Manager Appointments
10 variables
637 observations
One observation per manager per team per tournament. Some teams have co-managers. Includes the team and home country of each manager.
Referee Appointments
10 variables
668 observations
One observation per referee per tournament. Includes only the main referee — not assistant referees, fourth officials, or video assistant referees.

Appearance tables

These tables map teams, players, managers, and referees to individual matches — which teams participated in each match, which players participated in each match, which managers were in charge for each match, and which referees participated in each match.
Team Appearances
37 variables
2,496 observations
One observation per team per match. Includes whether the team is home or away, goals for and against, goal difference, penalty shootout details, and whether the team wins, loses, or draws.
Player Appearances
21 variables
27,432 observations
One observation per player per match (from 1970 onward). Includes players in the starting eleven and players who come on as substitutes. Players on the bench who are not substituted in appear in squads but not here.
Manager Appearances
17 variables
2,538 observations
One observation per manager per team per match. Some teams have co-managers.
Referee Appearances
15 variables
1,248 observations
One observation per referee per match.

Event tables

These tables record in-match events — every goal, every booking, every substitution, and every penalty kick. They include information about the player involed in the event.
Goals
26 variables
3,637 observations
One observation per goal. Includes the team credited, the player who scored, the player's team (to account for own goals), the minute, and whether the goal was an own goal or a penalty. Does not include converted penalties in a shootout.
Bookings
26 variables
3,178 observations
One observation per booking (from 1970 onward). Includes the minute, the player, whether the booking was a yellow or red card, whether it was a second yellow, and whether the player was sent off.
Substitutions
24 variables
10,222 observations
One observation per player per substitution (from 1970 onward). Includes the minute and the players going off and coming on.
Penalty Kicks
19 variables
396 observations
One observation per penalty kick in a shootout. Includes the minute, the player, and whether the kick was converted. Does not include penalty kicks taken during normal play.