Query · 1 views

Top 160 ADP Seasons 2019 2020 2028

I want a full database of all the fantasy football players drafted in the top 160 ADP in the years 2020, 2019, 2028 (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	1	25	5	15	14.91	13	0	0	979	244	338	52	0	6	2	8
2	2020	Alvin Kamara	NO	RB	2	2	25	4	15	25.19	1	0	0	932	187	756	83	0	16	5	21
3	2020	Derrick Henry	TEN	RB	3	3	26	5	16	20.82	3	0	0	2,027	378	114	19	0	17	0	17
4	2020	Dalvin Cook	MIN	RB	4	4	25	4	14	24.13	2	0	0	1,557	312	361	44	0	16	1	17
5	2020	Saquon Barkley	NYG	RB	5	5	23	3	2	7.7	38	0	0	34	19	60	6	0	0	0	0
6	2020	Tyreek Hill	KC	WR	6	6	26	5	15	21.93	2	0	0	123	13	1,276	87	0	2	15	17
7	2020	DeAndre Hopkins	ARI	WR	7	7	28	8	16	17.99	5	0	0	1	1	1,407	115	0	0	6	6
8	2020	Josh Jacobs	LV	RB	8	8	22	2	15	15.42	11	0	0	1,065	273	238	33	0	12	0	12
9	2020	Patrick Mahomes	KC	QB	9	9	24	4	15	24.96	2	4,740	588	308	62	0	0	38	2	0	40
10	2020	Nick Chubb	CLE	RB	10	10	24	3	12	17.31	6	0	0	1,067	190	150	16	0	12	0	12
11	2020	Travis Kelce	KC	TE	11	11	30	8	15	20.85	1	4	2	0	0	1,416	105	0	0	11	11
12	2020	Davante Adams	GB	WR	12	12	27	7	14	25.6	1	0	0	0	0	1,374	115	0	0	18	18
13	2020	Mike Evans	TB	WR	13	13	27	7	16	15.54	13	0	0	0	0	1,006	70	0	0	13	13
14	2020	Lamar Jackson	BAL	QB	14	14	23	3	15	22.19	8	2,757	376	1,005	159	0	0	26	7	0	33
15	2020	Aaron Jones	GB	RB	15	15	25	4	14	18.49	4	0	0	1,104	201	355	47	0	9	2	11
16	2020	Austin Ekeler	LAC	RB	16	16	25	4	10	16.53	9	0	0	530	116	403	54	0	1	2	3
17	2020	Russell Wilson	SEA	QB	17	17	31	9	16	22.49	7	4,212	558	513	83	0	0	40	2	0	42
18	2020	Amari Cooper	DAL	WR	18	18	26	6	16	14.8	16	0	0	14	6	1,114	92	0	0	5	5
19	2020	JuJu Smith-Schuster	PIT	WR	19	19	23	4	16	14.63	18	0	0	0	0	831	97	0	0	9	9
20	2020	Adam Thielen	MIN	WR	20	20	30	8	15	16.93	9	0	0	15	3	925	74	0	0	14	14
21	2020	Joe Mixon	CIN	RB	21	21	24	4	6	16.6	8	0	0	428	119	138	21	0	3	1	4
22	2020	Allen Robinson	CHI	WR	22	22	27	7	16	16.43	11	0	0	-1	1	1,250	102	0	0	6	6
23	2020	Todd Gurley	ATL	RB	23	23	26		15	10.88	25	0	0	678	195	164	25	0	9	0	9
24	2020	Odell Beckham	CLE	WR	24	24	27	7	7	12.4	26	18	1	72	3	319	23	0	1	3	4
25	2020	James Conner	PIT	RB	25	25	25	4	13	12.66	21	0	0	721	169	215	35	0	6	0	6
26	2020	DJ Moore	CAR	WR	26	26	23	3	15	14.1	22	0	1	22	2	1,193	66	0	0	4	4
27	2020	Mark Andrews	BAL	TE	27	27	24	3	14	12.15	4	0	0	0	0	701	58	0	0	7	7
28	2020	Zach Ertz	PHI	TE	28	28	29	8	11	7.05	18	0	0	0	0	335	36	0	0	1	1
29	2020	Le'Veon Bell	KC	RB	29	29	28		11	6.78	41	0	0	328	82	138	16	0	2	0	2
30	2020	George Kittle	SF	TE	30	30	26	4	8	15.64	3	0	0	17	2	634	48	0	0	2	2
31	2020	David Johnson	HOU	RB	31	31	28		12	14.96	12	0	0	691	147	314	33	0	6	2	8
32	2020	Tyler Lockett	SEA	WR	32	32	27	6	16	16.59	10	0	0	0	0	1,054	100	0	0	10	10
33	2020	Kenyan Drake	ARI	RB	33	33	26	5	15	12.81	20	0	0	955	239	137	25	0	10	0	10
34	2020	Michael Thomas	NO	WR	34	34	27	5	7	11.99	28	0	0	1	1	438	40	0	0	0	0
35	2020	Miles Sanders	PHI	RB	35	35	23	2	12	14.2	16	0	0	867	164	197	28	0	6	0	6
36	2020	DK Metcalf	SEA	WR	36	36	22	2	16	16.96	8	0	0	0	0	1,303	83	0	0	10	10
37	2020	Calvin Ridley	ATL	WR	37	37	25	3	15	18.77	4	0	0	1	5	1,374	90	0	0	9	9
38	2020	Chris Carson	SEA	RB	38	38	25		12	15.65	10	0	0	681	141	287	37	0	5	4	9
39	2020	Kyler Murray	ARI	QB	39	39	23	2	16	23.67	5	3,971	558	819	133	0	0	26	11	0	37
40	2020	Robert Woods	LAR	WR	40	40	28	8	16	15.32	15	0	0	155	24	936	90	0	2	6	8
41	2020	Deshaun Watson	HOU	QB	41	41	24	4	16	23.08	6	4,823	544	444	90	0	0	33	3	0	36
42	2020	Chris Godwin	TB	WR	42	42	24	4	12	15.92	12	0	0	0	0	840	65	0	0	7	7
43	2020	Melvin Gordon	DEN	RB	43	43	27	6	15	13.23	19	0	0	986	215	158	32	0	9	1	10
44	2020	Darren Waller	LV	TE	44	44	27	6	16	17.41	2	0	0	0	0	1,196	107	0	0	9	9
45	2020	Stefon Diggs	BUF	WR	45	45	26	6	16	20.54	3	0	0	1	1	1,535	127	0	0	8	8
46	2020	Jonathan Taylor	IND	RB	46	46	21	1	15	16.85	7	0	0	1,169	232	299	36	0	11	1	12
47	2020	Dak Prescott	DAL	QB	47	47	27	5	5	27.13	1	1,856	222	93	18	11	1	9	3	1	13
48	2020	Evan Engram	NYG	TE	48	48	25	4	16	8.81	14	0	0	26	6	654	63	0	1	1	2
49	2020	Leonard Fournette	TB	RB	49	49	25	4	13	10.15	27	0	0	367	97	233	36	0	6	0	6
50	2020	Kareem Hunt	CLE	RB	50	50	25	4	16	13.66	17	0	0	841	198	304	38	0	6	5	11
51	2020	A.J. Brown	TEN	WR	51	51	23	2	14	17.68	6	0	0	0	0	1,075	70	0	0	11	11
52	2020	T.Y. Hilton	IND	WR	52	52	30		15	10.95	32	0	0	0	0	762	56	0	0	5	5
53	2020	Rob Gronkowski	TB	TE	53	53	31		16	9.33	11	0	0	0	0	623	45	0	0	7	7
54	2020	Devin Singletary	BUF	RB	54	54	22	2	16	8.98	29	0	0	687	156	269	38	0	2	0	2
55	2020	Drew Brees	NO	QB	55	55	41		12	17.46	15	2,942	390	-2	18	0	0	24	2	0	26
56	2020	David Montgomery	CHI	RB	56	56	23	2	15	17.65	5	0	0	1,070	247	438	54	0	8	2	10
57	2020	Aaron Rodgers	GB	QB	57	57	36	16	16	23.95	4	4,299	526	149	38	-6	1	48	3	0	51
58	2020	DJ Chark	JAX	WR	58	58	23	3	13	11.82	29	0	0	0	0	706	53	0	0	5	5
59	2020	A.J. Green	CIN	WR	59	59	32		16	6.96	51	0	0	0	0	523	47	0	0	2	2
60	2020	Courtland Sutton	DEN	WR	60	60	24	3	1	9.6	38	0	0	0	0	66	3	0	0	0	0
61	2020	Tom Brady	TB	QB	61	61	43		16	21.12	10	4,633	610	6	30	0	0	40	3	0	43
62	2020	Raheem Mostert	SF	RB	62	62	28	6	8	12.46	22	0	0	521	104	156	16	0	2	1	3
63	2020	Marquise Brown	BAL	WR	63	63	23	2	16	11.44	31	0	0	1	1	769	58	0	0	8	8
64	2020	Julian Edelman	NE	WR	64	64	34		6	9.37	39	38	2	22	2	315	21	0	0	0	0
65	2020	Michael Gallup	DAL	WR	65	65	24	3	16	10.83	33	0	0	0	0	843	59	0	0	5	5
66	2020	Matt Ryan	ATL	QB	67	66	35		16	17.65	14	4,581	626	92	29	0	0	26	2	0	28
67	2020	Brandin Cooks	HOU	WR	69	67	26	7	15	15.47	14	0	0	0	0	1,150	81	0	0	6	6
68	2020	Josh Allen	BUF	QB	70	68	24	3	16	24.75	3	4,544	572	421	102	12	1	37	8	1	46
69	2020	CeeDee Lamb	DAL	WR	71	69	21	1	16	13.61	24	0	0	82	10	935	74	0	1	5	6
70	2020	Hayden Hurst	ATL	TE	73	70	27	3	16	9.32	12	0	0	0	0	571	56	0	0	6	6
71	2020	Ronald Jones	TB	RB	74	71	23		14	13.31	18	0	0	978	192	165	28	0	7	1	8
72	2020	D'Andre Swift	DET	RB	75	72	21	1	13	14.6	14	0	0	521	114	357	46	0	8	2	10
73	2020	James White	NE	RB	76	73	28		14	8.33	34	0	0	121	35	375	49	0	2	1	3
74	2020	J.K. Dobbins	BAL	RB	77	74	21	1	15	11.23	24	0	0	805	134	120	18	0	9	0	9
75	2020	Marlon Mack	IND	RB	79	75	24	4	1	8.6	31	0	0	26	4	30	3	0	0	0	0
76	2020	Jared Cook	NO	TE	80	76	33		15	8.49	17	0	0	0	0	504	37	0	0	7	7
77	2020	Tyler Higbee	LAR	TE	81	77	27	5	15	8.55	16	0	0	1	1	521	44	0	0	5	5
78	2020	Tarik Cohen	CHI	RB	84	78	25	4	3	5.83	44	0	0	74	14	41	6	0	0	0	0
79	2020	Marvin Jones	DET	WR	85	79	30	9	16	14.24	20	0	0	0	0	978	76	0	0	9	9
80	2020	Antonio Gibson	WAS	RB	86	80	22	1	14	14.44	15	0	0	795	170	247	36	0	11	0	11
81	2020	Carson Wentz	PHI	QB	87	81	27	5	12	16.53	18	2,620	437	276	52	0	0	16	5	0	21
82	2020	Phillip Lindsay	DEN	RB	88	82	26		11	6	42	0	0	502	118	28	7	0	1	0	1
83	2020	Henry Ruggs	LV	WR	89	83	21		13	6.47	53	0	0	49	9	452	26	0	0	2	2
84	2020	Jerry Jeudy	DEN	WR	90	84	21	1	16	9.85	36	0	0	0	0	856	52	0	0	3	3
85	2020	Jordan Howard	PHI	RB	91	85	25		7	4.39	48	0	0	60	35	-3	1	0	4	0	4
86	2020	Matt Breida	MIA	RB	92	86	25	4	12	3.5	50	0	0	254	59	96	9	0	0	0	0
87	2020	Emmanuel Sanders	NO	WR	93	87	33		14	11.77	30	0	0	12	1	726	61	0	0	5	5
88	2020	Cam Newton	NE	QB	95	88	31		15	17.4	16	2,657	368	592	137	35	2	8	12	1	21
89	2020	Latavius Murray	NO	RB	96	89	30	8	15	9.08	28	0	0	656	146	176	23	0	4	1	5
90	2020	Noah Fant	DEN	TE	97	90	22	2	15	9.95	8	0	0	0	0	673	62	0	0	3	3
91	2020	Diontae Johnson	PIT	WR	98	91	24	2	15	14.79	17	0	0	15	3	923	88	0	0	7	7
92	2020	Kerryon Johnson	DET	RB	99	92	23		16	4.49	47	0	0	181	52	187	19	0	2	1	3
93	2020	Austin Hooper	CLE	TE	101	93	25	5	13	8.73	15	0	0	0	0	435	46	0	0	4	4
94	2020	Zack Moss	BUF	RB	102	94	22	1	13	7.82	36	0	0	481	112	95	14	0	4	1	5
95	2020	Tevin Coleman	SF	RB	103	95	27		8	1.59	54	0	0	53	28	34	4	0	0	0	0
96	2020	Mecole Hardman	KC	WR	105	96	22	2	16	8.01	46	0	0	31	4	560	41	0	0	4	4
97	2020	Christian Kirk	ARI	WR	106	97	23	3	14	10.46	34	0	0	3	2	621	48	0	0	6	6
98	2020	Matthew Stafford	DET	QB	107	98	32	12	16	16.29	19	4,084	528	112	29	0	0	26	0	0	26
99	2020	Jamison Crowder	NYJ	WR	108	99	27	6	12	14.34	19	43	1	14	1	699	59	1	0	6	7
100	2020	Sony Michel	NE	RB	109	100	25		9	8.37	33	0	0	449	79	114	7	0	1	1	2
101	2020	Sterling Shepard	NYG	WR	110	101	27	5	12	13.54	25	0	0	49	6	656	66	0	1	3	4
102	2020	Joe Burrow	CIN	QB	111	102	23	1	10	17.37	17	2,688	404	142	37	0	0	13	3	0	16
103	2020	Darius Slayton	NYG	WR	112	103	23	2	16	8.81	42	0	0	-1	2	751	50	0	0	3	3
104	2020	Justin Jefferson	MIN	WR	115	104	21	1	16	17.14	7	0	0	2	1	1,400	88	0	0	7	7
105	2020	T.J. Hockenson	DET	TE	117	105	23	2	16	10.96	5	0	0	0	1	723	67	0	0	6	6
106	2020	Chase Edmonds	ARI	RB	118	106	24	3	16	10.5	26	0	0	448	97	402	53	0	1	4	5
107	2020	Mike Gesicki	MIA	TE	120	107	24	3	15	10.62	6	0	0	0	0	703	53	0	0	6	6
108	2020	DeSean Jackson	PHI	WR	122	108	33		5	8.96	41	0	0	12	1	236	14	0	0	1	1
109	2020	Ben Roethlisberger	PIT	QB	123	109	38		15	17.81	13	3,803	608	11	25	0	0	33	0	0	33
110	2020	Tony Pollard	DAL	RB	124	110	23	2	16	7.54	39	0	0	435	101	192	28	0	4	1	5
111	2020	Sammy Watkins	KC	WR	125	111	27		10	8.74	43	0	1	3	1	421	37	0	0	2	2
112	2020	Jalen Reagor	PHI	WR	126	112	21	1	11	7.93	47	0	0	26	4	396	31	0	0	1	1
113	2020	Darrell Henderson	LAR	RB	129	113	23	2	15	8.69	30	0	0	624	138	159	16	0	5	1	6
114	2020	Daniel Jones	NYG	QB	133	114	23	2	14	12.86	25	2,943	448	423	65	0	0	11	1	0	12
115	2020	Boston Scott	PHI	RB	135	115	25	3	16	5.98	43	0	0	374	80	212	25	0	1	1	2
116	2020	Anthony Miller	CHI	WR	136	116	25	3	16	6.79	52	0	0	12	2	485	49	0	0	2	2
117	2020	AJ Dillon	GB	RB	137	117	22	1	11	3.66	49	0	0	242	46	21	2	0	2	0	2
118	2020	Preston Williams	MIA	WR	138	118	23		8	9.35	40	0	0	0	0	288	18	0	0	4	4
119	2020	Baker Mayfield	CLE	QB	139	119	25	3	16	15.54	21	3,563	486	165	54	6	1	26	1	0	27
120	2020	Jonnu Smith	TEN	TE	140	120	25	4	15	9.35	10	0	0	4	2	448	41	0	1	8	9
121	2020	Allen Lazard	GB	WR	141	121	24	3	10	9.78	37	0	0	17	2	451	33	0	0	3	3
122	2020	Dallas Goedert	PHI	TE	142	122	25	3	11	10.58	7	0	0	0	0	524	46	0	0	3	3
123	2020	Adrian Peterson	DET	RB	144	123	35		16	7.78	37	0	0	604	156	101	12	0	7	0	7
124	2020	Chris Thompson	JAX	RB	145	124	29		8	5.33	45	0	0	20	7	146	20	0	0	1	1
125	2020	Michael Pittman	IND	WR	146	125	22	1	13	7.61	49	0	0	26	3	503	40	0	0	1	1
126	2020	N'Keal Harry	NE	TE	147	126	22	2	14	5.28	19	0	0	0	2	309	33	0	0	2	2
127	2020	Blake Jarwin	DAL	TE	148	127	26		1	2.2	23	0	0	0	0	12	1	0	0	0	0
128	2020	Larry Fitzgerald	ARI	WR	150	128	37		13	7.76	48	0	0	0	0	409	54	0	0	1	1
129	2020	Ke'Shawn Vaughn	TB	RB	151	129	23	1	10	2.33	53	0	0	109	26	34	5	0	0	1	1
130	2020	Nyheim Miller-Hines	IND	RB	152	130	23	3	16	12.08	23	0	0	380	89	482	63	0	3	4	7
131	2020	Jimmy Garoppolo	SF	QB	153	131	28	7	6	10.72	26	1,096	140	25	10	0	0	7	0	0	7
132	2020	Eric Ebron	PIT	TE	154	132	27		15	9.45	9	0	0	0	0	558	56	0	0	5	5
133	2020	Mike Williams	LAC	WR	156	133	25	4	15	10.25	35	0	0	1	1	756	48	0	0	5	5
134	2020	Robbie Chosen	CAR	WR	157	134	27	5	16	14.01	23	0	0	15	4	1,096	95	0	0	3	3
135	2020	Justin Jackson	LAC	RB	160	135	24		9	7.26	40	0	0	270	59	173	19	0	0	0	0
136	2020	Chris Herndon	NYJ	TE	162	136	24		16	4.61	21	0	0	0	0	287	31	0	0	3	3
137	2020	Bryce Love	WAS	RB	165	137	23		0			0	0	0	0	0	0	0	0	0	0
138	2020	Jack Doyle	IND	TE	167	138	30		14	4.58	22	0	0	0	0	251	23	0	0	3	3
139	2020	Curtis Samuel	CAR	WR	168	139	24	4	15	14.14	21	0	0	200	41	851	77	0	2	3	5
140	2020	Ryan Tannehill	TEN	QB	169	140	32	9	16	21.52	9	3,819	481	266	43	0	1	33	7	0	40
141	2020	Jerick McKinnon	SF	RB	170	141	28	7	16	7.89	35	0	0	319	81	253	33	0	5	1	6
142	2020	Greg Olsen	SEA	TE	171	142	35		11	4.9	20	0	0	0	0	239	24	0	0	1	1
143	2020	Philip Rivers	IND	QB	172	143	38	17	16	15	22	4,169	543	-8	18	0	0	24	0	0	24
144	2020	Breshad Perriman	NYJ	WR	173	144	26		12	8.26	44	0	0	6	1	505	30	0	0	3	3
145	2020	Drew Lock	DEN	QB	174	145	23	2	13	13.95	23	2,933	443	160	44	0	0	16	3	0	19
146	2020	Parris Campbell	IND	WR	175	146	23	2	2	7.35	50	0	0	16	2	71	6	0	0	0	0
147	2020	Carlos Hyde	SEA	RB	177	147	29		10	8.49	32	0	0	356	81	93	16	0	4	0	4
148	2020	Darrel Williams	KC	RB	178	148	25		16	3.41	51	0	0	169	39	116	18	0	1	0	1
149	2020	Bryan Edwards	LV	WR	179	149	21		12	3.03	55	0	0	0	0	193	11	0	0	1	1
150	2020	Gardner Minshew	JAX	QB	181	150	24	2	9	17.85	12	2,259	327	153	29	0	1	16	1	0	17
151	2020	Kirk Cousins	MIN	QB	183	151	32	9	16	19.14	11	4,265	516	156	32	0	0	35	1	0	36
152	2020	Benny Snell	PIT	RB	185	152	22		16	4.68	46	0	0	368	111	61	10	0	4	0	4
153	2020	Hunter Renfrow	LV	WR	186	153	24	2	16	8.23	45	0	0	0	0	656	56	0	0	2	2
154	2020	LeSean McCoy	TB	RB	187	154	32		10	2.82	52	0	0	31	10	101	15	0	0	0	0
155	2020	Tua Tagovailoa	MIA	QB	188	155	22	1	10	13.55	24	1,814	290	109	36	0	0	11	3	0	14
156	2020	Alshon Jeffery	PHI	WR	189	156	30		7	3.36	54	0	0	0	0	115	6	0	0	1	1
157	2020	Dede Westbrook	JAX	WR	190	157	26		2	-0.3	56	0	0	0	0	4	1	0	0	0	0
158	2020	Tee Higgins	CIN	WR	191	158	21	1	16	12.16	27	0	0	28	5	908	67	0	0	6	6
159	2020	Jimmy Graham	CHI	TE	192	159	33	11	16	8.98	13	0	0	0	0	456	50	0	0	8	8
160	2020	Teddy Bridgewater	CAR	QB	193	160	27	7	15	16.08	20	3,733	492	279	53	0	0	15	5	0	20