Titanic
Titanic

Reputation: 557

Missing Python Package Download Data from PyPI in 2016

Here is a plot of monthly download data from PyPI's old system pypi.python.org and new data storage on BigQuery.

enter image description here

Total Downloads of Module Missing on PyPi mentions that, Donald Stufft (PyPI maintainer in 2016 (is Donald still in charge?)), disabled the broken PyPI's download count system. Donald also mentioned in the email that "this isn't a permanent loss of the feature and we won't lose any data".

My question is that is where I can find the "missing" data from late 2015 to 2016? Is the raw data stored somewhere?

update 1: another related question Why PyPi doesn't show download stats anymore?

Footnote: the graph is a raw measure of user downloads but is far from accurate due to 1. PyPI data is cumulative downloads for each file, BQ data is the accurate download data. 2. non-PyPI sources are not counted, such as Anaconda, etc other ways to install packages.

Upvotes: 1

Views: 160

Answers (1)

艾瑪艾瑪艾瑪
艾瑪艾瑪艾瑪

Reputation: 310

Try this

SELECT COUNT(*) as download_count
FROM TABLE_DATE_RANGE(
  [the-psf:pypi.downloads],
  TIMESTAMP("2019-09-15"),
  CURRENT_TIMESTAMP()
)
WHERE file.project="sharks"

Upvotes: 0

Related Questions