Dataset: Big Bash Dataset(till 2017)

About this Dataset

Big Bash Dataset(till 2017)

This is the ball by ball data of all the Big Bash cricket (T20 League of Australia) matches till 2017 season.

Source: http://cricsheet.org/ (data is available on this website in the YAML format. This is converted to CSV format by using R Script ,SQL,SSIS.

Research scope: Predicting the winner of the next season of Big Bash based on past data, Visualizations, Perspectives, etc.

Tables

Ballbyball

@kaggle.raghu07_big_bash_datasettill_2017.ballbyball

213.69 KB
44382 rows
26 columns


CREATE TABLE ballbyball (
  "innings" BIGINT,
  "inningsdesc" VARCHAR,
  "over" DOUBLE,
  "striker" VARCHAR,
  "bowler" VARCHAR,
  "extras_byes" DOUBLE,
  "extras_legbyes" DOUBLE,
  "extras_noballs" DOUBLE,
  "extras_wides" DOUBLE,
  "non_striker" VARCHAR,
  "runs_batsman" BIGINT,
  "runs_extras" BIGINT,
  "runs_total" BIGINT,
  "wicket_fielders" VARCHAR,
  "wicket_kind" VARCHAR,
  "wicket_player_out" VARCHAR,
  "winning_team" VARCHAR,
  "mom" VARCHAR,
  "match_date" TIMESTAMP,
  "matchid" VARCHAR,
  "value_replacements_match" VARCHAR,
  "value_runs_non_boundary" DOUBLE,
  "replacements_role" VARCHAR,
  "l9_replacements_role" DOUBLE,
  "value_replacements_role" VARCHAR,
  "match_id" BIGINT
);

Match

@kaggle.raghu07_big_bash_datasettill_2017.match

11.72 KB
206 rows
11 columns


CREATE TABLE match (
  "matchdatesk" BIGINT,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "winner" VARCHAR,
  "margin" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "matchid" BIGINT,
  "issemifinal" BIGINT,
  "isfinal" BIGINT,
  "season_year" BIGINT
);