Skip to content

Instantly share code, notes, and snippets.

@mhawksey

mhawksey/QueryResult.csv

Created January 10, 2022 20:10
Show Gist options
  • Save mhawksey/9b10c1d759bad1bb42d4bbea70bcbbd9 to your computer and use it in GitHub Desktop.
Save mhawksey/9b10c1d759bad1bb42d4bbea70bcbbd9 to your computer and use it in GitHub Desktop.
Download ZIP
Snapshot of view count of Stack Overflow Questions tagged with google-apps-script https://data.stackexchange.com/stackoverflow/query/1539894/tag-views-by-year?Tag=google-apps-script
Raw
QueryResult.csv
year questions answers views
2009 1 4 23934
2010 51 129 651431
2011 72 141 836327
2012 1879 3186 8213291
2013 2601 3837 9766045
2014 2758 3802 7800393
2015 2779 3703 6018356
2016 2885 3615 5284099
2017 3895 4414 5246554
2018 4733 4536 4716497
2019 6614 7044 3422466
2020 7669 8174 2268064
2021 7534 7479 664226
2022 155 126 4419
Raw
StackExchange.sql
select
year(creationdate) as [year],
count(*) as questions,
sum(answercount) as answers,
sum(convert(bigint,viewcount)) as views
from posts
where
Tags LIKE '%##Tag##%'
AND posttypeid=1
group by year(creationdate)
order by year(creationdate)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment