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
Arizona Cardinals	3	13	0.188	225	425	-200	1 - 7 - 0	2 - 6 - 0	2 - 4 - 0	0.333	3 - 9 - 0	0.25	0 - 4 - 0	4L	1 - 4 - 0	2018
Las Vegas Raiders	4	12	0.25	290	467	-177	3 - 5 - 0	1 - 7 - 0	1 - 5 - 0	0.167	3 - 9 - 0	0.25	1 - 3 - 0	1L	2 - 3 - 0	2018
New York Jets	4	12	0.25	333	441	-108	2 - 6 - 0	2 - 6 - 0	1 - 5 - 0	0.167	3 - 9 - 0	0.25	1 - 3 - 0	3L	1 - 4 - 0	2018
San Francisco 49ers	4	12	0.25	342	435	-93	4 - 4 - 0	0 - 8 - 0	1 - 5 - 0	0.167	2 - 10 - 0	0.167	2 - 2 - 0	2L	2 - 3 - 0	2018
Jacksonville Jaguars	5	11	0.313	245	316	-71	3 - 5 - 0	2 - 6 - 0	1 - 5 - 0	0.167	4 - 8 - 0	0.333	1 - 3 - 0	1L	2 - 3 - 0	2018
New York Giants	5	11	0.313	369	412	-43	2 - 6 - 0	3 - 5 - 0	1 - 5 - 0	0.167	4 - 8 - 0	0.333	1 - 3 - 0	3L	2 - 3 - 0	2018
Tampa Bay Buccaneers	5	11	0.313	396	464	-68	4 - 4 - 0	1 - 7 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	1 - 3 - 0	4L	1 - 4 - 0	2018
Buffalo Bills	6	10	0.375	269	374	-105	4 - 4 - 0	2 - 6 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	2 - 2 - 0	1W	2 - 3 - 0	2018
Cincinnati Bengals	6	10	0.375	368	455	-87	4 - 4 - 0	2 - 6 - 0	1 - 5 - 0	0.167	4 - 8 - 0	0.333	2 - 2 - 0	2L	1 - 4 - 0	2018
Denver Broncos	6	10	0.375	329	349	-20	3 - 5 - 0	3 - 5 - 0	2 - 4 - 0	0.333	4 - 8 - 0	0.333	2 - 2 - 0	4L	1 - 4 - 0	2018


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