Skip to content

Instantly share code, notes, and snippets.

@kmmbvnr

kmmbvnr/bigquery.sql

Created July 21, 2016 02:59
Show Gist options
  • Save kmmbvnr/668eaa7ce6eb71234ef2954a871326a2 to your computer and use it in GitHub Desktop.
Save kmmbvnr/668eaa7ce6eb71234ef2954a871326a2 to your computer and use it in GitHub Desktop.
Download ZIP
Query pypi package download stats
Raw
bigquery.sql
SELECT details.installer.name, COUNT(*)
FROM
TABLE_DATE_RANGE(
[the-psf:pypi.downloads],
TIMESTAMP("20160601"),
TIMESTAMP("20160630")
)
WHERE file.project='django-material'
group by details.installer.name
@kmmbvnr
Copy link
Author

kmmbvnr commented Jun 23, 2017 •
edited 

SELECT DATE(timestamp), COUNT(*)
FROM
  TABLE_DATE_RANGE(
    [the-psf:pypi.downloads],
    TIMESTAMP("20170101"),
    TIMESTAMP("20170621")
  )
WHERE file.project='django-material'
  and details.installer.name=='pip'
group by 1
order by 1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment