Indian Premier League (IPL) - 2008-2024
Detailed Ball to Ball analysis of every match from 2008-2024
@kaggle.saiprudvirajy_indian_premier_league_ipl_2008_2024
Detailed Ball to Ball analysis of every match from 2008-2024
@kaggle.saiprudvirajy_indian_premier_league_ipl_2008_2024
CREATE TABLE ipl_ballbyball2008_2024_updated (
"match_id" BIGINT,
"date" TIMESTAMP,
"season" VARCHAR,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"innings_no" BIGINT,
"ball_no" DOUBLE,
"bowler" VARCHAR,
"striker" VARCHAR,
"non_striker" VARCHAR,
"runs_scored" BIGINT,
"extras" BIGINT,
"type_of_extras" VARCHAR,
"score" BIGINT,
"score_wicket" VARCHAR,
"wicket_confirmation" BIGINT,
"wicket_type" VARCHAR,
"fielders_involved" VARCHAR,
"player_out" VARCHAR
);
CREATE TABLE ipl_teams_2024_info (
"team_full_name" VARCHAR,
"team_captain_current" VARCHAR,
"team_coach_current" VARCHAR,
"team_home_ground_current" VARCHAR,
"number_of_ipl_titles" VARCHAR,
"team_owners" VARCHAR,
"team_about" VARCHAR
);
CREATE TABLE players_info_2024 (
"player_name" VARCHAR,
"team_name" VARCHAR,
"player_nationality" VARCHAR,
"date_of_birth" VARCHAR,
"player_role" VARCHAR,
"ipl_debut" DOUBLE,
"about" VARCHAR,
"batting_style" VARCHAR,
"bowling_style" VARCHAR,
"player_salary" VARCHAR
);
CREATE TABLE team_performance_dataset_2008to2024 (
"match_id" BIGINT,
"date" TIMESTAMP,
"teams" VARCHAR,
"venue" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"match_winner" VARCHAR,
"win_type" VARCHAR,
"win_margin" DOUBLE,
"first_innings_score" BIGINT,
"second_innings_score" DOUBLE,
"player_of_match" VARCHAR,
"umpire" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"powerplay_scores" BIGINT,
"middle_overs_scores" BIGINT,
"death_overs_scores" BIGINT
);
Anyone who has the link will be able to view this.