A Comprehensive Database On The FIFA World Cup

key_id Key Id	substitution_id Substitution 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	shirt_number Shirt Number	minute_label Minute Label	minute_regulation Minute Regulation	match_period Match Period	going_off Going Off	coming_on Coming On
1	S-0001	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-69	Soviet Union	SUN		1	P-04344	Serebryanikov	Viktor	15	46'	46	second half	1
2	S-0002	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-69	Soviet Union	SUN		1	P-07073	Puzach	Anatoliy	20	46'	46	second half		1
3	S-0003	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-69	Soviet Union	SUN		1	P-07350	Nodia	Givi	19	66'	66	second half	1
4	S-0004	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-69	Soviet Union	SUN		1	P-09955	Khmelnitsky	Vitaly	21	66'	66	second half		1
5	S-0005	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-44	Mexico	MEX	1		P-07267	Velarde	Mario	18	67'	67	second half	1
6	S-0006	WC-1970	1970 FIFA World Cup	M-1970-01	Mexico v Soviet Union	Sun May 31 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 1	T-44	Mexico	MEX	1		P-00927	Munguía	Antonio	8	67'	67	second half		1
7	S-0007	WC-1970	1970 FIFA World Cup	M-1970-02	Uruguay v Israel	Tue Jun 02 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-80	Uruguay	URY	1		P-05145	Rocha	Pedro	8	12'	12	first half	1
8	S-0008	WC-1970	1970 FIFA World Cup	M-1970-02	Uruguay v Israel	Tue Jun 02 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-80	Uruguay	URY	1		P-08635	Cortés	Julio César	20	12'	12	first half		1
9	S-0009	WC-1970	1970 FIFA World Cup	M-1970-02	Uruguay v Israel	Tue Jun 02 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-38	Israel	ISR		1	P-09513	Talbi	Rachamim	15	46'	46	second half	1
10	S-0010	WC-1970	1970 FIFA World Cup	M-1970-02	Uruguay v Israel	Tue Jun 02 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	group stage	Group 2	T-38	Israel	ISR		1	P-03139	Bar	Shraga	2	46'	46	second half		1


CREATE TABLE substitutions (
  "key_id" BIGINT,
  "substitution_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,
  "minute_label" VARCHAR,
  "minute_regulation" BIGINT,
  "minute_stoppage" BIGINT,
  "match_period" VARCHAR,
  "going_off" BIGINT,
  "coming_on" BIGINT
);