Baselight
Sign In

Cricinfo Statsguru Data

For anyone who enjoys Cricket, and analyzing cricket stats.

@kaggle.cclayford_cricinfo_statsguru_data

Loading...
Loading...

About this Dataset

Cricinfo Statsguru Data

Context

This is a data dump of the Statsguru section of Cricinfo's searchable cricket statistics database.

Content

I have pulled the data at an innings by innings level of granularity.

Acknowledgements

All data pulled can be found on the cricinfo website: http://stats.espncricinfo.com/ci/engine/stats/index.html

Inspiration

For anyone who enjoys Cricket, and analyzing cricket stats.

Tables

Ipl Player Stats 2016 Till 2019

@kaggle.cclayford_cricinfo_statsguru_data.ipl_player_stats_2016_till_2019
  • 48.24 kB
  • 631 rows
  • 29 columns
Loading... 
CREATE TABLE ipl_player_stats_2016_till_2019 (
  "team" VARCHAR,
  "player" VARCHAR,
  "tournament" VARCHAR,
  "matches" BIGINT,
  "batting_innings" VARCHAR,
  "not_out" VARCHAR,
  "runds_scored" VARCHAR,
  "highest_score" VARCHAR,
  "batting_average" VARCHAR,
  "balls_faced" VARCHAR,
  "batting_strike_rate" VARCHAR,
  "n_100" VARCHAR  -- 100,
  "n_50" VARCHAR  -- 50,
  "n_0" VARCHAR  -- 0,
  "n_4s" VARCHAR  -- 4s,
  "n_6s" VARCHAR  -- 6s,
  "bowling_innings" VARCHAR,
  "overs_bowled" VARCHAR,
  "maidens_bowled" VARCHAR,
  "runs_conceded" VARCHAR,
  "wickets_taken" VARCHAR,
  "best_bowling_figures" VARCHAR,
  "bowling_average" VARCHAR,
  "bowling_economy_rate" VARCHAR,
  "bowling_strike_rate" VARCHAR,
  "n_4_innings_wickets" VARCHAR  -- 4+ Innings Wickets,
  "n_5_innings_wickets" VARCHAR  -- 5+ Innings Wickets,
  "catches_taken" BIGINT,
  "stumpings_made" BIGINT
);

Men Odi Player Innings Stats 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_player_innings_stats_20th_century
  • 558.08 kB
  • 72,842 rows
  • 28 columns
Loading... 
CREATE TABLE men_odi_player_innings_stats_20th_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Odi Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_player_innings_stats_21st_century
  • 2.48 MB
  • 327,328 rows
  • 28 columns
Loading... 
CREATE TABLE men_odi_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Odi Team Batting Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_batting_stats
  • 11.21 kB
  • 17 rows
  • 12 columns
Loading... 
CREATE TABLE men_odi_team_batting_stats (
  "country" VARCHAR,
  "team_matches_played" BIGINT,
  "matches_won" BIGINT,
  "matches_lost" BIGINT,
  "matches_tied" BIGINT,
  "matches_with_no_result" BIGINT,
  "win_loss_ratio" DOUBLE,
  "avg_runs_per_wicket_batting" DOUBLE,
  "avg_runs_per_six_balls_batting" DOUBLE,
  "number_of_team_innings_batting" BIGINT,
  "highest_team_score_batting" BIGINT,
  "lowest_completed_score_batting" BIGINT
);

Men Odi Team Bowling Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_bowling_stats
  • 6.36 kB
  • 17 rows
  • 6 columns
Loading... 
CREATE TABLE men_odi_team_bowling_stats (
  "country" VARCHAR,
  "avg_runs_per_wicket_bowling" DOUBLE,
  "avg_runs_per_six_balls_bowling" DOUBLE,
  "number_of_team_innings_bowling" BIGINT,
  "highest_team_score_bowling" BIGINT,
  "lowest_completed_score_bowling" BIGINT
);

Men Odi Team Match Results 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_match_results_20th_century
  • 38.83 kB
  • 3,371 rows
  • 11 columns
Loading... 
CREATE TABLE men_odi_team_match_results_20th_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Men Odi Team Match Results 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_match_results_21st_century
  • 55.83 kB
  • 5,170 rows
  • 11 columns
Loading... 
CREATE TABLE men_odi_team_match_results_21st_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Men T20i Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_t20i_player_innings_stats_21st_century
  • 630.16 kB
  • 104,622 rows
  • 28 columns
Loading... 
CREATE TABLE men_t20i_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men T20i Team Batting Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_t20i_team_batting_stats
  • 11.12 kB
  • 17 rows
  • 12 columns
Loading... 
CREATE TABLE men_t20i_team_batting_stats (
  "country" VARCHAR,
  "team_matches_played" BIGINT,
  "matches_won" BIGINT,
  "matches_lost" BIGINT,
  "matches_tied" BIGINT,
  "matches_with_no_result" BIGINT,
  "win_loss_ratio" DOUBLE,
  "avg_runs_per_wicket_batting" DOUBLE,
  "avg_runs_per_six_balls_batting" DOUBLE,
  "number_of_team_innings_batting" BIGINT,
  "highest_team_score_batting" BIGINT,
  "lowest_completed_score_batting" BIGINT
);

Men T20i Team Bowling Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_t20i_team_bowling_stats
  • 6.37 kB
  • 17 rows
  • 6 columns
Loading... 
CREATE TABLE men_t20i_team_bowling_stats (
  "country" VARCHAR,
  "avg_runs_per_wicket_bowling" DOUBLE,
  "avg_runs_per_six_balls_bowling" DOUBLE,
  "number_of_team_innings_bowling" BIGINT,
  "highest_team_score_bowling" BIGINT,
  "lowest_completed_score_bowling" BIGINT
);

