FIFA World Cup

Dataset of every match played in FIFA World Cup history from 1930 to 2018

@kaggle.evangower_fifa_world_cup

Table List

2 tables(33.75 KB)

Wcmatches

@kaggle.evangower_fifa_world_cup.wcmatches

25.74 KB
900 rows
15 columns

year Year	country Country	city City	stage Stage	home_team Home Team	away_team Away Team	home_score Home Score	away_score Away Score	outcome Outcome	win_conditions Win Conditions	winning_team Winning Team	losing_team Losing Team	date Date	month Month	dayofweek Dayofweek
1930	Uruguay	Montevideo	Group 1	France	Mexico	4	1	H	nan	France	Mexico	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Sunday
1930	Uruguay	Montevideo	Group 4	Belgium	United States		3	A	nan	United States	Belgium	Sun Jul 13 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Sunday
1930	Uruguay	Montevideo	Group 2	Brazil	Yugoslavia	1	2	A	nan	Yugoslavia	Brazil	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Monday
1930	Uruguay	Montevideo	Group 3	Peru	Romania	1	3	A	nan	Romania	Peru	Mon Jul 14 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Monday
1930	Uruguay	Montevideo	Group 1	Argentina	France	1		H	nan	Argentina	France	Tue Jul 15 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Tuesday
1930	Uruguay	Montevideo	Group 1	Chile	Mexico	3		H	nan	Chile	Mexico	Wed Jul 16 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Wednesday
1930	Uruguay	Montevideo	Group 2	Bolivia	Yugoslavia		4	A	nan	Yugoslavia	Bolivia	Thu Jul 17 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Thursday
1930	Uruguay	Montevideo	Group 4	Paraguay	United States		3	A	nan	United States	Paraguay	Thu Jul 17 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Thursday
1930	Uruguay	Montevideo	Group 3	Uruguay	Peru	1		H	nan	Uruguay	Peru	Fri Jul 18 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Friday
1930	Uruguay	Montevideo	Group 1	Argentina	Mexico	6	3	H	nan	Argentina	Mexico	Sat Jul 19 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul	Saturday


CREATE TABLE wcmatches (
  "year" BIGINT,
  "country" VARCHAR,
  "city" VARCHAR,
  "stage" VARCHAR,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "outcome" VARCHAR,
  "win_conditions" VARCHAR,
  "winning_team" VARCHAR,
  "losing_team" VARCHAR,
  "date" TIMESTAMP,
  "month" VARCHAR,
  "dayofweek" VARCHAR
);