Cricket Player Statistics (December 2022)

Individual batting/bowling career statistics for cricketers as at December 2022.

@kaggle.aaronjones32_cricket_player_statistics_december_2022

Table List

1 table(588.15 KB)

Cricket Player Stats

@kaggle.aaronjones32_cricket_player_statistics_december_2022.cricket_player_stats

588.15 KB
5717 rows
77 columns

unnamed_0 Unnamed: 0	name Name	team Team	date_of_birth Date Of Birth	bt_test_m BT Test M	bt_test_inn BT Test Inn	bt_test_no BT Test NO	bt_test_runs BT Test Runs	bt_test_hs BT Test HS	bt_test_avg BT Test Avg	bt_test_bf BT Test BF	bt_test_sr BT Test SR	bt_test_100 BT Test 100	bt_test_200 BT Test 200	bt_test_50 BT Test 50	bt_test_4s BT Test 4s	bt_test_6s BT Test 6s	bt_odi_m BT ODI M	bt_odi_inn BT ODI Inn	bt_odi_no BT ODI NO	bt_odi_runs BT ODI Runs	bt_odi_hs BT ODI HS	bt_odi_avg BT ODI Avg	bt_odi_bf BT ODI BF	bt_odi_sr BT ODI SR	bt_odi_100 BT ODI 100	bt_odi_200 BT ODI 200	bt_odi_50 BT ODI 50	bt_odi_4s BT ODI 4s	bt_odi_6s BT ODI 6s	bt_t20i_m BT T20I M	bt_t20i_inn BT T20I Inn	bt_t20i_no BT T20I NO	bt_t20i_runs BT T20I Runs	bt_t20i_hs BT T20I HS	bt_t20i_avg BT T20I Avg	bt_t20i_bf BT T20I BF	bt_t20i_sr BT T20I SR	bt_t20i_50 BT T20I 50	bt_t20i_4s BT T20I 4s	bt_t20i_6s BT T20I 6s	bw_test_m BW Test M	bw_test_inn BW Test Inn	bw_test_b BW Test B	bw_test_runs BW Test Runs	bw_test_wkts BW Test Wkts	bw_test_bbi BW Test BBI	bw_test_bbm BW Test BBM	bw_test_econ BW Test Econ	bw_test_avg BW Test Avg	bw_test_sr BW Test SR	bw_test_5w BW Test 5W	bw_test_10w BW Test 10W	bw_odi_m BW ODI M	bw_odi_inn BW ODI Inn	bw_odi_b BW ODI B	bw_odi_runs BW ODI Runs	bw_odi_wkts BW ODI Wkts	bw_odi_bbm BW ODI BBM	bw_odi_econ BW ODI Econ	bw_odi_avg BW ODI Avg	bw_odi_sr BW ODI SR	bw_odi_5w BW ODI 5W	bw_t20i_m BW T20I M	bw_t20i_inn BW T20I Inn	bw_t20i_b BW T20I B	bw_t20i_runs BW T20I Runs	bw_t20i_wkts BW T20I Wkts	bw_t20i_bbm BW T20I BBM	bw_t20i_econ BW T20I Econ	bw_t20i_avg BW T20I Avg	bw_t20i_sr BW T20I SR
	Sachin Tendulkar	India	Apr 24, 1973 (49 years)	200	329	33	15921	248	53.79	29437	54.08	51	6	68	2058	69	463	452	41	18426	200	44.83	21367	86.24	49	1	96	2016	195	1	1		10	10	10	12	83.33		2		200	145	4240	2492	46	3 for 10	3 for 14	3.53	54.17	92.17			463	270	8054	6850	154	5 for 32	5.1	44.48	52.3	2	1	1	15	12	1	1 for 12	4.8	12	15
