IPL 2008-2023 All Match Dataset
Ball By Ball and Match Info Data
@kaggle.reeteshojha_ipl_2008_2023_match_dataset
Ball By Ball and Match Info Data
@kaggle.reeteshojha_ipl_2008_2023_match_dataset
IPL is among the most famous cricket league with players coming from worldwide. What makes this series more competitive this year is the auction resulting in all players changing their squad and two new teams added to the league. This dataset is a complete dataset from 2008 to 2023 Final.
The file IPL_Matches.csv contains all details of the match: Venue of the match, Toss Decision, Match Winer, Man of the Match, Squads, etc.
The file IPL_Ball_by_Bal.csv contains ball by ball data of each and every match: Batsman on strike, Bowler, Extras, Runs, Wicket Ball, etc.
CREATE TABLE ipl_ball_by_ball (
"id" BIGINT,
"innings" BIGINT,
"overs" BIGINT,
"ballnumber" BIGINT,
"batter" VARCHAR,
"bowler" VARCHAR,
"nonstriker" VARCHAR,
"extratype" VARCHAR,
"batsmanrun" BIGINT,
"extrasrun" BIGINT,
"totalrun" BIGINT,
"iswicketdelivery" BIGINT,
"playerout" VARCHAR,
"kind" VARCHAR,
"fieldersinvolved" VARCHAR,
"battingteam" VARCHAR
);CREATE TABLE ipl_matches (
"id" BIGINT,
"city" VARCHAR,
"date" TIMESTAMP,
"season" VARCHAR,
"matchnumber" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"venue" VARCHAR,
"tosswinner" VARCHAR,
"tossdecision" VARCHAR,
"winningteam" VARCHAR,
"margin" BIGINT,
"wonby" VARCHAR,
"player_of_match" VARCHAR,
"team1players" VARCHAR,
"team2players" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"umpire3" VARCHAR
);Anyone who has the link will be able to view this.