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 Matches Data

@kaggle.bhuvaneshprasad_test_matches_dataset_1877_2023.test_matches_data

363.58 KB
2537 rows
40 columns

test_match_no TEST Match No	match_id Match ID	match_name Match Name	series_id Series ID	series_name Series Name	match_start_date Match Start Date	match_end_date Match End Date	match_format Match Format	team1_id Team1 ID	team1_name Team1 Name	team1_captain Team1 Captain	innings1_team1_runs_scored Innings1 Team1 Runs Scored	innings1_team1_wickets_fell Innings1 Team1 Wickets Fell	innings1_team1_extras_rec Innings1 Team1 Extras Rec	innings2_team1_runs_scored Innings2 Team1 Runs Scored	innings2_team1_wickets_fell Innings2 Team1 Wickets Fell	innings2_team1_extras_rec Innings2 Team1 Extras Rec	team2_id Team2 ID	team2_name Team2 Name	team2_captain Team2 Captain	innings1_team2_runs_scored Innings1 Team2 Runs Scored	innings1_team2_wickets_fell Innings1 Team2 Wickets Fell	innings1_team2_extras_rec Innings1 Team2 Extras Rec	innings2_team2_runs_scored Innings2 Team2 Runs Scored	innings2_team2_wickets_fell Innings2 Team2 Wickets Fell	innings2_team2_extras_rec Innings2 Team2 Extras Rec	match_venue_stadium Match Venue (Stadium)	match_venue_city Match Venue (City)	match_venue_country Match Venue (Country)	umpire_1 Umpire 1	umpire_2 Umpire 2	match_referee Match Referee	toss_winner Toss Winner	toss_winner_choice Toss Winner Choice	match_winner Match Winner	match_result_text Match Result Text	mom_player MOM Player	team1_playing_11 Team1 Playing 11	team2_playing_11 Team2 Playing 11	debut_players Debut Players
2378	1183534	Australia Vs New Zealand 3Rd Test	1195334	ICC World Test Championship - 2019 (2019-2021)	Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	2	Australia	34747	454	10	8	217	2	7	5	New Zealand	59148	256	10	11	136	9	4	Sydney Cricket Ground	Sydney	Australia	Aleem Dar	M Erasmus	RB Richardson	Australia	bat	Australia	Australia won by 279 runs	78285	['48739', '54337', '78285', '50281', '49024', '66190', '34747', '50781', '64244', '53330', '50724']	['59148', '61839', '51094', '44930', '80639', '47492', '47231', '48641', '48432', '49219', '64947']	['80639']
2383	1212542	Zimbabwe Vs Sri Lanka 2Nd Test	1212540	Sri Lanka in Zimbabwe - 2020 (2019/20)	Mon Jan 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	9	Zimbabwe	47206	406	10	12	247	7	21	8	Sri Lanka	48988	293	10	19	204	3	3	Harare Sports Club	Harare	Zimbabwe	Aleem Dar	Nitin Menon	J Srinath	Zimbabwe	bat	nan	Match drawn	52319	['49274', '49118', '62298', '47205', '45253', '47206', '52319', '51554', '55145', '59384', '72441']	['48988', '57982', '70888', '47023', '52371', '62760', '61131', '46995', '81061', '62757', '78235']	['55145']
2384	1213062	Pakistan Vs Bangladesh 1St Test	1195334	Bangladesh in Pakistan - 2020 (2019/20)	Fri Feb 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	25	Bangladesh	58225	233	10	10	168	10	2	7	Pakistan	11475	445	10	7				Rawalpindi Cricket Stadium	Rawalpindi	Pakistan	CB Gaffaney	NJ Llong	RB Richardson	Pakistan	bowl	Pakistan	Pakistan won by an innings and 44 runs	103399	['48391', '80555', '70872', '58225', '47352', '50414', '66691', '59679', '52364', '60029', '86321']	['49236', '48306', '11475', '56880', '53493', '53639', '54018', '45170', '95855', '59220', '103399']	['80555']
650	63035	Pakistan Vs England 3Rd Test	60425	England tour of Pakistan - 1969 (1968/69)	Thu Mar 06 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 10 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	1	England	998	502	7	28				7	Pakistan	1065							National Stadium	Karachi	Pakistan	Daud Khan	Shujauddin	nan	England	bat	nan	Match drawn		['1282', '1203', '895', '998', '1316', '1283', '1301', '1270', '1273', '1284', '1296']	['1323', '931', '1105', '1237', '1065', '1239', '1241', '1117', '1299', '1324', '1329']	['1329']
651	63037	New Zealand Vs West Indies 2Nd Test	60426	West Indies tour of New Zealand - 1969 (1968/69)	Fri Mar 07 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 11 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	4	West Indies	985	297	10	20	148	10	7	5	New Zealand	1176	282	10	25	166	4	23	Basin Reserve	Wellington	New Zealand	RWR Shortt	ECA MacKintosh	nan	New Zealand	bowl	New Zealand	New Zealand won by 6 wickets		['1322', '1202', '1129', '1084', '1286', '985', '1281', '1183', '1130', '1321', '1067']	['1176', '1328', '1251', '1326', '1259', '1253', '1199', '1265', '1172', '1227', '1327']	[]
652	63038	New Zealand Vs West Indies 3Rd Test	60426	West Indies tour of New Zealand - 1969 (1968/69)	Thu Mar 13 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 17 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	4	West Indies	985	417	10	14				5	New Zealand	1176	217	10	9	367	6	27	Lancaster Park	Christchurch	New Zealand	ECA MacKintosh	WT Martin	nan	West Indies	bat	nan	Match drawn		['1322', '1202', '1129', '1084', '1286', '985', '1281', '1183', '1130', '1321', '1067']	['1176', '1328', '1199', '1251', '1326', '1311', '1259', '1265', '1172', '1227', '1327']	[]
653	63039	England Vs West Indies 1St Test	60427	West Indies tour of England and Ireland - 1969 (1969)	Thu Jun 12 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 17 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	1	England	1081	413	10	15	12		2	4	West Indies	985	147	10	5	275	10	13	Old Trafford	Manchester	England	CS Elliott	JS Buller	nan	England	bat	England	England won by 10 wickets		['1228', '1203', '1205', '895', '1283', '1301', '1081', '1161', '1273', '1284', '1270']	['1322', '1202', '1084', '1320', '985', '1286', '1330', '1332', '1183', '1331', '1067']	['1332', '1330', '1331']
654	63040	England Vs West Indies 2Nd Test	60427	West Indies tour of England and Ireland - 1969 (1969)	Thu Jun 26 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 01 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	4	West Indies	985	380	10	9	295	9	12	1	England	1081	344	10	16	295	7	19	Lord's	London	England	AE Fagg	JS Buller	nan	West Indies	bat	nan	Match drawn		['1322', '1308', '1320', '1084', '985', '1286', '1332', '1333', '1331', '1067', '1335']	['1228', '1203', '1178', '1283', '1205', '1334', '1301', '1081', '1161', '1273', '1270']	['1335', '1334', '1333']
655	63041	England Vs West Indies 3Rd Test	60427	West Indies tour of England and Ireland - 1969 (1969)	Thu Jul 10 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 15 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	1	England	1081	223	10	8	240	10	7	4	West Indies	985	161	9	8	272	10	14	Headingley	Leeds	England	AE Fagg	CS Elliott	nan	England	bat	England	England won by 30 runs		['1228', '1203', '1205', '1334', '1283', '1301', '1081', '1161', '1284', '1273', '1270']	['1322', '1308', '1320', '1084', '985', '1286', '1333', '1331', '1067', '1335', '1332']	[]
656	63042	England Vs New Zealand 1St Test	60428	New Zealand tour of England - 1969 (1969)	Thu Jul 24 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 28 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	TEST	1	England	1081	190	10	6	340	10	24	5	New Zealand	1176	169	10	8	131	10	10	Lord's	London	England	A Jepson	JS Buller	nan	England	bat	England	England won by 230 runs		['1228', '1203', '1205', '1316', '1283', '1301', '1081', '1161', '1273', '1284', '1339']	['1176', '1328', '1251', '1326', '1259', '1311', '1338', '1265', '1172', '1336', '1337']	['1339', '1336', '1337', '1338']


