PSL Matches
PSL matches 2016-2022
@kaggle.ibadkhanml_psl_matches_2016_to_2022
PSL matches 2016-2022
@kaggle.ibadkhanml_psl_matches_2016_to_2022
CREATE TABLE batting (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"matches" BIGINT,
"innings" VARCHAR,
"not_out" VARCHAR,
"runs" VARCHAR,
"high_score" VARCHAR,
"average" VARCHAR,
"ball_faced" VARCHAR,
"strike_rate" VARCHAR,
"hundreds" VARCHAR,
"fifties" VARCHAR,
"zeros" VARCHAR,
"fours" VARCHAR,
"sixes" VARCHAR,
"season" VARCHAR,
"team" VARCHAR
);
CREATE TABLE bowling (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"matches" BIGINT,
"innings" VARCHAR,
"overs" VARCHAR,
"maidens" VARCHAR,
"runs" VARCHAR,
"wickets" VARCHAR,
"best_bowling" VARCHAR,
"average" VARCHAR,
"economy" VARCHAR,
"strike_rate" VARCHAR,
"four_wkts" VARCHAR,
"five_wkts" VARCHAR,
"catches" BIGINT,
"stumps" BIGINT,
"season" VARCHAR,
"team" VARCHAR
);
CREATE TABLE matches (
"unnamed_0" BIGINT -- Unnamed: 0,
"team_1" VARCHAR,
"team_2" VARCHAR,
"winner" VARCHAR,
"margin" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"season" VARCHAR
);
CREATE TABLE players (
"unnamed_0" BIGINT -- Unnamed: 0,
"season" VARCHAR,
"team" VARCHAR,
"name" VARCHAR,
"role" VARCHAR,
"age" VARCHAR,
"batting" VARCHAR,
"bowling" VARCHAR
);
CREATE TABLE points (
"unnamed_0" BIGINT -- Unnamed: 0,
"team" VARCHAR,
"matches" BIGINT,
"win" BIGINT,
"loss" BIGINT,
"tie" BIGINT,
"no_result" BIGINT,
"points" DOUBLE,
"nrr" DOUBLE,
"for" VARCHAR,
"against" VARCHAR,
"season" VARCHAR,
"rank" BIGINT
);
Anyone who has the link will be able to view this.