Domestic Football Results From 1888 To 2019

A dataset of over 1 million football results

@kaggle.schochastics_domestic_football_results_from_1888_to_2019

Table List

1 table(12.24 MB)

Football Results

@kaggle.schochastics_domestic_football_results_from_1888_to_2019.football_results

12.24 MB
1078214 rows
17 columns

home Home	away Away	date Date	gh Gh	ga Ga	full_time Full Time	competition Competition	home_ident Home Ident	away_ident Away Ident	home_country Home Country	away_country Away Country	home_code Home Code	away_code Away Code	home_continent Home Continent	away_continent Away Continent	continent Continent	level Level
Bolton Wanderers	Derby County	Sat Sep 08 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	3	6	F	england	Bolton Wanderers (England)	Derby County (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Everton FC	Accrington FC	Sat Sep 08 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	F	england	Everton FC (England)	Accrington FC (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Preston North End	Burnley FC	Sat Sep 08 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	5	2	F	england	Preston North End (England)	Burnley FC (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Stoke City	West Bromwich Albion	Sat Sep 08 1888 00:00:00 GMT+0000 (Coordinated Universal Time)		2	F	england	Stoke City (England)	West Bromwich Albion (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Wolverhampton Wanderers	Aston Villa	Sat Sep 08 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	F	england	Wolverhampton Wanderers (England)	Aston Villa (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Aston Villa	Stoke City	Sat Sep 15 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	5	1	F	england	Aston Villa (England)	Stoke City (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Blackburn Rovers	Accrington FC	Sat Sep 15 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	5	5	F	england	Blackburn Rovers (England)	Accrington FC (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Bolton Wanderers	Burnley FC	Sat Sep 15 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	3	4	F	england	Bolton Wanderers (England)	Burnley FC (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Derby County	West Bromwich Albion	Sat Sep 15 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2	F	england	Derby County (England)	West Bromwich Albion (England)	england	england	ENG	ENG	Europe	Europe	Europe	national
Everton FC	Notts County	Sat Sep 15 1888 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	F	england	Everton FC (England)	Notts County (England)	england	england	ENG	ENG	Europe	Europe	Europe	national


CREATE TABLE football_results (
  "home" VARCHAR,
  "away" VARCHAR,
  "date" TIMESTAMP,
  "gh" BIGINT,
  "ga" BIGINT,
  "full_time" VARCHAR,
  "competition" VARCHAR,
  "home_ident" VARCHAR,
  "away_ident" VARCHAR,
  "home_country" VARCHAR,
  "away_country" VARCHAR,
  "home_code" VARCHAR,
  "away_code" VARCHAR,
  "home_continent" VARCHAR,
  "away_continent" VARCHAR,
  "continent" VARCHAR,
  "level" VARCHAR
);