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.
Squad lists and official appointments for managers and referees. Historical data on individual player awards. How to Use the SQLite File jfjelstul worldcup sqlite download
Nevertheless, you should double‑check the README for any (e.g., citing FIFA or the original data sources). The , created by Joshua C
SELECT m.match_id, t1.team_name AS home, t2.team_name AS away, COUNT(*) AS total_cards FROM cards c JOIN matches m ON c.match_id = m.match_id JOIN teams t1 ON m.home_team_id = t1.team_id JOIN teams t2 ON m.away_team_id = t2.team_id GROUP BY m.match_id ORDER BY total_cards DESC LIMIT 5; created by Joshua C. Fjelstul