Name: Cricket Players Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Cricket Players Dataset

This dataset is your gateway to a comprehensive world of cricket, housing information on over 90,000 professional players across formats and eras. Sourced directly from ESPN Cricinfo's rich database, it delves beyond scores, offering 180+ unique features that paint a detailed picture of each player's journey.

Tables

Cricket Players Cleaned Data

@kaggle.zainhaidar_cricket_players_dataset.cricket_players_cleaned_data

9.46 MB
90,308 rows
177 columns

CREATE TABLE cricket_players_cleaned_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "country" VARCHAR,
  "full_name" VARCHAR,
  "birthdate" VARCHAR,
  "birthplace" VARCHAR,
  "died" VARCHAR,
  "date_of_death" VARCHAR,
  "age" DOUBLE,
  "major_teams" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "other" VARCHAR,
  "awards" VARCHAR,
  "batting_tests_mat" DOUBLE,
  "batting_tests_inns" DOUBLE,
  "batting_tests_no" DOUBLE,
  "batting_tests_runs" DOUBLE,
  "batting_tests_hs" VARCHAR,
  "batting_tests_ave" DOUBLE,
  "batting_tests_bf" DOUBLE,
  "batting_tests_sr" DOUBLE,
  "batting_tests_100" DOUBLE,
  "batting_tests_50" DOUBLE,
  "batting_tests_4s" DOUBLE,
  "batting_tests_6s" DOUBLE,
  "batting_tests_ct" DOUBLE,
  "batting_tests_st" DOUBLE,
  "batting_odis_mat" DOUBLE,
  "batting_odis_inns" DOUBLE,
  "batting_odis_no" DOUBLE,
  "batting_odis_runs" DOUBLE,
  "batting_odis_hs" VARCHAR,
  "batting_odis_ave" DOUBLE,
  "batting_odis_bf" DOUBLE,
  "batting_odis_sr" DOUBLE,
  "batting_odis_100" DOUBLE,
  "batting_odis_50" DOUBLE,
  "batting_odis_4s" DOUBLE,
  "batting_odis_6s" DOUBLE,
  "batting_odis_ct" DOUBLE,
  "batting_odis_st" DOUBLE,
  "batting_t20is_mat" DOUBLE,
  "batting_t20is_inns" DOUBLE,
  "batting_t20is_no" DOUBLE,
  "batting_t20is_runs" DOUBLE,
  "batting_t20is_hs" VARCHAR,
  "batting_t20is_ave" DOUBLE,
  "batting_t20is_bf" DOUBLE,
  "batting_t20is_sr" DOUBLE,
  "batting_t20is_100" DOUBLE,
  "batting_t20is_50" DOUBLE,
  "batting_t20is_4s" DOUBLE,
  "batting_t20is_6s" DOUBLE,
  "batting_t20is_ct" DOUBLE,
  "batting_t20is_st" DOUBLE,
  "batting_first_class_mat" DOUBLE,
  "batting_first_class_inns" DOUBLE,
  "batting_first_class_no" DOUBLE,
  "batting_first_class_runs" DOUBLE,
  "batting_first_class_hs" VARCHAR,
  "batting_first_class_ave" DOUBLE,
  "batting_first_class_bf" DOUBLE,
  "batting_first_class_sr" DOUBLE,
  "batting_first_class_100" DOUBLE,
  "batting_first_class_50" DOUBLE,
  "batting_first_class_4s" DOUBLE,
  "batting_first_class_6s" DOUBLE,
  "batting_first_class_ct" DOUBLE,
  "batting_first_class_st" DOUBLE,
  "batting_list_a_mat" DOUBLE,
  "batting_list_a_inns" DOUBLE,
  "batting_list_a_no" DOUBLE,
  "batting_list_a_runs" DOUBLE,
  "batting_list_a_hs" VARCHAR,
  "batting_list_a_ave" DOUBLE,
  "batting_list_a_bf" DOUBLE,
  "batting_list_a_sr" DOUBLE,
  "batting_list_a_100" DOUBLE,
  "batting_list_a_50" DOUBLE,
  "batting_list_a_4s" DOUBLE,
  "batting_list_a_6s" DOUBLE,
  "batting_list_a_ct" DOUBLE,
  "batting_list_a_st" DOUBLE,
  "batting_t20s_mat" DOUBLE,
  "batting_t20s_inns" DOUBLE,
  "batting_t20s_no" DOUBLE,
  "batting_t20s_runs" DOUBLE,
  "batting_t20s_hs" VARCHAR,
  "batting_t20s_ave" DOUBLE,
  "batting_t20s_bf" DOUBLE,
  "batting_t20s_sr" DOUBLE,
  "batting_t20s_100" DOUBLE,
  "batting_t20s_50" DOUBLE,
  "batting_t20s_4s" DOUBLE,
  "batting_t20s_6s" DOUBLE,
  "batting_t20s_ct" DOUBLE,
  "batting_t20s_st" DOUBLE,
  "bowling_tests_mat" DOUBLE
);

