Code Sushi

tasty bits of code rolled and sliced by Mihai

StackOverflow Tag Popularity by Country

StackExchange provides a great little tool called Data Explorer that lets any user run readonly SQL queries on their Q&A sites. I decided to put it to the test and use it to find how many questions got posted from each country for a set of tags. The location information of each question author is declared voluntarily in freeform format. This means the data collected is pretty noisy, if available at all. To map the raw location to a canonical country name I used MapQuest’s open geocoder – one of few such services not placing restrictions on the number of daily requests. Below is the resulting map showing the breakdown of questions by country and tag: