Cricketer Info From Espncricinfo

cricketer dataset small.

@kaggle.exilour_cricinfo_cricketer

Table List

1 table(2.41 MB)

Players Data

@kaggle.exilour_cricinfo_cricketer.players_data

2.41 MB
78456 rows
90 columns

unnamed_0 Unnamed: 0	name Name	country Country	bfodi_tag Bfodi Tag	bfodi_match Bfodi Match	bfodi_innings Bfodi Innings	bfodi_no Bfodi No	bfodi_runs Bfodi Runs	bfodi_hs Bfodi Hs	bfodi_ave Bfodi Ave	bfodi_bf Bfodi Bf	bfodi_sr Bfodi Sr	bfodi_100 Bfodi 100	bfodi_50 Bfodi 50	bfodi_4 Bfodi 4	bfodi_6 Bfodi 6	bfodi_ct Bfodi Ct	bfodi_st Bfodi St	bftests_tag Bftests Tag	bftests_match Bftests Match	bftests_innings Bftests Innings	bftests_no Bftests No	bftests_runs Bftests Runs	bftests_hs Bftests Hs	bftests_ave Bftests Ave	bftests_bf Bftests Bf	bftests_sr Bftests Sr	bftests_100 Bftests 100	bftests_50 Bftests 50	bftests_4 Bftests 4	bftests_6 Bftests 6	bftests_ct Bftests Ct	bftests_st Bftests St	bft20s_tag Bft20s Tag	bft20s_match Bft20s Match	bft20s_innings Bft20s Innings	bft20s_no Bft20s No	bft20s_runs Bft20s Runs	bft20s_hs Bft20s Hs	bft20s_ave Bft20s Ave	bft20s_bf Bft20s Bf	bft20s_sr Bft20s Sr	bft20s_100 Bft20s 100	bft20s_50 Bft20s 50	bft20s_4 Bft20s 4	bft20s_6 Bft20s 6	bft20s_ct Bft20s Ct	bft20s_st Bft20s St	bwodi_tag Bwodi Tag	bwodi_match Bwodi Match	bwodi_innings Bwodi Innings	bwodi_balls Bwodi Balls	bwodi_runs Bwodi Runs	bwodi_wkts Bwodi Wkts	bwodi_bbi Bwodi Bbi	bwodi_bbm Bwodi Bbm	bwodi_ave Bwodi Ave	bwodi_econ Bwodi Econ	bwodi_sr Bwodi Sr	bwodi_4w Bwodi 4w	bwodi_5w Bwodi 5w	n_10 10	bwtests_tag Bwtests Tag	bwtests_match Bwtests Match	bwtests_innings Bwtests Innings	bwtests_balls Bwtests Balls	bwtests_runs Bwtests Runs	bwtests_wkts Bwtests Wkts	bwtests_bbi Bwtests Bbi	bwtests_bbm Bwtests Bbm	bwtests_ave Bwtests Ave	bwtests_econ Bwtests Econ	bwtests_sr Bwtests Sr	bwtests_4w Bwtests 4w	bwtests_5w Bwtests 5w	n_10_1 10.1	bwt20s_tag Bwt20s Tag	bwt20s_match Bwt20s Match	bwt20s_innings Bwt20s Innings	bwt20s_balls Bwt20s Balls	bwt20s_runs Bwt20s Runs	bwt20s_wkts Bwt20s Wkts	bwt20s_bbi Bwt20s Bbi	bwt20s_bbm Bwt20s Bbm	bwt20s_ave Bwt20s Ave	bwt20s_econ Bwt20s Econ	bwt20s_sr Bwt20s Sr	bwt20s_4w Bwt20s 4w	bwt20s_5w Bwt20s 5w	n_10_2 10.2
	John Dyson	Australia	ODIs	29	27	4	755	79	32.82	1553	48.61	0	4	55	2	12	0	Tests	30	58	7	1359	127*	26.64	4097	33.17	2	5	123	3	10	0	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	29	-	-	-	-	-	-	-	-	-	-	-	-	Tests	30	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
