A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	year Year	start_date Start Date	end_date End Date	host_country Host Country	winner Winner	host_won Host Won	count_teams Count Teams	group_stage Group Stage	second_group_stage Second Group Stage	final_round Final Round	round_of_16 Round Of 16	quarter_finals Quarter Finals	semi_finals Semi Finals	third_place_match Third Place Match	final Final
1	WC-1930	1930 FIFA World Cup	1930	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 30 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Uruguay	Uruguay	1	13	1					1		1
2	WC-1934	1934 FIFA World Cup	1934	Sun May 27 1934 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 10 1934 00:00:00 GMT+0000 (Coordinated Universal Time)	Italy	Italy	1	16				1	1	1	1	1
3	WC-1938	1938 FIFA World Cup	1938	Sat Jun 04 1938 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 19 1938 00:00:00 GMT+0000 (Coordinated Universal Time)	France	Italy		15				1	1	1	1	1
4	WC-1950	1950 FIFA World Cup	1950	Sat Jun 24 1950 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 16 1950 00:00:00 GMT+0000 (Coordinated Universal Time)	Brazil	Uruguay		13	1		1
5	WC-1954	1954 FIFA World Cup	1954	Wed Jun 16 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 04 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Switzerland	West Germany		16	1				1	1	1	1
6	WC-1958	1958 FIFA World Cup	1958	Sun Jun 08 1958 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 29 1958 00:00:00 GMT+0000 (Coordinated Universal Time)	Sweden	Brazil		16	1				1	1	1	1
7	WC-1962	1962 FIFA World Cup	1962	Wed May 30 1962 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 17 1962 00:00:00 GMT+0000 (Coordinated Universal Time)	Chile	Brazil		16	1				1	1	1	1
8	WC-1966	1966 FIFA World Cup	1966	Mon Jul 11 1966 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 30 1966 00:00:00 GMT+0000 (Coordinated Universal Time)	England	England	1	16	1				1	1	1	1
9	WC-1970	1970 FIFA World Cup	1970	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 21 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	Mexico	Brazil		16	1				1	1	1	1
10	WC-1974	1974 FIFA World Cup	1974	Thu Jun 13 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 07 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	West Germany	West Germany	1	16	1	1					1	1


CREATE TABLE tournaments (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "year" BIGINT,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "host_country" VARCHAR,
  "winner" VARCHAR,
  "host_won" BIGINT,
  "count_teams" BIGINT,
  "group_stage" BIGINT,
  "second_group_stage" BIGINT,
  "final_round" BIGINT,
  "round_of_16" BIGINT,
  "quarter_finals" BIGINT,
  "semi_finals" BIGINT,
  "third_place_match" BIGINT,
  "final" BIGINT
);