query.sql

SELECT
  COUNT(*) AS downloads,
  file.project
FROM
  TABLE_DATE_RANGE( [long-stack-762:pypi.downloads], TIMESTAMP("20160114"), CURRENT_TIMESTAMP() )
WHERE
  file.type = 'bdist_wheel'
  AND NOT REGEXP_MATCH(file.filename, '^.*-none-any.whl$')
GROUP BY
  file.project
ORDER BY
  downloads DESC
LIMIT
  1000

results.md

downloads	projec t
18369	cffi
17269	cryptography
15757	matplotlib
15151	pillow
11145	pandas
10311	numpy
9287	scikit-learn
8444	coverage
8014	regex
6809	pymongo
5887	pyzmq
5552	gnureadline
4437	cython
4382	psutil
4021	scipy
3004	pypiwin32
2801	gevent
2565	ruamel-yaml
2525	coolprop
2472	mistune
2279	libsass
2194	larch
1807	pyside
1791	lazy-object-proxy
1738	kivy-deps-sdl2
1721	landlab
1680	greenlet
1641	p4python
1534	billiard
1511	lxml
1356	pyodbc
1288	kivy-deps-sdl2-dev
1251	pydatalog
1226	graphlab-create
1167	rawpy
1161	cobra
1158	pywincffi
1119	twisted
1109	psycopg2
1105	eelbrain
995	cpymad
929	xxhash
897	aacgmv2
883	logbook
882	reportlab
880	h5py
864	lensfunpy
863	pymssql
797	pymi
775	astropy
770	argon2-cffi
770	oapackage
759	rasterio
748	guiqwt
748	lmdb
724	ecos
713	cx-freeze
706	shapely
706	kivy
701	kivy-deps-glew
678	pykd
670	mysqlclient
647	pycryptodome
639	scikit-image
636	lda
633	randomstate
630	pymatgen
614	bcrypt
596	gensim
594	pyaudio
594	lifelines
591	pystan
577	airship-steamcloud
564	tornado
544	netifaces
524	hunter
519	pylandau
507	pylinkbot
483	sdl2-cffi
473	msgpack-python
469	specpy
466	pyplatec
465	aerospike
465	trollius
448	bw2speedups
440	mimodd
438	fiona
437	numexpr
436	swmm5
436	fullrmc
433	pyaxon
427	pytesmo
406	pycorrfit
405	cvxcanon
389	gmpy2
385	pycosat
383	libtcod-cffi
380	brotlipy
353	simpleitk
350	pypandoc
344	convertbng
329	sima
315	kivy-deps-glew-dev
315	ahoy
312	kivy-deps-gstreamer-dev
308	pymice
306	primesieve
303	statsmodels
298	pyastyle
296	cytoflow
294	netcdf4
291	pyspotify
280	tulipgui-python
277	fastcluster
273	pythonnet
272	pcaspy
271	spherepy
267	pywavelets
251	nupic
250	fabio
249	tulip-python
246	dipy
245	gr
244	elide
242	pydsm
235	zeroc-ice
232	pydevd
230	cmappertools
229	pyuv
226	dukpy-lukegb
225	pycsdl2
219	yt
217	sounddevice
217	ruamel-ordereddict
215	codeintel
214	obspy
214	cachannel
213	sframe
205	redislite
202	pygeoprocessing
197	mwparserfromhell
196	nupic-bindings
187	somoclu
186	uwbpep
182	asyncio
180	bintrees
178	khmer
178	pyenchant
176	emzed-optimizations
175	dawg
175	ephem
170	rdpy
166	mpi4py
162	shiboken
162	ll-xist
161	svviz
159	pysoundfile
152	pandana
151	scrypt
147	bannock
146	streamingds
146	python-crfsuite
145	pyephem
143	pyviennacl
142	nadamq
139	primer3-py
138	orange
137	python-librtmp
137	pyeda
135	pyhashxx
133	vsm
131	facile
130	pyibex
129	word2vec
127	pysptk
125	python-ldap
124	pyrxp
122	crosscat
122	bonsai
120	fxrays
118	simpleparse
117	arch
114	synth
111	jump-consistent-hash
111	libaudioverse
109	soundfile
108	imageio
107	pycddlib
107	gala
106	pixel-clusterizer
106	librabbitmq
106	pip
106	pysha3
104	pyhull
104	gpy
104	simpleaudio
102	pybluez
101	pyemd
101	secp256k1-transient
101	ffpyplayer