A Comprehensive Database On The FIFA World Cup

key_id Key Id	team_id Team Id	team_name Team Name	team_code Team Code	federation_name Federation Name	region_name Region Name	confederation_id Confederation Id	confederation_name Confederation Name	confederation_code Confederation Code	team_wikipedia_link Team Wikipedia Link	federation_wikipedia_link Federation Wikipedia Link
1	T-01	Algeria	DZA	Algerian Football Federation	Africa	CF-2	Confederation of African Football	CAF	https://en.wikipedia.org/wiki/Algeria_national_football_team	https://en.wikipedia.org/wiki/Algerian_Football_Federation
2	T-02	Angola	AGO	Angolan Football Federation	Africa	CF-2	Confederation of African Football	CAF	https://en.wikipedia.org/wiki/Angola_national_football_team	https://en.wikipedia.org/wiki/Angolan_Football_Federation
3	T-03	Argentina	ARG	Argentine Football Association	South America	CF-4	South American Football Confederation	CONMEBOL	https://en.wikipedia.org/wiki/Argentina_national_football_team	https://en.wikipedia.org/wiki/Argentine_Football_Association
4	T-04	Australia	AUS	Football Australia	Oceania	CF-1	Asian Football Confederation	AFC	https://en.wikipedia.org/wiki/Australia_men%27s_national_soccer_team	https://en.wikipedia.org/wiki/Football_Australia
5	T-05	Austria	AUT	Austrian Football Association	Europe	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/Austria_national_football_team	https://en.wikipedia.org/wiki/Austrian_Football_Association
6	T-06	Belgium	BEL	Royal Belgian Football Association	Europe	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/Belgium_national_football_team	https://en.wikipedia.org/wiki/Royal_Belgian_Football_Association
7	T-07	Bolivia	BOL	Bolivian Football Federation	South America	CF-4	South American Football Confederation	CONMEBOL	https://en.wikipedia.org/wiki/Bolivia_national_football_team	https://en.wikipedia.org/wiki/Bolivian_Football_Federation
8	T-08	Bosnia and Herzegovina	BIH	Football Association of Bosnia and Herzegovina	Europe	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/Bosnia_and_Herzegovina_national_football_team	https://en.wikipedia.org/wiki/Football_Association_of_Bosnia_and_Herzegovina
9	T-09	Brazil	BRA	Brazilian Football Confederation	South America	CF-4	South American Football Confederation	CONMEBOL	https://en.wikipedia.org/wiki/Brazil_national_football_team	https://en.wikipedia.org/wiki/Brazilian_Football_Confederation
10	T-10	Bulgaria	BGR	Bulgarian Football Union	Europe	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/Bulgaria_national_football_team	https://en.wikipedia.org/wiki/Bulgarian_Football_Union


CREATE TABLE teams (
  "key_id" BIGINT,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "federation_name" VARCHAR,
  "region_name" VARCHAR,
  "confederation_id" VARCHAR,
  "confederation_name" VARCHAR,
  "confederation_code" VARCHAR,
  "team_wikipedia_link" VARCHAR,
  "federation_wikipedia_link" VARCHAR
);