CRICKET WORLD CUP SCORES(1975-2019
Scores of each match played in the World Cup from 1975 to 2019
@kaggle.amalab182_cricket_world_cup_scores1975_2019
Scores of each match played in the World Cup from 1975 to 2019
@kaggle.amalab182_cricket_world_cup_scores1975_2019
The dataset contains the scores of all the cricket matches played in the ODI World Cup from 1975 to 2019 collected from ICC website and Cricbuzz website.The tournament started in the year 1975 and was initially won by West Indies. Over the years , the tournament was held in group wise format and Round-Robin format.
If you find it useful, please support by upvoting ❤️
CREATE TABLE cricket_world_cup_1975 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1979 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1983 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1987 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1992 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1996 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1999 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2003 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2007 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2011 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2015 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2019 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
Anyone who has the link will be able to view this.