Baselight

Cricinfo Statsguru Data

For anyone who enjoys Cricket, and analyzing cricket stats.

@kaggle.cclayford_cricinfo_statsguru_data

Men Odi Team Batting Stats
@kaggle.cclayford_cricinfo_statsguru_data.men_odi_team_batting_stats

  • 10.95 KB
  • 17 rows
  • 12 columns
country

Country

team_matches_played

Team Matches Played

matches_won

Matches Won

matches_lost

Matches Lost

matches_tied

Matches Tied

matches_with_no_result

Matches With No Result

win_loss_ratio

Win/Loss Ratio

avg_runs_per_wicket_batting

Avg Runs Per Wicket Batting

avg_runs_per_six_balls_batting

Avg Runs Per Six Balls Batting

number_of_team_innings_batting

Number Of Team Innings Batting

highest_team_score_batting

Highest Team Score Batting

lowest_completed_score_batting

Lowest Completed Score Batting

England7463753349281.12231.14.9173848186
Australia9495753319341.73734.145.0193943470
South Africa6253852166181.78235.765.1162243969
West Indies82240138110301.05230.24.7881138954
New Zealand7723513747400.93829.214.8275740264
India9875134249411.20933.775.0697541854
Pakistan9274864138201.17630.654.8392639943
Sri Lanka8523894215370.92329.534.9183644343
Zimbabwe5291383737110.36925.314.5152535135
Bermuda357280.2521.684.13527578

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
);

Share link

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