Name: Domestic Football Results From 1888 To 2019
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Domestic Football Results From 1888 To 2019

Context

I have gathered this dataset over the course of 8 years and put a lot of effort in
it (see soccerverse.com). If you use the data for any kind of project, please drop me a line
or ping me on twitter.

Content

The dataset contains results of 1,078,214 football games in 207 top-tier domestic leagues and
20 international tournaments (UEFA EuroLeague/ChampionsLeague,etc.) from 1888-2019

variable	description
home	home team name (not necessarily unique)
away	away team name (not necessarily unique)
date	date of match
gh	goals for home team (including extra time and penalties)
ga	goals for away team (including extra time and penalties)
full_time	"F"=game ended in 90', "E"=extra time, "P"=penalty shoot-out
competition	country name of league or name of international competition
home_ident	unique identifier of home team
away_ident	unique identifier of away team
home_country	country of home team
away_country	country of away team
home_code	country code of home team
away_code	country code of away team
home_continent	continent of home team
away_continent	continent of away team
continent	continent of competition
level	"national"= domestic league, "international"= international cup

Tables

Football Results

@kaggle.schochastics_domestic_football_results_from_1888_to_2019.football_results

12.83 MB
1,078,214 rows
17 columns

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
);