Baselight
Sign In

South America Football Season 2023

Database for South America football leagues during the 2022/23 season.

@kaggle.mcarujo_south_america_football_season_2023

Loading...
Loading...

About this Dataset

South America Football Season 2023

This dataset contains information related to many national championships in South America 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 Brasileirao Serie A 23

@kaggle.mcarujo_south_america_football_season_2023.events_brasileirao_serie_a_23
  • 43.03 KB
  • 2795 rows
  • 8 columns
Loading... 

CREATE TABLE events_brasileirao_serie_a_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 Conmebol Libertadores 23

@kaggle.mcarujo_south_america_football_season_2023.events_conmebol_libertadores_23
  • 43.93 KB
  • 2140 rows
  • 8 columns
Loading... 

CREATE TABLE events_conmebol_libertadores_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 Conmebol Sudamericana 23

@kaggle.mcarujo_south_america_football_season_2023.events_conmebol_sudamericana_23
  • 45.31 KB
  • 2183 rows
  • 8 columns
Loading... 

CREATE TABLE events_conmebol_sudamericana_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 Primera Division Cl 23

@kaggle.mcarujo_south_america_football_season_2023.events_primera_division_cl_23
  • 16.09 KB
  • 466 rows
  • 8 columns
Loading... 

CREATE TABLE events_primera_division_cl_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 Primera Division De Argentina 23

@kaggle.mcarujo_south_america_football_season_2023.events_primera_division_de_argentina_23
  • 70.16 KB
  • 4931 rows
  • 8 columns
Loading... 

CREATE TABLE events_primera_division_de_argentina_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 Brasileirao Serie A 23

@kaggle.mcarujo_south_america_football_season_2023.matches_brasileirao_serie_a_23
  • 91.66 KB
  • 158 rows
  • 29 columns
Loading... 

CREATE TABLE matches_brasileirao_serie_a_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 Conmebol Libertadores 23

@kaggle.mcarujo_south_america_football_season_2023.matches_conmebol_libertadores_23
  • 78.37 KB
  • 126 rows
  • 29 columns
Loading... 

CREATE TABLE matches_conmebol_libertadores_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 Conmebol Sudamericana 23

@kaggle.mcarujo_south_america_football_season_2023.matches_conmebol_sudamericana_23
  • 80.37 KB
  • 125 rows
  • 29 columns
Loading... 

CREATE TABLE matches_conmebol_sudamericana_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 Primera Division Cl 23

@kaggle.mcarujo_south_america_football_season_2023.matches_primera_division_cl_23
  • 42.36 KB
  • 31 rows
  • 29 columns
Loading... 

CREATE TABLE matches_primera_division_cl_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 Primera Division De Argentina 23

@kaggle.mcarujo_south_america_football_season_2023.matches_primera_division_de_argentina_23
  • 121.08 KB
  • 309 rows
  • 29 columns
Loading... 

CREATE TABLE matches_primera_division_de_argentina_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
);

Table Brasileirao Serie A 23

@kaggle.mcarujo_south_america_football_season_2023.table_brasileirao_serie_a_23
  • 6.74 KB
  • 20 rows
  • 9 columns
Loading... 

CREATE TABLE table_brasileirao_serie_a_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Conmebol Libertadores 23

@kaggle.mcarujo_south_america_football_season_2023.table_conmebol_libertadores_23
  • 6.88 KB
  • 32 rows
  • 9 columns
Loading... 

CREATE TABLE table_conmebol_libertadores_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Conmebol Sudamericana 23

@kaggle.mcarujo_south_america_football_season_2023.table_conmebol_sudamericana_23
  • 6.93 KB
  • 32 rows
  • 9 columns
Loading... 

CREATE TABLE table_conmebol_sudamericana_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Primera Division Cl 23

@kaggle.mcarujo_south_america_football_season_2023.table_primera_division_cl_23
  • 6.62 KB
  • 16 rows
  • 9 columns
Loading... 

CREATE TABLE table_primera_division_cl_23 (
  "team" VARCHAR,
  "position" BIGINT,
  "pl" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gd" BIGINT,
  "pts" BIGINT,
  "group_name" VARCHAR
);

Table Primera Division De Argentina 23

@kaggle.mcarujo_south_america_football_season_2023.table_primera_division_de_argentina_23
  • 7 KB
  • 28 rows
  • 9 columns
Loading... 

CREATE TABLE table_primera_division_de_argentina_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.