MLB Game Data

pitchers Pitchers	ip IP	h H	r R	er ER	bb BB	k K	hr HR	pc_st PC-ST	era ERA	pc PC	game Game	team Team	extra Extra	pitcher_id Pitcher Id
A. Wainwright	6	6	3	3	3	3		96-59	4.5	96	360403123	STL	(L,0-1)	5403
S. Oh	1				2	2		27-12	0.0	27	360403123	STL	nan	34893
S. Maness	1	3	1	1				21-13	9.0	21	360403123	STL	nan	32639
TEAM	8	9	4	4	5	5		144-84	nan	144	360403123	STL	nan	-
F. Liriano	6	3			5	10		94-50	0.0	94	360403123	PIT	(W,1-0)	6211
T. Watson	1					2		11-7	0.0	11	360403123	PIT	(H,1)	31513
N. Feliz	1					1		11-9	0.0	11	360403123	PIT	(H,1)	30149
M. Melancon	1	2	1	1		1		25-15	9.0	25	360403123	PIT	nan	29446
TEAM	9	5	1	1	5	14		141-81	nan	141	360403123	PIT	nan	-
M. Stroman	8	6	3	3	1	5	1	98-74	3.38	98	360403130	TOR	(W,1-0)	32815


CREATE TABLE pitchersbygame (
  "pitchers" VARCHAR,
  "ip" DOUBLE,
  "h" BIGINT,
  "r" BIGINT,
  "er" BIGINT,
  "bb" BIGINT,
  "k" BIGINT,
  "hr" BIGINT,
  "pc_st" VARCHAR,
  "era" VARCHAR,
  "pc" VARCHAR,
  "game" BIGINT,
  "team" VARCHAR,
  "extra" VARCHAR,
  "pitcher_id" VARCHAR
);