1	Virender Sehwag	India	Oct 20, 1978 (44 years)	104	180	6	8586	319	49.34	10441	82.23	23	6	32	1233	91	251	245	9	8273	219	35.06	7929	104.34	15	1	38	1132	136	19	18		394	68	21.89	271	145.39	2	43	16	104	91	3731	1894	40	5 for 104	5 for 118	3.05	47.35	93.28	1		251	146	4392	3853	96	4 for 6	5.26	40.14	45.75		19	1	6	20		0 for 20	20
2	Rahul Dravid	India	Jan 11, 1973 (49 years)	164	286	32	13288	270	52.31	31258	42.51	36	5	63	1655	21	344	318	40	10889	153	39.17	15284	71.24	12		83	950	42	1	1		31	31	31	21	147.62			3	164	5	120	39	1	1 for 18	1 for 18	1.95	39	120			344	8	186	170	4	2 for 43	5.48	42.5	46.5		1					0
3	VVS Laxman	India	Nov 01, 1974 (48 years)	134	225	32	8781	281	45.5	17785	49.37	17	2	56	1135	5	86	83	7	2338	131	30.76	3282	71.24	6		10	222	4												134	13	324	126	2	1 for 2	1 for 2	2.33	63	162			86	4	42	40		0 for 5	5.71									0
4	Sourav Ganguly	India	Jul 08, 1972 (50 years)	113	188	17	7212	239	42.18	14070	51.26	16	1	35	900	57	311	300	21	11363	183	40.73	15416	73.71	22		72	1122	190												113	99	3117	1681	32	3 for 28	3 for 37	3.24	52.53	97.41			311	171	4561	3849	100	5 for 16	5.06	38.49	45.61	2						0
5	Shoaib Akhtar	Pakistan	Aug 13, 1975 (47 years)	46	67	13	544	47	10.07	1313	41.43				53	22	163	84	40	394	43	8.95	538	73.23				27	12	15	6	3	21	8	7	16	131.25		2	1	46	82	8143	4574	178	6 for 11	11 for 78	3.37	25.7	45.75	12	2	163	162	7764	6169	247	6 for 16	4.77	24.98	31.43	4	15	15	318	432	19	3 for 38	8.15	22.74	16.74
6	Mohammad Sami	Pakistan	Feb 24, 1981 (41 years)	36	56	14	487	49	11.6	1582	30.78				53	4	87	46	19	314	46	11.63	490	64.08				16	10	13	4	3	21	8	21	30	70		2		36	66	7499	4483	85	5 for 36	8 for 106	3.59	52.74	88.22	2		87	85	4284	3567	121	5 for 10	5	29.48	35.4	1	13	13	276	387	21	3 for 16	8.41	18.43	13.14
7	Shabbir Ahmed	Pakistan	Apr 21, 1976 (46 years)	10	15	5	88	24	8.8	234	37.61				10		32	11	5	10	2	1.67	29	34.48						1											10	19	2576	1175	51	5 for 48	8 for 109	2.74	23.04	50.51	2		32	32	1642	1192	33	3 for 32	4.36	36.12	49.76		1	1	12	19		0 for 19	9.5
8	Shoaib Malik	Pakistan	Feb 01, 1982 (40 years)	35	60	6	1898	245	35.15	4155	45.68	3	1	8	239	17	287	258	40	7534	143	34.56	9199	81.9	9		44	603	113	124	111	33	2435	75	31.22	1938	125.64	9	196	69	35	43	2712	1519	32	4 for 33	7 for 59	3.36	47.47	84.75			287	217	7958	6192	158	4 for 19	4.67	39.19	50.37		124	50	570	675	28	2 for 7	7.11	24.11	20.36
9	Mohammad Yousuf	Pakistan	Aug 27, 1974 (48 years)	90	156	12	7530	223	52.29	14372	52.39	24	4	33	957	51	288	273	40	9720	141	41.72	12942	75.1	15		64	785	90	3	3		50	26	16.67	43	116.28		5	1	90	1	6	3		0 for 3	0 for 3	3					288	2	2	1	1	1 for 0		1	2		3					0


CREATE TABLE cricket_player_stats (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "team" VARCHAR,
  "date_of_birth" VARCHAR,
  "bt_test_m" BIGINT,
  "bt_test_inn" BIGINT,
  "bt_test_no" BIGINT,
  "bt_test_runs" BIGINT,
  "bt_test_hs" BIGINT,
  "bt_test_avg" DOUBLE,
  "bt_test_bf" BIGINT,
  "bt_test_sr" DOUBLE,
  "bt_test_100" BIGINT,
  "bt_test_200" BIGINT,
  "bt_test_50" BIGINT,
  "bt_test_4s" BIGINT,
  "bt_test_6s" BIGINT,
  "bt_odi_m" BIGINT,
  "bt_odi_inn" BIGINT,
  "bt_odi_no" BIGINT,
  "bt_odi_runs" BIGINT,
  "bt_odi_hs" BIGINT,
  "bt_odi_avg" DOUBLE,
  "bt_odi_bf" BIGINT,
  "bt_odi_sr" DOUBLE,
  "bt_odi_100" BIGINT,
  "bt_odi_200" BIGINT,
  "bt_odi_50" BIGINT,
  "bt_odi_4s" BIGINT,
  "bt_odi_6s" BIGINT,
  "bt_t20i_m" BIGINT,
  "bt_t20i_inn" BIGINT,
  "bt_t20i_no" BIGINT,
  "bt_t20i_runs" BIGINT,
  "bt_t20i_hs" BIGINT,
  "bt_t20i_avg" DOUBLE,
  "bt_t20i_bf" BIGINT,
  "bt_t20i_sr" DOUBLE,
  "bt_t20i_100" BIGINT,
  "bt_t20i_200" BIGINT,
  "bt_t20i_50" BIGINT,
  "bt_t20i_4s" BIGINT,
  "bt_t20i_6s" BIGINT,
  "bw_test_m" BIGINT,
  "bw_test_inn" BIGINT,
  "bw_test_b" BIGINT,
  "bw_test_runs" BIGINT,
  "bw_test_wkts" BIGINT,
  "bw_test_bbi" VARCHAR,
  "bw_test_bbm" VARCHAR,
  "bw_test_econ" DOUBLE,
  "bw_test_avg" DOUBLE,
  "bw_test_sr" DOUBLE,
  "bw_test_5w" BIGINT,
  "bw_test_10w" BIGINT,
  "bw_odi_m" BIGINT,
  "bw_odi_inn" BIGINT,
  "bw_odi_b" BIGINT,
  "bw_odi_runs" BIGINT,
  "bw_odi_wkts" BIGINT,
  "bw_odi_bbm" VARCHAR,
  "bw_odi_econ" DOUBLE,
  "bw_odi_avg" DOUBLE,
  "bw_odi_sr" DOUBLE,
  "bw_odi_5w" BIGINT,
  "bw_odi_10w" BIGINT,
  "bw_t20i_m" BIGINT,
  "bw_t20i_inn" BIGINT,
  "bw_t20i_b" BIGINT,
  "bw_t20i_runs" BIGINT,
  "bw_t20i_wkts" BIGINT,
  "bw_t20i_bbm" VARCHAR,
  "bw_t20i_econ" DOUBLE,
  "bw_t20i_avg" DOUBLE,
  "bw_t20i_sr" DOUBLE,
  "bw_t20i_5w" BIGINT,
  "bw_t20i_10w" BIGINT
);