Skip to content

the-psf.pypi.file_downloads has had no data since November 22 #67

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
zippeurfou opened this issue Dec 20, 2021 · 2 comments
Closed

the-psf.pypi.file_downloads has had no data since November 22 #67

zippeurfou opened this issue Dec 20, 2021 · 2 comments

Comments

@zippeurfou
Copy link

I was using the-psf rather than the public bigquery dataset and I have noticed that there has been no data on it since Nov 22.
Here is the query I've been using.

  COUNT(*) AS num_downloads,
  DATE_TRUNC(DATE(timestamp), DAY) AS `day`
FROM `the-psf.pypi.file_downloads`
WHERE
   DATE(timestamp)
    BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 40 DAY)
    AND CURRENT_DATE()
GROUP BY `day`
ORDER BY `day` DESC
LIMIT 1

Screen Shot 2021-12-20 at 10 04 56 AM

I can switch to the public dataset but I thought I should report it anyways.

@di
Copy link
Member

di commented Dec 20, 2021

Thanks for the report. The thepsf dataset is deprecated and will no longer receive data. The bigquery-public-data is a drop-in replacement, please use that going forward.

@zippeurfou
Copy link
Author

Awesome. Closing this then as long as it is known all good.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants