Cricket query

SQL

Format:

Gender:

(Help)

Men's Test

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
67,388 BC Lara West Indies 400 400* True 778 582 43 4 68.72 3 1 England St John's 10 April 2004 p52337 m64080
65,935 ML Hayden Australia 380 380 False 622 437 38 11 86.95 2 1 Zimbabwe Perth 9 October 2003 p5616 m64048
50,008 BC Lara West Indies 375 375 False 766 538 45 0 69.70 3 1 England St John's 16 April 1994 p52337 m63641
72,020 DPMD Jayawardene Sri Lanka 374 374 False 752 572 43 1 65.38 4 2 South Africa Colombo (SSC) 27 July 2006 p49289 m249193
17,866 GS Sobers West Indies 365 365* True 614 38 0 3 2 Pakistan Kingston 26 February 1958 p52946 m62837
10,571 L Hutton England 364 364 False 797 847 35 0 42.97 1 1 Australia The Oval 20 August 1938 p14334 m62652
54,571 ST Jayasuriya Sri Lanka 340 340 False 799 578 36 2 58.82 1 2 India Colombo (RPS) 2 August 1997 p49209 m63762
17,710 Hanif Mohammad Pakistan 337 337 False 970 24 0 1 3 West Indies Bridgetown 17 January 1958 p40373 m62835
9,000 WR Hammond England 336 336* True 318 34 10 3 2 New Zealand Auckland 31 March 1933 p14022 m62612
94,940 DA Warner Australia 335 335* True 554 418 39 1 80.14 1 1 Pakistan Adelaide 29 November 2019 p219889 m1183531

38ms

Women's Test

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
4,701 Kiran Baluch Pakistan 242 242 False 584 488 38 0 49.59 1 1 West Indies Karachi 15 March 2004 p54989 m67521
4,495 M Raj India 214 214 False 598 407 19 0 52.57 4 2 England Taunton 14 August 2002 p54273 m67515
5,430 EA Perry Australia 213 213* True 374 27 1 56.95 4 2 England Sydney 9 November 2017 p275487 m1086066
4,384 KL Rolton Australia 209 209* True 361 313 29 1 66.77 3 2 England Leeds 6 July 2001 p53458 m67512
4,032 KE Flavell New Zealand 204 204 False 3 2 England Scarborough 24 June 1996 p54388 m67502
4,352 MAJ Goszko Australia 204 204 False 395 345 24 0 59.13 4 2 England Shenley 24 June 2001 p53428 m67511
4,164 J Broadbent Australia 200 200 False 517 476 25 0 42.01 3 2 England Guildford 6 August 1998 p53404 m67506
3,395 DA Annetts Australia 193 193 False 4 2 England Wetherby 21 August 1987 p53477 m67484
5,339 MDT Kamini India 192 192 False 541 430 24 1 44.65 1 1 South Africa Mysore 16 November 2014 p220728 m797899
3,316 S Agarwal India 190 190 False 2 2 England Worcester 12 July 1986 p53913 m67482

1ms

Men's ODI

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
78,089 RG Sharma India 264 264 False 225 173 33 9 152.60 2 1 Sri Lanka Kolkata 13 November 2014 p34102 m792295
80,266 MJ Guptill New Zealand 237 237* True 223 163 24 11 145.39 1 1 West Indies Wellington 21 March 2015 p226492 m656489
71,027 V Sehwag India 219 219 False 208 149 25 7 146.97 2 1 West Indies Indore 8 December 2011 p35263 m536932
79,585 CH Gayle West Indies 215 215 False 212 147 10 16 146.25 2 1 Zimbabwe Canberra 24 February 2015 p51880 m656427
88,561 Fakhar Zaman Pakistan 210 210* True 221 156 24 5 134.61 2 1 Zimbabwe Bulawayo 20 July 2018 p512191 m1142923
99,103 Ishan Kishan India 210 210 False 169 131 24 10 160.30 2 1 Bangladesh Chattogram 10 December 2022 p720471 m1340847
75,536 RG Sharma India 209 209 False 222 158 12 16 132.27 1 1 Australia Bengaluru 2 November 2013 p34102 m647261
86,822 RG Sharma India 208 208* True 212 153 13 12 135.94 1 1 Sri Lanka Mohali 13 December 2017 p34102 m1122727
99,281 Shubman Gill India 208 208 False 225 149 19 9 139.59 2 1 New Zealand Hyderabad 18 January 2023 p1070173 m1348646
65,285 SR Tendulkar India 200 200* True 226 147 25 3 136.05 2 1 South Africa Gwalior 24 February 2010 p35320 m441828

20ms

