Cricket World Cup Winners

The pinnacle of Cricket

@kaggle.zsinghrahulk_cricket_world_cup_winners

Table List

1 table(24.78 KB)

World Cup

@kaggle.zsinghrahulk_cricket_world_cup_winners.world_cup

24.78 KB
16 rows
29 columns

winning_country Winning Country	matches_won_out_of_last_10 Matches Won Out Of Last 10	runs_scored_in_last_10_matches Runs Scored In Last 10 Matches	wickets_taken_in_last_10_matches Wickets Taken In Last 10 Matches	odi_rankings_entering_world_cup ODI Rankings Entering World Cup	severe_injuries_to_main_players Severe Injuries To Main Players	won_in_home_ground Won In Home Ground	number_of_batsmen Number Of Batsmen	number_of_bowlers Number Of Bowlers	number_of_all_rounders Number Of All-Rounders	winning_country_s_gdp_growth Winning Country\u0027s GDP Growth	host_country Host Country	host_country_s_gdp_growth Host Country\u0027s GDP Growth	finalist Finalist	number_of_rain_affected_matches Number Of Rain-Affected Matches	test_match_players Test Match Players	winning_country_1 Winning Country.1	total_matches_of_players_leading_into_world_cup Total Matches Of Players Leading Into World Cup	total_runs_of_players_leading_into_world_cup Total Runs Of Players Leading Into World Cup	total_wickets_of_players_leading_into_world_cup Total Wickets Of Players Leading Into World Cup	total_catches_of_players_leading_into_world_cup Total Catches Of Players Leading Into World Cup	year Year	captain Captain	primary_skill Primary Skill	runs_scored_by_captain Runs Scored By Captain	wickets_taken_by_captain Wickets Taken By Captain	boundaries_hit_in_the_tournament Boundaries Hit In The Tournament	centuries_hit_in_the_tournament Centuries Hit In The Tournament	n_5_wicket_hauls_in_the_tournament 5-wicket Hauls In The Tournament
West Indies	5	1657	73	2	nan	No	5	6		2.90%	England	-0.20%	Australia		12	West Indies	1068	21350	465		1975	Clive Lloyd	Batsman	242	5	60	3	1
West Indies	4	1308	55	1	nan	No	6	5		2.80%	England	1.50%	England		11	West Indies	1647	25962	442		1979	Clive Lloyd	Batsman	183		105	2	2
India	2	792	30	8	nan	No	5	7		6.50%	England	1.80%	West Indies	1	11	India	876	16003	327		1983	Kapil Dev	All-rounder	303	12	109	1
Australia	5	2314	78	5	nan	No	5	5	1	2.90%	India	3.60%	England	1	14	Australia	2820	68796	1284	117	1987	Allan Border	Batsman	129		116	2	2
Pakistan	4	1519	66	6	Yes	No	7	3	1	4.10%	Australia	-0.50%	England	2	9	Pakistan	1124	25315	404	17	1992	Imran Khan	All-rounder	185	18	80	1	3
Sri Lanka	7	3287	125	2	nan	No	6	5		5.10%	India	7.60%	Australia	1	10	Sri Lanka	1086	41425	1307	118	1996	Arjuna Ranatunga	Batsman	241	5	105	2	3
Australia	4	1653	65	1	nan	No	4	6	1	4.20%	England	0.70%	Pakistan	2	13	Australia	1395	60192	2190	134	1999	Steve Waugh	Batsman	120	4	126	2	3
Australia	10	4337	194	1	yes	No	5	5	1	3.40%	South Africa	1.70%	India	1	14	Australia	3281	88005	1442	46	2003	Ricky Ponting	Batsman	415		140		6
Australia	9	3454	138	1	nan	No	4	7		4.40%	West Indies	4.30%	Sri Lanka		14	Australia	3191	78014	1373	26	2007	Ricky Ponting	Batsman	140		108	1	9
India	6	2620	83	2	yes	Yes	7	4	2	7.70%	India	8.40%	Sri Lanka	2	13	India	2306	49075	716	23	2011	MS Dhoni	All-rounder	241		93	1	6


CREATE TABLE world_cup (
  "winning_country" VARCHAR,
  "matches_won_out_of_last_10" DOUBLE,
  "runs_scored_in_last_10_matches" DOUBLE,
  "wickets_taken_in_last_10_matches" DOUBLE,
  "odi_rankings_entering_world_cup" DOUBLE,
  "severe_injuries_to_main_players" VARCHAR,
  "won_in_home_ground" VARCHAR,
  "number_of_batsmen" DOUBLE,
  "number_of_bowlers" DOUBLE,
  "number_of_all_rounders" DOUBLE,
  "winning_country_s_gdp_growth" VARCHAR,
  "host_country" VARCHAR,
  "host_country_s_gdp_growth" VARCHAR,
  "finalist" VARCHAR,
  "number_of_rain_affected_matches" DOUBLE,
  "test_match_players" DOUBLE,
  "winning_country_1" VARCHAR,
  "total_matches_of_players_leading_into_world_cup" DOUBLE,
  "total_runs_of_players_leading_into_world_cup" DOUBLE,
  "total_wickets_of_players_leading_into_world_cup" DOUBLE,
  "total_catches_of_players_leading_into_world_cup" DOUBLE,
  "year" VARCHAR,
  "captain" VARCHAR,
  "primary_skill" VARCHAR,
  "runs_scored_by_captain" DOUBLE,
  "wickets_taken_by_captain" DOUBLE,
  "boundaries_hit_in_the_tournament" DOUBLE,
  "centuries_hit_in_the_tournament" DOUBLE,
  "n_5_wicket_hauls_in_the_tournament" DOUBLE
);