Number of total *.deb package downloads of all released ROS 1 packages (Melodic + Noetic)

ros1_package_downloads_08_2022.csv

Data generated on 8 Aug 2022 using script https://github.com/DLu/ros_metrics/blob/main/ros_metrics/packages.py .

Each built version of a package counts, i.e. packages with a lot of builds will have higher numbers than not-so-often-updated packages.

Data from the automated collecting process were transformed using this command:

sqlite3 -header -csv data/packages.db 'select min(package) as package,sum(hits) as hits from (

select SUBSTR(SUBSTR(url, 35, 1000), 0, INSTR(SUBSTR(url, 35, 1000), "/")) as package,sum(hits) as hits from urls
where url LIKE "ros/ubuntu/pool/main/r/ros-noetic%" AND NOT url like "%dbgsym%"
group by package

union all

select SUBSTR(SUBSTR(url, 36, 1000), 0, INSTR(SUBSTR(url, 36, 1000), "/")) as package,sum(hits) as hits from urls
where url LIKE "ros/ubuntu/pool/main/r/ros-melodic%" AND NOT url like "%dbgsym%"
group by package

)
group by package
ORDER BY sum(hits) DESC' > /tmp/output.csv