NFL LEAGUE DATA

nfl_team NFL Team	w W	l L	t T	pct PCT	pf PF	pa PA	net_pts Net Pts	home Home	road Road	div Div	pct_59349c Pct	conf Conf	pct_1 Pct.1	non_conf Non-Conf	strk Strk	last_5 Last 5	year Year
Cleveland Browns	1	15		0.063	264	452	-188	1 - 7 - 0	0 - 8 - 0	0 - 6 - 0		1 - 11 - 0	0.083	0 - 4 - 0	1L	1 - 4 - 0	2016
San Francisco 49ers	2	14		0.125	309	480	-171	1 - 7 - 0	1 - 7 - 0	2 - 4 - 0	0.333	2 - 10 - 0	0.167	0 - 4 - 0	1L	1 - 4 - 0	2016
Chicago Bears	3	13		0.188	279	399	-120	3 - 5 - 0	0 - 8 - 0	2 - 4 - 0	0.333	3 - 9 - 0	0.25	0 - 4 - 0	4L	1 - 4 - 0	2016
Jacksonville Jaguars	3	13		0.188	318	400	-82	2 - 6 - 0	1 - 7 - 0	2 - 4 - 0	0.333	2 - 10 - 0	0.167	1 - 3 - 0	1L	1 - 4 - 0	2016
Los Angeles Rams	4	12		0.25	224	394	-170	1 - 7 - 0	3 - 5 - 0	2 - 4 - 0	0.333	3 - 9 - 0	0.25	1 - 3 - 0	7L	0 - 5 - 0	2016
Los Angeles Chargers	5	11		0.313	410	423	-13	3 - 5 - 0	2 - 6 - 0	1 - 5 - 0	0.167	4 - 8 - 0	0.333	1 - 3 - 0	5L	0 - 5 - 0	2016
New York Jets	5	11		0.313	275	409	-134	2 - 6 - 0	3 - 5 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	1 - 3 - 0	1W	2 - 3 - 0	2016
Carolina Panthers	6	10		0.375	369	402	-33	4 - 4 - 0	2 - 6 - 0	1 - 5 - 0	0.167	5 - 7 - 0	0.417	1 - 3 - 0	2L	2 - 3 - 0	2016
Cincinnati Bengals	6	9	1	0.406	325	315	10	4 - 3 - 1	2 - 6 - 0	3 - 3 - 0	0.5	5 - 7 - 0	0.417	1 - 2 - 1	1W	3 - 2 - 0	2016
Arizona Cardinals	7	8	1	0.469	418	362	56	4 - 3 - 1	3 - 5 - 0	4 - 1 - 1	0.75	6 - 5 - 1	0.542	1 - 3 - 0	2W	3 - 2 - 0	2016


CREATE TABLE nfl_league_2016 (
  "nfl_team" VARCHAR,
  "w" BIGINT,
  "l" BIGINT,
  "t" BIGINT,
  "pct" DOUBLE,
  "pf" BIGINT,
  "pa" BIGINT,
  "net_pts" BIGINT,
  "home" VARCHAR,
  "road" VARCHAR,
  "div" VARCHAR,
  "pct_59349c" DOUBLE,
  "conf" VARCHAR,
  "pct_1" DOUBLE,
  "non_conf" VARCHAR,
  "strk" VARCHAR,
  "last_5" VARCHAR,
  "year" BIGINT
);