Indian Premier League (IPL) Match Data 2008-2023
Comprehensive IPL Match Data (2008-2023) for your data science project
@kaggle.bhuvaneshprasad_ipl_dataset_2008_2023_only_dataset_you_need
Comprehensive IPL Match Data (2008-2023) for your data science project
@kaggle.bhuvaneshprasad_ipl_dataset_2008_2023_only_dataset_you_need
This dataset contains historical match results, batting cards, bowling cards, fall of wickets cards, partnership cards, players info and ball by ball data for all IPL matches since 2008 till date. The dataset is split into multiple files, each containing a different type of data.
Files:
Potential Uses:
This dataset can be used for a variety of purposes, such as:
i. Analyzing the performance of teams and players over time
ii. Identifying trends in the game
iii. Developing predictive models for match outcomes
iv. Creating simulations of matches
v. Creating educational and entertainment content
Licensing:
This dataset is licensed under the Open Database License (ODbL). This means that it is free to use, share, and modify for any purpose. The only requirement is that you must attribute the dataset to its creators.
CREATE TABLE ipl_ball_by_ball_data (
"series_id" BIGINT,
"match_id" BIGINT,
"innings_no" DOUBLE,
"batsman_id" DOUBLE,
"bowler_id" DOUBLE,
"over_number" DOUBLE,
"ball_number" DOUBLE,
"over" DOUBLE,
"total_runs" DOUBLE,
"batsman_runs" DOUBLE,
"isfour" VARCHAR,
"issix" VARCHAR,
"iswicket" VARCHAR,
"byes" DOUBLE,
"legbyes" DOUBLE,
"wides" DOUBLE,
"noballs" DOUBLE,
"penalties" DOUBLE,
"out_player_id" DOUBLE,
"current_innings_runs" DOUBLE,
"current_innings_wickets" DOUBLE
);CREATE TABLE ipl_batting_card (
"match_id" BIGINT,
"innings" BIGINT,
"team" VARCHAR,
"batsman_id" DOUBLE,
"batsman_position" DOUBLE,
"runs" DOUBLE,
"balls" DOUBLE,
"fours" DOUBLE,
"sixes" DOUBLE,
"strikerate" DOUBLE,
"isout" VARCHAR,
"wickettype" VARCHAR,
"fielders" VARCHAR,
"bowler_id" DOUBLE
);CREATE TABLE ipl_bowling_card (
"match_id" BIGINT,
"innings" BIGINT,
"team" VARCHAR,
"opposition" VARCHAR,
"bowler_id" DOUBLE,
"overs" DOUBLE,
"balls" DOUBLE,
"maidens" DOUBLE,
"conceded" DOUBLE,
"wickets" DOUBLE,
"economy" DOUBLE,
"dots" DOUBLE,
"fours" DOUBLE,
"sixes" DOUBLE,
"wides" DOUBLE,
"noballs" DOUBLE
);CREATE TABLE ipl_fow_card (
"match_id" BIGINT,
"innings" BIGINT,
"team" VARCHAR,
"player_id" DOUBLE,
"wicket" DOUBLE,
"overs" DOUBLE,
"runs" DOUBLE
);CREATE TABLE ipl_historical (
"season" BIGINT,
"title" VARCHAR,
"match_id" BIGINT,
"match_name" VARCHAR,
"series_id" BIGINT,
"series_name" VARCHAR,
"match_date" TIMESTAMP,
"match_format" VARCHAR,
"team1_id" BIGINT,
"team1_name" VARCHAR,
"team1_captain" BIGINT,
"team1_runs_scored" DOUBLE,
"team1_wickets_fell" DOUBLE,
"team1_extras_rec" DOUBLE,
"team2_id" BIGINT,
"team2_name" VARCHAR,
"team2_captain" BIGINT,
"team2_runs_scored" DOUBLE,
"team2_wickets_fell" DOUBLE,
"team2_extras_rec" DOUBLE,
"match_venue_stadium" VARCHAR,
"match_venue_city" VARCHAR,
"match_venue_country" VARCHAR,
"umpire1" VARCHAR,
"umpire2" VARCHAR,
"match_referee" VARCHAR,
"toss_winner" VARCHAR,
"toss_winner_choice" VARCHAR,
"match_winner" VARCHAR,
"match_result_text" VARCHAR,
"mom_player" DOUBLE,
"team1_playing11" VARCHAR,
"team2_playing11" VARCHAR,
"debut_players" VARCHAR
);CREATE TABLE ipl_partnership_card (
"match_id" BIGINT,
"innings" BIGINT,
"for_wicket" DOUBLE,
"team" VARCHAR,
"opposition" VARCHAR,
"player1_id" DOUBLE,
"player2_id" DOUBLE,
"player1_runs" DOUBLE,
"player2_runs" DOUBLE,
"player1_balls" DOUBLE,
"player2_balls" DOUBLE,
"partnership_runs" DOUBLE,
"partnership_balls" DOUBLE
);CREATE TABLE ipl_players_info (
"player_id" BIGINT,
"player_object_id" BIGINT,
"player_name" VARCHAR,
"dob" TIMESTAMP,
"dod" TIMESTAMP,
"gender" VARCHAR,
"batting_style" VARCHAR,
"bowling_style" VARCHAR,
"country_id" BIGINT,
"image_url" VARCHAR,
"image_metadata" VARCHAR
);Anyone who has the link will be able to view this.