details_distro_name | details_distro_version | downloads |
---|---|---|
Ubuntu | 14.04 | 15270281 |
debian | wheezy/sid | 6312027 |
Ubuntu | 12.04 | 4520294 |
debian | 8.2 | 2123973 |
OS X | 10.11.2 | 1384282 |
CentOS Linux | 7.2.1511 | 1179419 |
debian | jessie/sid | 1116834 |
debian | 7.9 | 736360 |
CentOS | 6.7 | 643098 |
CentOS Linux | 7.1.1503 | 624582 |
Ubuntu | 15.10 | 525356 |
OS X | 10.10.5 | 469805 |
debian | 6.0.10 | 439709 |
Ubuntu | 15.04 | 410267 |
CentOS | 6.6 | 365599 |
debian | 7.8 | 343880 |
OS X | 10.11.3 | 307658 |
VirtuozzoLinux | 7.0 | 285998 |
CentOS | 6.5 | 227411 |
Red Hat Enterprise Linux Server | 7.2 | 149174 |
Fedora | 22 | 148932 |
Red Hat Enterprise Linux Server | 7.1 | 140468 |
OS X | 10.11.1 | 138629 |
debian | 8.0 | 132637 |
OS X | 10.9.5 | 132111 |
CentOS Linux | 7.0.1406 | 131954 |
Fedora | 23 | 124294 |
debian | 8.1 | 118088 |
debian | 8.3 | 102207 |
Fedora | 21 | 100456 |
debian | 6.0.7 | 98107 |
Ubuntu | 14.10 | 89716 |
OS X | 10.11.4 | 84488 |
Red Hat Enterprise Linux Server | 6.7 | 76609 |
OS X | 10.11 | 57930 |
Red Hat Enterprise Linux Server | 6.5 | 57369 |
debian | 7.6 | 53301 |
arch | 50236 | |
CentOS | 6.4 | 45187 |
Red Hat Enterprise Linux Server | 6.6 | 44453 |
OS X | 10.10.4 | 42799 |
OS X | 10.10.3 | 35948 |
LinuxMint | 17.3 | 31155 |
debian | stretch/sid | 27842 |
debian | 6.0.9 | 27598 |
debian | 7.4 | 26771 |
Gentoo Base System | 2.2 | 24308 |
CentOS | 6.3 | 23506 |
LinuxMint | 17.2 | 21506 |
debian | 7.7 | 20320 |
OS X | 10.10.2 | 19292 |
McAfee DXL Platform | 2.2.0.138 | 18839 |
Oracle Linux Server | 7.2 | 16574 |
SUSE Linux Enterprise Server | 12 | 15505 |
Kali | 2.0 | 15321 |
Debian | 8 | 12551 |
CentOS | 5.11 | 12428 |
Ubuntu | 10.04 | 10946 |
OS X | 10.8.5 | 10476 |
openSUSE | 42.1 | 10161 |
LinuxMint | 17.1 | 10069 |
SUSE Linux Enterprise Server | 11 | 9878 |
Red Hat Enterprise Linux Server | 7.0 | 9821 |
Oracle Linux Server | 7.1 | 8407 |
Fedora | 20 | 8282 |
"elementary OS" | 0.3.2 | 8142 |
OS X | 10.10 | 7966 |
Ubuntu | 16.04 | 7963 |
LinuxMint | 17 | 7790 |
openSUSE | 13.2 | 7459 |
OS X | 10.10.1 | 7131 |
Red Hat Enterprise Linux ES | 4 | 6721 |
CentOS | 6.2 | 6612 |
DaterOS Linux | 1.1.0 | 6442 |
Slackware | 14.1 | 5948 |
Red Hat Enterprise Linux Server | 6.4 | 5868 |
Debian | 7 | 5452 |
debian | 7.5 | 5394 |
CloudLinux | 7.1 | 5358 |
Ubuntu | 12.10 | 4808 |
OS X | 10.7.5 | 4768 |
Oracle Linux Server | 6.7 | 4736 |
Ubuntu | 13.04 | 4336 |
DaterOS Linux | 1.0.0 | 4291 |
arch | Arch | 4096 |
Scientific Linux | 6.7 | 3931 |
OS X | 10.6.8 | 3649 |
McAfee DXL Platform | 2.2.0.147 | 3458 |
OS X | 10.9.4 | 3342 |
openSUSE | 13.1 | 3124 |
McAfee DXL Platform | 2.2.0.156 | 2884 |
CentOS | 5.8 | 2876 |
CentOS | 5.9 | 2808 |
Scientific Linux | 7.1 | 2776 |
Red Hat Enterprise Linux Workstation | 6.7 | 2705 |
Ubuntu | 13.10 | 2647 |
CentOS | 5.10 | 2599 |
McAfee DXL Platform | 2.2.0.148 | 2464 |
LinuxMint | 2 | 2434 |
Red Hat Enterprise Linux Server | 6.2 | 2371 |
Created
January 27, 2016 17:12
-
-
Save dstufft/e1b1fbebb3482362198f to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
details.distro.name, | |
details.distro.version, | |
COUNT(*) AS downloads, | |
FROM | |
TABLE_DATE_RANGE( [long-stack-762:pypi.downloads], TIMESTAMP("20160114"), CURRENT_TIMESTAMP() ) | |
WHERE | |
details.distro.name IS NOT NULL | |
GROUP BY | |
details.distro.name, | |
details.distro.version | |
ORDER BY | |
downloads DESC | |
LIMIT | |
100 IGNORE CASE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment