Jogos 2019 A 2022 Campeonato Paulista Série A1
Tabelas com estatísticas, eventos e jogos do Campeonato Paulista da A1
@kaggle.tiagodatascience_campeonato_paulista_a1
Tabelas com estatísticas, eventos e jogos do Campeonato Paulista da A1
@kaggle.tiagodatascience_campeonato_paulista_a1
CREATE TABLE events_paulista (
"idevent" BIGINT,
"timeelapsed" BIGINT,
"idteam" BIGINT,
"strteam" VARCHAR,
"idplayer" BIGINT,
"strplayer" VARCHAR,
"tipo" VARCHAR,
"detail" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE jogos_paulista (
"idevent" BIGINT,
"dateevent" TIMESTAMP,
"eventcity" VARCHAR,
"eventstatus" VARCHAR,
"eventelapsed" BIGINT,
"eventleague" VARCHAR,
"eventround" VARCHAR,
"idhometeam" BIGINT,
"strhometeam" VARCHAR,
"logohometeam" VARCHAR,
"idawayteam" BIGINT,
"strawayteam" VARCHAR,
"logoawayteam" VARCHAR,
"inthomescore" BIGINT,
"intawayscore" BIGINT,
"inthomeht" BIGINT,
"intawayht" BIGINT,
"date" TIMESTAMP,
"hour" VARCHAR,
"idwinner" DOUBLE,
"winner" VARCHAR,
"winordraw" BOOLEAN,
"underover" DOUBLE,
"predgoalshome" DOUBLE,
"predgoalsaway" DOUBLE,
"advice" VARCHAR,
"formhome" BIGINT,
"formaway" BIGINT,
"atthome" BIGINT,
"attaway" BIGINT,
"defhome" BIGINT,
"defaway" BIGINT,
"poissonhome" BIGINT,
"poissonaway" BIGINT,
"h2hhome" BIGINT,
"h2haway" BIGINT,
"goalshome" BIGINT,
"goalsaway" BIGINT,
"totalhome" DOUBLE,
"totalaway" DOUBLE,
"homeodd" DOUBLE,
"drawodd" DOUBLE,
"awayodd" DOUBLE,
"over05" DOUBLE,
"over05ht" DOUBLE,
"under15" DOUBLE,
"under15ht" DOUBLE
);
CREATE TABLE stats_paulista (
"idevent" BIGINT,
"idteam" BIGINT,
"strteam" VARCHAR,
"ishome" BOOLEAN,
"shots_on_goal" DOUBLE,
"shots_off_goal" DOUBLE,
"total_shots" DOUBLE,
"blocked_shots" DOUBLE,
"shots_insidebox" DOUBLE,
"shots_outsidebox" DOUBLE,
"fouls" DOUBLE,
"corner_kicks" DOUBLE,
"offsides" DOUBLE,
"ball_possession" VARCHAR,
"yellow_cards" DOUBLE,
"red_cards" DOUBLE,
"goalkeeper_saves" DOUBLE,
"total_passes" DOUBLE,
"passes_accurate" DOUBLE,
"passes" VARCHAR
);
Anyone who has the link will be able to view this.