Dataset: IPL 6s And 4s : 2007-24

About this Dataset

IPL 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

Tables

Ipl 2007–2024 Deliveries 4s

@kaggle.roslinux_ipl_deliveries_6s_and_4s_2007_24.ipl_2007_2024_deliveries_4s

228.1 KB
29850 rows
27 columns


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_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" DOUBLE
);

Ipl 2007–2024 Deliveries 6s

@kaggle.roslinux_ipl_deliveries_6s_and_4s_2007_24.ipl_2007_2024_deliveries_6s

116.22 KB
13051 rows
18 columns


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
);

Ipl 2007–2024 Matches

@kaggle.roslinux_ipl_deliveries_6s_and_4s_2007_24.ipl_2007_2024_matches

45.18 KB
1095 rows
20 columns


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
);