ICC Cricket World Cup Centuries

List of Centuries Scored at the World Cup

@kaggle.kabhishm_icc_cricket_world_cup_centuries

Table List

1 table(15.95 KB)

Worldcup Centuries

@kaggle.kabhishm_icc_cricket_world_cup_centuries.worldcup_centuries

15.95 KB
196 rows
12 columns

player Player	runs Runs	balls Balls	n_4s 4s	n_6s 6s	s_r S/R	team Team	opposition Opposition	venue Venue	date Date	result Result	not_out Not Out
Dennis Amiss	137	147	18		93.19	England	India	Lord's, London	7 June 1975	Won
Glenn Turner	171	201	16	2	85.07	New Zealand	East Africa	Edgbaston Cricket Ground, Birmingham	7 June 1975	Won	1
Keith Fletcher	131	147	13		89.11	England	New Zealand	Trent Bridge, Nottingham	11 June 1975	Won
Alan Turner	101	113	9	1	89.38	Australia	Sri Lanka	The Oval, London	11 June 1975	Won
Glenn Turner	114	177	13		64.4	New Zealand	India	Old Trafford Cricket Ground, Manchester	14 June 1975	Won	1
Clive Lloyd	102	85	12	2	120	West Indies	Australia	Lord's, London	21 June 1975	Won
Gordon Greenidge	106	173	9	1	61.27	West Indies	India	Edgbaston Cricket Ground, Birmingham	9 June 1979	Won	1
Viv Richards	138	157	11	3	87.89	West Indies	England	Lord's, London	23 June 1979	Won	1
Allan Lamb	102	105	12	2	97.14	England	New Zealand	The Oval, London	9 June 1983	Won
David Gower	130	120	12	5	108.33	England	Sri Lanka	County Ground, Taunton	11 June 1983	Won


CREATE TABLE worldcup_centuries (
  "player" VARCHAR,
  "runs" BIGINT,
  "balls" BIGINT,
  "n_4s" BIGINT,
  "n_6s" BIGINT,
  "s_r" DOUBLE,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "venue" VARCHAR,
  "date" VARCHAR,
  "result" VARCHAR,
  "not_out" BIGINT
);