MLB Game Data

hitters Hitters	h_ab H-AB	ab AB	r R	h H	rbi RBI	bb BB	k K	n__p #P	avg AVG	obp OBP	slg SLG	game Game	team Team	position Position	hitter_id Hitter Id
M. Carpenter	1-4	4	0	1	1	1	0	22	0.25	0.4	0.25	360403123	STL	3B	31015
T. Pham	0-1	1	0	0	0	0	0	1	0.0	0.0	0.0	360403123	STL	LF	31208
M. Adams	0-4	4	0	0	0	0	2	18	0.0	0.0	0.0	360403123	STL	1B	31359
M. Holliday	1-3	3	0	1	0	1	1	15	0.33299999999999996	0.5	0.33299999999999996	360403123	STL	1B-LF	5940
R. Grichuk	1-4	4	0	1	0	0	3	14	0.25	0.25	0.25	360403123	STL	CF	31399
S. Piscotty	0-3	3	0	0	0	1	2	18	0.0	0.25	0.0	360403123	STL	RF	32842
Y. Molina	2-3	3	1	2	0	1	1	13	0.667	0.75	0.667	360403123	STL	C	5986
K. Wong	0-3	3	0	0	0	0	2	14	0.0	0.25	0.0	360403123	STL	2B	32061
J. Gyorko	0-3	3	0	0	0	1	0	10	0.0	0.25	0.0	360403123	STL	SS	31402
A. Wainwright	0-2	2	0	0	0	0	1	6	0.0	0.0	0.0	360403123	STL	P	5403


CREATE TABLE hittersbygame (
  "hitters" VARCHAR,
  "h_ab" VARCHAR,
  "ab" VARCHAR,
  "r" VARCHAR,
  "h" VARCHAR,
  "rbi" VARCHAR,
  "bb" VARCHAR,
  "k" VARCHAR,
  "n__p" VARCHAR,
  "avg" VARCHAR,
  "obp" VARCHAR,
  "slg" VARCHAR,
  "game" BIGINT,
  "team" VARCHAR,
  "position" VARCHAR,
  "hitter_id" VARCHAR
);