Dataset: Brasileirao 2022 Serie A+B

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

85.98 KB
6527 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

84.03 KB
6348 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

170.47 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

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