ICC Cricket World Cup CWC23 All Innings

Complete & cleaned for analysis

@kaggle.jdaustralia_icc_cwc23_all_innings_cleaned

Table List

1 table(39.82 KB)

Cwc23 All Innings

@kaggle.jdaustralia_icc_cwc23_all_innings_cleaned.cwc23_all_innings

39.82 KB
1437 rows
20 columns

team Team	player Player	bat_or_bowl Bat Or Bowl	bb_bf Bb Bf	runs Runs	wkts Wkts	wicketball_prob Wicketball Prob	runs_per_ball Runs Per Ball	opposition Opposition	ground Ground	start_date Start Date	overs Overs	mdns Mdns	econ Econ	inns Inns
PAK	Shaheen Shah Afridi (PAK)	bowl	60	45	3	0.05	0.75	v South Africa	Chennai	27-Oct-23	10		4.5	2
ENG	DJ Willey (ENG)	bowl	60	45	3	0.05	0.75	v India	Lucknow	29-Oct-23	10	2	4.5	1
NZ	MJ Henry (NZ)	bowl	60	48	3	0.05	0.8	v England	Ahmedabad	5-Oct-23	10	1	4.8	1
NZ	LH Ferguson (NZ)	bowl	60	49	3	0.05	0.816666667	v Bangladesh	Chennai	13-Oct-23	10		4.9	1
AFG	Noor Ahmad (AFG)	bowl	60	49	3	0.05	0.816666667	v Pakistan	Chennai	23-Oct-23	10		4.9	1
AFG	Mujeeb Ur Rahman (AFG)	bowl	60	51	3	0.05	0.85	v England	Delhi	15-Oct-23	10	1	5.1	2
ENG	AU Rashid (ENG)	bowl	48	54	3	0.0625	1.125	v Netherlands	Pune	8-Nov-23	8		6.75	2
NED	LV van Beek (NED)	bowl	53	60	3	0.056603774	1.132075472	v South Africa	Dharamsala	17-Oct-23	8.5		6.79	2
BAN	Mehidy Hasan Miraz (BAN)	bowl	54	60	3	0.055555556	1.111111111	v Pakistan	Eden Gardens	31-Oct-23	9		6.66	2
PAK	Mohammad Wasim (1) (PAK)	bowl	60	60	3	0.05	1	v New Zealand	Bengaluru	4-Nov-23	10		6	1


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,
  "n_6s" DOUBLE,
  "sr" DOUBLE,
  "not_out" DOUBLE,
  "mins" DOUBLE
);