Men T20i Team Match Results 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_t20i_team_match_results_21st_century
  • 25.39 kB
  • 1,647 rows
  • 11 columns
Loading... 
CREATE TABLE men_t20i_team_match_results_21st_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Men Test Player Innings Stats 19th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_player_innings_stats_19th_century
  • 53.66 kB
  • 5,170 rows
  • 28 columns
Loading... 
CREATE TABLE men_test_player_innings_stats_19th_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" BIGINT,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Test Player Innings Stats 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_player_innings_stats_20th_century
  • 863.98 kB
  • 116,160 rows
  • 28 columns
Loading... 
CREATE TABLE men_test_player_innings_stats_20th_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Test Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_player_innings_stats_21st_century
  • 1.48 MB
  • 208,778 rows
  • 28 columns
Loading... 
CREATE TABLE men_test_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Test Team Batting Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_test_team_batting_stats
  • 10.69 kB
  • 11 rows
  • 12 columns
Loading... 
CREATE TABLE men_test_team_batting_stats (
  "country" VARCHAR,
  "team_matches_played" BIGINT,
  "matches_won" BIGINT,
  "matches_lost" BIGINT,
  "matches_tied" BIGINT,
  "matches_drawn" BIGINT,
  "win_loss_ratio" DOUBLE,
  "avg_runs_per_wicket_batting" DOUBLE,
  "avg_runs_per_six_balls_batting" DOUBLE,
  "number_of_team_innings_batting" BIGINT,
  "highest_team_score_batting" BIGINT,
  "lowest_completed_score_batting" BIGINT
);

Men Test Team Bowling Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_test_team_bowling_stats
  • 6.16 kB
  • 11 rows
  • 6 columns
Loading... 
CREATE TABLE men_test_team_bowling_stats (
  "country" VARCHAR,
  "avg_runs_per_wicket_bowling" DOUBLE,
  "avg_runs_per_six_balls_bowling" DOUBLE,
  "number_of_team_innings_bowling" BIGINT,
  "highest_team_score_bowling" BIGINT,
  "lowest_completed_score_bowling" BIGINT
);

Men Test Team Match Results 19th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_team_match_results_19th_century
  • 9.62 kB
  • 130 rows
  • 11 columns
Loading... 
CREATE TABLE men_test_team_match_results_19th_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Men Test Team Match Results 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_team_match_results_20th_century
  • 41.14 kB
  • 2,946 rows
  • 11 columns
Loading... 
CREATE TABLE men_test_team_match_results_20th_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Men Test Team Match Results 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.men_test_team_match_results_21st_century
  • 26.76 kB
  • 1,727 rows
  • 11 columns
Loading... 
CREATE TABLE men_test_team_match_results_21st_century (
  "result" VARCHAR,
  "margin" VARCHAR,
  "match" VARCHAR,
  "home_away" VARCHAR,
  "ground" VARCHAR,
  "match_date" VARCHAR,
  "match_month" VARCHAR,
  "match_year" BIGINT,
  "match_period" VARCHAR,
  "matches" BIGINT,
  "country" VARCHAR
);

Women Odi Player Innings Stats 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.women_odi_player_innings_stats_20th_century
  • 137.47 kB
  • 15,154 rows
  • 28 columns
Loading... 
CREATE TABLE women_odi_player_innings_stats_20th_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Women Odi Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.women_odi_player_innings_stats_21st_century
  • 598.13 kB
  • 107,988 rows
  • 28 columns
Loading... 
CREATE TABLE women_odi_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Women T20i Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.women_t20i_player_innings_stats_21st_century
  • 415.39 kB
  • 78,038 rows
  • 28 columns
Loading... 
CREATE TABLE women_t20i_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Women Test Player Innings Stats 20th Century

@kaggle.cclayford_cricinfo_statsguru_data.women_test_player_innings_stats_20th_century
  • 85.74 kB
  • 8,690 rows
  • 28 columns
Loading... 
CREATE TABLE women_test_player_innings_stats_20th_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Women Test Player Innings Stats 21st Century

@kaggle.cclayford_cricinfo_statsguru_data.women_test_player_innings_stats_21st_century
  • 49.74 kB
  • 6,864 rows
  • 28 columns
Loading... 
CREATE TABLE women_test_player_innings_stats_21st_century (
  "innings_player" VARCHAR,
  "innings_runs_scored" VARCHAR,
  "innings_runs_scored_num" VARCHAR,
  "innings_minutes_batted" VARCHAR,
  "innings_batted_flag" DOUBLE,
  "innings_not_out_flag" DOUBLE,
  "innings_balls_faced" VARCHAR,
  "innings_boundary_fours" VARCHAR,
  "innings_boundary_sixes" VARCHAR,
  "innings_batting_strike_rate" VARCHAR,
  "innings_number" BIGINT,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "innings_date" VARCHAR,
  "country" VARCHAR,
  "n_50_s" DOUBLE  -- 50\u0027s,
  "n_100_s" DOUBLE  -- 100\u0027s,
  "innings_runs_scored_buckets" VARCHAR,
  "innings_overs_bowled" VARCHAR,
  "innings_bowled_flag" DOUBLE,
  "innings_maidens_bowled" VARCHAR,
  "innings_runs_conceded" VARCHAR,
  "innings_wickets_taken" VARCHAR,
  "n_4_wickets" DOUBLE  -- 4 Wickets,
  "n_5_wickets" DOUBLE  -- 5 Wickets,
  "n_10_wickets" DOUBLE  -- 10 Wickets,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Share link

Anyone who has the link will be able to view this.