A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	match_id Match Id	match_name Match Name	stage_name Stage Name	group_name Group Name	group_stage Group Stage	match_date Match Date	match_time Match Time	stadium_id Stadium Id	stadium_name Stadium Name	city_name City Name	country_name Country Name	team_id Team Id	team_name Team Name	team_code Team Code	opponent_id Opponent Id	opponent_name Opponent Name	opponent_code Opponent Code	home_team Home Team	away_team Away Team	goals_for Goals For	goals_against Goals Against	goal_differential Goal Differential	result Result	win Win	lose Lose
1	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	group stage	Group 1	1	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	S-185	Estadio Pocitos	Montevideo	Uruguay	T-28	France	FRA	T-44	Mexico	MEX	1		4	1	3	win	1
2	WC-1930	1930 FIFA World Cup	M-1930-01	France v Mexico	group stage	Group 1	1	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	S-185	Estadio Pocitos	Montevideo	Uruguay	T-44	Mexico	MEX	T-28	France	FRA		1	1	4	-3	lose		1
3	WC-1930	1930 FIFA World Cup	M-1930-02	United States v Belgium	group stage	Group 4	1	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-79	United States	USA	T-06	Belgium	BEL	1		3		3	win	1
4	WC-1930	1930 FIFA World Cup	M-1930-02	United States v Belgium	group stage	Group 4	1	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-06	Belgium	BEL	T-79	United States	USA		1		3	-3	lose		1
5	WC-1930	1930 FIFA World Cup	M-1930-03	Yugoslavia v Brazil	group stage	Group 2	1	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	12:45	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-83	Yugoslavia	YUG	T-09	Brazil	BRA	1		2	1	1	win	1
6	WC-1930	1930 FIFA World Cup	M-1930-03	Yugoslavia v Brazil	group stage	Group 2	1	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	12:45	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-09	Brazil	BRA	T-83	Yugoslavia	YUG		1	1	2	-1	lose		1
7	WC-1930	1930 FIFA World Cup	M-1930-04	Romania v Peru	group stage	Group 3	1	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	14:50	S-185	Estadio Pocitos	Montevideo	Uruguay	T-58	Romania	ROU	T-54	Peru	PER	1		3	1	2	win	1
8	WC-1930	1930 FIFA World Cup	M-1930-04	Romania v Peru	group stage	Group 3	1	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	14:50	S-185	Estadio Pocitos	Montevideo	Uruguay	T-54	Peru	PER	T-58	Romania	ROU		1	1	3	-2	lose		1
9	WC-1930	1930 FIFA World Cup	M-1930-05	Argentina v France	group stage	Group 1	1	Tue Jul 15 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-03	Argentina	ARG	T-28	France	FRA	1		1		1	win	1
10	WC-1930	1930 FIFA World Cup	M-1930-05	Argentina v France	group stage	Group 1	1	Tue Jul 15 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-28	France	FRA	T-03	Argentina	ARG		1		1	-1	lose		1


CREATE TABLE team_appearances (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "match_id" VARCHAR,
  "match_name" VARCHAR,
  "stage_name" VARCHAR,
  "group_name" VARCHAR,
  "group_stage" BIGINT,
  "knockout_stage" BIGINT,
  "replayed" BIGINT,
  "replay" BIGINT,
  "match_date" TIMESTAMP,
  "match_time" VARCHAR,
  "stadium_id" VARCHAR,
  "stadium_name" VARCHAR,
  "city_name" VARCHAR,
  "country_name" VARCHAR,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "opponent_id" VARCHAR,
  "opponent_name" VARCHAR,
  "opponent_code" VARCHAR,
  "home_team" BIGINT,
  "away_team" BIGINT,
  "goals_for" BIGINT,
  "goals_against" BIGINT,
  "goal_differential" BIGINT,
  "extra_time" BIGINT,
  "penalty_shootout" BIGINT,
  "penalties_for" BIGINT,
  "penalties_against" BIGINT,
  "result" VARCHAR,
  "win" BIGINT,
  "lose" BIGINT,
  "draw" BIGINT
);