Name: Cricket Data From 2000 To 2020 For South Africa
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Cricket Data From 2000 To 2020 For South Africa

I was looking for something challenging and I stumble upon a journal titled 'INCREASED PREDICTION ACCURACY IN THE GAME OF
CRICKET USING MACHINE LEARNING' and decided to implement the project. The first aspect is understanding the journal and cricket 😁.

The next aspect is getting the data. I wrote scripts to scrap espncricinfo. The scripts and journal can be found on github.

The data contains matches played by South Africa from 2000 to 2020 and can be used for prediction as well as exploratory analysis. It consists of 6 tables:

Mat: Details of matches played
Bat: Details of each appearance of a batter
Bowl: Details of each appearance of a bowler
Ground: Details about venues
Opposition: ID, name and rating of opposing teams
Players: Details of each player

Note: Nan values are represented as -99. Also, match is commonly regarded as mat.

Tables

Bat

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.bat

41.98 kB
3,934 rows
8 columns

CREATE TABLE bat (
  "player" BIGINT,
  "mat" BIGINT,
  "runs" BIGINT,
  "ball" BIGINT,
  "m" BIGINT,
  "n__4s" BIGINT  -- 4s,
  "n__6s" BIGINT  -- 6s,
  "strike_rate" DOUBLE
);

Bowl

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.bowl

30.3 kB
2,929 rows
12 columns

CREATE TABLE bowl (
  "player" BIGINT,
  "mat" BIGINT,
  "overs" DOUBLE,
  "m" BIGINT,
  "runs" BIGINT,
  "wicket" BIGINT,
  "econ" DOUBLE,
  "n__0s" BIGINT  -- 0s,
  "n__4s" BIGINT  -- 4s,
  "n__6s" BIGINT  -- 6s,
  "wide" BIGINT,
  "no_ball" BIGINT
);

Ground

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.ground

5 kB
92 rows
3 columns

CREATE TABLE ground (
  "ground_id" BIGINT,
  "ground_name" VARCHAR,
  "country" VARCHAR
);

Mat

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.mat

23.94 kB
431 rows
9 columns

CREATE TABLE mat (
  "match_id" BIGINT,
  "odi_no" BIGINT,
  "opposition" BIGINT,
  "ground" BIGINT,
  "match_date" TIMESTAMP,
  "toss" VARCHAR,
  "series" VARCHAR,
  "result" VARCHAR,
  "match_days" VARCHAR
);

Opposition

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.opposition

3.13 kB
16 rows
3 columns

CREATE TABLE opposition (
  "opp_id" BIGINT,
  "opp_name" VARCHAR,
  "rating" BIGINT
);

Player

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.player

9.09 kB
108 rows
7 columns

CREATE TABLE player (
  "player_id" BIGINT,
  "name" VARCHAR,
  "odi_debut" TIMESTAMP,
  "playing_role" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "fielding_position" VARCHAR
);