tournaments ──┬── matches ──┬── goals │ ├── cards │ ├── substitutions │ ├── penalty_shootouts │ ├── appearances ── players │ └── team_appearances ── teams └── referees
Fjelstul, Joshua C. (2025). The World Cup Database (Version 2.3.0) [Data set]. GitHub. https://github.com/jfjelstul/worldcup Appendix: Quick Schema Diagram (simplified) jfjelstul worldcup sqlite download
1. Overview & Purpose Repository: jfjelstul/worldcup (GitHub / Zenodo) Author: Joshua C. Fjelstul, Ph.D. Format: SQLite database ( worldcup.sqlite ) Data Coverage: All FIFA World Cups (men's 1930–2022, women's 1991–2023) License: Creative Commons Attribution 4.0 International (CC BY 4.0) this database provides a clean
For anyone needing to answer questions like “Which player scored the most extra-time goals?” or “Does higher possession correlate with winning in knockout matches?”, this database provides a clean, verifiable, and immediately queryable foundation. and immediately queryable foundation.