Women's ODI

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
24,595 AC Kerr New Zealand 232 232* True 195 145 31 2 160 2 1 Ireland Dublin 13 June 2018 p803971 m1145893
5,607 BJ Clark Australia 229 229* True 181 155 22 0 147.74 1 1 Denmk Mumbai 16 December 1997 p53413 m67194
23,120 DB Sharma India 188 188 False 195 160 27 2 117.50 1 1 Ireland Potchefstroom 15 May 2017 p597811 m1089527
23,342 AMCJK Athapaththu Sri Lanka 178 178* True 143 22 6 124.47 3 1 Australia Bristol 29 June 2017 p318853 m1085952
28,491 Sidra Ameen Pakistan 176 176* True 151 20 1 116.55 2 1 Ireland Lahore 4 November 2022 p362356 m1308233
5,629 CM Edwards England 173 173* True 186 155 19 0 111.61 1 1 Ireland Pune 16 December 1997 p53696 m66983
18,721 SR Taylor West Indies 171 171 False 194 137 18 2 124.81 2 1 Sri Lanka Mumbai 3 February 2013 p355359 m594898
23,827 H Kaur India 171 171* True 143 115 20 7 148.69 4 1 Australia Derby 20 July 2017 p372317 m1085974
28,006 AJ Healy Australia 170 170 False 188 138 26 0 123.18 1 1 England Christchurch 3 April 2022 p275486 m1243938
15,466 SW Bates New Zealand 168 168 False 130 105 19 6 160 3 1 Pakistan Sydney 19 March 2009 p54565 m357975

6ms

Men's T20I

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
15,006 AJ Finch Australia 172 172 False 76 16 10 226.31 1 1 Zimbabwe Harare 3 July 2018 p5334 m1142915
16,392 Hazratullah Zazai Afghanistan 162 162* True 62 11 16 261.29 1 1 Ireland Dehradun 23 February 2019 p793457 m1168113
7,197 AJ Finch Australia 156 156 False 70 63 11 14 247.61 2 1 England Southampton 29 August 2013 p5334 m566937
12,410 GJ Maxwell Australia 145 145* True 65 14 9 223.07 1 1 Sri Lanka Pallekele 6 September 2016 p325026 m995467
34,094 Zeeshan Kukikhel Hungary 137 137 False 49 7 15 279.59 1 2 Austria Lower Austria 5 June 2022 p1204124 m1317142
25,282 MP O'Dowd Netherlands 133 133* True 73 15 6 182.19 1 1 Malaysia Kirtipur 18 April 2021 p643197 m1257946
19,428 HG Munsey Scotland 127 127* True 56 5 14 226.78 1 1 Netherlands Dublin (Malahide) 16 September 2019 p671805 m1200425
13,566 E Lewis West Indies 125 125* True 62 6 12 201.61 2 2 India Kingston 9 July 2017 p431901 m1098211
23,966 Shaheryar Butt Belgium 125 125* True 50 11 9 250 1 1 Czech Republic Walferdange 29 August 2020 p520127 m1229821
10,739 SR Watson Australia 124 124* True 86 71 10 6 174.64 2 1 India Sydney 31 January 2016 p8180 m895821

11ms

Women's T20I

i player team runs runs_txt not_out mins bf fours sixes sr pos innings opposition ground start_date player_id match_id
22,706 HMD Rasangika Bahrain 161 161* True 66 31 0 243.93 3 1 Saudia Arabia Al Amerat 22 March 2022 p54842 m1306389
22,880 ER Oza U.A.E. 158 158* True 71 22 6 222.53 1 1 Bahrain Al Amerat 26 March 2022 p1126416 m1306397
16,981 AJ Healy Australia 148 148* True 61 19 7 242.62 1 1 Sri Lanka Sydney 2 October 2019 p275486 m1183512
15,377 MM Lanning Australia 133 133* True 79 63 17 7 211.11 3 1 England Chelmsford 26 July 2019 p329336 m1168026
21,229 FO Kibasu Tanzania 127 127* True 66 19 0 192.42 1 1 Eswatini Gaborone (Oval 1) 14 September 2021 p1119581 m1275122
5,590 MM Lanning Australia 126 126 False 67 65 18 4 193.84 3 1 Ireland Sylhet 27 March 2014 p329336 m682983
14,979 SL Kalis Netherlands 126 126* True 76 10 5 165.78 1 1 Germany Cartagena 27 June 2019 p774311 m1190606
8,899 DN Wyatt England 124 124 False 64 15 5 193.75 1 2 India Brabourne 25 March 2018 p254168 m1131237
9,504 SW Bates New Zealand 124 124* True 78 66 16 3 187.87 1 1 South Africa Taunton 20 June 2018 p54565 m1126720
8,624 BL Mooney Australia 117 117* True 70 19 1 167.14 1 1 England Canberra 21 November 2017 p381258 m1086069

6ms

By Sean McGivern