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
CREATE TABLE hitting_0307 (
"n_2b" BIGINT,
"n_3b" BIGINT,
"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_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
);
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
);
Anyone who has the link will be able to view this.