Examples

Queries and visualizations to help people use data

As of June 2009, what are the top operating systems used by projects listed in Rubyforge?

Description

This chart shows the top operating systems used by projects in Rubyforge.

Visualization

Rubyforge Operating System Chart

Data Resources: 

As of June 2009, what are the top programming languages used by projects listed in Sourceforge?

Description

This chart shows the top programming languages used by projects in Sourceforge.

Visualization

Sourceforge Programming Language Chart

Data Resources: 

As of June 2009, what are the top operating systems used by projects listed in Sourceforge?

Description

This chart shows the top operating systems used by projects in Sourceforge.

Visualization

Sourceforge Operating System Chart

Data Resources: 

As of June 2009, what are the top programming languages used by projects listed in Objectweb?

Description

This chart shows the top programming languages used by projects in Objectweb.

Visualization:

Objectweb Programming Language Chart

Data Resources: 

As of June 2009, what are the top operating systems used by projects listed in Objectweb?

Description

This chart shows the top operating systems used by projects in Objectweb.

Visualization

Objectweb Operating System Chart

Data Resources: 

As of June 2009, how many projects of each team size are listed in Sourceforge?

Description

This chart shows the number of projects of each team size listed in Sourceforge.

Visualization

Projects listed as having NULL or 0 developers were disregarded (1432 and 1478 projects, respectively).

Sourceforge Developer Count Chart

Data Resources: 

As of June 2009, how many projects of each team size are listed in Objectweb?

Description

This chart shows the number of projects of each team size listed in Objectweb.

Visualization

Objectweb Developer Count Chart

SQL Script

SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM ow_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;

Data Resources: 

As of June 2009, how many projects of each team size are listed in Rubyforge?

Description

This chart shows the number of projects of each team size listed in Rubyforge.

Visualization

Rubyforge Developer Count Chart

SQL Script

SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM rf_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;

Data Resources: 

As of June 2009, how many projects of each team size are listed in Free Software Foundation?

Description

This chart shows the number of projects of each team size listed in Free Software Foundation.

Visualization

Projects listed as having 0 developers were disregarded (53 projects).

Free Software Foundation Developer Count Chart

Data Resources: 

As of June 2009, how has the use "Free" and "Open" in project names grown by year?

Description

This chart shows the number of new projects in each repository that use the words "Free" and "Open" in project names. (We ran the queries to make this chart in June. This means 2009 was not yet completed, so this explains the apparent drop-off for the 2009 numbers.)

Visualization

Freshmeat Free & Open Count Chart

Data Resources: 

Pages