MLB Game Data

game Game	pitching_team Pitching Team	batting_team Batting Team	inning Inning	event_id Event Id	events Events	away Away	home Home
360403123	PIT	STL	Top 1st		Liriano pitching for PIT	STL	PIT
360403123	PIT	STL	Top 1st	1	Carpenter grounded out to first.	0	0
360403123	PIT	STL	Top 1st	2	Pham grounded out to third.	0	0
360403123	PIT	STL	Top 1st	3	Holliday struck out looking.	0	0
360403123	STL	PIT	Bottom 1st	4	Wainwright pitching for STL	STL	PIT
360403123	STL	PIT	Bottom 1st	5	Jaso grounded out to second.	0	0
360403123	STL	PIT	Bottom 1st	6	McCutchen hit by pitch.	0	0
360403123	STL	PIT	Bottom 1st	7	Freese singled to center, McCutchen to third.	0	0
360403123	STL	PIT	Bottom 1st	8	Marte lined out to shortstop.	0	0
360403123	STL	PIT	Bottom 1st	9	Cervelli popped out to shortstop.	0	0


CREATE TABLE events (
  "game" BIGINT,
  "pitching_team" VARCHAR,
  "batting_team" VARCHAR,
  "inning" VARCHAR,
  "event_id" BIGINT,
  "events" VARCHAR,
  "away" VARCHAR,
  "home" VARCHAR
);