Babel download stats, 2018-03

gistfile1.txt

SELECT file.version, COUNT(*) c
FROM `the-psf.pypi.downloads201803*`
WHERE file.project = 'babel'
GROUP BY file.version
ORDER BY c DESC

---
$ tr ',' '\t' < results-20180403-200146.csv | expand

version c
2.5.3   683198
2.3.4   72123
2.5.1   24179
2.4.0   20266
1.3     17635
2.2.0   7290
2.5.0   2515
0.9.6   2216
2.1.1   2074
2.0     1948
2.3.3   763
2.3.2   194
1.0     150
2.5.2   141
2.3.1   111
2.3.0   96
1.1     44
1.2     42

---
$ cut -f2 -d, < results-20180403-200146.csv | tail +2 | awk '{sum += $1};END{print sum}'

834985