IPL 2024 Ball By Ball Dataset
deliveries.csv from IPL 2022
@kaggle.sahiltailor_ipl_2024_ball_by_ball_dataset
deliveries.csv from IPL 2022
@kaggle.sahiltailor_ipl_2024_ball_by_ball_dataset
CREATE TABLE ipl_2022_deliveries (
"match_id" BIGINT,
"season" BIGINT,
"match_no" BIGINT,
"date" TIMESTAMP,
"venue" VARCHAR,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"innings" BIGINT,
"over" DOUBLE,
"striker" VARCHAR,
"bowler" VARCHAR,
"runs_of_bat" BIGINT,
"extras" BIGINT,
"wide" BIGINT,
"legbyes" BIGINT,
"byes" BIGINT,
"noballs" BIGINT,
"wicket_type" VARCHAR,
"player_dismissed" VARCHAR,
"fielder" VARCHAR
);
CREATE TABLE ipl_2023_deliveries (
"match_id" BIGINT,
"season" BIGINT,
"match_no" BIGINT,
"date" TIMESTAMP,
"venue" VARCHAR,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"innings" BIGINT,
"over" DOUBLE,
"striker" VARCHAR,
"bowler" VARCHAR,
"runs_of_bat" BIGINT,
"extras" BIGINT,
"wide" BIGINT,
"legbyes" BIGINT,
"byes" BIGINT,
"noballs" BIGINT,
"wicket_type" VARCHAR,
"player_dismissed" VARCHAR,
"fielder" VARCHAR
);
CREATE TABLE ipl_2024_deliveries (
"match_id" BIGINT,
"season" BIGINT,
"match_no" BIGINT,
"date" TIMESTAMP,
"venue" VARCHAR,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"innings" BIGINT,
"over" DOUBLE,
"striker" VARCHAR,
"bowler" VARCHAR,
"runs_of_bat" BIGINT,
"extras" BIGINT,
"wide" BIGINT,
"legbyes" BIGINT,
"byes" BIGINT,
"noballs" BIGINT,
"wicket_type" VARCHAR,
"player_dismissed" VARCHAR,
"fielder" VARCHAR
);
Anyone who has the link will be able to view this.