Baselight

CartolaFC

Data from the popular Brazilian Fantasy Football (2014 to 2017) ⚽️

@kaggle.schiller_cartolafc

Loading...
Loading...

About this Dataset

CartolaFC

Context

CartolaFC is the most popular fantasy football in Brazil. Before each round of the Brazilian Football League, players choose which athletes they want for their teams, and they score points based on their real-life performances.

Content

Data is divided in 7 kinds of files:

Athletes (atletas)

  • "atleta_id": id,

  • "nome": athlete's full name,

  • "apelido": athlete's nickname

Clubs (clubes)

  • "id": id,

  • "nome": club's name,

  • "abreviacao": name abbreviation,

  • "slug": used for some API calls

Matches (partidas)

  • "rodada_id": current round,

  • "clube_casa_id": home team id,

  • "clube_visitante_id": away team id,

  • "clube_casa_posicao": home team's position on the league,

  • "clube_visitante_posicao": away team's position on the league,

  • "aproveitamento_mandante": home team's outcome on the last five matches (d: loss, e: draw, v: victory),

  • "aproveitamento_visitante": away team's outcome on the last five matches (d: loss, e: draw, v: victory),

  • "placar_oficial_mandante": home team's score,

  • "placar_oficial_visitante": away team's score,

  • "partida_data": match date,

  • "local": stadium,

  • "valida": match valid for scoring

Scouts

  • "atleta_id": reference to athlete,

  • "rodada_id": current round,

  • "clube_id": reference to club,

  • "posicao_id": reference to position,

  • "status_id": reference to status,

  • "pontos_num": points scored on current round,

  • "preco_num": current price,

  • "variacao_num": price variation from previous round,

  • "media_num": average points per played round,

  • "jogos_num": number of matches played,

  • "FS": suffered fouls,

  • "PE": missed passes,

  • "A": assistances,

  • "FT": shots on the post,

  • "FD": defended shots,

  • "FF": shots off target,

  • "G": goals,

  • "I": offsides,

  • "PP": missed penalties,

  • "RB": successful tackes,

  • "FC": fouls commited,

  • "GC": own goals,

  • "CA": yellow cards,

  • "CV": red cards,

  • "SG": clean sheets (only defenders),

  • "DD": difficult defenses (only goalies),

  • "DP": defended penalties (only goalies),

  • "GS": suffered goals (only goalies)

Positions (posicoes)

  • "id": id,

  • "nome": name,

  • "abreviacao": abbreviation

Status

  • "id": id,

  • "nome": name

Points (pontuacao)

  • "abreviacao": abbreviation,

  • "nome": name,

  • "pontuacao": points earned for respective scout

Acknowledgements

The datasets from 2014 to 2016 were taken from here: https://github.com/thevtm/CartolaFCDados.

Data from 2017 until round 11 was taken from this repo: https://github.com/henriquepgomide/caRtola.

From 2017 round 12 and on, I've been extracting the data from CartolaFC's API (which is not officially public).

Inspiration

It would be interesting to see analyses on which factors make an athlete or team more likely to score points, and also predictive models for future scores.

Tables

N 2014 Atletas

@kaggle.schiller_cartolafc.n_2014_atletas
  • 18.56 KB
  • 1033 rows
  • 4 columns
Loading...

CREATE TABLE n_2014_atletas (
  "id" BIGINT,
  "apelido" VARCHAR,
  "clube_id" BIGINT,
  "posicao_id" BIGINT
);

N 2014 Clubes

@kaggle.schiller_cartolafc.n_2014_clubes
  • 3.84 KB
  • 20 rows
  • 4 columns
Loading...

CREATE TABLE n_2014_clubes (
  "id" BIGINT,
  "nome" VARCHAR,
  "abreviacao" VARCHAR,
  "slug" VARCHAR
);

N 2014 Partidas

@kaggle.schiller_cartolafc.n_2014_partidas
  • 8.15 KB
  • 380 rows
  • 6 columns
Loading...

CREATE TABLE n_2014_partidas (
  "id" BIGINT,
  "rodada" BIGINT,
  "clube_casa_id" BIGINT,
  "clube_visitante_id" BIGINT,
  "placar_oficial_mandante" BIGINT,
  "placar_oficial_visitante" BIGINT
);

N 2014 Scouts

@kaggle.schiller_cartolafc.n_2014_scouts
  • 313.94 KB
  • 31567 rows
  • 34 columns
Loading...

