CartolaFC
Data from the popular Brazilian Fantasy Football (2014 to 2017) ⚽️
@kaggle.schiller_cartolafc
Data from the popular Brazilian Fantasy Football (2014 to 2017) ⚽️
@kaggle.schiller_cartolafc
CREATE TABLE n_2014_atletas (
"id" BIGINT,
"apelido" VARCHAR,
"clube_id" BIGINT,
"posicao_id" BIGINT
);
CREATE TABLE n_2014_clubes (
"id" BIGINT,
"nome" VARCHAR,
"abreviacao" VARCHAR,
"slug" VARCHAR
);
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
);
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
);
CREATE TABLE n_2015_atletas (
"id" BIGINT,
"apelido" VARCHAR,
"clube_id" DOUBLE,
"posicao_id" BIGINT
);
CREATE TABLE n_2015_clubes (
"id" BIGINT,
"nome" VARCHAR,
"abreviacao" VARCHAR,
"slug" VARCHAR
);
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
);
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
);
CREATE TABLE n_2016_atletas (
"id" BIGINT,
"apelido" VARCHAR,
"clube_id" BIGINT,
"posicao_id" BIGINT
);
CREATE TABLE n_2016_clubes (
"id" BIGINT,
"nome" VARCHAR,
"abreviacao" VARCHAR,
"slug" VARCHAR
);
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
);
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
);
CREATE TABLE n_2017_atletas (
"atleta_id" BIGINT,
"nome" VARCHAR,
"apelido" VARCHAR
);
CREATE TABLE n_2017_clubes (
"id" BIGINT,
"nome" VARCHAR,
"abreviacao" VARCHAR,
"slug" VARCHAR
);
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
);
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
);
CREATE TABLE pontuacao (
"abreviacao" VARCHAR,
"nome" VARCHAR,
"pontuacao" DOUBLE
);
CREATE TABLE posicoes (
"id" BIGINT,
"nome" VARCHAR,
"abreviacao" VARCHAR
);
CREATE TABLE status (
"id" BIGINT,
"nome" VARCHAR
);
Anyone who has the link will be able to view this.