Ipl 2022

Batting and bowling scorecards for ipl 2022

@kaggle.vikramrn_ipl_2022

Table List

2 tables(69.6 KB)

Batting

@kaggle.vikramrn_ipl_2022.batting

44.85 KB
1628 rows
19 columns

matchid MatchID	inningsno InningsNo	team Team	playername PlayerName	matchplayingorder MatchPlayingOrder	bowlername BowlerName	outdesc OutDesc	runs Runs	balls Balls	dotballs DotBalls	ones Ones	twos Twos	fours Fours	sixes Sixes	strikerate StrikeRate	wicketno WicketNo	againstfast AgainstFast	againstspin AgainstSpin
1	1	CSK	Ruturaj Gaikwad	1	Umesh Yadav	c Nitish Rana b Umesh Yadav		4	4					0.00	3	3
1	1	CSK	Devon Conway	2	Umesh Yadav	c Shreyas Iyer b Umesh Yadav	3	8	5	3				37.50	2	8
1	1	CSK	Robin Uthappa	3	Varun Chakaravarthy	st Sheldon Jackson b Varun Chakaravarthy	28	21	10	6	1	2	2	133.33	5	15	6
1	1	CSK	Ambati Rayudu	4	Sunil Narine	run out (Shreyas Iyer)	15	17	10	5		1	1	88.24	1	4	13
1	1	CSK	Ravindra Jadeja	5	nan	not out	26	28	8	18	1		1	92.86		14	14
1	1	CSK	Shivam Dube	7	Andre Russell	c Sunil Narine b Andre Russell	3	6	3	3				50.00	4	3	3
1	1	CSK	MS Dhoni	6	nan	not out	50	38	16	12	2	7	1	131.58		25	12
1	1	CSK	Dwayne Bravo	8	nan	nan								-
1	1	CSK	Adam Milne	9	nan	nan								-
1	1	CSK	Tushar Deshpande	10	nan	nan								-


CREATE TABLE batting (
  "matchid" BIGINT,
  "inningsno" BIGINT,
  "team" VARCHAR,
  "playername" VARCHAR,
  "matchplayingorder" BIGINT,
  "bowlername" VARCHAR,
  "outdesc" VARCHAR,
  "runs" BIGINT,
  "balls" BIGINT,
  "dotballs" BIGINT,
  "ones" BIGINT,
  "twos" BIGINT,
  "threes" BIGINT,
  "fours" BIGINT,
  "sixes" BIGINT,
  "strikerate" VARCHAR,
  "wicketno" DOUBLE,
  "againstfast" BIGINT,
  "againstspin" BIGINT
);