CREATE TABLE n_2014_scouts (
  "atleta_id" BIGINT,
  "rodada" BIGINT,
  "clube_id" DOUBLE,
  "participou" BIGINT,
  "posicao_id" DOUBLE,
  "jogos_num" BIGINT,
  "pontos_num" DOUBLE,
  "media_num" DOUBLE,
  "preco_num" DOUBLE,
  "variacao_num" DOUBLE,
  "partida_id" DOUBLE,
  "mando" BIGINT,
  "titular" DOUBLE,
  "substituido" BIGINT,
  "tempo_jogado" DOUBLE,
  "nota" DOUBLE,
  "fs" BIGINT,
  "pe" BIGINT,
  "a" BIGINT,
  "ft" BIGINT,
  "fd" BIGINT,
  "ff" BIGINT,
  "g" BIGINT,
  "i" BIGINT,
  "pp" BIGINT,
  "rb" BIGINT,
  "fc" BIGINT,
  "gc" BIGINT,
  "ca" BIGINT,
  "cv" BIGINT,
  "sg" BIGINT,
  "dd" BIGINT,
  "dp" BIGINT,
  "gs" BIGINT
);

N 2015 Atletas

@kaggle.schiller_cartolafc.n_2015_atletas
  • 18.58 KB
  • 1026 rows
  • 4 columns
Loading...

CREATE TABLE n_2015_atletas (
  "id" BIGINT,
  "apelido" VARCHAR,
  "clube_id" DOUBLE,
  "posicao_id" BIGINT
);

N 2015 Clubes

@kaggle.schiller_cartolafc.n_2015_clubes
  • 3.82 KB
  • 20 rows
  • 4 columns
Loading...

CREATE TABLE n_2015_clubes (
  "id" BIGINT,
  "nome" VARCHAR,
  "abreviacao" VARCHAR,
  "slug" VARCHAR
);

N 2015 Partidas

@kaggle.schiller_cartolafc.n_2015_partidas
  • 8.12 KB
  • 380 rows
  • 6 columns
Loading...

CREATE TABLE n_2015_partidas (
  "id" BIGINT,
  "rodada" BIGINT,
  "clube_casa_id" BIGINT,
  "clube_visitante_id" BIGINT,
  "placar_oficial_mandante" BIGINT,
  "placar_oficial_visitante" BIGINT
);

N 2015 Scouts

@kaggle.schiller_cartolafc.n_2015_scouts
  • 399.89 KB
  • 30510 rows
  • 26 columns
Loading...

CREATE TABLE n_2015_scouts (
  "atleta_id" BIGINT,
  "rodada" BIGINT,
  "clube_id" BIGINT,
  "jogos_num" BIGINT,
  "pontos_num" DOUBLE,
  "media_num" DOUBLE,
  "preco_num" DOUBLE,
  "variacao_num" DOUBLE,
  "fs" BIGINT,
  "pe" BIGINT,
  "a" BIGINT,
  "ft" BIGINT,
  "fd" BIGINT,
  "ff" BIGINT,
  "g" BIGINT,
  "i" BIGINT,
  "pp" BIGINT,
  "rb" BIGINT,
  "fc" BIGINT,
  "gc" BIGINT,
  "ca" BIGINT,
  "cv" BIGINT,
  "sg" BIGINT,
  "dd" BIGINT,
  "dp" BIGINT,
  "gs" BIGINT
);

N 2016 Atletas

@kaggle.schiller_cartolafc.n_2016_atletas
  • 18.1 KB
  • 1001 rows
  • 4 columns
Loading...

CREATE TABLE n_2016_atletas (
  "id" BIGINT,
  "apelido" VARCHAR,
  "clube_id" BIGINT,
  "posicao_id" BIGINT
);

N 2016 Clubes

@kaggle.schiller_cartolafc.n_2016_clubes
  • 3.86 KB
  • 20 rows
  • 4 columns
Loading...

CREATE TABLE n_2016_clubes (
  "id" BIGINT,
  "nome" VARCHAR,
  "abreviacao" VARCHAR,
  "slug" VARCHAR
);

N 2016 Partidas

@kaggle.schiller_cartolafc.n_2016_partidas
  • 8.13 KB
  • 380 rows
  • 6 columns
Loading...

CREATE TABLE n_2016_partidas (
  "id" BIGINT,
  "rodada" BIGINT,
  "clube_casa_id" BIGINT,
  "clube_visitante_id" BIGINT,
  "placar_oficial_mandante" DOUBLE,
  "placar_oficial_visitante" DOUBLE
);

