Last 5 Season Serie A Matches And Statistics
Last 5 Season Serie A Matches And Statistics
@kaggle.sinansaglam_last_5_season_serie_a_matches_and_statistics
Last 5 Season Serie A Matches And Statistics
@kaggle.sinansaglam_last_5_season_serie_a_matches_and_statistics
In this dataset, there are the matches of the last 5 seasons in Serie A, the dates of the matches, the results, the referees, the team captains and detailed statistics about these matches. There is an indexing based on seasonal standings.
CREATE TABLE seriea_matches (
"unnamed_0" BIGINT -- Unnamed: 0,
"date" TIMESTAMP,
"time" VARCHAR,
"comp" VARCHAR,
"round" VARCHAR,
"day" VARCHAR,
"venue" VARCHAR,
"result" VARCHAR,
"gf" DOUBLE,
"ga" DOUBLE,
"opponent" VARCHAR,
"xg" DOUBLE,
"xga" DOUBLE,
"poss_x" DOUBLE,
"attendance" DOUBLE,
"captain" VARCHAR,
"formation" VARCHAR,
"referee" VARCHAR,
"sh" DOUBLE,
"sot" DOUBLE,
"dist" DOUBLE,
"fk" DOUBLE,
"pk" BIGINT,
"pkatt" BIGINT,
"poss_y" DOUBLE,
"touches" DOUBLE,
"def_pen" DOUBLE,
"def_3rd" DOUBLE,
"mid_3rd" DOUBLE,
"att_3rd" DOUBLE,
"att_pen" DOUBLE,
"live" DOUBLE,
"succ" DOUBLE,
"att" DOUBLE,
"succ_c8ffb4" DOUBLE -- Succ%,
"n__pl" DOUBLE -- #pl,
"megs" DOUBLE,
"carries" DOUBLE,
"totdist" DOUBLE,
"prgdist" DOUBLE,
"prog" DOUBLE,
"prog_1" DOUBLE,
"n_1_3" DOUBLE -- 1/3,
"cpa" DOUBLE,
"mis" DOUBLE,
"dis" DOUBLE,
"targ" DOUBLE,
"rec" DOUBLE,
"rec_04e8c8" DOUBLE -- Rec%,
"team" VARCHAR
);
Anyone who has the link will be able to view this.