Examples

Queries and visualizations to help people use data

How many projects of each team size are listed in Savannah? (05-2011)

Description

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

Visualization

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

Data Resources: 

How many projects of each team size are listed in Free Software Foundation? (05-2011)

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 (57 projects).

Data Resources: 

How many projects of each team size are listed in Objectweb? (05-2011)

Description

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

Visualization

Data Resources: 

How many projects of each team size are listed in Rubyforge? (05-2011)

Description

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

Visualization

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

Data Resources: 

How has the use of "Free" and "Open" in project names grown by year? (2010 data)

Description

This chart shows the number of new projects in each repository that use the words "Free" and "Open" in project names through 2010.

Visualization

Data Resources: 

How many projects at each repository share URL's? (05-2011)

Description

This chart shows the number of projects at each repository that share URL's as of May 2011.

Visualization

URL-to

URL-from

SQL Script

Data Resources: 

How many projects at each repository share identical short project names? (05-2011)

Description

This chart shows the number of projects at each repository that share project names as of May 2011.

Visualization

project-names

SQL Script

Data Resources: 

How have projects in each repository grown by year? (05-2011)

Description

This chart shows the number of NEW projects added to each repository by month/year.

Visualization

Notes: RF had 697 projects without a project start date. OW had one project started in 1970.

Data Resources: 

How many projects are listed in each repository? (05-2011)

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_name )
FROM gc_projects
WHERE datasource_id = <current>;

Data Resources: 

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

Description

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

Visualization

Rubyforge Programming Language Chart

Data Resources: 

Pages