MLB Game Data

game Game	team Team	stat Stat	data Data
360403123	STL	RBI	Carpenter (1)
360403123	STL	2Out RBI	Carpenter
360403123	STL	GIDP	Carpenter
360403123	STL	Team RISP	2-10 (Carpenter 1-2, Wong 0-2, Adams 0-1, Piscotty 0-1, Molina 1-1, Gyorko 0-2, Moss 0-1)
360403123	STL	Team LOB	10
360403123	PIT	2B	Polanco (1, Wainwright); Mercer (1, Maness)
360403123	PIT	3B	Cervelli (1, Wainwright)
360403123	PIT	RBI	Liriano (1), Jaso (1), Harrison (1), Mercer (1)
360403123	PIT	2Out RBI	Mercer
360403123	PIT	SF	Harrison


CREATE TABLE hittingnotes (
  "game" BIGINT,
  "team" VARCHAR,
  "stat" VARCHAR,
  "data" VARCHAR
);