Query · 2 views

Top 160 ADP Seasons 2018-2020

I want a full database of all the fantasy football players drafted in the top 160 ADP in the years 2020, 2019, 2018 (since you can only provide 500 rows per query, provide as many full seasons as you can then I will repeat for older years). I want to know what their ADP was, how they finished on a PPR scoring (per game) basis across QB, RB, WR, TE. I also want to know their position, team, age, career year. I would like it in a csv or excel format. I would also like counting stats (yards, receptions, attempts, TDs).

#
1	2020	Ezekiel Elliott	DAL	RB	1.3	25	5	15	14.91	13	223.7	0	979	338	52	0	244	71	8
2	2020	Alvin Kamara	NO	RB	2	25	4	15	25.19	1	377.8	0	932	756	83	0	187	107	21
3	2020	Derrick Henry	TEN	RB	3	26	5	16	20.82	3	333.1	0	2,027	114	19	0	378	31	17
4	2020	Dalvin Cook	MIN	RB	4	25	4	14	24.13	2	337.8	0	1,557	361	44	0	312	54	17
5	2020	Saquon Barkley	NYG	RB	5	23	3	2	7.7	38	15.4	0	34	60	6	0	19	9	0
6	2020	Tyreek Hill	KC	WR	6	26	5	15	21.93	2	328.9	0	123	1,276	87	0	13	135	17
7	2020	DeAndre Hopkins	ARI	WR	7	28	8	16	17.99	5	287.8	0	1	1,407	115	0	1	160	6
8	2020	Josh Jacobs	LV	RB	8	22	2	15	15.42	11	231.3	0	1,065	238	33	0	273	45	12
9	2020	Patrick Mahomes	KC	QB	9	24	4	15	24.96	2	374.4	4,740	308	0	0	588	62	2	40
10	2020	Nick Chubb	CLE	RB	10	24	3	12	17.31	6	207.7	0	1,067	150	16	0	190	18	12
11	2020	Travis Kelce	KC	TE	11	30	8	15	20.85	1	312.76	4	0	1,416	105	2	0	145	11
12	2020	Davante Adams	GB	WR	12	27	7	14	25.6	1	358.4	0	0	1,374	115	0	0	149	18
13	2020	Mike Evans	TB	WR	13	27	7	16	15.54	13	248.6	0	0	1,006	70	0	0	109	13
14	2020	Lamar Jackson	BAL	QB	14	23	3	15	22.19	8	332.78	2,757	1,005	0	0	376	159	0	33
15	2020	Aaron Jones	GB	RB	15	25	4	14	18.49	4	258.9	0	1,104	355	47	0	201	63	11
16	2020	Austin Ekeler	LAC	RB	16	25	4	10	16.53	9	165.3	0	530	403	54	0	116	65	3
17	2020	Russell Wilson	SEA	QB	17	31	9	16	22.49	7	359.78	4,212	513	0	0	558	83	0	42
18	2020	Amari Cooper	DAL	WR	18	26	6	16	14.8	16	236.8	0	14	1,114	92	0	6	130	5
19	2020	JuJu Smith-Schuster	PIT	WR	19	23	4	16	14.63	18	234.1	0	0	831	97	0	0	128	9
20	2020	Adam Thielen	MIN	WR	20	30	8	15	16.93	9	254	0	15	925	74	0	3	108	14
21	2020	Joe Mixon	CIN	RB	21	24	4	6	16.6	8	99.6	0	428	138	21	0	119	26	4
22	2020	Allen Robinson	CHI	WR	22	27	7	16	16.43	11	262.9	0	-1	1,250	102	0	1	151	6
23	2020	Todd Gurley	ATL	RB	23	26		15	10.88	25	163.2	0	678	164	25	0	195	34	9
24	2020	Odell Beckham	CLE	WR	24	27	7	7	12.4	26	86.82	18	72	319	23	1	3	43	4
25	2020	James Conner	PIT	RB	25	25	4	13	12.66	21	164.6	0	721	215	35	0	169	43	6
26	2020	DJ Moore	CAR	WR	26	23	3	15	14.1	22	211.5	0	22	1,193	66	1	2	118	4
27	2020	Mark Andrews	BAL	TE	27	24	3	14	12.15	4	170.1	0	0	701	58	0	0	88	7
28	2020	Zach Ertz	PHI	TE	28	29	8	11	7.05	17	77.5	0	0	335	36	0	0	72	1
29	2020	Le'Veon Bell	KC	RB	29	28		11	6.78	41	74.6	0	328	138	16	0	82	20	2
30	2020	George Kittle	SF	TE	30	26	4	8	15.64	3	125.1	0	17	634	48	0	2	63	2
31	2020	David Johnson	HOU	RB	31	28		12	14.96	12	179.5	0	691	314	33	0	147	46	8
32	2020	Tyler Lockett	SEA	WR	32	27	6	16	16.59	10	265.4	0	0	1,054	100	0	0	132	10
33	2020	Kenyan Drake	ARI	RB	33	26	5	15	12.81	20	192.2	0	955	137	25	0	239	31	10
34	2020	Michael Thomas	NO	WR	34	27	5	7	11.99	27	83.9	0	1	438	40	0	1	55	0
35	2020	Miles Sanders	PHI	RB	35	23	2	12	14.2	16	170.4	0	867	197	28	0	164	52	6
36	2020	DK Metcalf	SEA	WR	36	22	2	16	16.96	8	271.3	0	0	1,303	83	0	0	129	10
37	2020	Calvin Ridley	ATL	WR	37	25	3	15	18.77	4	281.5	0	1	1,374	90	0	5	143	9
38	2020	Chris Carson	SEA	RB	38	25		12	15.65	10	187.8	0	681	287	37	0	141	46	9
39	2020	Kyler Murray	ARI	QB	39	23	2	16	23.67	5	378.74	3,971	819	0	0	558	133	0	37
40	2020	Robert Woods	LAR	WR	40	28	8	16	15.32	15	245.1	0	155	936	90	0	24	129	8
41	2020	Deshaun Watson	HOU	QB	41	24	4	16	23.08	6	369.32	4,823	444	0	0	544	90	0	36
42	2020	Chris Godwin	TB	WR	42	24	4	12	15.92	12	191	0	0	840	65	0	0	84	7
43	2020	Melvin Gordon	DEN	RB	43	27	6	15	13.23	19	198.4	0	986	158	32	0	215	44	10
44	2020	Darren Waller	LV	TE	44	27	6	16	17.41	2	278.6	0	0	1,196	107	0	0	146	9
45	2020	Stefon Diggs	BUF	WR	45	26	6	16	20.54	3	328.6	0	1	1,535	127	0	1	166	8
46	2020	Jonathan Taylor	IND	RB	46	21	1	15	16.85	7	252.8	0	1,169	299	36	0	232	39	12
47	2020	Dak Prescott	DAL	QB	47	27	5	5	27.13	1	135.64	1,856	93	11	1	222	18	1	13
48	2020	Evan Engram	NYG	TE	48	25	4	16	8.81	13	141	0	26	654	63	0	6	109	2
49	2020	Leonard Fournette	TB	RB	49	25	4	13	10.15	27	132	0	367	233	36	0	97	47	6
50	2020	Kareem Hunt	CLE	RB	50	25	4	16	13.66	17	218.5	0	841	304	38	0	198	51	11
51	2020	A.J. Brown	TEN	WR	51	23	2	14	17.68	6	247.5	0	0	1,075	70	0	0	106	11
52	2020	T.Y. Hilton	IND	WR	52	30		15	10.95	31	164.2	0	0	762	56	0	0	93	5
53	2020	Rob Gronkowski	TB	TE	53	31		16	9.33	11	149.3	0	0	623	45	0	0	77	7
54	2020	Devin Singletary	BUF	RB	54	22	2	16	8.98	29	143.6	0	687	269	38	0	156	50	2
55	2020	Drew Brees	NO	QB	55	41		12	17.46	13	209.48	2,942	-2	0	0	390	18	0	26
56	2020	David Montgomery	CHI	RB	56	23	2	15	17.65	5	264.8	0	1,070	438	54	0	247	68	10
57	2020	Aaron Rodgers	GB	QB	57	36	16	16	23.95	4	383.26	4,299	149	-6	1	526	38	1	51
58	2020	DJ Chark	JAX	WR	58	23	3	13	11.82	28	153.6	0	0	706	53	0	0	93	5
59	2020	A.J. Green	CIN	WR	59	32		16	6.96	49	111.3	0	0	523	47	0	0	104	2
60	2020	Courtland Sutton	DEN	WR	60	24	3	1	9.6	37	9.6	0	0	66	3	0	0	6	0
61	2020	Tom Brady	TB	QB	61	43		16	21.12	10	337.92	4,633	6	0	0	610	30	0	43
62	2020	Raheem Mostert	SF	RB	62	28	6	8	12.46	22	99.7	0	521	156	16	0	104	19	3
63	2020	Marquise Brown	BAL	WR	63	23	2	16	11.44	30	183	0	1	769	58	0	1	100	8
64	2020	Julian Edelman	NE	WR	64	34		6	9.37	38	56.22	38	22	315	21	2	2	39	0
65	2020	Michael Gallup	DAL	WR	65	24	3	16	10.83	32	173.3	0	0	843	59	0	0	105	5
66	2020	Matt Ryan	ATL	QB	67	35		16	17.65	12	282.44	4,581	92	0	0	626	29	0	28
67	2020	Brandin Cooks	HOU	WR	69	26	7	15	15.47	14	232	0	0	1,150	81	0	0	119	6
68	2020	Josh Allen	BUF	QB	70	24	3	16	24.75	3	396.06	4,544	421	12	1	572	102	1	46
69	2020	CeeDee Lamb	DAL	WR	71	21	1	16	13.61	24	217.7	0	82	935	74	0	10	111	6
70	2020	Hayden Hurst	ATL	TE	73	27	3	16	9.32	12	149.1	0	0	571	56	0	0	88	6
71	2020	Ronald Jones	TB	RB	74	23		14	13.31	18	186.3	0	978	165	28	0	192	42	8
72	2020	D'Andre Swift	DET	RB	75	21	1	13	14.6	14	189.8	0	521	357	46	0	114	57	10
73	2020	James White	NE	RB	76	28		14	8.33	34	116.6	0	121	375	49	0	35	62	3
74	2020	J.K. Dobbins	BAL	RB	77	21	1	15	11.23	24	168.5	0	805	120	18	0	134	24	9
75	2020	Marlon Mack	IND	RB	79	24	4	1	8.6	31	8.6	0	26	30	3	0	4	3	0
76	2020	Jared Cook	NO	TE	80	33		15	8.49	16	127.4	0	0	504	37	0	0	60	7
77	2020	Tyler Higbee	LAR	TE	81	27	5	15	8.55	15	128.2	0	1	521	44	0	1	60	5
78	2020	Tarik Cohen	CHI	RB	84	25	4	3	5.83	44	17.5	0	74	41	6	0	14	9	0
79	2020	Marvin Jones	DET	WR	85	30	9	16	14.24	20	227.8	0	0	978	76	0	0	115	9
80	2020	Antonio Gibson	WAS	RB	86	22	1	14	14.44	15	202.2	0	795	247	36	0	170	44	11
81	2020	Carson Wentz	PHI	QB	87	27	5	12	16.53	16	198.4	2,620	276	0	0	437	52	0	21
82	2020	Phillip Lindsay	DEN	RB	88	26		11	6	42	66	0	502	28	7	0	118	14	1
83	2020	Henry Ruggs	LV	WR	89	21		13	6.47	51	84.1	0	49	452	26	0	9	43	2
84	2020	Jerry Jeudy	DEN	WR	90	21	1	16	9.85	35	157.6	0	0	856	52	0	0	113	3
85	2020	Jordan Howard	PHI	RB	91	25		7	4.39	47	30.7	0	60	-3	1	0	35	1	4
86	2020	Matt Breida	MIA	RB	92	25	4	12	3.5	49	42	0	254	96	9	0	59	10	0
87	2020	Emmanuel Sanders	NO	WR	93	33		14	11.77	29	164.8	0	12	726	61	0	1	82	5
88	2020	Cam Newton	NE	QB	95	31		15	17.4	14	260.98	2,657	592	35	2	368	137	2	21
89	2020	Latavius Murray	NO	RB	96	30	8	15	9.08	28	136.2	0	656	176	23	0	146	26	5
90	2020	Noah Fant	DEN	TE	97	22	2	15	9.95	8	149.3	0	0	673	62	0	0	93	3
91	2020	Diontae Johnson	PIT	WR	98	24	2	15	14.79	17	221.8	0	15	923	88	0	3	144	7
92	2020	Kerryon Johnson	DET	RB	99	23		16	4.49	46	71.8	0	181	187	19	0	52	26	3
93	2020	Austin Hooper	CLE	TE	101	25	5	13	8.73	14	113.5	0	0	435	46	0	0	70	4
94	2020	Zack Moss	BUF	RB	102	22	1	13	7.82	36	101.6	0	481	95	14	0	112	18	5
95	2020	Tevin Coleman	SF	RB	103	27		8	1.59	51	12.7	0	53	34	4	0	28	5	0
96	2020	Mecole Hardman	KC	WR	105	22	2	16	8.01	44	128.1	0	31	560	41	0	4	62	4
97	2020	Christian Kirk	ARI	WR	106	23	3	14	10.46	33	146.4	0	3	621	48	0	2	79	6
98	2020	Matthew Stafford	DET	QB	107	32	12	16	16.29	17	260.56	4,084	112	0	0	528	29	1	26
99	2020	Jamison Crowder	NYJ	WR	108	27	6	12	14.34	19	172.02	43	14	699	59	1	1	89	7
100	2020	Sony Michel	NE	RB	109	25		9	8.37	33	75.3	0	449	114	7	0	79	9	2
101	2020	Sterling Shepard	NYG	WR	110	27	5	12	13.54	25	162.5	0	49	656	66	0	6	90	4
102	2020	Joe Burrow	CIN	QB	111	23	1	10	17.37	15	173.72	2,688	142	0	0	404	37	0	16
103	2020	Darius Slayton	NYG	WR	112	23	2	16	8.81	41	141	0	-1	751	50	0	2	96	3
104	2020	Justin Jefferson	MIN	WR	115	21	1	16	17.14	7	274.2	0	2	1,400	88	0	1	125	7
105	2020	T.J. Hockenson	DET	TE	117	23	2	16	10.96	5	175.3	0	0	723	67	0	1	101	6
106	2020	Chase Edmonds	ARI	RB	118	24	3	16	10.5	26	168	0	448	402	53	0	97	67	5
107	2020	Mike Gesicki	MIA	TE	120	24	3	15	10.62	6	159.3	0	0	703	53	0	0	85	6
108	2020	DeSean Jackson	PHI	WR	122	33		5	8.96	40	44.8	0	12	236	14	0	1	26	1
109	2020	Ben Roethlisberger	PIT	QB	123	38		15	17.81	11	267.22	3,803	11	0	0	608	25	0	33
110	2020	Tony Pollard	DAL	RB	124	23	2	16	7.54	39	120.7	0	435	192	28	0	101	40	5
111	2020	Sammy Watkins	KC	WR	125	27		10	8.74	42	87.4	0	3	421	37	1	1	55	2
112	2020	Jalen Reagor	PHI	WR	126	21	1	11	7.93	45	87.2	0	26	396	31	0	4	54	1
113	2020	Darrell Henderson	LAR	RB	129	23	2	15	8.69	30	130.3	0	624	159	16	0	138	24	6
114	2020	Daniel Jones	NYG	QB	133	23	2	14	12.86	21	180.02	2,943	423	0	0	448	65	0	12
115	2020	Boston Scott	PHI	RB	135	25	3	16	5.98	43	95.6	0	374	212	25	0	80	36	2
116	2020	Anthony Miller	CHI	WR	136	25	3	16	6.79	50	108.7	0	12	485	49	0	2	76	2
117	2020	AJ Dillon	GB	RB	137	22	1	11	3.66	48	40.3	0	242	21	2	0	46	2	2
118	2020	Preston Williams	MIA	WR	138	23		8	9.35	39	74.8	0	0	288	18	0	0	35	4
119	2020	Baker Mayfield	CLE	QB	139	25	3	16	15.54	18	248.62	3,563	165	6	1	486	54	1	27
120	2020	Jonnu Smith	TEN	TE	140	25	4	15	9.35	10	140.2	0	4	448	41	0	2	65	9
121	2020	Allen Lazard	GB	WR	141	24	3	10	9.78	36	97.8	0	17	451	33	0	2	46	3
122	2020	Dallas Goedert	PHI	TE	142	25	3	11	10.58	7	116.4	0	0	524	46	0	0	65	3
123	2020	Adrian Peterson	DET	RB	144	35		16	7.78	37	124.5	0	604	101	12	0	156	18	7
124	2020	Chris Thompson	JAX	RB	145	29		8	5.33	45	42.6	0	20	146	20	0	7	23	1
125	2020	Michael Pittman	IND	WR	146	22	1	13	7.61	47	98.9	0	26	503	40	0	3	61	1
126	2020	N'Keal Harry	NE	TE	147	22	2	14	5.28	18	73.9	0	0	309	33	0	2	57	2
127	2020	Blake Jarwin	DAL	TE	148	26		1	2.2	22	2.2	0	0	12	1	0	0	1	0
128	2020	Larry Fitzgerald	ARI	WR	150	37		13	7.76	46	100.9	0	0	409	54	0	0	72	1
129	2020	Ke'Shawn Vaughn	TB	RB	151	23	1	10	2.33	50	23.3	0	109	34	5	0	26	10	1
130	2020	Nyheim Miller-Hines	IND	RB	152	23	3	16	12.08	23	193.2	0	380	482	63	0	89	76	7
131	2020	Jimmy Garoppolo	SF	QB	153	28	7	6	10.72	22	64.34	1,096	25	0	0	140	10	0	7
132	2020	Eric Ebron	PIT	TE	154	27		15	9.45	9	141.8	0	0	558	56	0	0	91	5
133	2020	Mike Williams	LAC	WR	156	25	4	15	10.25	34	153.7	0	1	756	48	0	1	85	5
134	2020	Robbie Chosen	CAR	WR	157	27	5	16	14.01	23	224.1	0	15	1,096	95	0	4	136	3
135	2020	Justin Jackson	LAC	RB	160	24		9	7.26	40	65.3	0	270	173	19	0	59	24	0
136	2020	Chris Herndon	NYJ	TE	162	24		16	4.61	20	73.7	0	0	287	31	0	0	46	3
137	2020	Bryce Love	WAS	RB	165	23				52		0	0	0	0	0	0	0	0
138	2020	Jack Doyle	IND	TE	167	30		14	4.58	21	64.1	0	0	251	23	0	0	33	3
139	2020	Curtis Samuel	CAR	WR	168	24	4	15	14.14	21	212.1	0	200	851	77	0	41	97	5
140	2020	Ryan Tannehill	TEN	QB	169	32	9	16	21.52	9	344.36	3,819	266	0	1	481	43	1	40
141	2020	Jerick McKinnon	SF	RB	170	28	7	16	7.89	35	126.2	0	319	253	33	0	81	46	6
142	2020	Greg Olsen	SEA	TE	171	35		11	4.9	19	53.9	0	0	239	24	0	0	37	1
143	2020	Philip Rivers	IND	QB	172	38	17	16	15	19	239.96	4,169	-8	0	0	543	18	0	24
144	2020	Breshad Perriman	NYJ	WR	173	26		12	8.26	43	99.1	0	6	505	30	0	1	60	3
145	2020	Drew Lock	DEN	QB	174	23	2	13	13.95	20	181.32	2,933	160	0	0	443	44	0	19
146	2020	Parris Campbell	IND	WR	175	23	2	2	7.35	48	14.7	0	16	71	6	0	2	9	0
147	2020	Carlos Hyde	SEA	RB	177	29		10	8.49	32	84.9	0	356	93	16	0	81	20	4