Stack Overflow query titled as under 1,000 questions a month
Original title: StackOverflow now gets fewer than 1000 questions a month
The pasted Data Explorer output is truncated and the visible rows stop in April 2011, so the recent count is not shown.
A Hacker News item points to a Stack Exchange Data Explorer query that counts Stack Overflow questions by month. The page title says Stack Overflow now gets fewer than 1,000 questions a month. The excerpt lists monthly totals from July 2008 through April 2011 and says 220 rows were returned, without displaying later months.
Unconfirmed: The under-1,000 claim is in the title; the visible results do not include recent months.
- The query groups Posts with PostTypeId 1 by calendar month.
- Visible counts rise from 4 questions in July 2008 to 95,529 in April 2011.
- The result note says 220 rows returned in under 1 ms.
- No month in the pasted table is below 1,000 after July 2008.
- Organizations
- Stack Exchange
From the original article
1 min read at data.stackexchange.comSELECT DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDa... DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) AS [Month], Run Query Cancel Options: - [x] Text-only results - [x] Include execution plan
By babelfish · data.stackexchange.com
A short excerpt; the article and its images belong to the publisher. Summary, key facts and assessment above are AI-written from the article and can be wrong.