As of June 2009, how many projects are listed in each repository?

Description

This chart shows the number of projects that FLOSSmole most recently collected from each repository.

Visualization

Project Count Chart

SQL Script

SELECT count(DISTINCT proj_unixname) FROM projects
WHERE datasource_id= <current>;


SELECT count(DISTINCT project_id) FROM fm_projects
WHERE datasource_id= <current>;


SELECT count(DISTINCT proj_unixname) FROM rf_projects
WHERE datasource_id= <current>;


SELECT count(DISTINCT proj_unixname) FROM ow_projects
WHERE datasource_id= <current>;


SELECT count(DISTINCT proj_num) FROM fsf_projects
WHERE datasource_id= <current>;

AttachmentSize
Image icon 06-09-ProjectCount.gif14.18 KB
Data Resources: