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 Teams

@kaggle.jsppimentel99_coparussiajogos.cup_russia_teams

11.16 KB
32 rows
14 columns

team Team	matches_played Matches Played	goals Goals	goals_scored Goals Scored	goals_against Goals Against	penalty Penalty	own_goals Own Goals	open_play_goals Open Play Goals	set_piece_goals Set Piece Goals	yellow_cards Yellow Cards	red_cards Red Cards	fouls_committed Fouls Committed	fouls_suffered Fouls Suffered	penalty_commeitted Penalty Commeitted
Argentina	4	6	6	9			6		11		55	75	2
Australia	3	2	2	5	2			2	7		37	30	1
Belgium	7	16	15	6	1	1	14	1	11		99	75
Brazil	5	8	8	3			8		7		50	73
Colombia	4	6	6	3			5	1	9	1	63	52	2
Costa Rica	3	2	1	5		1	1		6		43	35
Croatia	7	14	13	9	1	1	12	1	15		114	105	2
Denmark	4	3	3	2			3		6		54	28	3
Egypt	3	2	2	6	1		1	1	5		38	21	2
England	7	12	12	8	3		8	4	8		72	100	1


CREATE TABLE cup_russia_teams (
  "team" VARCHAR,
  "matches_played" BIGINT,
  "goals" BIGINT,
  "goals_scored" BIGINT,
  "goals_against" BIGINT,
  "penalty" BIGINT,
  "own_goals" BIGINT,
  "open_play_goals" BIGINT,
  "set_piece_goals" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" DOUBLE,
  "fouls_committed" BIGINT,
  "fouls_suffered" BIGINT,
  "penalty_commeitted" BIGINT
);