Cricket Data From 2000 To 2020 For South Africa

Cricket matches, players, innings, bat, bowl, venues, etc

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020

Table List

6 tables(110.78 KB)

Bat

Bowl

Ground

Mat

Opposition

Player

Mat

@kaggle.bizzyvinci_south_africa_cricket_data_from_2000_to_2020.mat

23.38 KB
431 rows
9 columns

match_id Match Id	odi_no Odi No	opposition Opposition	ground Ground	match_date Match Date	toss Toss	series Series	result Result	match_days Match Days
64657	1572	6	58230	Thu Mar 09 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to bat first	South Africa tour of India	India led the 5-match series 1-0	9 March 2000 (50-over match)
64658	1573	6	58180	Sun Mar 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to bat first	South Africa tour of India	India led the 5-match series 2-0	12 March 2000 (50-over match)
64659	1574	6	58081	Wed Mar 15 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to field first	South Africa tour of India	India led the 5-match series 2-1	15 March 2000 (50-over match)
64660	1575	6	58516	Fri Mar 17 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to bat first	South Africa tour of India	India led the 5-match series 3-1	17 March 2000 (50-over match)
64661	1576	6	58344	Sun Mar 19 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	India , elected to field first	South Africa tour of India	India won the 5-match series 3-2	19 March 2000 (50-over match)
64662	1587	2	59089	Wed Apr 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to field first	Australia tour of South Africa	South Africa led the 3-match series 1-0	12 April 2000 - day/night match (50-over match)
64663	1589	2	59068	Fri Apr 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Australia , elected to field first	Australia tour of South Africa	3-match series level 1-1	14 April 2000 - day/night match (50-over match)
64664	1591	2	59120	Sun Apr 16 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to field first	Australia tour of South Africa	South Africa won the 3-match series 2-1	16 April 2000 (50-over match)
64665	1620	2	56450	Wed Aug 16 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to field first	South Africa tour of Australia	Australia led the 3-match series 1-0	16 August 2000 - day/night match (50-over match)
64666	1621	2	56450	Fri Aug 18 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa , elected to bat first	South Africa tour of Australia	Australia led the 3-match series 1-0	18 August 2000 - day/night match (50-over match)


CREATE TABLE mat (
  "match_id" BIGINT,
  "odi_no" BIGINT,
  "opposition" BIGINT,
  "ground" BIGINT,
  "match_date" TIMESTAMP,
  "toss" VARCHAR,
  "series" VARCHAR,
  "result" VARCHAR,
  "match_days" VARCHAR
);