package-count.md

Previously: https://gist.github.com/ianb/9124545

Current package list:

• waitforit
• minimock
• wsgi-intercept
• webob
• sqlapi
• wsgiproxy
• htconsole
• cmdutils
• pastescript
• webtestrecorder
• sqlobject
• sqlobject2
• debugheaders
• webtest
• workingenv.py
• tempita
• ohm
• wareweb
• sqlobject
• devauth
• wsgioverlay
• wsgiremote
• dtopt
• scripttest
• formencode
• wsgifilter
• tracpaste
• initools
• deliverance
• weberror
• fassembler
• cherrypaste
• djangopaste
• httpencode
• paste
• pylogo
• ScriptTranscluder
• VaingloriousEye
• zptkit
• pastedeploy
• wphp
• pip
• virtualenv

BigQuery:

#standardSQL
SELECT COUNT(*) AS num_downloads, file.project
FROM `the-psf.pypi.downloads*`
WHERE lower(file.project) IN ('waitforit', 'minimock', 'wsgi-intercept',
'webob',
'sqlapi',
'wsgiproxy',
'htconsole',
'cmdutils',
'pastescript',
'webtestrecorder',
'sqlobject',
'sqlobject2',
'debugheaders',
'webtest',
'workingenv.py',
'tempita',
'ohm',
'wareweb',
'sqlobject',
'devauth',
'wsgioverlay',
'wsgiremote',
'dtopt',
'scripttest',
'formencode',
'wsgifilter',
'tracpaste',
'initools',
'deliverance',
'weberror',
'fassembler',
'cherrypaste',
'djangopaste',
'httpencode',
'paste',
'pylogo',
'scripttranscluder',
'vaingloriouseye',
'zptkit',
'pastedeploy',
'wphp',
'pip',
'virtualenv'
)
GROUP BY file.project

Results roughly:

pip = 979,167,771

virtualenv = 157,499,426

everything else = 69,736,505