FIFA World Cup

Dataset of every match played in FIFA World Cup history from 1930 to 2018

@kaggle.evangower_fifa_world_cup

Table List

2 tables(33.75 KB)

Worldcups

@kaggle.evangower_fifa_world_cup.worldcups

8 KB
21 rows
10 columns

year Year	host Host	winner Winner	second Second	third Third	fourth Fourth	goals_scored Goals Scored	teams Teams	games Games	attendance Attendance
1930	Uruguay	Uruguay	Argentina	USA	Yugoslavia	70	13	18	434000
1934	Italy	Italy	Czechoslovakia	Germany	Austria	70	16	17	395000
1938	France	Italy	Hungary	Brazil	Sweden	84	15	18	483000
1950	Brazil	Uruguay	Brazil	Sweden	Spain	88	13	22	1337000
1954	Switzerland	West Germany	Hungary	Austria	Uruguay	140	16	26	943000
1958	Sweden	Brazil	Sweden	France	West Germany	126	16	35	868000
1962	Chile	Brazil	Czechoslovakia	Chile	Yugoslavia	89	16	32	776000
1966	England	England	West Germany	Portugal	Soviet Union	89	16	32	1614677
1970	Mexico	Brazil	Italy	West Germany	Uruguay	95	16	32	1673975
1974	Germany	West Germany	Netherlands	Poland	Brazil	97	16	38	1774022


CREATE TABLE worldcups (
  "year" BIGINT,
  "host" VARCHAR,
  "winner" VARCHAR,
  "second" VARCHAR,
  "third" VARCHAR,
  "fourth" VARCHAR,
  "goals_scored" BIGINT,
  "teams" BIGINT,
  "games" BIGINT,
  "attendance" BIGINT
);