Dataset: CartolaFC

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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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

Posicoes

@kaggle.schiller_cartolafc.posicoes

2.69 KB
6 rows
3 columns


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

Status

@kaggle.schiller_cartolafc.status

2.09 KB
5 rows
2 columns


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