I maintain a project that publishes a SQLite file containing all package metadata, if you don’t want to use BigQuery or the API to do this kind of analysis

https://github.com/pypi-data/pypi-json-data