# file: sfSummaryStatusData28-Jan-2005.txt
#  Scripts & raw data available at http://ossmole.sourceforge.net
#  Scripts written by Megan Conklin and contributed to the ossmole project
#
#  This data is free and available for any use (afterall we just spidered it ;).
#  We do however request that those using the data in any published form provide 
#  a citation to: ossmole Project (2004) SourceForge Available at: 
#  http://ossmole.sourceforge.net
#
# This particular file is a list of what status is listed for each project.
# The information in this file was generated by running the 
# following:
#
# SELECT description, code, count(*)
# FROM project_status
# where datasource_ID=4
# group by 1
# order by 3 desc

# Note: not all projects have a status code/description represented on their 
# "SF project description" web page.
#
#Here is the information with datasource_id=4 (April 2005)
description code    count(*)
Planning 	1 	15399
Beta 	4 	14257
Alpha 	3 	11118
Production/Stable 	5 	10932
Pre-Alpha 	2 	9517
Inactive 	7 	990
Mature 	6 	821

#Here is the information with datasourceID=2 (January 2005)
+-------------+--------------------+----------+
| status_code | status_description | COUNT(*) |
+-------------+--------------------+----------+
| 1           | Planning           |    14925 |
| 4           | Beta               |    13576 |
| 3           | Alpha              |    10635 |
| 5           | Production/Stable  |    10414 |
| 2           | Pre-Alpha          |     9177 |
| 7           | Inactive           |      881 |
| 6           | Mature             |      789 |
+-------------+--------------------+----------+

#Here is the information with datasourceID=1 (October 2005)
+-------------+--------------------+----------+
| status_code | status_description | COUNT(*) |
+-------------+--------------------+----------+
| 1           | Planning           |    14159 |
| 4           | Beta               |    12695 |
| 3           | Alpha              |     9948 |
| 5           | Production/Stable  |     9585 |
| 2           | Pre-Alpha          |     8586 |
| 6           | Mature             |      724 |
| 7           | Inactive           |      710 |
+-------------+--------------------+----------+