Cricket Mach Dataset

ball to ball coverage of cricket matches

@kaggle.sunnykusawa_cricket_mach_dataset

Table List

1 table(1.57 MB)

Odi Cricket Match Dataset

@kaggle.sunnykusawa_cricket_mach_dataset.odi_cricket_match_dataset

1.57 MB
350899 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	total Total
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston		0.1		301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston		0.2		301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston	4	0.3	4	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston	6	0.4	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston	6	0.5	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	ME Trescothick	DT Johnston	6	0.6	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	EC Joyce	D Langford-Smith	6	1.1	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	EC Joyce	D Langford-Smith	6	1.2	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	EC Joyce	D Langford-Smith	6	1.3	6	301
1	Tue Jun 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Civil Service Cricket Club, Stormont	England	Ireland	EC Joyce	D Langford-Smith	7	1.3	7	301


CREATE TABLE odi_cricket_match_dataset (
  "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
);