Dataset: Big Bash League (BBL) Complete Dataset (2010-21)

About this Dataset

Big Bash League (BBL) Complete Dataset (2010-21)

Context

The Big Bash League (often abbreviated to BBL or Big Bash) is an Australian professional franchise Twenty20 cricket league, which was established in 2011 by Cricket Australia. The Big Bash League replaced the previous competition, the KFC Twenty20 Big Bash, and features eight city-based franchises instead of the six state teams which had participated previously.

Content

This dataset consists of two seperate CSV files : matches and deliveries. These files contain the information of each match summary and ball by ball details, respectively.

Acknowledgements

Data Source : Cricsheet

Tables

Bbl Ball By Ball 2011–2019

@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019.bbl_ball_by_ball_2011_2019

406.83 KB
81698 rows
18 columns


CREATE TABLE bbl_ball_by_ball_2011_2019 (
  "id" BIGINT,
  "inning" BIGINT,
  "over" BIGINT,
  "ball" BIGINT,
  "batsman" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "batsman_runs" BIGINT,
  "extra_runs" BIGINT,
  "total_runs" BIGINT,
  "non_boundary" BIGINT,
  "is_wicket" BIGINT,
  "dismissal_kind" VARCHAR,
  "player_dismissed" VARCHAR,
  "fielder" VARCHAR,
  "extras_type" VARCHAR,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR
);

Bbl Matches 2011–2019

@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019.bbl_matches_2011_2019

21.7 KB
353 rows
17 columns


CREATE TABLE bbl_matches_2011_2019 (
  "id" BIGINT,
  "city" VARCHAR,
  "date" TIMESTAMP,
  "player_of_match" VARCHAR,
  "venue" VARCHAR,
  "neutral_venue" BIGINT,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "winner" VARCHAR,
  "result" VARCHAR,
  "result_margin" DOUBLE,
  "eliminator" VARCHAR,
  "method" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR
);

Deliveries

@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019.deliveries

477.71 KB
95823 rows
18 columns


CREATE TABLE deliveries (
  "id" BIGINT,
  "inning" BIGINT,
  "over" BIGINT,
  "ball" BIGINT,
  "batsman" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "batsman_runs" BIGINT,
  "extra_runs" BIGINT,
  "total_runs" BIGINT,
  "non_boundary" BIGINT,
  "is_wicket" BIGINT,
  "dismissal_kind" VARCHAR,
  "player_dismissed" VARCHAR,
  "fielder" VARCHAR,
  "extras_type" VARCHAR,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR
);

Matches

@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019.matches

23.07 KB
414 rows
17 columns


CREATE TABLE matches (
  "id" BIGINT,
  "city" VARCHAR,
  "date" TIMESTAMP,
  "player_of_match" VARCHAR,
  "venue" VARCHAR,
  "neutral_venue" BIGINT,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "winner" VARCHAR,
  "result" VARCHAR,
  "result_margin" DOUBLE,
  "eliminator" VARCHAR,
  "method" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR
);