Big Bash League (BBL) Complete Dataset (2010-21)
The most complete Big Bash dataset
@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019
The most complete Big Bash dataset
@kaggle.patrickb1912_big_bash_league_complete_dataset_20112019
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.
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.
Data Source : Cricsheet
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.