A Comprehensive Database On The FIFA World Cup

key_id Key Id	stadium_id Stadium Id	stadium_name Stadium Name	city_name City Name	country_name Country Name	stadium_capacity Stadium Capacity	stadium_wikipedia_link Stadium Wikipedia Link	city_wikipedia_link City Wikipedia Link
1	S-001	Estadio José Amalfitani	Buenos Aires	Argentina	49000	https://en.wikipedia.org/wiki/José_Amalfitani_Stadium	https://en.wikipedia.org/wiki/Buenos_Aires
2	S-002	Estadio Monumental	Buenos Aires	Argentina	75000	https://en.wikipedia.org/wiki/Estadio_Monumental_Antonio_Vespucio_Liberti	https://en.wikipedia.org/wiki/Buenos_Aires
3	S-003	Estadio Chateau Carreras	Córdoba	Argentina	47000	https://en.wikipedia.org/wiki/Estadio_Mario_Alberto_Kempes	https://en.wikipedia.org/wiki/Córdoba,_Argentina
4	S-004	Estadio José María Minella	Mar del Plata	Argentina	44000	https://en.wikipedia.org/wiki/Estadio_José_Mar%C3%ADa_Minella	https://en.wikipedia.org/wiki/Mar_del_Plata
5	S-005	Estadio Ciudad de Mendoza	Mendoza	Argentina	35000	https://en.wikipedia.org/wiki/Estadio_Malvinas_Argentinas	https://en.wikipedia.org/wiki/Mendoza,_Argentina
6	S-006	Estadio Gigante de Arroyito	Rosario	Argentina	46000	https://en.wikipedia.org/wiki/Estadio_Gigante_de_Arroyito	https://en.wikipedia.org/wiki/Rosario,_Santa_Fe
7	S-007	Estádio Independência	Belo Horizonte	Brazil	30000	https://en.wikipedia.org/wiki/Estádio_Independência	https://en.wikipedia.org/wiki/Belo_Horizonte
8	S-008	Estádio Mineirão	Belo Horizonte	Brazil	43000	https://en.wikipedia.org/wiki/Mineirão	https://en.wikipedia.org/wiki/Belo_Horizonte
9	S-009	Estádio Nacional	Brasília	Brazil	70000	https://en.wikipedia.org/wiki/Estádio_Nacional_Mané_Garrincha	https://en.wikipedia.org/wiki/Bras%C3%ADlia
10	S-010	Arena Pantanal	Cuiabá	Brazil	41000	https://en.wikipedia.org/wiki/Arena_Pantanal	https://en.wikipedia.org/wiki/Cuiabá


CREATE TABLE stadiums (
  "key_id" BIGINT,
  "stadium_id" VARCHAR,
  "stadium_name" VARCHAR,
  "city_name" VARCHAR,
  "country_name" VARCHAR,
  "stadium_capacity" BIGINT,
  "stadium_wikipedia_link" VARCHAR,
  "city_wikipedia_link" VARCHAR
);