MLB 2020
data scraped from the mlb.com on 2020 regular season
@kaggle.erichschulman_mlb_2020
data scraped from the mlb.com on 2020 regular season
@kaggle.erichschulman_mlb_2020
Data scraped from MLB about baseball stats from the 2020 season. There are 3 files, one with pitching data, one with hitting data, and one expanded file with in depth stats.
CREATE TABLE hitting_0307 (
"n_2b" BIGINT -- 2B,
"n_3b" BIGINT -- 3B,
"ab" BIGINT,
"avg" DOUBLE,
"bb" BIGINT,
"cs" BIGINT,
"g" BIGINT,
"h" BIGINT,
"hr" BIGINT,
"obp" DOUBLE,
"player" VARCHAR,
"r" BIGINT,
"rbi" BIGINT,
"sb" BIGINT,
"slg" DOUBLE,
"so" BIGINT,
"team" VARCHAR,
"caret_upcaret_downops" DOUBLE
);CREATE TABLE pitching_0307 (
"avg" DOUBLE,
"bb" BIGINT,
"cg" BIGINT,
"er" BIGINT,
"g" BIGINT,
"gs" BIGINT,
"h" BIGINT,
"hb" BIGINT,
"hr" BIGINT,
"ip" DOUBLE,
"l" BIGINT,
"player" VARCHAR,
"r" BIGINT,
"sho" BIGINT,
"so" BIGINT,
"sv" BIGINT,
"svo" BIGINT,
"team" VARCHAR,
"w" BIGINT,
"whip" DOUBLE,
"caret_upcaret_downera" DOUBLE
);CREATE TABLE pitching_0307_expanded (
"babip" VARCHAR,
"bb_9" DOUBLE,
"bk" BIGINT,
"cs" BIGINT,
"gdp" BIGINT,
"gf" BIGINT,
"go_ao" VARCHAR,
"hld" BIGINT,
"ibb" BIGINT,
"k_bb" VARCHAR,
"np" BIGINT,
"p_ip" DOUBLE,
"pk" BIGINT,
"player" VARCHAR,
"qs" BIGINT,
"sb" BIGINT,
"so_9" DOUBLE,
"tbf" BIGINT,
"team" VARCHAR,
"wp" BIGINT
);Anyone who has the link will be able to view this.