What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

With Stack Overflow approaching 1.5 million questions, I wonder: Has anyone been collecting a history of the question count? Maybe Jeff has this saved somewhere. ;)

I'm interested because I'd like to see a plot of the growth, preferably with at least a monthly resolution.

Two data points from milestones:

share|improve this question

3 Answers 3

up vote 8 down vote accepted

Here's one I put together when I was trying to compare new sites with the older ones.

year month xcount Graph                           
---- ----- ------ ------------------------------- 
2008 7     5      | 
2008 8     4504   |*
2008 9     15882  |*****
2008 10    15941  |***** 
2008 11    13616  |****                           
2008 12    13058  |****                           
2009 1     17057  |*****                          
2009 2     18700  |******                         
2009 3     21532  |******                         
2009 4     22453  |*******                        
2009 5     27010  |********                       
2009 6     29551  |*********                      
2009 7     33963  |**********                     
2009 8     34129  |**********                     
2009 9     34379  |***********                    
2009 10    37792  |************                   
2009 11    40034  |************                   
2009 12    39373  |************                   
2010 1     46633  |**************                 
2010 2     46590  |**************                 
2010 3     55324  |*****************              
2010 4     54739  |*****************              
2010 5     57139  |******************             
2010 6     61955  |*******************            
2010 7     67309  |*********************          
2010 8     70813  |**********************         
2010 9     68040  |*********************          
2010 10    70823  |**********************         
2010 11    77018  |************************       
2010 12    77387  |************************       
2011 1     88288  |****************************   
2011 2     93279  |******************************
2011 3     72863  |***********************        
share|improve this answer
    
Note for those who aren't familiar with SEDE - you can run the same query on all the sites, just hit the icons or twiddle the url. –  Benjol Apr 5 '11 at 12:48
    
This is great! Can't vote up yet here, but thank you! –  entropo Apr 5 '11 at 16:39

You can use something like this on the Data Explorer.

SELECT
    CONVERT(varchar(4), YEAR(CreationDate)) + '.' + CONVERT(varchar(2), MONTH(CreationDate)),
    COUNT(*)
FROM
    Posts
GROUP BY
    YEAR(CreationDate),
    MONTH(CreationDate)
ORDER BY
    YEAR(CreationDate)*100 + MONTH(CreationDate) ASC

Yes, I know that this is ugly like the night...

share|improve this answer
2  
Here's one I prepared earlier :) –  Benjol Apr 5 '11 at 11:00
    
@Benjol: ... ... ... okay, you win. ;) –  Time Traveling Bobby Apr 5 '11 at 11:04
    
@Benjol: You can post that as an answer of your own, by the way. –  Time Traveling Bobby Apr 5 '11 at 11:44
    
yup.... –  Benjol Apr 5 '11 at 11:49

Here's another example: http://data.stackexchange.com/stackoverflow/s/348/my-money-for-jam

share|improve this answer
    
I'm sorry, but I fail to see how that relates with the question... –  Time Traveling Bobby Apr 8 '11 at 7:11
    
@Bobby: Damn, I think I herped when I should have derped. Must have answered in the wrong tab. @me back and I'll delete. –  Won't Apr 8 '11 at 13:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .