FIFA World Cup 2018

Copa do Mundo Rússia 2018 - World Cup Russia 2018

@kaggle.jsppimentel99_coparussiajogos

Table List

2 tables(22.9 KB)

Cup Russia Matches

@kaggle.jsppimentel99_coparussiajogos.cup_russia_matches

11.74 KB
64 rows
14 columns

time_brazil Time (Brazil)	date Date	stage Stage	stadium Stadium	city City	home_team Home Team	home_team_goals Home Team Goals	away_team_goals Away Team Goals	away_team Away Team	win_conditions Win Conditions	penalty Penalty	win Win	total_goals Total Goals	attendance Attendance
12:00	Thu Jun 14 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group A	Luzhniki Stadium	Moscow	Russia	5		Saudi Arabia	Normal Time	nan	Russia	5	78011
09:00	Fri Jun 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group A	Ekaterinburg Arena	Ekaterinburg	Egypt		1	Uruguay	Normal Time	nan	Uruguay	1	27015
12:00	Fri Jun 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group B	Saint Petersburg Stadium	St. Petersburg	Morocco		1	IR Iran	Normal Time	nan	IR Iran	1	62548
15:00	Fri Jun 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group B	Fisht Stadium	Sochi	Portugal	3	3	Spain	Normal Time	nan	Empate	6	43866
07:00	Sat Jun 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group C	Kazan Arena	Kazan	France	2	1	Australia	Normal Time	nan	France	3	41279
10:00	Sat Jun 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group D	Spartak Stadium	Moscow	Argentina	1	1	Iceland	Normal Time	nan	Empate	2	44190
13:00	Sat Jun 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group C	Mordovia Arena	Saransk	Peru		1	Denmark	Normal Time	nan	Denmark	1	40502
16:00	Sat Jun 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group D	Kaliningrad Stadium	Kaliningrad	Croatia	2		Nigeria	Normal Time	nan	Croatia	2	31136
09:00	Sun Jun 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group E	Samara Arena	Samara	Costa Rica		1	Serbia	Normal Time	nan	Serbia	1	41432
12:00	Sun Jun 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Group F	Luzhniki Stadium	Moscow	Germany		1	Mexico	Normal Time	nan	Mexico	1	78011


CREATE TABLE cup_russia_matches (
  "time_brazil" VARCHAR,
  "date" TIMESTAMP,
  "stage" VARCHAR,
  "stadium" VARCHAR,
  "city" VARCHAR,
  "home_team" VARCHAR,
  "home_team_goals" BIGINT,
  "away_team_goals" BIGINT,
  "away_team" VARCHAR,
  "win_conditions" VARCHAR,
  "penalty" VARCHAR,
  "win" VARCHAR,
  "total_goals" BIGINT,
  "attendance" BIGINT
);