International Football Results

40,000 international football results from 1872 to 2020

@kaggle.eng0mohamed0nabil_international_football_results

Table List

1 table(482.59 KB)

Results

@kaggle.eng0mohamed0nabil_international_football_results.results

482.59 KB
41586 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
);