Worldwide Football Results (1872-2022)

More than 100 years updated dataset over 42,000 FIFA results

@kaggle.zeesolver_fifa_results

Table List

3 tables(979.22 KB)

Decision

Fifa Results

Penality Kick

Decision

@kaggle.zeesolver_fifa_results.decision

502.58 KB
44353 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 decision (
  "date" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "tournament" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "neutral" BOOLEAN
);