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

Axar Rajeshbhai Patel Stats1

@kaggle.jalota_india_test_cricket_players_stats.axar_rajeshbhai_patel_stats1

12.09 kB
52 rows
15 columns

CREATE TABLE axar_rajeshbhai_patel_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
);

Axar Rajeshbhai Patel Stats2

@kaggle.jalota_india_test_cricket_players_stats.axar_rajeshbhai_patel_stats2

9.7 kB
6 rows
14 columns

CREATE TABLE axar_rajeshbhai_patel_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
);

Bhuvneshwar Kumar Singh Stats1

@kaggle.jalota_india_test_cricket_players_stats.bhuvneshwar_kumar_singh_stats1

12.79 kB
57 rows
15 columns

CREATE TABLE bhuvneshwar_kumar_singh_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
);

Bhuvneshwar Kumar Singh Stats2

@kaggle.jalota_india_test_cricket_players_stats.bhuvneshwar_kumar_singh_stats2

10.02 kB
13 rows
14 columns

CREATE TABLE bhuvneshwar_kumar_singh_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
);

Cheteshwar Pujara Stats1

@kaggle.jalota_india_test_cricket_players_stats.cheteshwar_pujara_stats1

14.15 kB
76 rows
15 columns

CREATE TABLE cheteshwar_pujara_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
);

Cheteshwar Pujara Stats2

@kaggle.jalota_india_test_cricket_players_stats.cheteshwar_pujara_stats2

11.06 kB
35 rows
14 columns

CREATE TABLE cheteshwar_pujara_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
);

Deepak Jagbir Hooda Stats1

@kaggle.jalota_india_test_cricket_players_stats.deepak_jagbir_hooda_stats1

11.3 kB
45 rows
15 columns

CREATE TABLE deepak_jagbir_hooda_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
);

Deepak Jagbir Hooda Stats2

@kaggle.jalota_india_test_cricket_players_stats.deepak_jagbir_hooda_stats2

9.63 kB
4 rows
14 columns

CREATE TABLE deepak_jagbir_hooda_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
);

Deepak Lokandersingh Chahar Stats1

@kaggle.jalota_india_test_cricket_players_stats.deepak_lokandersingh_chahar_stats1

11.32 kB
59 rows
14 columns

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

Deepak Lokandersingh Chahar Stats2

@kaggle.jalota_india_test_cricket_players_stats.deepak_lokandersingh_chahar_stats2

9.13 kB
10 rows
13 columns

CREATE TABLE deepak_lokandersingh_chahar_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
);

Hanuma Vihari Stats1

@kaggle.jalota_india_test_cricket_players_stats.hanuma_vihari_stats1

12.6 kB
65 rows
15 columns

CREATE TABLE hanuma_vihari_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
);

Hanuma Vihari Stats2

@kaggle.jalota_india_test_cricket_players_stats.hanuma_vihari_stats2

9.9 kB
12 rows
14 columns

CREATE TABLE hanuma_vihari_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
);

Hardik Himanshu Pandya Stats1

@kaggle.jalota_india_test_cricket_players_stats.hardik_himanshu_pandya_stats1

11.6 kB
45 rows
15 columns

CREATE TABLE hardik_himanshu_pandya_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
);

Hardik Himanshu Pandya Stats2

@kaggle.jalota_india_test_cricket_players_stats.hardik_himanshu_pandya_stats2

9.66 kB
5 rows
14 columns

CREATE TABLE hardik_himanshu_pandya_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
);

Ishan Pranav Kumar Pandey Kishan Stats1

@kaggle.jalota_india_test_cricket_players_stats.ishan_pranav_kumar_pandey_kishan_stats1

11.98 kB
50 rows
15 columns

CREATE TABLE ishan_pranav_kumar_pandey_kishan_stats1 (
  "cat" VARCHAR,
  "span" 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
);

Ishan Pranav Kumar Pandey Kishan Stats2

@kaggle.jalota_india_test_cricket_players_stats.ishan_pranav_kumar_pandey_kishan_stats2

9.75 kB
7 rows
14 columns

CREATE TABLE ishan_pranav_kumar_pandey_kishan_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
);

Jasprit Jasbirsingh Bumrah Stats1

@kaggle.jalota_india_test_cricket_players_stats.jasprit_jasbirsingh_bumrah_stats1

13.3 kB
70 rows
15 columns

CREATE TABLE jasprit_jasbirsingh_bumrah_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
);

Jasprit Jasbirsingh Bumrah Stats2

@kaggle.jalota_india_test_cricket_players_stats.jasprit_jasbirsingh_bumrah_stats2

10.19 kB
14 rows
14 columns

CREATE TABLE jasprit_jasbirsingh_bumrah_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
);

Jaydev Unadkat Stats1

@kaggle.jalota_india_test_cricket_players_stats.jaydev_unadkat_stats1

10.41 kB
32 rows
15 columns

CREATE TABLE jaydev_unadkat_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
);

Jaydev Unadkat Stats2

@kaggle.jalota_india_test_cricket_players_stats.jaydev_unadkat_stats2

9.2 kB
4 rows
14 columns

CREATE TABLE jaydev_unadkat_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
);

Kl Rahul Stats1

@kaggle.jalota_india_test_cricket_players_stats.kl_rahul_stats1

13.37 kB
67 rows
15 columns

CREATE TABLE kl_rahul_stats1 (
  "cat" VARCHAR,
  "span" 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
);

Kl Rahul Stats2

@kaggle.jalota_india_test_cricket_players_stats.kl_rahul_stats2

10.49 kB
21 rows
14 columns

CREATE TABLE kl_rahul_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
);

Krishnakumar Dinesh Karthik Stats1

@kaggle.jalota_india_test_cricket_players_stats.krishnakumar_dinesh_karthik_stats1

12.95 kB
67 rows
15 columns

CREATE TABLE krishnakumar_dinesh_karthik_stats1 (
  "cat" VARCHAR,
  "span" 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
);

Krishnakumar Dinesh Karthik Stats2

@kaggle.jalota_india_test_cricket_players_stats.krishnakumar_dinesh_karthik_stats2

10.08 kB
16 rows
14 columns

CREATE TABLE krishnakumar_dinesh_karthik_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
);

Kuldeep Yadav Stats1

@kaggle.jalota_india_test_cricket_players_stats.kuldeep_yadav_stats1

11.9 kB
52 rows
15 columns

CREATE TABLE kuldeep_yadav_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
);