Kumar Sangakkara Test Data
Test Cricket Data Kumar Sangakkara
@kaggle.pavin123_kumar_sangakkara_test_data
Test Cricket Data Kumar Sangakkara
@kaggle.pavin123_kumar_sangakkara_test_data
The data is comprised of data from Kumar Sangakkara's test cricket career. There are five different files.
The data has been scraped from the ESPN cricinfo statsguru data query. All and any suggestions and improvements are welcome.
CREATE TABLE sanga_cumulative_avg_test (
"unnamed_0" BIGINT -- Unnamed: 0,
"mat" BIGINT,
"runs" BIGINT,
"hs" VARCHAR,
"bowl_avg" DOUBLE,
"n_100" BIGINT -- 100,
"wickets" VARCHAR,
"bbi" VARCHAR,
"bowl_av" VARCHAR,
"n_5" VARCHAR -- 5,
"catches" BIGINT,
"stumpings" BIGINT,
"ave_diff" VARCHAR,
"opposition" VARCHAR,
"start_date" VARCHAR
);
CREATE TABLE sanga_innings_test (
"unnamed_0" BIGINT -- Unnamed: 0,
"inns" BIGINT,
"score" VARCHAR,
"overs" VARCHAR,
"conc" VARCHAR,
"wkts" VARCHAR,
"catches" VARCHAR,
"stumpings" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"start_date" VARCHAR
);
CREATE TABLE sanga_match_awards_test (
"unnamed_0" BIGINT -- Unnamed: 0,
"award" VARCHAR,
"innings1" VARCHAR,
"innings2" VARCHAR,
"runs" BIGINT,
"wickets" VARCHAR,
"conceded" VARCHAR,
"catches" BIGINT,
"stumpings" BIGINT,
"opposition" VARCHAR,
"ground" VARCHAR,
"start_date" VARCHAR
);
CREATE TABLE sanga_matches_test (
"unnamed_0" BIGINT -- Unnamed: 0,
"innings1" VARCHAR,
"innings2" VARCHAR,
"runs" VARCHAR,
"wickets" VARCHAR,
"conceded" VARCHAR,
"catches" BIGINT,
"stumpings" BIGINT,
"opposition" VARCHAR,
"ground" VARCHAR,
"start_date" VARCHAR
);
CREATE TABLE sanga_match_results_test (
"unnamed_0" BIGINT -- Unnamed: 0,
"result" VARCHAR,
"margin" VARCHAR,
"toss" VARCHAR,
"bat" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"start_date" VARCHAR
);
Anyone who has the link will be able to view this.