ICC World Test Championship Data
Batting Average data for WTC
@kaggle.shubhamzorc9_icc_world_test_championship_batting_data
Batting Average data for WTC
@kaggle.shubhamzorc9_icc_world_test_championship_batting_data
The dataset contains the batting and bowling data for players who played in test matches under the ICC World test Championship. The data has been obtained from ESPN CricInfo and contains data from the following Teams
Australia | Bangladesh | England | India | New Zealand | Pakistan | South Africa | Sri Lanka | West Indies
Following are the columns in the dataset
-Player
-Mat
-Inns
-NO
-Runs
-HS
-Ave
-BF
-SR
-100
-50
-0
-4s
-6s
CREATE TABLE wtc_batting_average (
"player" VARCHAR,
"mat" VARCHAR,
"inns" VARCHAR,
"no" VARCHAR,
"runs" VARCHAR,
"hs" VARCHAR,
"ave" VARCHAR,
"bf" VARCHAR,
"sr" VARCHAR,
"n_100" VARCHAR -- 100,
"n_50" VARCHAR -- 50,
"n_0" VARCHAR -- 0,
"n_4s" VARCHAR -- 4s,
"n_6s" VARCHAR -- 6s,
"country" VARCHAR
);CREATE TABLE wtc_bowling_average (
"player" VARCHAR,
"mat" VARCHAR,
"inns" VARCHAR,
"overs" VARCHAR,
"mdns" VARCHAR,
"runs" VARCHAR,
"wkts" VARCHAR,
"bbi" VARCHAR,
"bbm" VARCHAR,
"ave" VARCHAR,
"econ" VARCHAR,
"sr" VARCHAR,
"n_5" VARCHAR -- 5,
"n_10" VARCHAR -- 10,
"ct" BIGINT,
"st" BIGINT,
"country" VARCHAR
);Anyone who has the link will be able to view this.