A Comprehensive Database On The FIFA World Cup

key_id Key Id	goal_id Goal Id	tournament_id Tournament Id	tournament_name Tournament Name	match_id Match Id	match_name Match Name	match_date Match Date	stage_name Stage Name	group_name Group Name	team_id Team Id	team_name Team Name	team_code Team Code	home_team Home Team	away_team Away Team	player_id Player Id	family_name Family Name	given_name Given Name	player_team_id Player Team Id	player_team_name Player Team Name	player_team_code Player Team Code	minute_label Minute Label	minute_regulation Minute Regulation	match_period Match Period
1	G-0001	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-28	France	FRA	1		P-09831	Laurent	Lucien	T-28	France	FRA	19'	19	first half
2	G-0002	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-28	France	FRA	1		P-05670	Langiller	Marcel	T-28	France	FRA	40'	40	first half
3	G-0003	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-28	France	FRA	1		P-07295	Maschinot	André	T-28	France	FRA	43'	43	first half
4	G-0004	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-28	France	FRA	1		P-07295	Maschinot	André	T-28	France	FRA	87'	87	second half
5	G-0005	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-44	Mexico	MEX		1	P-03952	Carreño	Juan	T-44	Mexico	MEX	70'	70	second half
6	G-0006	WC-1930	1930 FIFA World Cup	M-1930-02	United States v Belgium	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 4	T-79	United States	USA	1		P-09935	McGhee	Bart	T-79	United States	USA	23'	23	first half
7	G-0007	WC-1930	1930 FIFA World Cup	M-1930-02	United States v Belgium	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 4	T-79	United States	USA	1		P-06672	Florie	Tom	T-79	United States	USA	45'	45	first half
8	G-0008	WC-1930	1930 FIFA World Cup	M-1930-02	United States v Belgium	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 4	T-79	United States	USA	1		P-09215	Patenaude	Bert	T-79	United States	USA	69'	69	second half
9	G-0009	WC-1930	1930 FIFA World Cup	M-1930-03	Yugoslavia v Brazil	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-83	Yugoslavia	YUG	1		P-00319	Tirnanić	Aleksandar	T-83	Yugoslavia	YUG	21'	21	first half
10	G-0010	WC-1930	1930 FIFA World Cup	M-1930-03	Yugoslavia v Brazil	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-83	Yugoslavia	YUG	1		P-06435	Bek	Ivan	T-83	Yugoslavia	YUG	30'	30	first half


CREATE TABLE goals (
  "key_id" BIGINT,
  "goal_id" VARCHAR,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "match_id" VARCHAR,
  "match_name" VARCHAR,
  "match_date" TIMESTAMP,
  "stage_name" VARCHAR,
  "group_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "home_team" BIGINT,
  "away_team" BIGINT,
  "player_id" VARCHAR,
  "family_name" VARCHAR,
  "given_name" VARCHAR,
  "shirt_number" BIGINT,
  "player_team_id" VARCHAR,
  "player_team_name" VARCHAR,
  "player_team_code" VARCHAR,
  "minute_label" VARCHAR,
  "minute_regulation" BIGINT,
  "minute_stoppage" BIGINT,
  "match_period" VARCHAR,
  "own_goal" BIGINT,
  "penalty" BIGINT
);