MLB Game Data

game Game	team Team	batter_id Batter Id	batter Batter	event Event
360403123	STL	31015	M. Carpenter	1st: Carpenter grounded out to first.
360403123	STL	31015	M. Carpenter	3rd: Carpenter grounded into double play, shortstop to first, Wainwright out at second.
360403123	STL	31015	M. Carpenter	5th: Carpenter walked.
360403123	STL	31015	M. Carpenter	7th: Carpenter flied out to left.
360403123	STL	31015	M. Carpenter	9th: Carpenter singled to right, Molina scored, Wong to third.
360403123	STL	31208	T. Pham	1st: Pham grounded out to third.
360403123	STL	31359	M. Adams	4th: Adams struck out swinging.
360403123	STL	31359	M. Adams	5th: Adams grounded out to shortstop.
360403123	STL	31359	M. Adams	7th: Adams struck out swinging.
360403123	STL	31359	M. Adams	9th: Adams flied out to center.


CREATE TABLE plays (
  "game" BIGINT,
  "team" VARCHAR,
  "batter_id" VARCHAR,
  "batter" VARCHAR,
  "event" VARCHAR
);