Team Records In One-day Internationals Cricket
Statistical analysis of team performances in one-day internationals,
@kaggle.tariqsays_team_records_in_one_day_internationals_cricket
Statistical analysis of team performances in one-day internationals,
@kaggle.tariqsays_team_records_in_one_day_internationals_cricket
The "Team records in one-day internationals Cricket" dataset includes various team records for one-day international cricket matches. The dataset comprises information such as the team name, opponent team name, venue, date of the match, the highest score by a team, lowest score by a team, most fours in a match by a team, most sixes in a match by a team, largest victory by runs, and largest victory by wickets. The dataset is aimed at providing insights into the performance of teams in one-day internationals, highlighting their strengths and weaknesses, and identifying trends over time. The dataset can be used by cricket enthusiasts, analysts, and researchers to analyze team performance and develop new strategies.
CREATE TABLE most_fours_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_fours_in_an_innings (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_runs_from_fours_and_sixes_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_runs_from_fours_and_sixes_in_an_innings (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_sixes_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_sixes_in_an_innings (
"team" VARCHAR,
"score" VARCHAR,
"n_4s" BIGINT -- 4s,
"n_6s" BIGINT -- 6s,
"inns" BIGINT,
"result" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
Anyone who has the link will be able to view this.