Package ecosystem statistics - Django

README.md

Package ecosystem statistics - Django

For more examples see timeline-of-django and 20,000 Django packages.

Source queries

• all-packages-downloads.sql (BigQuery, $10 per query)
• all-packages-statistics.sql (DuckDB)

Analysis queries

In DuckDB:

create table all_pkg as select * from './all_pkg.parquet.zst';
copy(select name, downloads_30d, number_of_releases, markdown from all_pkg where latest_release_upload_time >= NOW() - INTERVAL '1 years' order by latest_release_upload_time desc) to './released_1_year.csv';
copy(select name, downloads_30d, number_of_releases, markdown from all_pkg where latest_release_upload_time >= NOW() - INTERVAL '3 years' order by latest_release_upload_time desc) to './released_3_year.csv';
copy(select name, downloads_30d, number_of_releases, markdown from all_pkg where latest_release_upload_time >= CAST('2025-01-16T09:15:08.000Z' AS TIMESTAMP) order by latest_release_upload_time desc) to './released_since_5_2.csv';

all_pkg.parquet.zst

released_1_year.csv

released_3_year.csv

released_since_5_2.csv