Football Matches Results
A dataset of football matches results
@kaggle.rodrigoazs_football_results
A dataset of football matches results
@kaggle.rodrigoazs_football_results
The idea of this dataset is to include different tournaments/championships for international and the principal national competitions as well friendly matches .
Currently it contains more than 78000 matches for:
The schema of the files are the following:
date - date of the matchhome_team - the name of the home teamhome_score - full-time home team score including extra time, not including penalty-shootoutsaway_score - full-time away team score including extra time, not including penalty-shootoutsaway_team - the name of the away teamneutral - True/False column indicating whether the match was played at a neutral venueknockout - True/False if the the situation of a team is decided in this single matchstage - indicating the stage of the match in the tournamenttournament_name - the name of the tournamenttournament_year - the year of the tournamentIf you notice a mistake or want to update the dataset, you can submit a pull request on Github: https://github.com/rodrigoazs/football-matches-dataset
CREATE TABLE results (
"date" TIMESTAMP,
"home_team" VARCHAR,
"home_score" BIGINT,
"away_score" BIGINT,
"away_team" VARCHAR,
"neutral" BOOLEAN,
"knockout" BOOLEAN,
"stage" VARCHAR,
"tournament_name" VARCHAR,
"tournament_year" BIGINT
);CREATE TABLE teams (
"team" VARCHAR,
"full_name" VARCHAR,
"country" VARCHAR
);Anyone who has the link will be able to view this.