MLB Game Data

team Team	n_1 1	n_2 2	n_3 3	n_4 4	n_5 5	n_6 6	n_7 7	n_8 8	n_9 9	r R	h H	e E	game Game
STL						0	0	0	1	1	5		360403123
PIT		2				1	0	1	-	4	9	1	360403123
TOR	2			1		0	0	2	0	5	7	2	360403130
TB			1			0	0	0	2	3	7	1	360403130
NYM						0	0	3	0	3	7	1	360403107
KC	1			1		2	0	0	-	4	9		360403107
SF		2	2	1	2	0	0	5	0	12	15		360404108
MIL	1	1	1			0	0	0	0	3	8	1	360404108
MIN						0	2	0	0	2	7		360404101
BAL					2	0	0	0	1	3	10		360404101


CREATE TABLE inningscore (
  "team" VARCHAR,
  "n_1" BIGINT,
  "n_2" BIGINT,
  "n_3" BIGINT,
  "n_4" BIGINT,
  "n_5" BIGINT,
  "n_6" VARCHAR,
  "n_7" VARCHAR,
  "n_8" VARCHAR,
  "n_9" VARCHAR,
  "r" BIGINT,
  "h" BIGINT,
  "e" BIGINT,
  "game" BIGINT,
  "n_10" DOUBLE,
  "n_11" DOUBLE,
  "n_12" DOUBLE,
  "n_13" DOUBLE,
  "n_14" DOUBLE,
  "n_15" DOUBLE,
  "n_16" DOUBLE,
  "n_17" DOUBLE,
  "n_18" DOUBLE,
  "n_19" DOUBLE
);