Fjelstul World Cup Database Csv -

SELECT year, tournament FROM fjelstul_world_cup_database ORDER BY year;

The database has been cited by major news outlets including The Washington Post , FiveThirtyEight , and The Times . The Fjelstul World Cup Database - GitHub fjelstul world cup database csv

SELECT DISTINCT winner AS country FROM fjelstul_world_cup_database UNION SELECT DISTINCT runner_up AS country FROM fjelstul_world_cup_database UNION SELECT DISTINCT third_place AS country FROM fjelstul_world_cup_database; tournament FROM fjelstul_world_cup_database ORDER BY year

To identify successful teams, you can use the winner , runner_up , and third_place columns. For example, to get a list of countries that have won the World Cup: To identify successful teams

Matches, squads, goals, penalty kicks, bookings (yellow/red cards), and substitutions.