: You can easily join a players table with a goals table to see which players scored in which stadium without manual filtering.
CREATE TABLE matches ( id INTEGER PRIMARY KEY, date DATE, team1_id INTEGER, team2_id INTEGER, score TEXT, stadium TEXT, FOREIGN KEY (team1_id) REFERENCES teams (id), FOREIGN KEY (team2_id) REFERENCES teams (id) );
I’ve prepared a clean, version-controlled copy for you. No registration, no paywalls.
: For developers needing a schema to test applications, the FIFAWorldCupDatabase repository provides .sql files to generate a simulation of scores and fixtures specifically for SQLite. Why Choose SQLite for World Cup Data?
The downloadable SQLite file includes these core tables:
Finding a ready-to-use .sqlite or .db file is easier than you might think. Several high-quality, open-source projects host these datasets:
Here's some sample SQL code to create these tables:
: This is perhaps the most comprehensive resource available. It covers all 22 men’s tournaments (1930–2022) and 8 women’s tournaments (1991–2019) with over 1.58 million data points. You can download the SQLite version directly from the data-sqlite folder on GitHub .