Most Wickets In Test Cricket History

Leading wicket takers in Test Cricket History

@kaggle.anubhavgoyal10_most_wickets_in_test_cricket_history

Table List

1 table(15.41 KB)

Test Wickets

@kaggle.anubhavgoyal10_most_wickets_in_test_cricket_history.test_wickets

15.41 KB
79 rows
15 columns

rank Rank	player Player	country Country	career_span Career Span	matches Matches	innings Innings	balls Balls	runs Runs	wickets Wickets	average Average	economy Economy	strike_rate Strike Rate	n_5 5	n_10 10	best_figures Best Figures
1	M Muralidaran	SL	18	133	230	44039	18180	800	22.72	2.47	55	67	22	9/51
2	SK Warne	AUS	15	145	273	40705	17995	708	25.41	2.65	57.4	37	10	8/71
3	JM Anderson	ENG	19	175	325	37505	17491	667	26.22	2.79	56.2	32	3	7/42
4	A Kumble	INDIA	18	132	236	40850	18355	619	29.65	2.69	65.9	35	8	10/74
5	SCJ Broad	ENG	15	159	293	31982	15720	566	27.77	2.94	56.5	19	3	8/15
6	GD McGrath	AUS	14	124	243	29248	12186	563	21.64	2.49	51.9	29	3	8/24
7	CA Walsh	WI	17	132	242	30019	12688	519	24.44	2.53	57.8	22	3	7/37
8	R Ashwin	INDIA	11	86	162	23089	10666	442	24.13	2.77	52.2	30	7	7/59
9	DW Steyn	SA	15	93	171	18608	10077	439	22.95	3.24	42.3	26	5	7/51
10	NM Lyon	AUS	11	110	207	28583	14047	438	32.07	2.94	65.2	20	3	8/50


CREATE TABLE test_wickets (
  "rank" BIGINT,
  "player" VARCHAR,
  "country" VARCHAR,
  "career_span" BIGINT,
  "matches" BIGINT,
  "innings" BIGINT,
  "balls" BIGINT,
  "runs" BIGINT,
  "wickets" BIGINT,
  "average" DOUBLE,
  "economy" DOUBLE,
  "strike_rate" DOUBLE,
  "n_5" BIGINT,
  "n_10" BIGINT,
  "best_figures" VARCHAR
);