NBA Enhanced Box Score And Standings (2012 - 2018)

gmdate GmDate	gmtime GmTime	seastyp SeasTyp	offlnm1 OffLNm1	offfnm1 OffFNm1	offlnm2 OffLNm2	offfnm2 OffFNm2	offlnm3 OffLNm3	offfnm3 OffFNm3	teamabbr TeamAbbr	teamconf TeamConf	teamdiv TeamDiv	teamloc TeamLoc	teamrslt TeamRslt	teammin TeamMin	teampts TeamPTS	teamast TeamAST	teamto TeamTO	teamstl TeamSTL	teamblk TeamBLK	teampf TeamPF	teamfga TeamFGA	teamfgm TeamFGM	teamfg TeamFG%	team2pa Team2PA	team2pm Team2PM	team2p Team2P%	team3pa Team3PA	team3pm Team3PM	team3p Team3P%	teamfta TeamFTA	teamftm TeamFTM	teamft TeamFT%	teamorb TeamORB	teamdrb TeamDRB	teamtrb TeamTRB	teampts1 TeamPTS1	teampts2 TeamPTS2	teampts3 TeamPTS3	teampts4 TeamPTS4	teamtreb TeamTREB%	teamasst TeamASST%	teamts TeamTS%	teamefg TeamEFG%	teamoreb TeamOREB%	teamdreb TeamDREB%	teamto_7b6bd9 TeamTO%	teamstl_6034de TeamSTL%	teamblk_d02235 TeamBLK%	teamblkr TeamBLKR	teampps TeamPPS	teamfic TeamFIC	teamfic40 TeamFIC40	teamortg TeamOrtg	teamdrtg TeamDrtg	teamediff TeamEDiff	teamplay TeamPlay%	teamar TeamAR	teamast_to TeamAST/TO	teamstl_to TeamSTL/TO	opptabbr OpptAbbr	opptconf OpptConf	opptdiv OpptDiv	opptloc OpptLoc	opptrslt OpptRslt	opptmin OpptMin	opptpts OpptPTS	opptast OpptAST	opptto OpptTO	opptstl OpptSTL	opptblk OpptBLK	opptpf OpptPF	opptfga OpptFGA	opptfgm OpptFGM	opptfg OpptFG%	oppt2pa Oppt2PA	oppt2pm Oppt2PM	oppt2p Oppt2P%	oppt3pa Oppt3PA	oppt3pm Oppt3PM	oppt3p Oppt3P%	opptfta OpptFTA	opptftm OpptFTM	opptft OpptFT%	opptorb OpptORB	opptdrb OpptDRB	oppttrb OpptTRB	opptpts1 OpptPTS1	opptpts2 OpptPTS2	opptpts3 OpptPTS3	opptpts4 OpptPTS4
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	08:00	Regular	Forte	Brian	Smith	Michael	McCutchen	Monty	BOS	East	Atlantic	Away	Loss	241	99	24	12	11	4	24	88	36	0.4091	56	28	0.5	32	8	0.25	25	19	0.76	9	37	46	19	19	33	28	47.9167	66.6667	0.5	0.4545	18	80.4348	10.8108	10.9692	3.9888	7.1429	1.125	75.375	62.5519	98.7227	101.7143	-2.9916	0.3956	17.7778	2	91.6667	CLE	East	Central	Home	Win	240	102	19	17	3	4	25	83	38	0.4578	61	33	0.541	22	5	0.2273	25	21	0.84	9	41	50	29	25	18	30
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	08:00	Regular	Forte	Brian	Smith	Michael	McCutchen	Monty	CLE	East	Central	Home	Win	240	102	19	17	3	4	25	83	38	0.4578	61	33	0.541	22	5	0.2273	25	21	0.84	9	41	50	29	25	18	30	52.0833	50	0.5426	0.488	19.5652	82	15.3153	2.9916	3.9888	6.5574	1.2289	66.625	55.5208	101.7143	98.7227	2.9916	0.4176	14.6154	1.1176	17.6471	BOS	East	Atlantic	Away	Loss	241	99	24	12	11	4	24	88	36	0.4091	56	28	0.5	32	8	0.25	25	19	0.76	9	37	46	19	19	33	28
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	10:30	Regular	Maddox	Tre	Garretson	Ron	Foster	Scott	HOU	West	Southwest	Away	Win	239	122	28	13	9	5	16	97	47	0.4845	56	32	0.5714	41	15	0.3659	19	13	0.6842	10	33	43	34	28	26	34	51.1905	59.5745	0.579	0.5619	22.2222	84.6154	10.9834	8.7795	4.8775	8.9286	1.2577	97.875	81.9038	119.0108	118.0353	0.9755	0.47	19.1309	2.1538	69.2308	GS	West	Pacific	Home	Loss	241	121	34	17	5	9	25	80	43	0.5375	50	27	0.54	30	16	0.5333	21	19	0.9048	6	35	41	35	36	30	20
Tue Oct 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	10:30	Regular	Maddox	Tre	Garretson	Ron	Foster	Scott	GS	West	Pacific	Home	Loss	241	121	34	17	5	9	25	80	43	0.5375	50	27	0.54	30	16	0.5333	21	19	0.9048	6	35	41	35	36	30	20	48.8095	79.0698	0.6779	0.6375	15.3846	77.7778	16.0015	4.8775	8.7795	18	1.5125	103.875	86.2033	118.0353	119.0108	-0.9755	0.4725	24.2442	2	29.4118	HOU	West	Southwest	Away	Win	239	122	28	13	9	5	16	97	47	0.4845	56	32	0.5714	41	15	0.3659	19	13	0.6842	10	33	43	34	28	26	34
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Davis	Marc	Boland	Matt	DeRosa	Joe	CHA	East	Southeast	Away	Loss	238	90	16	17	4	3	15	73	29	0.3973	43	20	0.4651	30	9	0.3	29	23	0.7931	3	44	47	27	18	25	20	50	55.1724	0.5247	0.4589	7.3171	83.0189	16.5434	4.0412	3.0309	6.9767	1.2329	58.875	49.4748	90.927	103.0506	-12.1236	0.3333	13.4725	0.9412	23.5294	DET	East	Central	Home	Win	239	102	24	9	14	3	21	96	41	0.4271	70	32	0.4571	26	9	0.3462	12	11	0.9167	9	38	47	29	27	26	20
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Davis	Marc	Boland	Matt	DeRosa	Joe	DET	East	Central	Home	Win	239	102	24	9	14	3	21	96	41	0.4271	70	32	0.4571	26	9	0.3462	12	11	0.9167	9	38	47	29	27	26	20	50	58.5366	0.5036	0.474	16.9811	92.6829	8.161	14.1442	3.0309	4.2857	1.0625	84.5	70.7113	103.0506	90.927	12.1236	0.4271	17.8731	2.6667	155.5556	CHA	East	Southeast	Away	Loss	238	90	16	17	4	3	15	73	29	0.3973	43	20	0.4651	30	9	0.3	29	23	0.7931	3	44	47	27	18	25	20
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Cutler	Kevin	Brothers	Tony	Collins	Derrick	BKN	East	Atlantic	Away	Loss	241	131	22	20	7	2	25	94	45	0.4787	64	33	0.5156	30	12	0.4	32	29	0.9063	11	32	43	30	33	35	33	47.7778	48.8889	0.606	0.5426	25	69.5652	15.6152	6.18	1.7657	3.125	1.3936	82	68.0498	115.6539	123.5996	-7.9457	0.4369	14.6588	1.1	35	IND	East	Central	Home	Win	240	140	29	14	12	9	25	102	53	0.5196	68	44	0.6471	34	9	0.2647	32	25	0.7813	14	33	47	29	36	41	34
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Cutler	Kevin	Brothers	Tony	Collins	Derrick	IND	East	Central	Home	Win	240	140	29	14	12	9	25	102	53	0.5196	68	44	0.6471	34	9	0.2647	32	25	0.7813	14	33	47	29	36	41	34	52.2222	54.717	0.603	0.5637	30.4348	75	10.7626	10.5942	7.9457	13.2353	1.3725	113.75	94.7917	123.5996	115.6539	7.9457	0.5196	18.2298	2.0714	85.7143	BKN	East	Atlantic	Away	Loss	241	131	22	20	7	2	25	94	45	0.4787	64	33	0.5156	30	12	0.4	32	29	0.9063	11	32	43	30	33	35	33
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Lane	Karl	Holtkamp	Lauren	Malloy	Ed	MIA	East	Southeast	Away	Loss	240	109	27	13	6	4	20	102	44	0.4314	72	36	0.5	30	8	0.2667	17	13	0.7647	11	33	44	37	18	23	31	46.3158	61.3636	0.4978	0.4706	21.5686	75	10.614	5.6486	3.7657	5.5556	1.0686	75.875	63.2292	102.6166	109.2067	-6.5901	0.4231	18.0626	2.0769	46.1538	ORL	East	Southeast	Home	Win	240	116	22	15	8	10	18	90	43	0.4778	69	35	0.5072	21	8	0.381	29	22	0.7586	11	40	51	32	26	30	28
Wed Oct 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	07:00	Regular	Lane	Karl	Holtkamp	Lauren	Malloy	Ed	ORL	East	Southeast	Home	Win	240	116	22	15	8	10	18	90	43	0.4778	69	35	0.5072	21	8	0.381	29	22	0.7586	11	40	51	32	26	30	28	53.6842	51.1628	0.5644	0.5222	25	78.4314	12.7378	7.5315	9.4144	14.4928	1.2889	94.625	78.8542	109.2067	102.6166	6.5901	0.4574	15.7413	1.4667	53.3333	MIA	East	Southeast	Away	Loss	240	109	27	13	6	4	20	102	44	0.4314	72	36	0.5	30	8	0.2667	17	13	0.7647	11	33	44	37	18	23	31


