IPL 2020 Complete Data
Ball by ball complete details for all matches of Indian Premier League 2020
@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data
Ball by ball complete details for all matches of Indian Premier League 2020
@kaggle.aritrachakraborti_ipl_2020_ball_by_ball_data
Complete data of all IPL 2020 matches is provided in this space for data enthusiasts to aid their flair. The data will be refreshed post every match with the updates.
Also historic data of all IPL matches played from 2008 to 2019 is provided here. All the player names are synced in all the 'Deliveries' datasets.
Note: If you are interested in the code and tutorial, you can check it out this link- https://dicco89.medium.com/web-scraping-ball-by-ball-data-from-espn-cricinfo-192b36583d4a
Happy Analyzing !!!
CREATE TABLE deliveries_ipl_2008_2019 (
"match_id" BIGINT,
"inning" BIGINT,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"over" BIGINT,
"ball" BIGINT,
"batsman" VARCHAR,
"non_striker" VARCHAR,
"bowler" VARCHAR,
"is_super_over" BIGINT,
"wide_runs" BIGINT,
"bye_runs" BIGINT,
"legbye_runs" BIGINT,
"noball_runs" BIGINT,
"penalty_runs" BIGINT,
"batsman_runs" BIGINT,
"extra_runs" BIGINT,
"total_runs" BIGINT,
"player_dismissed" VARCHAR,
"dismissal_kind" VARCHAR,
"fielder" VARCHAR
);
CREATE TABLE deliveries_ipl_2020 (
"match_id" BIGINT,
"inning" BIGINT,
"batting_team" VARCHAR,
"bowling_team" VARCHAR,
"over" BIGINT,
"ball" BIGINT,
"batsman" VARCHAR,
"non_striker" VARCHAR,
"bowler" VARCHAR,
"is_super_over" BIGINT,
"wide_runs" BIGINT,
"bye_runs" BIGINT,
"legbye_runs" BIGINT,
"noball_runs" BIGINT,
"penalty_runs" BIGINT,
"batsman_runs" BIGINT,
"extra_runs" BIGINT,
"total_runs" BIGINT,
"player_dismissed" VARCHAR,
"dismissal_kind" VARCHAR,
"fielder" VARCHAR
);
CREATE TABLE ipl_2020_schedule (
"sl_no" BIGINT -- Sl. No.,
"day" VARCHAR,
"date" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR
);
CREATE TABLE matches_ipl_2008_2019 (
"id" BIGINT,
"season" BIGINT,
"city" VARCHAR,
"date" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"result" VARCHAR,
"dl_applied" BIGINT,
"winner" VARCHAR,
"win_by_runs" BIGINT,
"win_by_wickets" BIGINT,
"player_of_match" VARCHAR,
"venue" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"umpire3" VARCHAR
);
CREATE TABLE matches_ipl_2020 (
"id" BIGINT,
"season" BIGINT,
"city" VARCHAR,
"date" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"toss_winner" VARCHAR,
"toss_decision" VARCHAR,
"result" VARCHAR,
"dl_applied" BIGINT,
"winner" VARCHAR,
"win_by_runs" BIGINT,
"win_by_wickets" BIGINT,
"player_of_match" VARCHAR,
"venue" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"umpire3" VARCHAR
);
CREATE TABLE qualifiers_ipl_2008_2019 (
"season" BIGINT,
"champion" VARCHAR,
"runners_up" VARCHAR,
"q1" VARCHAR,
"q2" VARCHAR,
"q3" VARCHAR,
"q4" VARCHAR
);
Anyone who has the link will be able to view this.