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 Bowling Card

@kaggle.bhuvaneshprasad_test_matches_dataset_1877_2023.test_bowling_card

499.99 KB
49120 rows
16 columns

match_id Match ID	innings Innings	team Team	opposition Opposition	bowler_id Bowler Id	overs Overs	balls Balls	maidens Maidens	conceded Conceded	wickets Wickets	economy Economy	dots Dots	fours Fours	wides Wides	noballs Noballs
1198242	1	England	Pakistan	10829	27	162	5	60	3	2.22	132	7		1
1198242	1	England	Pakistan	48440	27.2	164	9	56	4	2.04	135	5
1198242	1	England	Pakistan	72103	18	108	3	44	1	2.44	82	3
1198242	1	England	Pakistan	49496	19	114	3	55	1	2.89	86	5	1
1198242	2	Pakistan	England	95855	10	60	3	25	1	2.5	51	2	1	1
1198242	2	Pakistan	England	59220	14	84	5	28	2	2	74	3		1
1198242	2	Pakistan	England	103399	5	30		10		2	25	1		1
1214666	1	Bangladesh	Zimbabwe	86321	17	102	8	26		1.52	90	3	2
1198242	2	Pakistan	England	45170	11	66	2	30	1	2.72	50	3
1198242	2	Pakistan	England	49236	3	18		14		4.66	12	2


CREATE TABLE test_bowling_card (
  "match_id" BIGINT,
  "innings" BIGINT,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "bowler_id" BIGINT,
  "overs" DOUBLE,
  "balls" BIGINT,
  "maidens" BIGINT,
  "conceded" BIGINT,
  "wickets" BIGINT,
  "economy" DOUBLE,
  "dots" DOUBLE,
  "fours" DOUBLE,
  "sixes" DOUBLE,
  "wides" BIGINT,
  "noballs" BIGINT
);