International Cricket Player Performance Stats
Detailed Metrics for Every International Match Format
@kaggle.ijajdatanerd_intl_cricketer_stats_odi_t20_tests
Detailed Metrics for Every International Match Format
@kaggle.ijajdatanerd_intl_cricketer_stats_odi_t20_tests
CREATE TABLE all_players (
"id" BIGINT,
"name" VARCHAR,
"gender" VARCHAR,
"bating_style" VARCHAR,
"bowling_style" VARCHAR,
"playing_role" VARCHAR,
"country_id" BIGINT
);
CREATE TABLE country (
"id" BIGINT,
"country" VARCHAR
);
CREATE TABLE fielding (
"id" BIGINT,
"sp" VARCHAR,
"cf" DOUBLE,
"ck" DOUBLE,
"ct" DOUBLE,
"ds" DOUBLE,
"dspi" DOUBLE,
"mds" VARCHAR,
"mt" BIGINT,
"pr" VARCHAR,
"st" DOUBLE
);
CREATE TABLE odi_all_round (
"id" BIGINT,
"bbad" DOUBLE,
"bbi" VARCHAR,
"bta" DOUBLE,
"bwa" DOUBLE,
"ct" BIGINT,
"fw" DOUBLE,
"hn" DOUBLE,
"hs" VARCHAR,
"pr" VARCHAR,
"rn" DOUBLE,
"st" BIGINT,
"wk" DOUBLE,
"sp" VARCHAR
);
CREATE TABLE odi_batting (
"id" BIGINT,
"span" VARCHAR,
"matches" BIGINT,
"innings" DOUBLE,
"not_out" DOUBLE,
"runs" DOUBLE,
"high_score" VARCHAR,
"average_score" DOUBLE,
"ball_faced" DOUBLE,
"strike_rate" DOUBLE,
"n_100s" DOUBLE,
"n_50" DOUBLE,
"n_0s" DOUBLE,
"n_4s" DOUBLE,
"n_6s" DOUBLE
);
CREATE TABLE odi_bowling (
"id" BIGINT,
"sp" VARCHAR,
"bbi" VARCHAR,
"bbm" VARCHAR,
"bl" VARCHAR,
"bwa" DOUBLE,
"bwe" DOUBLE,
"bwsr" DOUBLE,
"cd" DOUBLE,
"fw" DOUBLE,
"fwk" DOUBLE,
"in" DOUBLE,
"md" DOUBLE,
"mt" BIGINT,
"ov" DOUBLE,
"pr" VARCHAR,
"tw" DOUBLE,
"wk" DOUBLE
);
CREATE TABLE t20_all_round (
"id" BIGINT,
"bbad" DOUBLE,
"bbi" VARCHAR,
"bta" DOUBLE,
"bwa" DOUBLE,
"ct" BIGINT,
"fw" DOUBLE,
"hn" DOUBLE,
"hs" VARCHAR,
"pr" VARCHAR,
"rn" DOUBLE,
"st" BIGINT,
"wk" DOUBLE,
"sp" VARCHAR
);
CREATE TABLE t20_batting (
"id" BIGINT,
"span" VARCHAR,
"matches" BIGINT,
"innings" DOUBLE,
"not_out" DOUBLE,
"runs" DOUBLE,
"high_score" VARCHAR,
"average_score" DOUBLE,
"ball_faced" DOUBLE,
"strike_rate" DOUBLE,
"n_100s" DOUBLE,
"n_50" DOUBLE,
"n_0s" DOUBLE,
"n_4s" DOUBLE,
"n_6s" DOUBLE
);
CREATE TABLE t20_bowling (
"id" BIGINT,
"sp" VARCHAR,
"bbi" VARCHAR,
"bbm" VARCHAR,
"bl" VARCHAR,
"bwa" DOUBLE,
"bwe" DOUBLE,
"bwsr" DOUBLE,
"cd" DOUBLE,
"fw" DOUBLE,
"fwk" DOUBLE,
"in" DOUBLE,
"md" DOUBLE,
"mt" BIGINT,
"ov" DOUBLE,
"pr" VARCHAR,
"tw" DOUBLE,
"wk" DOUBLE
);
CREATE TABLE test_all_round (
"id" BIGINT,
"bbad" DOUBLE,
"bbi" VARCHAR,
"bta" DOUBLE,
"bwa" DOUBLE,
"ct" BIGINT,
"fw" DOUBLE,
"hn" BIGINT,
"hs" VARCHAR,
"pr" VARCHAR,
"rn" BIGINT,
"st" BIGINT,
"wk" DOUBLE,
"sp" VARCHAR
);
CREATE TABLE test_batting (
"id" BIGINT,
"span" VARCHAR,
"matches" BIGINT,
"innings" BIGINT,
"not_out" BIGINT,
"runs" BIGINT,
"high_score" VARCHAR,
"average_score" DOUBLE,
"ball_faced" BIGINT,
"strike_rate" DOUBLE,
"n_100s" BIGINT,
"n_50" BIGINT,
"n_0s" BIGINT,
"n_4s" BIGINT,
"n_6s" BIGINT
);
CREATE TABLE test_bowling (
"id" BIGINT,
"sp" VARCHAR,
"bbi" VARCHAR,
"bbm" VARCHAR,
"bl" VARCHAR,
"bwa" DOUBLE,
"bwe" DOUBLE,
"bwsr" DOUBLE,
"cd" DOUBLE,
"fw" DOUBLE,
"fwk" DOUBLE,
"in" DOUBLE,
"md" DOUBLE,
"mt" BIGINT,
"ov" DOUBLE,
"pr" VARCHAR,
"tw" DOUBLE,
"wk" DOUBLE
);
Anyone who has the link will be able to view this.