Name: FIFA World Cup 2018
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FIFA World Cup 2018

Conjunto de dados construído pela falta de informações sobre a copa do mundo de 2018 em forma de banco de dados. Originalmente, está base foi construída para ser utilizada em trabalho acadêmico durante o curso de graduação em estatística da UFBA. Dataset built by the lack of information about the 2018 World Cup in the form of a database. Originally, this base was built to be used in academic work during the undergraduate course in statistics at UFBA.

Tables

Cup Russia Matches

@kaggle.jsppimentel99_coparussiajogos.cup_russia_matches

12.03 kB
64 rows
14 columns

CREATE TABLE cup_russia_matches (
  "time_brazil" VARCHAR  -- Time (Brazil),
  "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
);

Cup Russia Teams

@kaggle.jsppimentel99_coparussiajogos.cup_russia_teams

11.42 kB
32 rows
14 columns

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
);