A Comprehensive Database On The FIFA World Cup

Data on teams, players, managers, refs, matches, goals, cards, subs, and more!

@kaggle.joshfjelstul_world_cup_database

Host Countries

@kaggle.joshfjelstul_world_cup_database.host_countries

6.05 KB
22 rows
7 columns

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	team_id Team Id	team_name Team Name	team_code Team Code	performance Performance
1	WC-1930	1930 FIFA World Cup	T-80	Uruguay	URY	champions
2	WC-1934	1934 FIFA World Cup	T-39	Italy	ITA	champions
3	WC-1938	1938 FIFA World Cup	T-28	France	FRA	quater-finals
4	WC-1950	1950 FIFA World Cup	T-09	Brazil	BRA	runners-up
5	WC-1954	1954 FIFA World Cup	T-72	Switzerland	CHE	quarter-final
6	WC-1958	1958 FIFA World Cup	T-71	Sweden	SWE	runners-up
7	WC-1962	1962 FIFA World Cup	T-13	Chile	CHL	third place
8	WC-1966	1966 FIFA World Cup	T-27	England	ENG	champions
9	WC-1970	1970 FIFA World Cup	T-44	Mexico	MEX	quater-finals
10	WC-1974	1974 FIFA World Cup	T-82	West Germany	DEU	champions


CREATE TABLE host_countries (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "performance" VARCHAR
);

A Comprehensive Database On The FIFA World Cup

Table List

Host Countries

@kaggle.joshfjelstul_world_cup_database.host_countries

key_id

tournament_id

tournament_name

team_id

team_name

team_code

performance

Share link

Are you sure?