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
Detroit Lions		16			268	517	-249	0 - 8 - 0	0 - 8 - 0	0 - 6 - 0		0 - 12 - 0		0 - 4 - 0	16L	0 - 5 - 0	2008
Kansas City Chiefs	2	14		0.125	291	440	-149	1 - 7 - 0	1 - 7 - 0	2 - 4 - 0	0.333	2 - 10 - 0	0.167	0 - 4 - 0	4L	1 - 4 - 0	2008
Los Angeles Rams	2	14		0.125	232	465	-233	1 - 7 - 0	1 - 7 - 0	0 - 6 - 0		2 - 10 - 0	0.167	0 - 4 - 0	10L	0 - 5 - 0	2008
Cincinnati Bengals	4	11	1	0.281	204	364	-160	3 - 4 - 1	1 - 7 - 0	1 - 5 - 0	0.167	3 - 9 - 0	0.25	1 - 2 - 1	3W	3 - 2 - 0	2008
Cleveland Browns	4	12		0.25	232	350	-118	1 - 7 - 0	3 - 5 - 0	1 - 5 - 0	0.167	3 - 9 - 0	0.25	1 - 3 - 0	6L	0 - 5 - 0	2008
Seattle Seahawks	4	12		0.25	294	392	-98	2 - 6 - 0	2 - 6 - 0	3 - 3 - 0	0.5	3 - 9 - 0	0.25	1 - 3 - 0	1L	2 - 3 - 0	2008
Jacksonville Jaguars	5	11		0.313	302	367	-65	2 - 6 - 0	3 - 5 - 0	2 - 4 - 0	0.333	3 - 9 - 0	0.25	2 - 2 - 0	2L	1 - 4 - 0	2008
Las Vegas Raiders	5	11		0.313	263	388	-125	2 - 6 - 0	3 - 5 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	1 - 3 - 0	2W	2 - 3 - 0	2008
Green Bay Packers	6	10		0.375	419	380	39	4 - 4 - 0	2 - 6 - 0	4 - 2 - 0	0.667	5 - 7 - 0	0.417	1 - 3 - 0	1W	1 - 4 - 0	2008
Buffalo Bills	7	9		0.438	336	342	-6	3 - 5 - 0	4 - 4 - 0	0 - 6 - 0		5 - 7 - 0	0.417	2 - 2 - 0	1L	1 - 4 - 0	2008


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