Cricket Dataset

Stats are for all 3 formats of the game

@kaggle.notkrishna_cricket_statistics_for_all_formats

Table List

9 tables(149.31 KB)

Odb

Odbo

Odt

Tbo

Twb

Twbo

Twt

Tb

@kaggle.notkrishna_cricket_statistics_for_all_formats.tb

13.65 KB
97 rows
12 columns

unnamed_0 Unnamed: 0	player Player	span Span	mat Mat	inns Inns	no NO	runs Runs	hs HS	ave Ave	n_100 100	n_50 50	n_0 0
	SR Tendulkar (INDIA)	1989-2013	200	329	33	15921	248*	53.78	51	68	14
1	RT Ponting (AUS)	1995-2012	168	287	29	13378	257	51.85	41	62	17
2	JH Kallis (ICC/SA)	1995-2013	166	280	40	13289	224	55.37	45	58	16
3	R Dravid (ICC/INDIA)	1996-2012	164	286	32	13288	270	52.31	36	63	8
4	AN Cook (ENG)	2006-2018	161	291	16	12472	294	45.35	33	57	9
5	KC Sangakkara (SL)	2000-2015	134	233	17	12400	319	57.4	38	52	11
6	BC Lara (ICC/WI)	1990-2006	131	232	6	11953	400*	52.88	34	48	17
7	S Chanderpaul (WI)	1994-2015	164	280	49	11867	203*	51.37	30	66	15
8	DPMD Jayawardene (SL)	1997-2014	149	252	15	11814	374	49.84	34	50	15
9	AR Border (AUS)	1978-1994	156	265	44	11174	205	50.56	27	63	11


CREATE TABLE tb (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "span" VARCHAR,
  "mat" VARCHAR,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "ave" DOUBLE,
  "n_100" BIGINT,
  "n_50" BIGINT,
  "n_0" BIGINT
);