A Comprehensive Database On The FIFA World Cup

key_id Key Id	referee_id Referee Id	family_name Family Name	given_name Given Name	country_name Country Name	confederation_id Confederation Id	confederation_name Confederation Name	confederation_code Confederation Code	referee_wikipedia_link Referee Wikipedia Link
1	R-001	Abdel-Fatah	Essam	Egypt	CF-2	Confederation of African Football	CAF	https://en.wikipedia.org/wiki/Essam_Abd_El_Fatah
2	R-002	Adair	John	Northern Ireland	CF-6	Union of European Football Associations	UEFA	not available
3	R-003	Agnolin	Luigi	Italy	CF-6	Union of European Football Associations	UEFA	https://en.wikipedia.org/wiki/Luigi_Agnolin
4	R-004	Aguilar	Joel	El Salvador	CF-3	Confederation of North, Central American and Caribbean Association Football	CONCACAF	https://en.wikipedia.org/wiki/Joel_Aguilar
5	R-005	Aguilar Elizalde	Abel	Mexico	CF-3	Confederation of North, Central American and Caribbean Association Football	CONCACAF	not available
6	R-006	Ahlner	Sten	Sweden	CF-6	Union of European Football Associations	UEFA	not available
7	R-007	Al-Doy	Ibrahim Youssef	Bahrain	CF-1	Asian Football Confederation	AFC	https://en.wikipedia.org/wiki/Ibrahim_Youssef_Al-Doy
8	R-008	Al-Ghamdi	Khalil	Saudi Arabia	CF-1	Asian Football Confederation	AFC	https://en.wikipedia.org/wiki/Khalil_Al_Ghamdi
9	R-009	Al-Ghandour	Gamal	Egypt	CF-2	Confederation of African Football	CAF	https://en.wikipedia.org/wiki/Gamal_Al-Ghandour
10	R-010	Al-Shanar	Fallaj	Saudi Arabia	CF-1	Asian Football Confederation	AFC	https://en.wikipedia.org/wiki/Fallaj_Al_Shanar


CREATE TABLE referees (
  "key_id" BIGINT,
  "referee_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "country_name" VARCHAR,
  "confederation_id" VARCHAR,
  "confederation_name" VARCHAR,
  "confederation_code" VARCHAR,
  "referee_wikipedia_link" VARCHAR
);