Updated Freecode Project Counts, 2005-2014

We have collected Freecode (formerly Freshmeat) data since 2005. This chart shows the number of projects listed in the Freecode directory between 2005 and 2014. Each line represents one collection. (Collections are referred to in our database by the term "datasource_id".)

Here is the code used in the FLOSSmole database to generate the data list to create this graph:

SELECT f.datasource_id, year(d.date_donated), count( f.project_id )
FROM fm_projects f
INNER JOIN datasources d
ON f.datasource_id=d.datasource_id
GROUP BY 1,2
ORDER BY 1,2