Closed
Description
Hello!
My apologies if this is the wrong place to file an issue. I use BigQuery to grab statistics, and one thing I noticed is Windows 11 never appears in the data. This can be seen with this query as en example:
SELECT REGEXP_EXTRACT(details.python, r"[0-9]+\.[0-9]+") AS python_version,
file.version AS file_version,
details.distro.name as distro_name,
details.distro.version as distro_version,
details.system.name as system_name,
details.system.release as system_release,
timestamp as time_stamp,
country_code as countrycode,
COUNT(*) AS num_downloads,
FROM `bigquery-public-data.pypi.file_downloads`
WHERE file.project="pip" and details.system.name='Windows' and details.system.release='11'
AND DATE(timestamp)
BETWEEN DATE_TRUNC(DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY), DAY)
AND CURRENT_DATE()
GROUP BY `python_version`, `countrycode`, `file_version`, `distro_name`, `distro_version`, `system_name`, `system_release`, `time_stamp`
ORDER BY `num_downloads` DESC
This happens with any project. Is it something that I'm doing wrong?
Metadata
Metadata
Assignees
Labels
No labels