SELECT
REGEXP_EXTRACT(details.python, r"^([^\.]+\.[^\.]+)") as python_version,
details.installer.name,
details.installer.version,
COUNT(*) as total_downloads
FROM
TABLE_DATE_RANGE(
[the-psf:pypi.downloads],
TIMESTAMP("20160114"),
CURRENT_TIMESTAMP()
)
GROUP BY
python_version,
details.installer.name,
details.installer.version
ORDER BY
total_downloads DESC
LIMIT 100
| Row |
python_version |
details_installer_name |
details_installer_version |
total_downloads |
| 1 |
2.7 |
pip |
9.0.1 |
2329351194 |
| 2 |
2.7 |
pip |
6.0.8 |
1026930256 |
| 3 |
2.7 |
pip |
8.1.2 |
827186887 |
| 4 |
2.7 |
pip |
1.5.4 |
749604308 |
| 5 |
null |
bandersnatch |
1.11 |
714791614 |
| 6 |
2.7 |
null |
null |
638936352 |
| 7 |
2.7 |
pip |
6.1.1 |
436756002 |
| 8 |
3.5 |
pip |
9.0.1 |
321444466 |
| 9 |
2.7 |
pip |
7.1.2 |
284777575 |
| 10 |
3.6 |
pip |
9.0.1 |
262371972 |
| 11 |
2.7 |
pip |
8.1.1 |
261798294 |
