Examples

Queries and visualizations to help people use data

What packages are required most by Free Software Foundation projects? (07-2011)

Description

This chart shows the packages that are required most frequently in FSF projects. There is a total of 8,024 requirements.

Visualization

Data Resources: 

What time of the day is email communication highest in Alioth projects? (07-2011)

Description

This chart shows the hourly breakdown of email communication in select Alioth projects. The projects shown had the highest total number of emails in their mailing lists.

Visualization:

Data Resources: 

What programming languages are paired together in Lanchpad projects (Network Diagram)? (07-2011)

Description

This graph shows a network diagram of the programming languages paired together by projects in Launchpad. The top 100 combinations are represented in the visual.

Visualization

LP Network Diagram


For an interactive visual, click the image below and then click the "Recompute layout" button (connected dots).


Data Resources: 

What programming languages are paired together in Launchpad projects? (07-2011)

Description

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

Visualization

LP Lang Pairs


Data Resources: 

What is the status of current Alioth projects? (07-2011)

Description

This chart shows the status breakdown of Alioth projects.

Visualization:

Data Resources: 

What are the most common programming languages used by projects listed in Alioth? (07-2011)

Description

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

Visualization:

Data Resources: 

What are the most common operating systems used by projects in Alioth? (07-2011)

Description

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

Visualization

Data Resources: 

What are the most common licenses used by projects in Alioth? (07-2011)

Description

This chart shows the top licenses used by projects in Alioth.

Visualization

Data Resources: 

What are the most common bugs in Launchpad projects? (07-2011)

Description: This shows the top 30 bugs tagged in Launchpad projects as of June 2011.

Launchpad Bug Cloud, June 2011
LPbugcloud



SQL Script

SELECT lp.official_bug_tag AS Bug, COUNT(name) AS Count
FROM lpd_official_bug_tags lp
WHERE lp.datasource_id = <current>
GROUP BY Bug
ORDER BY Count DESC;

Data Resources: 

What are the most common content licenses used by projects listed in Google Code? (06-2011)

Description

This chart shows the top content licenses used by projects in Google Code. There were 197,465 projects that did not list a content license.

Visualization

Data Resources: 

Pages