ICC Cricket World Cup CWC23 All Innings
Complete & cleaned for analysis
@kaggle.jdaustralia_icc_cwc23_all_innings_cleaned
Complete & cleaned for analysis
@kaggle.jdaustralia_icc_cwc23_all_innings_cleaned
team: 2 or 3 letter code matching that used in player name description.
player: Standard name used in statsguru innings database. Note: this may not match standard name used in statsguru for teamlists.
bat_or_bowl: indicates whether row represents a batting or bowling innings
bb_bf: Ball Bowled or Balls Faced. Provides a consistent and clean statistic. For bowlers, this is a cleaned version of number of overs bowled. So 1.5 overs becomes 11 in the bb_bf column.
runs: Either runs score by batsman or conceded by bowler. If a batsman produces a not out innings, the data is cleaned to only show the score (eg 100, rather than 100*). Reference can be made to the not_out column to determine if the batsman was out or not.
wkts: Number of wickets taken by a bowler in this innings.
wicketball_prob: Number of wickets taken (or lost by batsman) divided by number of balls bowled or faced. Will be zero for a not out batsman. Can be used to represent the probability of taking or losing a wicket in any given delivery. [This stat developed by JDau].
runs_per_ball: Number of runs score or conceded divided by the number of balls bowled or faced. Represents the average runs score or conceded per ball in this innings. [This stat developed by JDau].
opposition: The team this innings was played against
ground: Which ground in India was the game played
start_date: Which date the game was played
overs: Represents the number of overs delivered by each bowler. This is raw data. Compare to the cleaned bb_bf column. A full over is usually 6 deliveries. A partially completed over will be shown as a decimal point where 0.1 represents 1 delivery. So 1.5 overs means the bowler 1 complete over and 5 additional balls for 11 deliveries.
mdns: Number of maidens a bowler bowled. A maiden is an over of 6 balls that does not concede any runs.
econ: The average number of runs conceded by the bowler per over in this innings. Compare to runs_per_ball column.
inns: 1 means this was the first innings of the day. 2 represents the 2nd innings of the day. So a row that includes the value 'bowl' in the bat_or_bowl column and 1 in the inns column indicates the innings in this row occurred when that team bowled first and batted second.
4s: How many 4's did the batsman score
6s: How many 6's did the batsman score
sr: The batsman strike rate. This has been converted to runs_per_ball by diving the sr by 100.
not_out: Whether the batsman's innings was a not out or not. This column removes the need for a * beside the batsman's score.
mins: Duration of a batsman's inning in minutes.
CREATE TABLE cwc23_all_innings (
"team" VARCHAR,
"player" VARCHAR,
"bat_or_bowl" VARCHAR,
"bb_bf" BIGINT,
"runs" BIGINT,
"wkts" DOUBLE,
"wicketball_prob" DOUBLE,
"runs_per_ball" DOUBLE,
"opposition" VARCHAR,
"ground" VARCHAR,
"start_date" VARCHAR,
"overs" DOUBLE,
"mdns" DOUBLE,
"econ" DOUBLE,
"inns" BIGINT,
"n_4s" DOUBLE -- 4s,
"n_6s" DOUBLE -- 6s,
"sr" DOUBLE,
"not_out" DOUBLE,
"mins" DOUBLE
);Anyone who has the link will be able to view this.