Major League Baseball Game Logs
Historical MLB Game Logs and Player Statistics from 1871-2016
@kaggle.thedevastator_major_league_baseball_game_logs
Historical MLB Game Logs and Player Statistics from 1871-2016
@kaggle.thedevastator_major_league_baseball_game_logs
CREATE TABLE game_logs (
"index" BIGINT,
"date" BIGINT,
"number_of_game" BIGINT,
"day_of_week" VARCHAR,
"v_name" VARCHAR,
"v_league" VARCHAR,
"v_game_number" BIGINT,
"h_name" VARCHAR,
"h_league" VARCHAR,
"h_game_number" BIGINT,
"v_score" BIGINT,
"h_score" BIGINT,
"length_outs" DOUBLE,
"day_night" VARCHAR,
"completion" VARCHAR,
"forefeit" VARCHAR,
"protest" VARCHAR,
"park_id" VARCHAR,
"attendance" DOUBLE,
"length_minutes" DOUBLE,
"v_line_score" VARCHAR,
"h_line_score" VARCHAR,
"v_at_bats" DOUBLE,
"v_hits" DOUBLE,
"v_doubles" DOUBLE,
"v_triples" DOUBLE,
"v_homeruns" DOUBLE,
"v_rbi" DOUBLE,
"v_sacrifice_hits" DOUBLE,
"v_sacrifice_flies" DOUBLE,
"v_hit_by_pitch" DOUBLE,
"v_walks" DOUBLE,
"v_intentional_walks" DOUBLE,
"v_strikeouts" DOUBLE,
"v_stolen_bases" DOUBLE,
"v_caught_stealing" DOUBLE,
"v_grounded_into_double" DOUBLE,
"v_first_catcher_interference" DOUBLE,
"v_left_on_base" DOUBLE,
"v_pitchers_used" DOUBLE,
"v_individual_earned_runs" DOUBLE,
"v_team_earned_runs" DOUBLE,
"v_wild_pitches" DOUBLE,
"v_balks" DOUBLE,
"v_putouts" DOUBLE,
"v_assists" DOUBLE,
"v_errors" DOUBLE,
"v_passed_balls" DOUBLE,
"v_double_plays" DOUBLE,
"v_triple_plays" DOUBLE,
"h_at_bats" DOUBLE,
"h_hits" DOUBLE,
"h_doubles" DOUBLE,
"h_triples" DOUBLE,
"h_homeruns" DOUBLE,
"h_rbi" DOUBLE,
"h_sacrifice_hits" DOUBLE,
"h_sacrifice_flies" DOUBLE,
"h_hit_by_pitch" DOUBLE,
"h_walks" DOUBLE,
"h_intentional_walks" DOUBLE,
"h_strikeouts" DOUBLE,
"h_stolen_bases" DOUBLE,
"h_caught_stealing" DOUBLE,
"h_grounded_into_double" DOUBLE,
"h_first_catcher_interference" DOUBLE,
"h_left_on_base" DOUBLE,
"h_pitchers_used" DOUBLE,
"h_individual_earned_runs" DOUBLE,
"h_team_earned_runs" DOUBLE,
"h_wild_pitches" DOUBLE,
"h_balks" DOUBLE,
"h_putouts" DOUBLE,
"h_assists" DOUBLE,
"h_errors" DOUBLE,
"h_passed_balls" DOUBLE,
"h_double_plays" DOUBLE,
"h_triple_plays" DOUBLE,
"hp_umpire_id" VARCHAR,
"hp_umpire_name" VARCHAR,
"n_1b_umpire_id" VARCHAR,
"n_1b_umpire_name" VARCHAR,
"n_2b_umpire_id" VARCHAR,
"n_2b_umpire_name" VARCHAR,
"n_3b_umpire_id" VARCHAR,
"n_3b_umpire_name" VARCHAR,
"lf_umpire_id" VARCHAR,
"lf_umpire_name" VARCHAR,
"rf_umpire_id" VARCHAR,
"rf_umpire_name" VARCHAR,
"v_manager_id" VARCHAR,
"v_manager_name" VARCHAR,
"h_manager_id" VARCHAR,
"h_manager_name" VARCHAR,
"winning_pitcher_id" VARCHAR,
"winning_pitcher_name" VARCHAR,
"losing_pitcher_id" VARCHAR,
"losing_pitcher_name" VARCHAR,
"saving_pitcher_id" VARCHAR,
"saving_pitcher_name" VARCHAR
);
Anyone who has the link will be able to view this.