All T20 Internationals Dataset (2005 - 2024)
Comprehensive Records of T20 International Cricket Matches from 2005 Onwards
@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023
Players Info
@kaggle.bhuvaneshprasad_all_t20_internationals_dataset_2005_to_2023.players_info
- 627.57 KB
- 6701 rows
- 11 columns
player_idPlayer Id | player_object_idPlayer Object Id | player_namePlayer Name | dobDob | dodDod | genderGender | batting_styleBatting Style | bowling_styleBowling Style | country_idCountry Id | image_urlImage Url | image_metadataImage 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
);