Test Cricket Matches Dataset (1877 - 2024)

Dataset containing all test cricket matches data since 1877

@kaggle.bhuvaneshprasad_test_matches_dataset_1877_2023

Table List

6 tables(3.31 MB)

Test Partnership Card

Test Batting Card

@kaggle.bhuvaneshprasad_test_matches_dataset_1877_2023.test_batting_card

934.13 KB
101574 rows
13 columns

match_id Match ID	innings Innings	team Team	batsman Batsman	runs Runs	balls Balls	fours Fours	sixes Sixes	strikerate StrikeRate	isout IsOut	wickettype WicketType	fielders Fielders	bowler Bowler
1213062	1	Bangladesh	48391	3	5			60	true	lbw	nan	59220
1213062	1	Bangladesh	80555		2				true	caught	['53493']	95855
1213062	1	Bangladesh	70872	44	110	6		40	true	caught	['54018']	59220
1213062	1	Bangladesh	58225	30	59	5		50.84	true	caught	['54018']	95855
1213062	1	Bangladesh	47352	25	48	4		52.08	true	caught	['53493']	95855
1213062	1	Bangladesh	50414	63	140	7	1	45	true	caught	['54018']	103399
1213062	1	Bangladesh	66691	33	46	7		71.73	true	lbw	nan	53639
1198242	1	Pakistan	49236	1	5			20	true	lbw	nan	10829
1213062	1	Bangladesh	59679	24	72	4		33.33	true	caught	['45170']	53639
1198242	1	Pakistan	48306	60	111	7		54.05	true	caught	['59611']	72103


CREATE TABLE test_batting_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "team" VARCHAR,
  "batsman" BIGINT,
  "runs" DOUBLE,
  "balls" DOUBLE,
  "fours" DOUBLE,
  "sixes" DOUBLE,
  "strikerate" DOUBLE,
  "isout" BOOLEAN,
  "wickettype" VARCHAR,
  "fielders" VARCHAR,
  "bowler" DOUBLE
);