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

Players Info

@kaggle.bhuvaneshprasad_test_matches_dataset_1877_2023.players_info

627.57 KB
6701 rows
11 columns

player_id Player Id	player_object_id Player Object Id	player_name Player Name	dob Dob	gender Gender	batting_style Batting Style	bowling_style Bowling Style	country_id Country Id	image_url Image Url	image_metadata Image Metadata
93957	1046619	Avinash Pai	Sun Jan 24 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm offbreak	18	nan	nan
2182	51462	Sherwin Campbell	Sun Nov 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm medium	4	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/326600/326616.4.jpg	{'id': 326616, 'url': '/db/PICTURES/CMS/326600/326616.4.jpg', 'slug': 'sherwin-campbell-player-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 254, 'caption': 'Sherwin Campbell, player portrait', 'objectId': 1275842, 'peerUrls': None, 'longCaption': 'Sherwin Campbell, player portrait', …
48391	56194	Tamim Iqbal	Mon Mar 20 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	M	left-hand bat	nan	25	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/303100/303166.jpg	{'id': 303166, 'url': '/db/PICTURES/CMS/303100/303166.jpg', 'slug': 'tamim-iqbal-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 201, 'caption': 'Tamim Iqbal portrait', 'objectId': 1221600, 'peerUrls': None, 'longCaption': 'Tamim Iqbal portrait, April 2020', 'photographer': None}
2198	55935	Javed Omar	Thu Nov 25 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	legbreak	25	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/302900/302990.jpg	{'id': 302990, 'url': '/db/PICTURES/CMS/302900/302990.jpg', 'slug': 'javed-omar-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 202, 'caption': 'Javed Omar portrait', 'objectId': 1221372, 'peerUrls': None, 'longCaption': 'Javed Omar portrait, April 2020', 'photographer': None}
52290	298438	Jason Roy	Sat Jul 21 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	nan	1	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/303900/303963.jpg	{'id': 303963, 'url': '/db/PICTURES/CMS/303900/303963.jpg', 'slug': 'jason-roy-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 200, 'caption': 'Jason Roy portrait', 'objectId': 1222865, 'peerUrls': None, 'longCaption': 'Jason Roy, May 2020', 'photographer': None}
87157	938959	Wessly Madhevere	Mon Sep 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm offbreak	9	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/324700/324710.4.jpg	{'id': 324710, 'url': '/db/PICTURES/CMS/324700/324710.4.jpg', 'slug': 'wessley-madhevere-player-portrait', 'width': 160, 'credit': 'ICC/Getty Images', 'height': 216, 'caption': 'Wessley Madhevere, player portrait', 'objectId': 1270432, 'peerUrls': None, 'longCaption': 'Wessley Madhevere, player port…
48927	226492	Martin Guptill	Tue Sep 30 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm offbreak	5	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/303600/303656.png	{'id': 303656, 'url': '/db/PICTURES/CMS/303600/303656.png', 'slug': 'martin-guptill-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 200, 'caption': 'Martin Guptill portrait', 'objectId': 1222454, 'peerUrls': None, 'longCaption': 'Martin Guptill, May 2020', 'photographer': None}
51444	290462	Solomon Mire	Mon Aug 21 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm medium-fast	9	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/205200/205281.1.jpg	{'id': 205281, 'url': '/db/PICTURES/CMS/205200/205281.1.jpg', 'slug': 'solomon-mire', 'width': 160, 'credit': 'Getty Images', 'height': 200, 'caption': 'Solomon Mire', 'objectId': 828123, 'peerUrls': None, 'longCaption': 'Solomon Mire, February 9, 2015', 'photographer': None}
1550	38757	John Wright	Mon Jul 05 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	M	left-hand bat	right-arm medium	5	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/303700/303762.png	{'id': 303762, 'url': '/db/PICTURES/CMS/303700/303762.png', 'slug': 'john-wright-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 201, 'caption': 'John Wright portrait', 'objectId': 1222588, 'peerUrls': None, 'longCaption': 'John Wright, May 2020', 'photographer': None}
10381	37265	Jamie How	Tue May 19 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	M	right-hand bat	right-arm medium	5	https://img1.hscicdn.com/image/upload/f_auto,t_ds_w_1280,q_80/lsci/db/PICTURES/CMS/303600/303649.png	{'id': 303649, 'url': '/db/PICTURES/CMS/303600/303649.png', 'slug': 'jamie-how-portrait', 'width': 160, 'credit': 'Getty Images', 'height': 200, 'caption': 'Jamie How portrait', 'objectId': 1222447, 'peerUrls': None, 'longCaption': 'Jamie How, May 2020', 'photographer': None}


CREATE TABLE players_info (
  "player_id" BIGINT,
  "player_object_id" BIGINT,
  "player_name" VARCHAR,
  "dob" TIMESTAMP,
  "dod" TIMESTAMP,
  "gender" VARCHAR,
  "batting_style" VARCHAR,
  "bowling_style" VARCHAR,
  "country_id" DOUBLE,
  "image_url" VARCHAR,
  "image_metadata" VARCHAR
);