FIFA World Cup

All the results from World Cups

@kaggle.abecklas_fifa_world_cup

Table List

3 tables(318.28 KB)

Worldcupmatches

Worldcupplayers

Worldcups

Worldcupmatches

@kaggle.abecklas_fifa_world_cup.worldcupmatches

65.89 KB
4572 rows
20 columns

year Year	datetime Datetime	stage Stage	stadium Stadium	city City	home_team_name Home Team Name	home_team_goals Home Team Goals	away_team_goals Away Team Goals	away_team_name Away Team Name	attendance Attendance	half_time_home_goals Half-time Home Goals	referee Referee	assistant_1 Assistant 1	assistant_2 Assistant 2	roundid RoundID	matchid MatchID	home_team_initials Home Team Initials	away_team_initials Away Team Initials
1930	13 Jul 1930 - 15:00	Group 1	Pocitos	Montevideo	France	4	1	Mexico	4444	3	LOMBARDI Domingo (URU)	CRISTOPHE Henry (BEL)	REGO Gilberto (BRA)	201	1096	FRA	MEX
1930	13 Jul 1930 - 15:00	Group 4	Parque Central	Montevideo	USA	3		Belgium	18346	2	MACIAS Jose (ARG)	MATEUCCI Francisco (URU)	WARNKEN Alberto (CHI)	201	1090	USA	BEL
1930	14 Jul 1930 - 12:45	Group 2	Parque Central	Montevideo	Yugoslavia	2	1	Brazil	24059	2	TEJADA Anibal (URU)	VALLARINO Ricardo (URU)	BALWAY Thomas (FRA)	201	1093	YUG	BRA
1930	14 Jul 1930 - 14:50	Group 3	Pocitos	Montevideo	Romania	3	1	Peru	2549	1	WARNKEN Alberto (CHI)	LANGENUS Jean (BEL)	MATEUCCI Francisco (URU)	201	1098	ROU	PER
1930	15 Jul 1930 - 16:00	Group 1	Parque Central	Montevideo	Argentina	1		France	23409		REGO Gilberto (BRA)	SAUCEDO Ulises (BOL)	RADULESCU Constantin (ROU)	201	1085	ARG	FRA
1930	16 Jul 1930 - 14:45	Group 1	Parque Central	Montevideo	Chile	3		Mexico	9249	1	CRISTOPHE Henry (BEL)	APHESTEGUY Martin (URU)	LANGENUS Jean (BEL)	201	1095	CHI	MEX
1930	17 Jul 1930 - 12:45	Group 2	Parque Central	Montevideo	Yugoslavia	4		Bolivia	18306		MATEUCCI Francisco (URU)	LOMBARDI Domingo (URU)	WARNKEN Alberto (CHI)	201	1092	YUG	BOL
1930	17 Jul 1930 - 14:45	Group 4	Parque Central	Montevideo	USA	3		Paraguay	18306	2	MACIAS Jose (ARG)	APHESTEGUY Martin (URU)	TEJADA Anibal (URU)	201	1097	USA	PAR
1930	18 Jul 1930 - 14:30	Group 3	Estadio Centenario	Montevideo	Uruguay	1		Peru	57735		LANGENUS Jean (BEL)	BALWAY Thomas (FRA)	CRISTOPHE Henry (BEL)	201	1099	URU	PER
1930	19 Jul 1930 - 12:50	Group 1	Estadio Centenario	Montevideo	Chile	1		France	2000		TEJADA Anibal (URU)	LOMBARDI Domingo (URU)	REGO Gilberto (BRA)	201	1094	CHI	FRA


CREATE TABLE worldcupmatches (
  "year" DOUBLE,
  "datetime" VARCHAR,
  "stage" VARCHAR,
  "stadium" VARCHAR,
  "city" VARCHAR,
  "home_team_name" VARCHAR,
  "home_team_goals" DOUBLE,
  "away_team_goals" DOUBLE,
  "away_team_name" VARCHAR,
  "win_conditions" VARCHAR,
  "attendance" DOUBLE,
  "half_time_home_goals" DOUBLE,
  "half_time_away_goals" DOUBLE,
  "referee" VARCHAR,
  "assistant_1" VARCHAR,
  "assistant_2" VARCHAR,
  "roundid" DOUBLE,
  "matchid" DOUBLE,
  "home_team_initials" VARCHAR,
  "away_team_initials" VARCHAR
);