FIFA World Cup

All the results from World Cups

@kaggle.abecklas_fifa_world_cup

Table List

3 tables(318.28 KB)

Worldcupmatches

Worldcupplayers

Worldcups

Worldcupplayers

@kaggle.abecklas_fifa_world_cup.worldcupplayers

244.27 KB
37784 rows
9 columns

roundid RoundID	matchid MatchID	team_initials Team Initials	coach_name Coach Name	line_up Line-up	player_name Player Name	position Position	event Event
201	1096	FRA	CAUDRON Raoul (FRA)	S	Alex THEPOT	GK	nan
201	1096	MEX	LUQUE Juan (MEX)	S	Oscar BONFIGLIO	GK	nan
201	1096	FRA	CAUDRON Raoul (FRA)	S	Marcel LANGILLER	nan	G40'
201	1096	MEX	LUQUE Juan (MEX)	S	Juan CARRENO	nan	G70'
201	1096	FRA	CAUDRON Raoul (FRA)	S	Ernest LIBERATI	nan	nan
201	1096	MEX	LUQUE Juan (MEX)	S	Rafael GARZA	C	nan
201	1096	FRA	CAUDRON Raoul (FRA)	S	Andre MASCHINOT	nan	G43' G87'
201	1096	MEX	LUQUE Juan (MEX)	S	Hilario LOPEZ	nan	nan
201	1096	FRA	CAUDRON Raoul (FRA)	S	Etienne MATTLER	nan	nan
201	1096	MEX	LUQUE Juan (MEX)	S	Dionisio MEJIA	nan	nan


CREATE TABLE worldcupplayers (
  "roundid" BIGINT,
  "matchid" BIGINT,
  "team_initials" VARCHAR,
  "coach_name" VARCHAR,
  "line_up" VARCHAR,
  "shirt_number" BIGINT,
  "player_name" VARCHAR,
  "position" VARCHAR,
  "event" VARCHAR
);