I was looking at this question: What is the best time to ask questions?, and the thought that popped into my mind was, are certain tags more popular in certain countries than other tags?

For example, does the usage of the Java tag go up or down when it enters a particular timezone, say the West Coast? Looking on Google Trends, while searching for names of programming languages, I have noticed that India is usually the place with the most searches, but after that, it often varies, going to places such as Cuba and the Philippines. Are certain tags more preferred in the US?


If you take the tag the total number of post and comment actions can be obtained by this query and the graph looks like this:

java tag time distribution

So for the java tag we can conclude that between 14:00 and 15:00 UTC is the time that you can expect most activity on posts/comments.

To analyze based on location is less easy because the location field is either empty or the Google geocoder breaks on Somewhere on Earth but nevertheless I created this query that can be used as a starting point for the analysis. I only looked at java badgeholders here.

;with all_loc as (
select  u.location
, count(*) as per_country
from users u 
where u.location is not null
and u.location <> ''
group by u.location
, badge_loc as (
select  u.location
, count(*) as [badges]
from users u 
where exists (select 1 
              from badges 
              where userid = u.id 
              and name ='java')
and u.location is not null
 and u.location <>''
group by u.location 
select a.location
     , a.per_country
     , b.badges
     , cast(b.badges as decimal) 
     / cast(a.per_country as decimal) * 100 as perc
     , (select count(*) 
        from users 
        where location is not null
        and location <> '') as tot_count
from all_loc a
inner join badge_loc b on b.location = a.location

You must log in to answer this question.

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