Baselight
Sign In

European Football Season 2022/23

Database for European football leagues during the 2022/23 season.

@kaggle.mcarujo_european_football_season_202223

Loading...
Loading...

About this Dataset

European Football Season 2022/23

This dataset contains information related to many national championships in Europe as well as the continental league.

Competitions:

For each competition, there are two datasets: events and matches.

  • Events -> as the name suggests, save the time of each event (ex: goal, red card) that happened in the match.
  • Matches -> a match overview information (ex: score, lineup, location, date).
  • Tables -> the board league.

Inspiration

The inspiration for creating this dataset is to analyze the performance of teams during the competition and relate them to the bet on other platforms around the world.

Source

Tables

Events Bundesliga 2022–23

@kaggle.mcarujo_european_football_season_202223.events_bundesliga_2022_23
  • 68.9 kB
  • 5,032 rows
  • 8 columns
Loading... 
CREATE TABLE events_bundesliga_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Champions League 2022–23

@kaggle.mcarujo_european_football_season_202223.events_champions_league_2022_23
  • 41.79 kB
  • 2,008 rows
  • 8 columns
Loading... 
CREATE TABLE events_champions_league_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Eredivisie 2022–23

@kaggle.mcarujo_european_football_season_202223.events_eredivisie_2022_23
  • 64.29 kB
  • 4,482 rows
  • 8 columns
Loading... 
CREATE TABLE events_eredivisie_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Europa League 2022–23

@kaggle.mcarujo_european_football_season_202223.events_europa_league_2022_23
  • 49.1 kB
  • 2,276 rows
  • 8 columns
Loading... 
CREATE TABLE events_europa_league_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Laliga 2022–23

@kaggle.mcarujo_european_football_season_202223.events_laliga_2022_23
  • 83.89 kB
  • 6,452 rows
  • 8 columns
Loading... 
CREATE TABLE events_laliga_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Liga Portugal 2022–23

@kaggle.mcarujo_european_football_season_202223.events_liga_portugal_2022_23
  • 72.33 kB
  • 5,422 rows
  • 8 columns
Loading... 
CREATE TABLE events_liga_portugal_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Ligue 1–2022–23

@kaggle.mcarujo_european_football_season_202223.events_ligue_1_2022_23
  • 77.64 kB
  • 5,646 rows
  • 8 columns
Loading... 
CREATE TABLE events_ligue_1_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Premier League 2022–23

@kaggle.mcarujo_european_football_season_202223.events_premier_league_2022_23
  • 75.87 kB
  • 5,524 rows
  • 8 columns
Loading... 
CREATE TABLE events_premier_league_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Events Serie 2022–23

@kaggle.mcarujo_european_football_season_202223.events_serie_2022_23
  • 83.99 kB
  • 6,281 rows
  • 8 columns
Loading... 
CREATE TABLE events_serie_2022_23 (
  "event_id" BIGINT,
  "match_id" BIGINT,
  "team" VARCHAR,
  "event_team" VARCHAR,
  "event_time" BIGINT,
  "event_type" VARCHAR,
  "action_player_1" VARCHAR,
  "action_player_2" VARCHAR
);

Matches Bundesliga 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_bundesliga_2022_23
  • 115.56 kB
  • 304 rows
  • 29 columns
Loading... 
CREATE TABLE matches_bundesliga_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Champions League 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_champions_league_2022_23
  • 76.91 kB
  • 125 rows
  • 29 columns
Loading... 
CREATE TABLE matches_champions_league_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" VARCHAR,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Eredivisie 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_eredivisie_2022_23
  • 115.71 kB
  • 310 rows
  • 29 columns
Loading... 
CREATE TABLE matches_eredivisie_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Europa League 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_europa_league_2022_23
  • 87.86 kB
  • 137 rows
  • 29 columns
Loading... 
CREATE TABLE matches_europa_league_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Laliga 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_laliga_2022_23
  • 139.86 kB
  • 377 rows
  • 29 columns
Loading... 
CREATE TABLE matches_laliga_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Liga Portugal 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_liga_portugal_2022_23
  • 122.85 kB
  • 307 rows
  • 21 columns
Loading... 
CREATE TABLE matches_liga_portugal_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Ligue 1–2022–23

@kaggle.mcarujo_european_football_season_202223.matches_ligue_1_2022_23
  • 139.36 kB
  • 380 rows
  • 29 columns
Loading... 
CREATE TABLE matches_ligue_1_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Premier League 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_premier_league_2022_23
  • 134.92 kB
  • 380 rows
  • 29 columns
Loading... 
CREATE TABLE matches_premier_league_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Matches Serie 2022–23

@kaggle.mcarujo_european_football_season_202223.matches_serie_2022_23
  • 140.61 kB
  • 378 rows
  • 29 columns
Loading... 
CREATE TABLE matches_serie_2022_23 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "pens" BOOLEAN,
  "pens_home_score" BOOLEAN,
  "pens_away_score" BOOLEAN,
  "team_name_home" VARCHAR,
  "team_name_away" VARCHAR,
  "team_home_score" BIGINT,
  "team_away_score" BIGINT,
  "possession_home" DOUBLE,
  "possession_away" DOUBLE,
  "total_shots_home" BIGINT,
  "total_shots_away" BIGINT,
  "shots_on_target_home" BIGINT,
  "shots_on_target_away" BIGINT,
  "duels_won_home" DOUBLE,
  "duels_won_away" DOUBLE,
  "prediction_team_home_win" DOUBLE,
  "prediction_draw" DOUBLE,
  "prediction_team_away_win" DOUBLE,
  "prediction_quantity" BIGINT,
  "location" VARCHAR,
  "lineup_home" VARCHAR,
  "lineup_away" VARCHAR,
  "player_names_home" VARCHAR,
  "player_numbers_home" VARCHAR,
  "player_names_away" VARCHAR,
  "player_numbers_away" VARCHAR
);

Table Bundesliga 2022–23

@kaggle.mcarujo_european_football_season_202223.table_bundesliga_2022_23
  • 6.96 kB
  • 18 rows
  • 9 columns
Loading... 
CREATE TABLE table_bundesliga_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Champions League 2022–23

@kaggle.mcarujo_european_football_season_202223.table_champions_league_2022_23
  • 7.11 kB
  • 32 rows
  • 9 columns
Loading... 
CREATE TABLE table_champions_league_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Eredivisie 2022–23

@kaggle.mcarujo_european_football_season_202223.table_eredivisie_2022_23
  • 6.87 kB
  • 18 rows
  • 9 columns
Loading... 
CREATE TABLE table_eredivisie_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Europa League 2022–23

@kaggle.mcarujo_european_football_season_202223.table_europa_league_2022_23
  • 7.07 kB
  • 32 rows
  • 9 columns
Loading... 
CREATE TABLE table_europa_league_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Laliga 2022–23

@kaggle.mcarujo_european_football_season_202223.table_laliga_2022_23
  • 6.95 kB
  • 20 rows
  • 9 columns
Loading... 
CREATE TABLE table_laliga_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Liga Portugal 2022–23

@kaggle.mcarujo_european_football_season_202223.table_liga_portugal_2022_23
  • 6.87 kB
  • 18 rows
  • 9 columns
Loading... 
CREATE TABLE table_liga_portugal_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Ligue 1–2022–23

@kaggle.mcarujo_european_football_season_202223.table_ligue_1_2022_23
  • 6.94 kB
  • 20 rows
  • 9 columns
Loading... 
CREATE TABLE table_ligue_1_2022_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Share link

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