Name: India Test Cricket Players Stats.
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

India Test Cricket Players Stats.

This data set has performance stats for all the frequent players, who play the test format for Team India. Every player has two files that first file or the file ending with stats1 has stats for respective columns for the total playing span of the player. The second file or the file ending with stats2 has stats for respective years and seasons.

Please Note: The Dataset also has some players who do not play test matches, hence their ODI performance stats is given. (for example : Yuzvendra Chahal)

The columns may differ depending on the playing role of the player. All the abbreviations in the columns are the same as standard.

The data is acquired from https://www.espncricinfo.com/ and please feel free to visit the website if you have any confusion understanding the data.

overview row has the stats for a player's entire career, other rows are self-exploratory and are having stats in a particular condition.

The Cat column stands for the category, and all the other columns are standard abbreviations for different terms in crickets.

The data can be used to analyze and predict the performance of each player in the upcoming test matches and which players perform better in what conditions. This Data set can be used to practice real-life implementation of sports analytics and developing attractive dashboards.

Also if you like this dataset and want to see how I extracted the data you can visit my Github link: https://github.com/Jalota0110 , I will be posting my notebook there for data collection along with a few new players.

Tables

Kuldeep Yadav Stats2

@kaggle.jalota_india_test_cricket_players_stats.kuldeep_yadav_stats2

9.68 kB
11 rows
14 columns

CREATE TABLE kuldeep_yadav_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" VARCHAR,
  "econ" DOUBLE,
  "sr" VARCHAR,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Mohammed Shami Ahmed Stats1

@kaggle.jalota_india_test_cricket_players_stats.mohammed_shami_ahmed_stats1

13.9 kB
71 rows
15 columns

CREATE TABLE mohammed_shami_ahmed_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Mohammed Shami Ahmed Stats2

@kaggle.jalota_india_test_cricket_players_stats.mohammed_shami_ahmed_stats2

10.75 kB
27 rows
14 columns

CREATE TABLE mohammed_shami_ahmed_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" VARCHAR,
  "econ" DOUBLE,
  "sr" VARCHAR,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Mohammed Siraj Stats1

@kaggle.jalota_india_test_cricket_players_stats.mohammed_siraj_stats1

12.55 kB
58 rows
15 columns

CREATE TABLE mohammed_siraj_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Mohammed Siraj Stats2

@kaggle.jalota_india_test_cricket_players_stats.mohammed_siraj_stats2

9.93 kB
9 rows
14 columns

CREATE TABLE mohammed_siraj_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Muralikrishna Prasidh Krishna Stats1

@kaggle.jalota_india_test_cricket_players_stats.muralikrishna_prasidh_krishna_stats1

11.24 kB
48 rows
14 columns

CREATE TABLE muralikrishna_prasidh_krishna_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_4w" BIGINT  -- 4w,
  "n_5w" BIGINT  -- 5w
);

Muralikrishna Prasidh Krishna Stats2

@kaggle.jalota_india_test_cricket_players_stats.muralikrishna_prasidh_krishna_stats2

9.02 kB
5 rows
13 columns

CREATE TABLE muralikrishna_prasidh_krishna_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_4w" BIGINT  -- 4w,
  "n_5w" BIGINT  -- 5w
);

Ravichandran Ashwin Stats1

@kaggle.jalota_india_test_cricket_players_stats.ravichandran_ashwin_stats1

14.6 kB
75 rows
15 columns

CREATE TABLE ravichandran_ashwin_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Ravichandran Ashwin Stats2

@kaggle.jalota_india_test_cricket_players_stats.ravichandran_ashwin_stats2

11.31 kB
32 rows
14 columns

CREATE TABLE ravichandran_ashwin_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Ravindrasinh Anirudhsinh Jadeja Stats1

@kaggle.jalota_india_test_cricket_players_stats.ravindrasinh_anirudhsinh_jadeja_stats1

13.87 kB
74 rows
15 columns

CREATE TABLE ravindrasinh_anirudhsinh_jadeja_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Ravindrasinh Anirudhsinh Jadeja Stats2

@kaggle.jalota_india_test_cricket_players_stats.ravindrasinh_anirudhsinh_jadeja_stats2

