# 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-2005) SourceForge Available at: # http://ossmole.sourceforge.net # # This particular file is a list of the registration dates for each project. # This report includes both monthly and yearly totals. # 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 !="" AND date_registered !=0 # GROUP BY year Here is the yearly report as of the April, 2005 run: year number of projects 1999 1298 2000 16977 2001 49041 2002 64807 2003 67082 2004 63935 2005 7582 Here is the yearly report as of the January, 2005 run: +--------+--------------------+ | 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 != "" AND date_registered !=0 # GROUP BY year, month Here is the monthly report as of the April 2005 run: month year number of projects 11 1999 197 12 1999 235 1 2000 480 2 2000 422 3 2000 455 4 2000 405 5 2000 440 6 2000 417 7 2000 483 8 2000 532 9 2000 456 10 2000 571 11 2000 529 12 2000 464 1 2001 620 2 2001 1323 3 2001 1733 4 2001 1467 5 2001 1433 6 2001 1371 7 2001 1524 8 2001 1539 9 2001 1286 10 2001 1430 11 2001 1268 12 2001 1286 1 2002 1801 2 2002 1766 3 2002 1789 4 2002 2006 5 2002 1752 6 2002 1666 7 2002 1882 8 2002 1716 9 2002 1793 10 2002 1966 11 2002 1735 12 2002 1658 1 2003 2016 2 2003 1737 3 2003 1814 4 2003 1810 5 2003 1790 6 2003 1702 7 2003 1971 8 2003 1740 9 2003 1936 10 2003 2083 11 2003 1953 12 2003 1725 1 2004 1908 2 2004 1495 3 2004 1931 4 2004 1844 5 2004 1753 6 2004 1792 7 2004 1904 8 2004 1804 9 2004 1744 10 2004 1902 11 2004 1841 12 2004 1617 1 2005 1918 2 2005 1933 3 2005 1946 4 2005 197 Here is the monthly report as of the January 2005 run: +--------+--------+--------------------+ | 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 | +--------+--------+--------------------+