Jfjelstul Worldcup: Data-csv Appearances Csv
: Users can download the data in .csv, .json, and SQLite formats.
Covers the entire history of the World Cup, allowing for longitudinal studies on the evolution of play styles, goal rates, and player longevity.
The 27 datasets are categorized into five logical groups to cover every facet of the tournament: Description Key Datasets Foundation data for core entities with unique IDs. tournaments , teams , players , managers , referees , stadiums Tournament Maps Maps entities (players, teams) to specific World Cup years. player_appearances , team_appearances Match Maps Maps entities to individual matches within a tournament. match_appearances , referee_appearances In-Match Events Granular detail on every significant action. goals , penalty_kicks , bookings , substitutions Tournament Stats High-level outcomes and summaries. standings , awards , qualified_teams Key Features for Analysts jfjelstul worldcup data-csv appearances csv
Unlike datasets that only show total tournament stats, this file allows you to calculate efficiency. You can determine a player's "Goals per 90 Minutes" ratio, which is a much fairer comparison metric for substitutes versus starters.
A full description of every variable and dataset is provided in the codebook/csv/ folder through files like datasets.csv and variables.csv . Core Datasets in the Database : Users can download the data in
For developers, the data is also available on Kaggle , which hosts the same comprehensive documentation and discussion forums. csv for a specific tournament? The Fjelstul World Cup Database - GitHub
: Fjelstul standardized player names and Wikipedia links to resolve common errors found in official FIFA match reports, such as misspellings or inconsistent transliterations. Impact on Sports Analytics tournaments , teams , players , managers ,
The player_appearances dataset is particularly notable for its depth. It records every instance of a player entering the pitch during a match since 1970 (the year substitutions were officially introduced). Unlike simpler datasets that might only list squads, this file identifies:
