Club Soccer: SPI Ratings And Forecasts
Club Soccer Dataset - SPI Ratings, Forecasts, Technical Information
@kaggle.thedevastator_club_soccer_predictions_spi_ratings_and_forecast
Club Soccer Dataset - SPI Ratings, Forecasts, Technical Information
@kaggle.thedevastator_club_soccer_predictions_spi_ratings_and_forecast
CREATE TABLE spi_global_rankings (
"index" BIGINT,
"rank" BIGINT,
"prev_rank" BIGINT,
"name" VARCHAR,
"league" VARCHAR,
"off" DOUBLE,
"def" DOUBLE,
"spi" DOUBLE
);
CREATE TABLE spi_global_rankings_intl (
"index" BIGINT,
"rank" BIGINT,
"name" VARCHAR,
"confed" VARCHAR,
"off" DOUBLE,
"def" DOUBLE,
"spi" DOUBLE
);
CREATE TABLE spi_matches (
"index" BIGINT,
"season" BIGINT,
"date" TIMESTAMP,
"league_id" BIGINT,
"league" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"spi1" DOUBLE,
"spi2" DOUBLE,
"prob1" DOUBLE,
"prob2" DOUBLE,
"probtie" DOUBLE,
"proj_score1" DOUBLE,
"proj_score2" DOUBLE,
"importance1" DOUBLE,
"importance2" DOUBLE,
"score1" DOUBLE,
"score2" DOUBLE,
"xg1" DOUBLE,
"xg2" DOUBLE,
"nsxg1" DOUBLE,
"nsxg2" DOUBLE,
"adj_score1" DOUBLE,
"adj_score2" DOUBLE
);
CREATE TABLE spi_matches_latest (
"index" BIGINT,
"season" BIGINT,
"date" TIMESTAMP,
"league_id" BIGINT,
"league" VARCHAR,
"team1" VARCHAR,
"team2" VARCHAR,
"spi1" DOUBLE,
"spi2" DOUBLE,
"prob1" DOUBLE,
"prob2" DOUBLE,
"probtie" DOUBLE,
"proj_score1" DOUBLE,
"proj_score2" DOUBLE,
"importance1" DOUBLE,
"importance2" DOUBLE,
"score1" DOUBLE,
"score2" DOUBLE,
"xg1" DOUBLE,
"xg2" DOUBLE,
"nsxg1" DOUBLE,
"nsxg2" DOUBLE,
"adj_score1" DOUBLE,
"adj_score2" DOUBLE
);
Anyone who has the link will be able to view this.