Cricket Dataset
Stats are for all 3 formats of the game
@kaggle.notkrishna_cricket_statistics_for_all_formats
Stats are for all 3 formats of the game
@kaggle.notkrishna_cricket_statistics_for_all_formats
CREATE TABLE odb (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"no" BIGINT,
"runs" BIGINT,
"hs" VARCHAR,
"ave" DOUBLE,
"bf" BIGINT,
"sr" DOUBLE,
"n_100" BIGINT,
"n_50" BIGINT,
"n_0" BIGINT,
"n_4s" VARCHAR,
"n_6s" VARCHAR
);
CREATE TABLE odbo (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"balls" BIGINT,
"runs" BIGINT,
"wkts" BIGINT,
"bbi" VARCHAR,
"ave" DOUBLE,
"econ" DOUBLE,
"sr" DOUBLE,
"n_4" BIGINT,
"n_5" BIGINT
);
CREATE TABLE odt (
"unnamed_0" BIGINT,
"series_tournament" VARCHAR,
"season" VARCHAR,
"unnamed_2" VARCHAR,
"winner" VARCHAR,
"margin" VARCHAR
);
CREATE TABLE tb (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" VARCHAR,
"inns" BIGINT,
"no" BIGINT,
"runs" BIGINT,
"hs" VARCHAR,
"ave" DOUBLE,
"n_100" BIGINT,
"n_50" BIGINT,
"n_0" BIGINT
);
CREATE TABLE tbo (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" VARCHAR,
"inns" BIGINT,
"balls" BIGINT,
"runs" BIGINT,
"wkts" BIGINT,
"bbi" VARCHAR,
"bbm" VARCHAR,
"ave" DOUBLE,
"econ" DOUBLE,
"sr" DOUBLE,
"n_5" BIGINT,
"n_10" BIGINT
);
CREATE TABLE tt (
"unnamed_0" BIGINT,
"series_tournament" VARCHAR,
"season" VARCHAR,
"unnamed_2" VARCHAR,
"winner" VARCHAR,
"margin" VARCHAR
);
CREATE TABLE twb (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"no" BIGINT,
"runs" BIGINT,
"hs" VARCHAR,
"ave" DOUBLE,
"bf" BIGINT,
"sr" DOUBLE,
"n_100" BIGINT,
"n_50" BIGINT,
"n_0" BIGINT,
"n_4s" BIGINT,
"n_6s" BIGINT
);
CREATE TABLE twbo (
"unnamed_0" BIGINT,
"player" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"overs" DOUBLE,
"mdns" BIGINT,
"runs" BIGINT,
"wkts" BIGINT,
"bbi" VARCHAR,
"ave" DOUBLE,
"econ" DOUBLE,
"sr" DOUBLE,
"n_4" BIGINT,
"n_5" BIGINT
);
CREATE TABLE twt (
"unnamed_0" BIGINT,
"series_tournament" VARCHAR,
"season" VARCHAR,
"unnamed_2" VARCHAR,
"winner" VARCHAR,
"margin" VARCHAR
);
Anyone who has the link will be able to view this.