CREATE TABLE teamboxscore (
  "gmdate" TIMESTAMP,
  "gmtime" VARCHAR,
  "seastyp" VARCHAR,
  "offlnm1" VARCHAR,
  "offfnm1" VARCHAR,
  "offlnm2" VARCHAR,
  "offfnm2" VARCHAR,
  "offlnm3" VARCHAR,
  "offfnm3" VARCHAR,
  "teamabbr" VARCHAR,
  "teamconf" VARCHAR,
  "teamdiv" VARCHAR,
  "teamloc" VARCHAR,
  "teamrslt" VARCHAR,
  "teammin" BIGINT,
  "teamdayoff" BIGINT,
  "teampts" BIGINT,
  "teamast" BIGINT,
  "teamto" BIGINT,
  "teamstl" BIGINT,
  "teamblk" BIGINT,
  "teampf" BIGINT,
  "teamfga" BIGINT,
  "teamfgm" BIGINT,
  "teamfg" DOUBLE,
  "team2pa" BIGINT,
  "team2pm" BIGINT,
  "team2p" DOUBLE,
  "team3pa" BIGINT,
  "team3pm" BIGINT,
  "team3p" DOUBLE,
  "teamfta" BIGINT,
  "teamftm" BIGINT,
  "teamft" DOUBLE,
  "teamorb" BIGINT,
  "teamdrb" BIGINT,
  "teamtrb" BIGINT,
  "teampts1" BIGINT,
  "teampts2" BIGINT,
  "teampts3" BIGINT,
  "teampts4" BIGINT,
  "teampts5" BIGINT,
  "teampts6" BIGINT,
  "teampts7" BIGINT,
  "teampts8" BIGINT,
  "teamtreb" DOUBLE,
  "teamasst" DOUBLE,
  "teamts" DOUBLE,
  "teamefg" DOUBLE,
  "teamoreb" DOUBLE,
  "teamdreb" DOUBLE,
  "teamto_7b6bd9" DOUBLE,
  "teamstl_6034de" DOUBLE,
  "teamblk_d02235" DOUBLE,
  "teamblkr" DOUBLE,
  "teampps" DOUBLE,
  "teamfic" DOUBLE,
  "teamfic40" DOUBLE,
  "teamortg" DOUBLE,
  "teamdrtg" DOUBLE,
  "teamediff" DOUBLE,
  "teamplay" DOUBLE,
  "teamar" DOUBLE,
  "teamast_to" DOUBLE,
  "teamstl_to" DOUBLE,
  "opptabbr" VARCHAR,
  "opptconf" VARCHAR,
  "opptdiv" VARCHAR,
  "opptloc" VARCHAR,
  "opptrslt" VARCHAR,
  "opptmin" BIGINT,
  "opptdayoff" BIGINT,
  "opptpts" BIGINT,
  "opptast" BIGINT,
  "opptto" BIGINT,
  "opptstl" BIGINT,
  "opptblk" BIGINT,
  "opptpf" BIGINT,
  "opptfga" BIGINT,
  "opptfgm" BIGINT,
  "opptfg" DOUBLE,
  "oppt2pa" BIGINT,
  "oppt2pm" BIGINT,
  "oppt2p" DOUBLE,
  "oppt3pa" BIGINT,
  "oppt3pm" BIGINT,
  "oppt3p" DOUBLE,
  "opptfta" BIGINT,
  "opptftm" BIGINT,
  "opptft" DOUBLE,
  "opptorb" BIGINT,
  "opptdrb" BIGINT,
  "oppttrb" BIGINT,
  "opptpts1" BIGINT,
  "opptpts2" BIGINT,
  "opptpts3" BIGINT,
  "opptpts4" BIGINT,
  "opptpts5" BIGINT,
  "opptpts6" BIGINT,
  "opptpts7" BIGINT
);