Fjelstul also maintains a similar comprehensive database for English football (1888–2024), also available in SQLite format.
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; worldcup sqlite jfjelstul download
Hosts get a boost, but do they win more? Fjelstul also maintains a similar comprehensive database for
import sqlite3 import pandas as pd
If you haven't already, download and install SQLite on your computer. SQLite comes with a command-line tool that allows you to create, modify, and query databases. m.home_goals + m.away_goals AS goals