WPL Dataset

Women's Premier League, India

@kaggle.leelaa_wpl_dataset

Table List

1 table(22.23 KB)

Wpl

@kaggle.leelaa_wpl_dataset.wpl

22.23 KB
22 rows
32 columns

m_no M No	date Date	city City	venue Venue	stage Stage	team1 Team1	team2 Team2	toss_winner Toss Winner	toss_decision Toss Decision	umpire1 Umpire1	umpire2 Umpire2	umpire3 Umpire3	match_referee Match Referee	runs_1inn Runs 1inn	wk_1inn Wk 1inn	overs_1inn Overs 1inn	sixes_1inn Sixes 1inn	bnd_1inn Bnd 1inn	extras_1inn Extras 1inn	runs_2inn Runs 2inn	wk_2inn Wk 2inn	overs_2inn Overs 2inn	sixes_2inns Sixes 2inns	bnd_2inn Bnd 2inn	extras_2inn Extras 2inn	winner Winner	tie Tie	dl Dl	result Result	win_by_wickets Win By Wickets	win_by_runs Win By Runs	pom Pom
1	4-3-23	Navi Mumbai	DY Patil	League	GGT	MIW	GGT	Field	Nitin Pandit	Vrinda Rathi	Pashchim Pathak	GS Lakshmi	207	5	20	6	31	5	64	10	15.1	2	5	2	MIW	N	N	Runs		143	Harmanpreet Kaur
2	5-3-23	Mumbai	Brabourne	League	RCBW	DCW	RCBW	Field	Chirra Ravikanthreddy	N Janani	Madangopal Kuppuraj	Rajni Basnet	223	2	20	7	30	6	163	8	20	3	21	4	DCW	N	N	Runs		60	Tara Norris
3	5-3-23	Navi Mumbai	DY Patil	League	UPW	GGT	GGT	Bat	Gayathri Venugopalan	Sanjay Kumar Singh	Pashchim Pathak	Anupa Narvekar	169	6	20	2	21	14	175	7	19.5	6	15	14	UPW	N	N	Wickets	3		Grace Harris
4	6-3-23	Mumbai	Brabourne	League	MIW	RCBW	RCBW	Bat	Pashchim Pathak	Ranjeev Sharma	Saurabh Dhote	Sanjay Kumar Singh	155	10	18.4	4	21	7	159	1	14.2	2	26	4	MIW	N	N	Wickets	9		Hayley Matthews
5	7-3-23	Navi Mumbai	DY Patil	League	DCW	UPW	UPW	Field	Chirra Ravikanthreddy	Vrinda Rathi	N Janani	Rajni Basnet	211	4	20	9	21	11	169	5	20	4	20	11	DCW	N	N	Runs		42	Jess Jonassen
6	8-3-23	Mumbai	Brabourne	League	GGT	RCBW	GGT	Bat	Ranjeev Sharma	Sanjay Kumar Singh	Nitin Pandit	GS Lakshmi	201	7	20	6	28	2	190	6	20	4	26	11	GGT	N	N	Runs		11	Sophia Dunkley
7	9-3-23	Navi Mumbai	DY Patil	League	DCW	MIW	DCW	Bat	Madanagopal Kuppuraj	Vrinda Rathi	Pashchim Pathak	Varsha Nagre	105	10	18	1	9	7	109	2	15		20	2	MIW	N	N	Wickets	8		Saika Ishaque
8	10-3-23	Mumbai	Brabourne	League	RCBW	UPW	RCBW	Bat	N Janani	Saurabh Dhote	Ranjeev Sharma	Anupa Narvekar	138	10	19.3	2	16		139		13	1	23	7	UPW	N	N	Wickets	10		Alyssa Healy
9	11-3-23	Navi Mumbai	DY Patil	League	GGT	DCW	GGT	Bat	Gayathri Venugopalan	Sanjay Kumar Singh	Vrinda Rathi	GS Lakshmi	105	9	20		12	3	107		7.1	5	13	10	DCW	N	N	Wickets	10		Marizanne Kapp
10	12-3-23	Mumbai	Brabourne	League	UPW	MIW	UPW	Bat	N Janani	Pashchim Pathak	Chirra Ravikanthreddy	Rajni Basnet	159	6	20	2	20	9	164	2	17.3	3	25	12	MIW	N	N	Wickets	8		Harmanpreet Kaur


CREATE TABLE wpl (
  "m_no" BIGINT,
  "date" VARCHAR,
  "city" VARCHAR,
  "venue" VARCHAR,
  "stage" VARCHAR,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "umpire1" VARCHAR,
  "umpire2" VARCHAR,
  "umpire3" VARCHAR,
  "match_referee" VARCHAR,
  "runs_1inn" BIGINT,
  "wk_1inn" BIGINT,
  "overs_1inn" DOUBLE,
  "sixes_1inn" BIGINT,
  "bnd_1inn" BIGINT,
  "extras_1inn" BIGINT,
  "runs_2inn" BIGINT,
  "wk_2inn" BIGINT,
  "overs_2inn" DOUBLE,
  "sixes_2inns" BIGINT,
  "bnd_2inn" BIGINT,
  "extras_2inn" BIGINT,
  "winner" VARCHAR,
  "tie" VARCHAR,
  "dl" VARCHAR,
  "result" VARCHAR,
  "win_by_wickets" BIGINT,
  "win_by_runs" BIGINT,
  "pom" VARCHAR
);