Cricket Players Data

@kaggle.zainhaidar_cricket_players_dataset.cricket_players_data

18.04 MB
90,308 rows
181 columns

CREATE TABLE cricket_players_data (
  "id" BIGINT,
  "name" VARCHAR,
  "country" VARCHAR,
  "full_name" VARCHAR,
  "born" VARCHAR,
  "died" VARCHAR,
  "current_age" VARCHAR,
  "major_teams" VARCHAR,
  "education" VARCHAR,
  "height" VARCHAR,
  "nickname" VARCHAR,
  "playing_role" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "other" VARCHAR,
  "relation" VARCHAR,
  "in_a_nutshell" VARCHAR,
  "description" VARCHAR,
  "awards" VARCHAR,
  "batting_tests_mat" DOUBLE,
  "batting_tests_inns" VARCHAR,
  "batting_tests_no" VARCHAR,
  "batting_tests_runs" VARCHAR,
  "batting_tests_hs" VARCHAR,
  "batting_tests_ave" VARCHAR,
  "batting_tests_bf" VARCHAR,
  "batting_tests_sr" VARCHAR,
  "batting_tests_100" VARCHAR,
  "batting_tests_50" VARCHAR,
  "batting_tests_4s" VARCHAR,
  "batting_tests_6s" VARCHAR,
  "batting_tests_ct" VARCHAR,
  "batting_tests_st" VARCHAR,
  "batting_odis_mat" DOUBLE,
  "batting_odis_inns" VARCHAR,
  "batting_odis_no" VARCHAR,
  "batting_odis_runs" VARCHAR,
  "batting_odis_hs" VARCHAR,
  "batting_odis_ave" VARCHAR,
  "batting_odis_bf" VARCHAR,
  "batting_odis_sr" VARCHAR,
  "batting_odis_100" VARCHAR,
  "batting_odis_50" VARCHAR,
  "batting_odis_4s" VARCHAR,
  "batting_odis_6s" VARCHAR,
  "batting_odis_ct" VARCHAR,
  "batting_odis_st" VARCHAR,
  "batting_t20is_mat" DOUBLE,
  "batting_t20is_inns" VARCHAR,
  "batting_t20is_no" VARCHAR,
  "batting_t20is_runs" VARCHAR,
  "batting_t20is_hs" VARCHAR,
  "batting_t20is_ave" VARCHAR,
  "batting_t20is_bf" VARCHAR,
  "batting_t20is_sr" VARCHAR,
  "batting_t20is_100" VARCHAR,
  "batting_t20is_50" VARCHAR,
  "batting_t20is_4s" VARCHAR,
  "batting_t20is_6s" VARCHAR,
  "batting_t20is_ct" VARCHAR,
  "batting_t20is_st" VARCHAR,
  "batting_first_class_mat" DOUBLE,
  "batting_first_class_inns" VARCHAR,
  "batting_first_class_no" VARCHAR,
  "batting_first_class_runs" VARCHAR,
  "batting_first_class_hs" VARCHAR,
  "batting_first_class_ave" VARCHAR,
  "batting_first_class_bf" VARCHAR,
  "batting_first_class_sr" VARCHAR,
  "batting_first_class_100" VARCHAR,
  "batting_first_class_50" VARCHAR,
  "batting_first_class_4s" VARCHAR,
  "batting_first_class_6s" VARCHAR,
  "batting_first_class_ct" VARCHAR,
  "batting_first_class_st" VARCHAR,
  "batting_list_a_mat" DOUBLE,
  "batting_list_a_inns" VARCHAR,
  "batting_list_a_no" VARCHAR,
  "batting_list_a_runs" VARCHAR,
  "batting_list_a_hs" VARCHAR,
  "batting_list_a_ave" VARCHAR,
  "batting_list_a_bf" VARCHAR,
  "batting_list_a_sr" VARCHAR,
  "batting_list_a_100" VARCHAR,
  "batting_list_a_50" VARCHAR,
  "batting_list_a_4s" VARCHAR,
  "batting_list_a_6s" VARCHAR,
  "batting_list_a_ct" VARCHAR,
  "batting_list_a_st" VARCHAR,
  "batting_t20s_mat" DOUBLE,
  "batting_t20s_inns" VARCHAR,
  "batting_t20s_no" VARCHAR,
  "batting_t20s_runs" VARCHAR,
  "batting_t20s_hs" VARCHAR,
  "batting_t20s_ave" VARCHAR,
  "batting_t20s_bf" VARCHAR,
  "batting_t20s_sr" VARCHAR,
  "batting_t20s_100" VARCHAR,
  "batting_t20s_50" VARCHAR,
  "batting_t20s_4s" VARCHAR
);