| Table | Description | Key Fields | |-------|-------------|-------------| | tournaments | Each World Cup edition | tournament_id , year , country , winner , host | | teams | National teams | team_id , team_code , team_name | | players | Individual players | player_id , given_name , family_name , position | | managers | Team managers | manager_id , given_name , family_name |
| Aspect | Detail | |--------|--------| | File size (uncompressed) | ~20 MB | | Compression | None (SQLite) | | SQLite version | 3.x compatible | | Encoding | UTF-8 | | Indexes present | Foreign keys, match_id, player_id, team_id, tournament_id | | Views | None (intentional – user creates as needed) | | Triggers | None | jfjelstul worldcup sqlite download
sqlite3 worldcup.sqlite "SELECT team_name FROM teams WHERE team_code = 'BRA';" | Table | Description | Key Fields |
: Navigate to the official GitHub repository and download the .sqlite file from the data-sqlite/ folder. The , created by Joshua C
Squads, goals, substitutions, and bookings. Staff & Officials: Managers and referees.
The , created by Joshua C. Fjelstul, Ph.D., is one of the most comprehensive open-source datasets available for football analytics. It covers every men’s FIFA World Cup from 1930 to 2022 and every women’s tournament from 1991 to 2019.
Unlike the CSV and JSON versions, which often have pre-merged variables for convenience, the .