International Football Results From 1872 To 2024

An up-to-date dataset of over 47,000 international football results

@kaggle.martj42_international_football_results_from_1872_to_2017

Table List

3 tables(1.03 MB)

Goalscorers

Results

Shootouts

Results

@kaggle.martj42_international_football_results_from_1872_to_2017.results

541.09 KB
47917 rows
9 columns

date Date	home_team Home Team	away_team Away Team	home_score Home Score	away_score Away Score	tournament Tournament	city City	country Country
Sat Nov 30 1872 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	England			Friendly	Glasgow	Scotland
Sat Mar 08 1873 00:00:00 GMT+0000 (Coordinated Universal Time)	England	Scotland	4	2	Friendly	London	England
Sat Mar 07 1874 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	England	2	1	Friendly	Glasgow	Scotland
Sat Mar 06 1875 00:00:00 GMT+0000 (Coordinated Universal Time)	England	Scotland	2	2	Friendly	London	England
Sat Mar 04 1876 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	England	3		Friendly	Glasgow	Scotland
Sat Mar 25 1876 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	Wales	4		Friendly	Glasgow	Scotland
Sat Mar 03 1877 00:00:00 GMT+0000 (Coordinated Universal Time)	England	Scotland	1	3	Friendly	London	England
Mon Mar 05 1877 00:00:00 GMT+0000 (Coordinated Universal Time)	Wales	Scotland		2	Friendly	Wrexham	Wales
Sat Mar 02 1878 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	England	7	2	Friendly	Glasgow	Scotland
Sat Mar 23 1878 00:00:00 GMT+0000 (Coordinated Universal Time)	Scotland	Wales	9		Friendly	Glasgow	Scotland


CREATE TABLE results (
  "date" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "tournament" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "neutral" BOOLEAN
);