As of the database dump from 2023-08-12-020056.
File on GitHub Gist truncated to 2000 to make file rendering smoother.
Exported with query
CREATE MATERIALIZED VIEW all_versions AS (
SELECT DISTINCT ON (crate_id)
id,
crate_id
FROM versions
WHERE NOT yanked
ORDER BY crate_id, to_semver_no_prerelease(num) DESC NULLS LAST, id DESC
);
ANALYZE all_versions;
CREATE INDEX someindex ON all_versions (id, crate_id);
\COPY (
SELECT
outer_crates.name AS crate_name,
outer_crates.downloads AS total_crate_downloads,
(
SELECT COUNT(*) FROM (
SELECT DISTINCT ON (crates.id)
crates.id
FROM dependencies
INNER JOIN all_versions AS versions
ON versions.id = dependencies.version_id
INNER JOIN crates
ON crates.id = versions.crate_id
WHERE dependencies.crate_id = outer_crates.id
) t
) AS total_reverse_dependencies
FROM crates AS outer_crates
ORDER BY
total_reverse_dependencies DESC,
crate_name ASC
) TO '/tmp/crates.csv' WITH CSV DELIMITER ',' HEADER;