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
  • 47.11 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,
  "n_50" VARCHAR,
  "n_0" VARCHAR,
  "n_4s" VARCHAR,
  "n_6s" VARCHAR,
  "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,
  "n_5_innings_wickets" VARCHAR,
  "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
  • 545 KB
  • 72842 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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.36 MB
  • 327328 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men Odi Team Batting Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_batting_stats
  • 10.95 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.21 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
  • 37.92 KB
  • 3371 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
  • 54.52 KB
  • 5170 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
  • 615.4 KB
  • 104622 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Men T20i Team Batting Stats

@kaggle.cclayford_cricinfo_statsguru_data.men_t20i_team_batting_stats
  • 10.86 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.22 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
  • 24.79 KB
  • 1647 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
  • 52.4 KB
  • 5170 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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
  • 843.73 KB
  • 116160 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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.41 MB
  • 208778 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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.44 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.01 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.39 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
  • 40.18 KB
  • 2946 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.13 KB
  • 1727 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
  • 134.25 KB
  • 15154 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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
  • 584.11 KB
  • 107988 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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
  • 405.65 KB
  • 78038 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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
  • 83.73 KB
  • 8690 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "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
  • 48.57 KB
  • 6864 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,
  "n_100_s" DOUBLE,
  "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,
  "n_5_wickets" DOUBLE,
  "n_10_wickets" DOUBLE,
  "innings_wickets_taken_buckets" VARCHAR,
  "innings_economy_rate" VARCHAR
);

Share link

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