PyPI Download stats, past 7 days, grouped by whether user-agent self-reports `ci: true`

query.sql

SELECT
  DATE(timestamp) AS download_date,
  COUNTIF(details.ci = TRUE) AS ci_downloads,
  COUNTIF(details.ci IS NULL OR details.ci = FALSE) AS non_ci_downloads
FROM `bigquery-public-data.pypi.file_downloads`
WHERE DATE(timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
GROUP BY download_date
ORDER BY download_date;

results.csv