IPL 6s And 4s : 2007-24
Season wise, match wise data of all boundaries in IPL : 2007 - 24
@kaggle.roslinux_ipl_deliveries_6s_and_4s_2007_24
Season wise, match wise data of all boundaries in IPL : 2007 - 24
@kaggle.roslinux_ipl_deliveries_6s_and_4s_2007_24
This dataset is a subset of deliveries dataset shared by PRATEEK BHARDWAJ. The deliveries are separated as 6s and 4s in 2 separate files.
I have used this data for data visualization project in this video.
Data Source : https://www.kaggle.com/datasets/patrickb1912/ipl-complete-dataset-20082020
CREATE TABLE ipl_2007_2024_deliveries_4s (
"match_id" BIGINT,
"season" VARCHAR,
"inning" BIGINT,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"over" BIGINT,
"ball" BIGINT,
"batter" VARCHAR,
"bowler" VARCHAR,
"non_striker" VARCHAR,
"batsman_runs" BIGINT,
"extra_runs" BIGINT,
"total_runs" BIGINT,
"extras_type" VARCHAR,
"is_wicket" BIGINT,
"player_dismissed" VARCHAR,
"dismissal_kind" VARCHAR,
"fielder" VARCHAR,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" DOUBLE -- Unnamed: 26
);CREATE TABLE ipl_2007_2024_deliveries_6s (
"match_id" BIGINT,
"season" VARCHAR,
"inning" BIGINT,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"over" BIGINT,
"ball" BIGINT,
"batter" VARCHAR,
"bowler" VARCHAR,
"non_striker" VARCHAR,
"batsman_runs" BIGINT,
"extra_runs" BIGINT,
"total_runs" BIGINT,
"extras_type" VARCHAR,
"is_wicket" BIGINT,
"player_dismissed" VARCHAR,
"dismissal_kind" VARCHAR,
"fielder" VARCHAR
);CREATE TABLE ipl_2007_2024_matches (
"id" BIGINT,
"season" VARCHAR,
"city" VARCHAR,
"date" TIMESTAMP,
"match_type" VARCHAR,
"player_of_match" VARCHAR,
"venue" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"winner" VARCHAR,
"result" VARCHAR,
"result_margin" DOUBLE,
"target_runs" DOUBLE,
"target_overs" DOUBLE,
"super_over" VARCHAR,
"method" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR
);Anyone who has the link will be able to view this.