NFL LEAGUE DATA

nfl_team NFL Team	w W	l L	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
Jacksonville Jaguars	2	14	0.125	255	444	-189	1 - 7 - 0	1 - 7 - 0	2 - 4 - 0	0.333	2 - 10 - 0	0.167	0 - 4 - 0	5L	0 - 5 - 0	2012
Kansas City Chiefs	2	14	0.125	211	425	-214	1 - 7 - 0	1 - 7 - 0	0 - 6 - 0		0 - 12 - 0		2 - 2 - 0	4L	1 - 4 - 0	2012
Detroit Lions	4	12	0.25	372	437	-65	2 - 6 - 0	2 - 6 - 0	0 - 6 - 0		3 - 9 - 0	0.25	1 - 3 - 0	8L	0 - 5 - 0	2012
Las Vegas Raiders	4	12	0.25	290	443	-153	3 - 5 - 0	1 - 7 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	0 - 4 - 0	2L	1 - 4 - 0	2012
Philadelphia Eagles	4	12	0.25	280	444	-164	2 - 6 - 0	2 - 6 - 0	1 - 5 - 0	0.167	2 - 10 - 0	0.167	2 - 2 - 0	3L	1 - 4 - 0	2012
Arizona Cardinals	5	11	0.313	250	357	-107	4 - 4 - 0	1 - 7 - 0	1 - 5 - 0	0.167	3 - 9 - 0	0.25	2 - 2 - 0	2L	1 - 4 - 0	2012
Cleveland Browns	5	11	0.313	302	368	-66	4 - 4 - 0	1 - 7 - 0	2 - 4 - 0	0.333	5 - 7 - 0	0.417	0 - 4 - 0	3L	2 - 3 - 0	2012
Buffalo Bills	6	10	0.375	344	435	-91	4 - 4 - 0	2 - 6 - 0	2 - 4 - 0	0.333	5 - 7 - 0	0.417	1 - 3 - 0	1W	2 - 3 - 0	2012
New York Jets	6	10	0.375	281	375	-94	3 - 5 - 0	3 - 5 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	2 - 2 - 0	3L	2 - 3 - 0	2012
Tennessee Titans	6	10	0.375	330	471	-141	4 - 4 - 0	2 - 6 - 0	1 - 5 - 0	0.167	5 - 7 - 0	0.417	1 - 3 - 0	1W	2 - 3 - 0	2012


CREATE TABLE nfl_league_2012 (
  "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
);