ICC Mens World Cup 2023
ICC Mens Cricket World Cup 2023, India
@kaggle.pardeep19singh_icc_mens_world_cup_2023
ICC Mens Cricket World Cup 2023, India
@kaggle.pardeep19singh_icc_mens_world_cup_2023
CREATE TABLE deliveries (
"match_id" BIGINT,
"season" VARCHAR,
"start_date" TIMESTAMP,
"venue" VARCHAR,
"innings" BIGINT,
"ball" DOUBLE,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"striker" VARCHAR,
"non_striker" VARCHAR,
"bowler" VARCHAR,
"runs_off_bat" BIGINT,
"extras" BIGINT,
"wides" DOUBLE,
"noballs" DOUBLE,
"byes" DOUBLE,
"legbyes" DOUBLE,
"penalty" DOUBLE,
"wicket_type" VARCHAR,
"player_dismissed" VARCHAR,
"other_wicket_type" VARCHAR,
"other_player_dismissed" VARCHAR
);
CREATE TABLE matches (
"season" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"date" VARCHAR,
"match_number" BIGINT,
"venue" VARCHAR,
"city" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"player_of_match" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"reserve_umpire" VARCHAR,
"match_referee" VARCHAR,
"winner" VARCHAR,
"winner_runs" DOUBLE,
"winner_wickets" DOUBLE,
"match_type" VARCHAR
);
CREATE TABLE points_table (
"ranking" BIGINT,
"team" VARCHAR,
"matches" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"tie" BIGINT,
"no_results" BIGINT,
"points" BIGINT,
"net_run_rate" DOUBLE,
"for" VARCHAR,
"against" VARCHAR
);
Anyone who has the link will be able to view this.