1	Keith Dudgeon	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Frank Deveney	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Bruce Duperouzel	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Gerard Dowling	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
5	John Donaldson	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Richard Drewer	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
7	John Douglas	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
8	John Davey	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Peter Davies	Australia	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-	-	ODIs	-	-	-	-	-	-	-	-	-	-	-	-	-	Tests	-	-	-	-	-	-	-	-	-	-	-	-	-	T20s	-	-	-	-	-	-	-	-	-	-	-	-	-


CREATE TABLE players_data (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "country" VARCHAR,
  "bfodi_tag" VARCHAR,
  "bfodi_match" VARCHAR,
  "bfodi_innings" VARCHAR,
  "bfodi_no" VARCHAR,
  "bfodi_runs" VARCHAR,
  "bfodi_hs" VARCHAR,
  "bfodi_ave" VARCHAR,
  "bfodi_bf" VARCHAR,
  "bfodi_sr" VARCHAR,
  "bfodi_100" VARCHAR,
  "bfodi_50" VARCHAR,
  "bfodi_4" VARCHAR,
  "bfodi_6" VARCHAR,
  "bfodi_ct" VARCHAR,
  "bfodi_st" VARCHAR,
  "bftests_tag" VARCHAR,
  "bftests_match" VARCHAR,
  "bftests_innings" VARCHAR,
  "bftests_no" VARCHAR,
  "bftests_runs" VARCHAR,
  "bftests_hs" VARCHAR,
  "bftests_ave" VARCHAR,
  "bftests_bf" VARCHAR,
  "bftests_sr" VARCHAR,
  "bftests_100" VARCHAR,
  "bftests_50" VARCHAR,
  "bftests_4" VARCHAR,
  "bftests_6" VARCHAR,
  "bftests_ct" VARCHAR,
  "bftests_st" VARCHAR,
  "bft20s_tag" VARCHAR,
  "bft20s_match" VARCHAR,
  "bft20s_innings" VARCHAR,
  "bft20s_no" VARCHAR,
  "bft20s_runs" VARCHAR,
  "bft20s_hs" VARCHAR,
  "bft20s_ave" VARCHAR,
  "bft20s_bf" VARCHAR,
  "bft20s_sr" VARCHAR,
  "bft20s_100" VARCHAR,
  "bft20s_50" VARCHAR,
  "bft20s_4" VARCHAR,
  "bft20s_6" VARCHAR,
  "bft20s_ct" VARCHAR,
  "bft20s_st" VARCHAR,
  "bwodi_tag" VARCHAR,
  "bwodi_match" VARCHAR,
  "bwodi_innings" VARCHAR,
  "bwodi_balls" VARCHAR,
  "bwodi_runs" VARCHAR,
  "bwodi_wkts" VARCHAR,
  "bwodi_bbi" VARCHAR,
  "bwodi_bbm" VARCHAR,
  "bwodi_ave" VARCHAR,
  "bwodi_econ" VARCHAR,
  "bwodi_sr" VARCHAR,
  "bwodi_4w" VARCHAR,
  "bwodi_5w" VARCHAR,
  "n_10" VARCHAR,
  "bwtests_tag" VARCHAR,
  "bwtests_match" VARCHAR,
  "bwtests_innings" VARCHAR,
  "bwtests_balls" VARCHAR,
  "bwtests_runs" VARCHAR,
  "bwtests_wkts" VARCHAR,
  "bwtests_bbi" VARCHAR,
  "bwtests_bbm" VARCHAR,
  "bwtests_ave" VARCHAR,
  "bwtests_econ" VARCHAR,
  "bwtests_sr" VARCHAR,
  "bwtests_4w" VARCHAR,
  "bwtests_5w" VARCHAR,
  "n_10_1" VARCHAR,
  "bwt20s_tag" VARCHAR,
  "bwt20s_match" VARCHAR,
  "bwt20s_innings" VARCHAR,
  "bwt20s_balls" VARCHAR,
  "bwt20s_runs" VARCHAR,
  "bwt20s_wkts" VARCHAR,
  "bwt20s_bbi" VARCHAR,
  "bwt20s_bbm" VARCHAR,
  "bwt20s_ave" VARCHAR,
  "bwt20s_econ" VARCHAR,
  "bwt20s_sr" VARCHAR,
  "bwt20s_4w" VARCHAR,
  "bwt20s_5w" VARCHAR,
  "n_10_2" VARCHAR
);