Jfjelstul Worldcup Sqlite May 2026

Repository: jfjelstul/worldcup on GitHub Author: Joshua C. Fjelstul, Ph.D. Format: SQLite, CSV, R data package

| Table | Description | |-------|-------------| | WorldCups | Tournament metadata: year, country, winner, runner‑up, third place, goals scored, number of teams, etc. | | Matches | Every match: date, stage (group, round of 16, quarter‑final, semi‑final, final), home/away team, score, attendance, stadium, referee. | | Goals | Each goal: minute, scorer (player ID), own goal flag, penalty flag, match ID. | | Cards | Each card: type (yellow, second yellow, red), minute, player ID, match ID. | | Substitutions | Each substitution: minute on/off, player in/out, match ID. | | Players | Player metadata: name, position, date of birth, shirt number (for recent tournaments). | | Teams | Team name, FIFA code, confederation (UEFA, CONMEBOL, etc.). | | Managers | Manager name, nationality, team, tournament. | | Referees | Referee name, nationality. | | Stadiums | Stadium name, city, country, capacity. | | Appearances | Player‑tournament level data: goals, own goals, assists, minutes played, etc. (derived). | jfjelstul worldcup sqlite

Download the database, run SELECT COUNT(*) FROM Matches; (should return ~900 matches as of 2022), and start exploring. Repository: jfjelstul/worldcup on GitHub Author: Joshua C