Name: Brasileirao 2022 Serie A+B
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Brasileirao 2022 Serie A+B

Brasileirao 2022 - Serie A and B

This dataset contains all information related to Brasileirao A and B.
Please feel free to share and use it.

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

All data were taken from OneFootball platform:

Serie A.
Serie B.

The images were taken from Wikipedia.

Tables

Events Brasileirao Serie A 2022

@kaggle.mcarujo_brasileirao_2022_serie_ab.events_brasileirao_serie_a_2022

88.04 kB
6,527 rows
8 columns

CREATE TABLE events_brasileirao_serie_a_2022 (
  "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 Brasileirao Serie B 2022

@kaggle.mcarujo_brasileirao_2022_serie_ab.events_brasileirao_serie_b_2022

86.04 kB
6,348 rows
8 columns

CREATE TABLE events_brasileirao_serie_b_2022 (
  "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 2022

@kaggle.mcarujo_brasileirao_2022_serie_ab.matches_brasileirao_serie_a_2022

174.57 kB
380 rows
26 columns

CREATE TABLE matches_brasileirao_serie_a_2022 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "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 Brasileirao Serie B 2022

@kaggle.mcarujo_brasileirao_2022_serie_ab.matches_brasileirao_serie_b_2022

175.35 kB
380 rows
26 columns

CREATE TABLE matches_brasileirao_serie_b_2022 (
  "match_id" BIGINT,
  "stage" VARCHAR,
  "date" TIMESTAMP,
  "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
);