IPL Data From 2008-2019
Ball by ball and Match wise data for all Indian Premiere League (IPL)matches
@kaggle.divjain_ipl_data_till_2019
Ball by ball and Match wise data for all Indian Premiere League (IPL)matches
@kaggle.divjain_ipl_data_till_2019
CREATE TABLE innings_data (
"id" BIGINT,
"season" BIGINT,
"batsman" VARCHAR,
"bowler" VARCHAR,
"innings" VARCHAR,
"non_striker" VARCHAR,
"replacements" VARCHAR,
"bowled_over" DOUBLE,
"batsman_team" VARCHAR,
"player_out" VARCHAR,
"fielder_caught_out" VARCHAR,
"type_out" VARCHAR,
"extras_wides" BIGINT,
"extras_legbyes" BIGINT,
"extras_noballs" BIGINT,
"extras_byes" BIGINT,
"extras_penalty" BIGINT,
"total_extras_runs" BIGINT,
"batsman_runs" BIGINT,
"total_runs" BIGINT
);
CREATE TABLE match_data (
"id" BIGINT,
"season" BIGINT,
"city" VARCHAR,
"date" TIMESTAMP,
"team1" VARCHAR,
"team2" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"winner" VARCHAR,
"eliminator" VARCHAR,
"dl_applied" VARCHAR,
"win_by_runs" DOUBLE,
"win_by_wickets" DOUBLE,
"result" VARCHAR,
"overs" BIGINT,
"player_of_match" VARCHAR,
"venue" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"umpire3" VARCHAR,
"first_bat_team" VARCHAR,
"first_bowl_team" VARCHAR,
"first_bat_score" DOUBLE,
"second_bat_score" DOUBLE
);
Anyone who has the link will be able to view this.