# Install the package devtools::install_github("jfjelstul/worldcup") # Load the library library(worldcup) Use code with caution.
If you are looking to download this data in format for local SQL queries, data science projects, or application development, here is a comprehensive guide on how to access and use it. What is in the Fjelstul World Cup Database?
The database is structured into containing over 1.58 million data points . These are organized into logical groups to make relational queries easy: Tournaments: Host countries, winners, dates, and formats. Matches: Scores, lineups, and match-level statistics. worldcup sqlite jfjelstul download
Once downloaded, the file can be queried using Python (sqlite3 library), DB Browser for SQLite, or any SQL client.
SELECT m.year, m.home_team, m.away_team, m.home_goals + m.away_goals AS goals, (SELECT COUNT(*) FROM cards c WHERE c.match_id = m.match_id) AS cards, goals + cards AS total_events FROM matches m ORDER BY total_events DESC LIMIT 1; The database is structured into containing over 1
sqlite3 world_cup.db
Josh Fjelstul also maintains a World Cup Database on Kaggle . You can download the data in various formats, including CSVs which can be easily imported into a SQLite database using tools like . 3. Using the R Package ( worldcup ) Once downloaded, the file can be queried using
The database is provided in the SQLite format ( worldcup.sqlite ), which is a self-contained, serverless, zero-configuration, transactional SQL database engine.
Open a terminal or command prompt and navigate to the directory where your World Cup data CSV file is located. Create a new SQLite database file by typing: