IPL DATASET

"IPL Dataset: Exploring Cricket Statistics and Player Performance"

@kaggle.umairziact_ipl_dataset

Table List

1 table(391.67 KB)

Ipl Data

@kaggle.umairziact_ipl_dataset.ipl_data

391.67 KB
76014 rows
15 columns

mid Mid	date Date	venue Venue	bat_team Bat Team	bowl_team Bowl Team	batsman Batsman	bowler Bowler	runs Runs	overs Overs	runs_last_5 Runs Last 5	striker Striker	total Total
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	SC Ganguly	P Kumar	1	0.1	1		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	1	0.2	1		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	2	0.2	2		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	2	0.3	2		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	2	0.4	2		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	2	0.5	2		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	P Kumar	3	0.6	3		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	Z Khan	3	1.1	3		222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	Z Khan	7	1.2	7	4	222
1	Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	M Chinnaswamy Stadium	Kolkata Knight Riders	Royal Challengers Bangalore	BB McCullum	Z Khan	11	1.3	11	8	222


CREATE TABLE ipl_data (
  "mid" BIGINT,
  "date" TIMESTAMP,
  "venue" VARCHAR,
  "bat_team" VARCHAR,
  "bowl_team" VARCHAR,
  "batsman" VARCHAR,
  "bowler" VARCHAR,
  "runs" BIGINT,
  "wickets" BIGINT,
  "overs" DOUBLE,
  "runs_last_5" BIGINT,
  "wickets_last_5" BIGINT,
  "striker" BIGINT,
  "non_striker" BIGINT,
  "total" BIGINT
);