Dataset: Pakistan Super League(PSL) Ball By Ball 2016-2022

About this Dataset

Pakistan Super League(PSL) Ball By Ball 2016-2022

Context

Being a huge cricket fan and a Machine Learning Engineer, I wanted data from Pakistan super league to run visualizations on and potentially train a predictor. So I decided to generate this dataset

Content

The data Contains ball by ball coverage for each match of every PSL season from 2016 to 20202

Acknowledgements

The data has been scrapped from espn cricinfo website

Tables

Psl 2016–2022

@kaggle.hassanj576_pakistan_super_leaguepsl_ball_by_ball_20162020.psl_2016_2022

118.7 KB
50262 rows
16 columns


CREATE TABLE psl_2016_2022 (
  "psl_year" BIGINT,
  "match_number" BIGINT,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "inning" BIGINT,
  "over" BIGINT,
  "ball" BIGINT,
  "runs" BIGINT,
  "wicket" DOUBLE,
  "total_runs" BIGINT,
  "wickets" BIGINT,
  "is_four" BOOLEAN,
  "is_six" BOOLEAN,
  "is_wicket" BOOLEAN,
  "wicket_text" VARCHAR,
  "result" VARCHAR
);

Psl Formated

@kaggle.hassanj576_pakistan_super_leaguepsl_ball_by_ball_20162020.psl_formated

84.53 KB
33962 rows
16 columns


CREATE TABLE psl_formated (
  "psl_year" BIGINT,
  "match_number" BIGINT,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "inning" BIGINT,
  "over" BIGINT,
  "ball" BIGINT,
  "runs" BIGINT,
  "total_runs" BIGINT,
  "wickets" BIGINT,
  "is_four" BOOLEAN,
  "is_six" BOOLEAN,
  "is_wicket" BOOLEAN,
  "wicket" DOUBLE,
  "wicket_text" VARCHAR,
  "result" VARCHAR
);