A Comprehensive Database On The FIFA World Cup

key_id Key Id	player_id Player Id	family_name Family Name	given_name Given Name	birth_date Birth Date	goal_keeper Goal Keeper	defender Defender	forward Forward	count_tournaments Count Tournaments	list_tournaments List Tournaments	player_wikipedia_link Player Wikipedia Link
1	P-05074	A'Court	Alan	1934-09-30			1	1	1958	https://en.wikipedia.org/wiki/Alan_A%27Court
2	P-00942	Abadzhiev	Stefan	1934-07-03			1	1	1966	https://en.wikipedia.org/wiki/Stefan_Abadzhiev
3	P-03051	Abalo	Jean-Paul	1975-06-26		1		1	2006	https://en.wikipedia.org/wiki/Jean-Paul_Abalo
4	P-03371	Abanda	Patrice	1978-08-03		1		1	1998	https://en.wikipedia.org/wiki/Patrice_Abanda
5	P-04977	Abate	Ignazio	1986-11-12		1		1	2014	https://en.wikipedia.org/wiki/Ignazio_Abate
6	P-06675	Abbadie	Julio	1930-09-07			1	1	1954	https://en.wikipedia.org/wiki/Julio_Abbadie
7	P-02825	Abbes	Claude	1927-05-24	1			2	1954, 1958	https://en.wikipedia.org/wiki/Claude_Abbes
8	P-06214	Abbiati	Christian	1977-07-08	1			1	2002	https://en.wikipedia.org/wiki/Christian_Abbiati
9	P-05883	Abbondanzieri	Roberto	1972-08-19	1			1	2006	https://en.wikipedia.org/wiki/Roberto_Abbondanzieri
10	P-06019	Abd Al-Jawad	Mohamed	1962-11-28		1		1	1994	https://en.wikipedia.org/wiki/Mohamed_Abd_Al-Jawad


CREATE TABLE players (
  "key_id" BIGINT,
  "player_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "birth_date" VARCHAR,
  "goal_keeper" BIGINT,
  "defender" BIGINT,
  "midfielder" BIGINT,
  "forward" BIGINT,
  "count_tournaments" BIGINT,
  "list_tournaments" VARCHAR,
  "player_wikipedia_link" VARCHAR
);