Name: Brazilian Soccer Results
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Brazilian Soccer Results

Context

Dataset with the results of the games of the first division of the Brazilian football championship since 2002.

Content

We have 20 columns where:

Ano: year
Rod: round
Pos: current position
Clb: Team name
Pts: number of points received in this match
Vit: Boolean for team victory
Emp: Boolean for team drawn
Der: Boolean for team defeat
GP: Number of goals for the team in this match
GC: Number of goals against
SG: Goal difference in this match
Adv: opposing team
Home: If the match is in the team home
Pts(ac): Current number of points
Vit(ac): Year cumulative number of victories
Emp(ac): Year cumulative number of drawns
Der(ac): Year cumulative number of defeats
GP(ac): Year cumulative number of goals for
GC(ac): Year cumulative number of goals against
SG(ac): Year cumulative goal difference

Tables

Dados Brasileirao 2003 A 2018

@kaggle.emdemor_brazilian_soccer_results.dados_brasileirao_2003_a_2018

131.36 kB
13,012 rows
20 columns

CREATE TABLE dados_brasileirao_2003_a_2018 (
  "ano" BIGINT,
  "rod" BIGINT,
  "pos" BIGINT,
  "clb" VARCHAR,
  "pts" BIGINT,
  "vit" BIGINT,
  "emp" BIGINT,
  "der" BIGINT,
  "gp" BIGINT,
  "gc" BIGINT,
  "sg" BIGINT,
  "adv" VARCHAR,
  "home" BOOLEAN,
  "pts_ac" BIGINT  -- Pts(ac),
  "vit_ac" BIGINT  -- Vit(ac),
  "emp_ac" BIGINT  -- Emp(ac),
  "der_ac" BIGINT  -- Der(ac),
  "gp_ac" BIGINT  -- GP(ac),
  "gc_ac" BIGINT  -- GC(ac),
  "sg_ac" BIGINT  -- SG(ac)
);