N 2016 Scouts

@kaggle.schiller_cartolafc.n_2016_scouts
  • 254.38 KB
  • 31168 rows
  • 26 columns
Loading...

CREATE TABLE n_2016_scouts (
  "atleta_id" BIGINT,
  "rodada" BIGINT,
  "clube_id" DOUBLE,
  "participou" BOOLEAN,
  "pontos_num" DOUBLE,
  "media_num" DOUBLE,
  "preco_num" DOUBLE,
  "variacao_num" DOUBLE,
  "fs" BIGINT,
  "pe" BIGINT,
  "a" BIGINT,
  "ft" BIGINT,
  "fd" BIGINT,
  "ff" BIGINT,
  "g" BIGINT,
  "i" BIGINT,
  "pp" BIGINT,
  "rb" BIGINT,
  "fc" BIGINT,
  "gc" BIGINT,
  "ca" BIGINT,
  "cv" BIGINT,
  "sg" BIGINT,
  "dd" BIGINT,
  "dp" BIGINT,
  "gs" BIGINT
);

N 2017 Atletas

@kaggle.schiller_cartolafc.n_2017_atletas
  • 32.65 KB
  • 944 rows
  • 3 columns
Loading...

CREATE TABLE n_2017_atletas (
  "atleta_id" BIGINT,
  "nome" VARCHAR,
  "apelido" VARCHAR
);

N 2017 Clubes

@kaggle.schiller_cartolafc.n_2017_clubes
  • 3.83 KB
  • 20 rows
  • 4 columns
Loading...

CREATE TABLE n_2017_clubes (
  "id" BIGINT,
  "nome" VARCHAR,
  "abreviacao" VARCHAR,
  "slug" VARCHAR
);

N 2017 Partidas

@kaggle.schiller_cartolafc.n_2017_partidas
  • 13.57 KB
  • 200 rows
  • 12 columns
Loading...

CREATE TABLE n_2017_partidas (
  "rodada_id" BIGINT,
  "clube_casa_id" BIGINT,
  "clube_visitante_id" BIGINT,
  "clube_casa_posicao" BIGINT,
  "clube_visitante_posicao" BIGINT,
  "aproveitamento_mandante" VARCHAR,
  "aproveitamento_visitante" VARCHAR,
  "placar_oficial_mandante" DOUBLE,
  "placar_oficial_visitante" DOUBLE,
  "partida_data" TIMESTAMP,
  "local" VARCHAR,
  "valida" BOOLEAN
);

N 2017 Scouts

@kaggle.schiller_cartolafc.n_2017_scouts
  • 153.97 KB
  • 16313 rows
  • 28 columns
Loading...

CREATE TABLE n_2017_scouts (
  "atleta_id" BIGINT,
  "rodada_id" BIGINT,
  "clube_id" BIGINT,
  "posicao_id" BIGINT,
  "status_id" BIGINT,
  "pontos_num" DOUBLE,
  "preco_num" DOUBLE,
  "variacao_num" DOUBLE,
  "media_num" DOUBLE,
  "jogos_num" BIGINT,
  "fs" BIGINT,
  "pe" BIGINT,
  "a" BIGINT,
  "ft" BIGINT,
  "fd" BIGINT,
  "ff" BIGINT,
  "g" BIGINT,
  "i" BIGINT,
  "pp" BIGINT,
  "rb" BIGINT,
  "fc" BIGINT,
  "gc" BIGINT,
  "ca" BIGINT,
  "cv" BIGINT,
  "sg" BIGINT,
  "dd" BIGINT,
  "dp" BIGINT,
  "gs" BIGINT
);

Pontuacao

@kaggle.schiller_cartolafc.pontuacao
  • 3.12 KB
  • 18 rows
  • 3 columns
Loading...

CREATE TABLE pontuacao (
  "abreviacao" VARCHAR,
  "nome" VARCHAR,
  "pontuacao" DOUBLE
);

Posicoes

@kaggle.schiller_cartolafc.posicoes
  • 2.69 KB
  • 6 rows
  • 3 columns
Loading...

CREATE TABLE posicoes (
  "id" BIGINT,
  "nome" VARCHAR,
  "abreviacao" VARCHAR
);

Status

@kaggle.schiller_cartolafc.status
  • 2.09 KB
  • 5 rows
  • 2 columns
Loading...

CREATE TABLE status (
  "id" BIGINT,
  "nome" VARCHAR
);

Share link

Anyone who has the link will be able to view this.