Baselight

Football Matches Results

A dataset of football matches results

@kaggle.rodrigoazs_football_results

Loading...
Loading...

About this Dataset

Football Matches Results

Context

The idea of this dataset is to include different tournaments/championships for international and the principal national competitions as well friendly matches .

Content

Currently it contains more than 78000 matches for:

  1. Brasileirao Seria A ranging from 1971 to 2023
  2. Copa do Brasil ranging from 1989 to 2023
  3. National teams matches from 1872.
  4. Copa Libertadores from 1960 to 2023.

Schema

The schema of the files are the following:

  • date - date of the match
  • home_team - the name of the home team
  • home_score - full-time home team score including extra time, not including penalty-shootouts
  • away_score - full-time away team score including extra time, not including penalty-shootouts
  • away_team - the name of the away team
  • neutral - True/False column indicating whether the match was played at a neutral venue
  • knockout - True/False if the the situation of a team is decided in this single match
  • stage - indicating the stage of the match in the tournament
  • tournament_name - the name of the tournament
  • tournament_year - the year of the tournament

Contribute

If 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

Tables

Results

@kaggle.rodrigoazs_football_results.results
  • 598.5 KB
  • 78635 rows
  • 10 columns
Loading...

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

Teams

@kaggle.rodrigoazs_football_results.teams
  • 17.07 KB
  • 1022 rows
  • 3 columns
Loading...

CREATE TABLE teams (
  "team" VARCHAR,
  "full_name" VARCHAR,
  "country" VARCHAR
);

Share link

Anyone who has the link will be able to view this.