FIFA World Cup

Explore FIFA analysts for global data, emphasizing key World Cup success metrics

@kaggle.alexcj10_fifa_world_cup_data

Table List

3 tables(318.28 KB)

Worldcupmatches

Worldcupplayers

Worldcups

Worldcups

@kaggle.alexcj10_fifa_world_cup_data.worldcups

8.12 KB
20 rows
10 columns

year Year	country Country	winner Winner	runners_up Runners-Up	third Third	fourth Fourth	goalsscored GoalsScored	qualifiedteams QualifiedTeams	matchesplayed MatchesPlayed	attendance Attendance
1930	Uruguay	Uruguay	Argentina	USA	Yugoslavia	70	13	18	590.549
1934	Italy	Italy	Czechoslovakia	Germany	Austria	70	16	17	363.000
1938	France	Italy	Hungary	Brazil	Sweden	84	15	18	375.700
1950	Brazil	Uruguay	Brazil	Sweden	Spain	88	13	22	1.045.246
1954	Switzerland	Germany FR	Hungary	Austria	Uruguay	140	16	26	768.607
1958	Sweden	Brazil	Sweden	France	Germany FR	126	16	35	819.810
1962	Chile	Brazil	Czechoslovakia	Chile	Yugoslavia	89	16	32	893.172
1966	England	England	Germany FR	Portugal	Soviet Union	89	16	32	1.563.135
1970	Mexico	Brazil	Italy	Germany FR	Uruguay	95	16	32	1.603.975
1974	Germany	Germany FR	Netherlands	Poland	Brazil	97	16	38	1.865.753


CREATE TABLE worldcups (
  "year" BIGINT,
  "country" VARCHAR,
  "winner" VARCHAR,
  "runners_up" VARCHAR,
  "third" VARCHAR,
  "fourth" VARCHAR,
  "goalsscored" BIGINT,
  "qualifiedteams" BIGINT,
  "matchesplayed" BIGINT,
  "attendance" VARCHAR
);