Name: 150 Years Of International Football Matches
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

150 Years Of International Football Matches

This dataset contains a detailed record of international football (soccer) match goals and outcomes spanning from 1872 to 2022. Each row represents a goal scored in a match, with information about the date, home and away teams, scoring team, player (scorer), match minute, and whether the goal was an own goal or penalty. The dataset is goal-level (not just match-level), meaning matches with multiple goals appear as multiple rows. This structure enables a deeper analysis of trends, such as penalty frequency, average goal times, and the contributions of individual players

Tables

Decision

@kaggle.rehan497_historic_football_match_outcomes_18722022.decision

514.85 kB
44,353 rows
9 columns

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

Fifa Results

@kaggle.rehan497_historic_football_match_outcomes_18722022.fifa_results

473.73 kB
41,008 rows
8 columns

CREATE TABLE fifa_results (
  "date" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "team" VARCHAR,
  "scorer" VARCHAR,
  "minute" DOUBLE,
  "own_goal" BOOLEAN,
  "penalty" BOOLEAN
);

Penality Kick

@kaggle.rehan497_historic_football_match_outcomes_18722022.penality_kick

14.81 kB
547 rows
4 columns

CREATE TABLE penality_kick (
  "date" TIMESTAMP,
  "home_team" VARCHAR,
  "apponent_team" VARCHAR,
  "winner" VARCHAR
);