International Football From 1872 To 2022

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

@kaggle.whenamancodes_international_football_from_1872_to_2022

Table List

2 tables(512.94 KB)

Results

@kaggle.whenamancodes_international_football_from_1872_to_2022.results

499.87 KB
44060 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" DOUBLE,
  "away_score" DOUBLE,
  "tournament" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "neutral" BOOLEAN
);