# file: sfSummaryRegistrationDateData28-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 the registration dates for each project.
# The information in this file was generated by running the 
# following queries:
#
#  SELECT YEAR(date_registered) AS 'year', COUNT(*) AS 'number of projects'
#  FROM projects
#  WHERE date_registered IS NOT NULL AND date_registered !=""
#  GROUP BY year

+--------+--------------------+
| year   | number of projects |
+--------+--------------------+
|   1999 |                433 |
|   2000 |               5663 |
|   2001 |              16407 |
|   2002 |              21659 |
|   2003 |              22428 |
|   2004 |              21535 |
|   2005 |               1587 |
+--------+--------------------+


#  SELECT MONTH(date_registered) AS 'month', 
#    YEAR(date_registered) AS 'year', 
#    COUNT(*) AS 'number of projects'
#  FROM projects
#  WHERE date_registered IS NOT NULL AND date_registered != ""
#  GROUP BY year, month

+--------+--------+--------------------+
| month  | year   | number of projects |
+--------+--------+--------------------+
|     11 |   1999 |                198 |
|     12 |   1999 |                235 |
|      1 |   2000 |                480 |
|      2 |   2000 |                422 |
|      3 |   2000 |                455 |
|      4 |   2000 |                405 |
|      5 |   2000 |                440 |
|      6 |   2000 |                419 |
|      7 |   2000 |                483 |
|      8 |   2000 |                533 |
|      9 |   2000 |                459 |
|     10 |   2000 |                571 |
|     11 |   2000 |                532 |
|     12 |   2000 |                464 |
|      1 |   2001 |                623 |
|      2 |   2001 |               1337 |
|      3 |   2001 |               1754 |
|      4 |   2001 |               1475 |
|      5 |   2001 |               1437 |
|      6 |   2001 |               1381 |
|      7 |   2001 |               1540 |
|      8 |   2001 |               1548 |
|      9 |   2001 |               1297 |
|     10 |   2001 |               1439 |
|     11 |   2001 |               1280 |
|     12 |   2001 |               1296 |
|      1 |   2002 |               1812 |
|      2 |   2002 |               1776 |
|      3 |   2002 |               1800 |
|      4 |   2002 |               2015 |
|      5 |   2002 |               1764 |
|      6 |   2002 |               1675 |
|      7 |   2002 |               1888 |
|      8 |   2002 |               1729 |
|      9 |   2002 |               1802 |
|     10 |   2002 |               1981 |
|     11 |   2002 |               1750 |
|     12 |   2002 |               1667 |
|      1 |   2003 |               2025 |
|      2 |   2003 |               1746 |
|      3 |   2003 |               1826 |
|      4 |   2003 |               1820 |
|      5 |   2003 |               1803 |
|      6 |   2003 |               1712 |
|      7 |   2003 |               1989 |
|      8 |   2003 |               1751 |
|      9 |   2003 |               1949 |
|     10 |   2003 |               2101 |
|     11 |   2003 |               1968 |
|     12 |   2003 |               1738 |
|      1 |   2004 |               1921 |
|      2 |   2004 |               1501 |
|      3 |   2004 |               1941 |
|      4 |   2004 |               1852 |
|      5 |   2004 |               1761 |
|      6 |   2004 |               1799 |
|      7 |   2004 |               1920 |
|      8 |   2004 |               1814 |
|      9 |   2004 |               1757 |
|     10 |   2004 |               1878 |
|     11 |   2004 |               1803 |
|     12 |   2004 |               1588 |
|      1 |   2005 |               1587 |
+--------+--------+--------------------+