Baselight

IPL Dataset 2008-2019

Match by Match dataset

@kaggle.lazycoder00_ipl_dataset_20082019

Matches
@kaggle.lazycoder00_ipl_dataset_20082019.matches

  • 31.87 KB
  • 756 rows
  • 18 columns
id

Id

season

Season

city

City

date

Date

team1

Team1

team2

Team2

toss_winner

Toss Winner

toss_decision

Toss Decision

result

Result

dl_applied

Dl Applied

winner

Winner

win_by_runs

Win By Runs

win_by_wickets

Win By Wickets

player_of_match

Player Of Match

venue

Venue

umpire1

Umpire1

umpire2

Umpire2

umpire3

Umpire3

1IPL-2017Hyderabad05-04-2017Sunrisers HyderabadRoyal Challengers BangaloreRoyal Challengers BangalorefieldnormalSunrisers Hyderabad35Yuvraj SinghRajiv Gandhi International Stadium, UppalAY DandekarNJ Llongnan
2IPL-2017Pune06-04-2017Mumbai IndiansRising Pune SupergiantRising Pune SupergiantfieldnormalRising Pune Supergiant7SPD SmithMaharashtra Cricket Association StadiumA Nand KishoreS Ravinan
3IPL-2017Rajkot07-04-2017Gujarat LionsKolkata Knight RidersKolkata Knight RidersfieldnormalKolkata Knight Riders10CA LynnSaurashtra Cricket Association StadiumNitin MenonCK Nandannan
4IPL-2017Indore08-04-2017Rising Pune SupergiantKings XI PunjabKings XI PunjabfieldnormalKings XI Punjab6GJ MaxwellHolkar Cricket StadiumAK ChaudharyC Shamshuddinnan
5IPL-2017Bangalore08-04-2017Royal Challengers BangaloreDelhi DaredevilsRoyal Challengers BangalorebatnormalRoyal Challengers Bangalore15KM JadhavM Chinnaswamy Stadiumnannannan
6IPL-2017Hyderabad09-04-2017Gujarat LionsSunrisers HyderabadSunrisers HyderabadfieldnormalSunrisers Hyderabad9Rashid KhanRajiv Gandhi International Stadium, UppalA DeshmukhNJ Llongnan
7IPL-2017Mumbai09-04-2017Kolkata Knight RidersMumbai IndiansMumbai IndiansfieldnormalMumbai Indians4N RanaWankhede StadiumNitin MenonCK Nandannan
8IPL-2017Indore10-04-2017Royal Challengers BangaloreKings XI PunjabRoyal Challengers BangalorebatnormalKings XI Punjab8AR PatelHolkar Cricket StadiumAK ChaudharyC Shamshuddinnan
9IPL-2017Pune11-04-2017Delhi DaredevilsRising Pune SupergiantRising Pune SupergiantfieldnormalDelhi Daredevils97SV SamsonMaharashtra Cricket Association StadiumAY DandekarS Ravinan
10IPL-2017Mumbai12-04-2017Sunrisers HyderabadMumbai IndiansMumbai IndiansfieldnormalMumbai Indians4JJ BumrahWankhede StadiumNitin MenonCK Nandannan

CREATE TABLE matches (
  "id" BIGINT,
  "season" VARCHAR,
  "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
);