10.69 kB
29 rows
14 columns

CREATE TABLE ravindrasinh_anirudhsinh_jadeja_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Rishabh Rajendra Pant Stats1

@kaggle.jalota_india_test_cricket_players_stats.rishabh_rajendra_pant_stats1

13.16 kB
70 rows
15 columns

CREATE TABLE rishabh_rajendra_pant_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" VARCHAR,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Rishabh Rajendra Pant Stats2

@kaggle.jalota_india_test_cricket_players_stats.rishabh_rajendra_pant_stats2

10.1 kB
14 rows
14 columns

CREATE TABLE rishabh_rajendra_pant_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Rohit Sharma Stats1

@kaggle.jalota_india_test_cricket_players_stats.rohit_sharma_stats1

13.87 kB
73 rows
15 columns

CREATE TABLE rohit_sharma_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Rohit Sharma Stats2

@kaggle.jalota_india_test_cricket_players_stats.rohit_sharma_stats2

10.46 kB
24 rows
14 columns

CREATE TABLE rohit_sharma_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Shardul Thakur Stats1

@kaggle.jalota_india_test_cricket_players_stats.shardul_thakur_stats1

11.84 kB
54 rows
15 columns

CREATE TABLE shardul_thakur_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" VARCHAR,
  "econ" DOUBLE,
  "sr" VARCHAR,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Shardul Thakur Stats2

@kaggle.jalota_india_test_cricket_players_stats.shardul_thakur_stats2

9.53 kB
8 rows
14 columns

CREATE TABLE shardul_thakur_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" VARCHAR,
  "econ" DOUBLE,
  "sr" VARCHAR,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Shikhar Dhawan Stats1

@kaggle.jalota_india_test_cricket_players_stats.shikhar_dhawan_stats1

12.83 kB
62 rows
15 columns

CREATE TABLE shikhar_dhawan_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Shikhar Dhawan Stats2

@kaggle.jalota_india_test_cricket_players_stats.shikhar_dhawan_stats2

10.25 kB
17 rows
14 columns

CREATE TABLE shikhar_dhawan_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Shreyas Santosh Iyer Stats1

@kaggle.jalota_india_test_cricket_players_stats.shreyas_santosh_iyer_stats1

11.05 kB
55 rows
15 columns

CREATE TABLE shreyas_santosh_iyer_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" VARCHAR,
  "no" VARCHAR,
  "runs" VARCHAR,
  "hs" VARCHAR,
  "avg" VARCHAR,
  "bf" VARCHAR,
  "sr" VARCHAR,
  "n_100s" VARCHAR  -- 100s,
  "n_50s" VARCHAR  -- 50s,
  "n_0s" VARCHAR  -- 0s,
  "n_4s" VARCHAR  -- 4s,
  "n_6s" VARCHAR  -- 6s
);

Shreyas Santosh Iyer Stats2

@kaggle.jalota_india_test_cricket_players_stats.shreyas_santosh_iyer_stats2

9.78 kB
6 rows
14 columns

CREATE TABLE shreyas_santosh_iyer_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" BIGINT,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Shubman Gill Stats1

@kaggle.jalota_india_test_cricket_players_stats.shubman_gill_stats1

12.45 kB
61 rows
15 columns

CREATE TABLE shubman_gill_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Shubman Gill Stats2

@kaggle.jalota_india_test_cricket_players_stats.shubman_gill_stats2

9.95 kB
9 rows
14 columns

CREATE TABLE shubman_gill_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" BIGINT,
  "avg" DOUBLE,
  "bf" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Umesh Yadav Stats1

@kaggle.jalota_india_test_cricket_players_stats.umesh_yadav_stats1

13.86 kB
71 rows
15 columns

CREATE TABLE umesh_yadav_stats1 (
  "cat" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);

Umesh Yadav Stats2

@kaggle.jalota_india_test_cricket_players_stats.umesh_yadav_stats2

10.97 kB
29 rows
14 columns

CREATE TABLE umesh_yadav_stats2 (
  "cat" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "bbm" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_5w" BIGINT  -- 5w,
  "n_10w" BIGINT  -- 10w
);