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	home_team_id Home Team Id	home_team_name Home Team Name	home_team_code Home Team Code	away_team_id Away Team Id	away_team_name Away Team Name	away_team_code Away Team Code	score Score	home_team_score Home Team Score	away_team_score Away Team Score	home_team_score_margin Home Team Score Margin	away_team_score_margin Away Team Score Margin	score_penalties Score Penalties	result Result	home_team_win Home Team Win
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	4–1	4	1	3	-3	0-0	home team win	1
2	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	3–0	3		3	-3	0-0	home team win	1
3	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	2–1	2	1	1	-1	0-0	home team win	1
4	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	3–1	3	1	2	-2	0-0	home team win	1
5	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–0	1		1	-1	0-0	home team win	1
6	WC-1930	1930 FIFA World Cup	M-1930-06	Chile v Mexico	group stage	Group 1	1	Wed Jul 16 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	14:45	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-13	Chile	CHL	T-44	Mexico	MEX	3–0	3		3	-3	0-0	home team win	1
7	WC-1930	1930 FIFA World Cup	M-1930-07	Yugoslavia v Bolivia	group stage	Group 2	1	Thu Jul 17 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	12:45	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-83	Yugoslavia	YUG	T-07	Bolivia	BOL	4–0	4		4	-4	0-0	home team win	1
8	WC-1930	1930 FIFA World Cup	M-1930-08	United States v Paraguay	group stage	Group 4	1	Thu Jul 17 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	14:45	S-184	Estadio Gran Parque Central	Montevideo	Uruguay	T-79	United States	USA	T-53	Paraguay	PRY	3–0	3		3	-3	0-0	home team win	1
9	WC-1930	1930 FIFA World Cup	M-1930-09	Uruguay v Peru	group stage	Group 3	1	Fri Jul 18 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	14:30	S-183	Estadio Centenario	Montevideo	Uruguay	T-80	Uruguay	URY	T-54	Peru	PER	1–0	1		1	-1	0-0	home team win	1
10	WC-1930	1930 FIFA World Cup	M-1930-10	Chile v France	group stage	Group 1	1	Sat Jul 19 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	12:50	S-183	Estadio Centenario	Montevideo	Uruguay	T-13	Chile	CHL	T-28	France	FRA	1–0	1		1	-1	0-0	home team win	1


CREATE TABLE matches (
  "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,
  "home_team_id" VARCHAR,
  "home_team_name" VARCHAR,
  "home_team_code" VARCHAR,
  "away_team_id" VARCHAR,
  "away_team_name" VARCHAR,
  "away_team_code" VARCHAR,
  "score" VARCHAR,
  "home_team_score" BIGINT,
  "away_team_score" BIGINT,
  "home_team_score_margin" BIGINT,
  "away_team_score_margin" BIGINT,
  "extra_time" BIGINT,
  "penalty_shootout" BIGINT,
  "score_penalties" VARCHAR,
  "home_team_score_penalties" BIGINT,
  "away_team_score_penalties" BIGINT,
  "result" VARCHAR,
  "home_team_win" BIGINT,
  "away_team_win" BIGINT,
  "draw" BIGINT
);