CREATE TABLE test_matches_data (
  "test_match_no" BIGINT,
  "match_id" BIGINT,
  "match_name" VARCHAR,
  "series_id" BIGINT,
  "series_name" VARCHAR,
  "match_start_date" TIMESTAMP,
  "match_end_date" TIMESTAMP,
  "match_format" VARCHAR,
  "team1_id" BIGINT,
  "team1_name" VARCHAR,
  "team1_captain" BIGINT,
  "innings1_team1_runs_scored" BIGINT,
  "innings1_team1_wickets_fell" BIGINT,
  "innings1_team1_extras_rec" BIGINT,
  "innings2_team1_runs_scored" DOUBLE,
  "innings2_team1_wickets_fell" DOUBLE,
  "innings2_team1_extras_rec" DOUBLE,
  "team2_id" BIGINT,
  "team2_name" VARCHAR,
  "team2_captain" BIGINT,
  "innings1_team2_runs_scored" DOUBLE,
  "innings1_team2_wickets_fell" DOUBLE,
  "innings1_team2_extras_rec" DOUBLE,
  "innings2_team2_runs_scored" DOUBLE,
  "innings2_team2_wickets_fell" DOUBLE,
  "innings2_team2_extras_rec" DOUBLE,
  "match_venue_stadium" VARCHAR,
  "match_venue_city" VARCHAR,
  "match_venue_country" VARCHAR,
  "umpire_1" VARCHAR,
  "umpire_2" VARCHAR,
  "match_referee" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_winner_choice" VARCHAR,
  "match_winner" VARCHAR,
  "match_result_text" VARCHAR,
  "mom_player" DOUBLE,
  "team1_playing_11" VARCHAR,
  "team2_playing_11" VARCHAR,
  "debut_players" VARCHAR
);