Indian Premier League Cricket (2023)

Indian Premier League 2023

@kaggle.pardeep19singh_indian_premier_league_cricket_2023

Table List

2 tables(92.05 KB)

Deliveries

@kaggle.pardeep19singh_indian_premier_league_cricket_2023.deliveries

75.77 KB
17863 rows
22 columns

match_id Match Id	season Season	start_date Start Date	venue Venue	innings Innings	ball Ball	batting_team Batting Team	bowling_team Bowling Team	striker Striker	non_striker Non Striker	bowler Bowler	runs_off_bat Runs Off Bat	extras Extras	legbyes Legbyes	wicket_type Wicket Type	player_dismissed Player Dismissed
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.1	Chennai Super Kings	Gujarat Titans	DP Conway	RD Gaikwad	Mohammed Shami				nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.2	Chennai Super Kings	Gujarat Titans	DP Conway	RD Gaikwad	Mohammed Shami		1	1	nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.3	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	Mohammed Shami				nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.4	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	Mohammed Shami	1			nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.5	Chennai Super Kings	Gujarat Titans	DP Conway	RD Gaikwad	Mohammed Shami				nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	0.6	Chennai Super Kings	Gujarat Titans	DP Conway	RD Gaikwad	Mohammed Shami				nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.1	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	HH Pandya	4			nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.2	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	HH Pandya				nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.3	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	HH Pandya	4			nan	nan
1359475	2023	Fri Mar 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Narendra Modi Stadium, Ahmedabad	1	1.4	Chennai Super Kings	Gujarat Titans	RD Gaikwad	DP Conway	HH Pandya	1			nan	nan


CREATE TABLE deliveries (
  "match_id" BIGINT,
  "season" BIGINT,
  "start_date" TIMESTAMP,
  "venue" VARCHAR,
  "innings" BIGINT,
  "ball" DOUBLE,
  "batting_team" VARCHAR,
  "bowling_team" VARCHAR,
  "striker" VARCHAR,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "runs_off_bat" BIGINT,
  "extras" BIGINT,
  "wides" DOUBLE,
  "noballs" DOUBLE,
  "byes" DOUBLE,
  "legbyes" DOUBLE,
  "penalty" VARCHAR,
  "wicket_type" VARCHAR,
  "player_dismissed" VARCHAR,
  "other_wicket_type" VARCHAR,
  "other_player_dismissed" VARCHAR
);