Ipl 2022

Batting and bowling scorecards for ipl 2022

@kaggle.vikramrn_ipl_2022

Table List

2 tables(69.6 KB)

Bowling

@kaggle.vikramrn_ipl_2022.bowling

24.75 KB
857 rows
20 columns

matchid MatchID	inningsno InningsNo	team Team	playername PlayerName	overs Overs	runs Runs	wickets Wickets	wides Wides	noballs NoBalls	economy Economy	bowlingorder BowlingOrder	totallegalballsbowled TotalLegalBallsBowled	dotballs DotBalls	ones Ones	twos Twos	fours Fours	sixes Sixes	strikerate StrikeRate
1	1	KKR	Umesh Yadav	4	20	2	2	1	5	1	24	15	7		1	1	12
1	1	KKR	Shivam Mavi	4	35		1	1	8.75	2	24	12	7	1	3	2
1	1	KKR	Varun Chakaravarthy	4	23	1	1		5.75	3	24	11	10	1	1	1	24
1	1	KKR	Sunil Narine	4	15				3.75	4	24	10	13	1
1	1	KKR	Andre Russell	4	38	1			9.5	5	24	7	10	1	5	1	24
1	2	CSK	Tushar Deshpande	3	23				7.67	1	18	9	3	2	4
1	2	CSK	Adam Milne	2.3	19				7.6	2	15	9	1	2	2	1
1	2	CSK	Mitchell Santner	4	31	1			7.75	3	24	5	13	4	1	1	24
1	2	CSK	Dwayne Bravo	4	20	3			5	4	24	11	10	1	2		8
1	2	CSK	Shivam Dube	1	11				11	5	6	1	3		3


CREATE TABLE bowling (
  "matchid" BIGINT,
  "inningsno" BIGINT,
  "team" VARCHAR,
  "playername" VARCHAR,
  "overs" DOUBLE,
  "maidens" BIGINT,
  "runs" BIGINT,
  "wickets" BIGINT,
  "wides" BIGINT,
  "noballs" BIGINT,
  "economy" DOUBLE,
  "bowlingorder" BIGINT,
  "totallegalballsbowled" BIGINT,
  "dotballs" BIGINT,
  "ones" BIGINT,
  "twos" BIGINT,
  "threes" BIGINT,
  "fours" BIGINT,
  "sixes" BIGINT,
  "strikerate" DOUBLE
);