5

Is it possible to query how many questions per day have been asked on a particular subject on Stackoverflow over a period of time?

For instance, I can use Google Web Trends to compare number of searches per unit time for different search terms, but often the results are skewed because I'm searching for a technology that shares the same name as something else. For instance, searching for 'java vs c#' on Google Web Trends would probably pick up quite a lot of noise as java is also a type of coffee, and c# is a musical note.

This could be a great way to look at what technologies are 'up and coming', and potentially what I should learn next.

9

That's exactly what the data explorer is for.


Edit: Here's a query I put together just now, feeling guilty earning rep for such a trivial answer otherwise. It uses this answer on grouping counts by week as a reference.

DECLARE @Tag nvarchar(25) = '##Tag##';

SELECT
  COUNT(UniqueId), WeekStart
FROM 
(
  SELECT
    Posts.Id AS UniqueId, 
    dateadd(week, datediff(day, '20000109', Posts.CreationDate) / 7, '20000109') AS WeekStart  
  FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.Id
    INNER JOIN Posts ON Posts.Id = PostTags.PostId
  WHERE
    Tags.TagName = @Tag and
    Posts.PostTypeId = 1 -- Questions
) RelevantQuestionsByWeek
GROUP BY WeekStart;

for the tag outputs:

enter image description here

  • Cool, thanks for the link. – rcgeorge23 Feb 10 '14 at 13:30
  • @rcgeorge23 - I edited the answer to include a query you can start with. – Andrew Cheong Feb 10 '14 at 13:51
  • Note that you can simply replace the 7 with any number you want (30 for example), but to do month-by-month breakdowns you'll have to parse the middle two digits of dates, or find some other technique. – Andrew Cheong Feb 10 '14 at 13:59

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