Skip to content

Instantly share code, notes, and snippets.

@trevoro

trevoro/gist:77b237698eec8a2f18c1 Secret

Last active December 17, 2015 22:09
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trevoro/77b237698eec8a2f18c1 to your computer and use it in GitHub Desktop.
Save trevoro/77b237698eec8a2f18c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT max(repository_watchers) as watchers, repository_name, STRFTIME_UTC_USEC(PARSE_UTC_USEC(created_at), "%F") as parsed_date
FROM [githubarchive:github.timeline]
WHERE repository_name IN ("backbone", "spine", "angular.js", "ember.js", "meteor")
AND type = "WatchEvent"
GROUP BY parsed_date, repository_name
ORDER BY parsed_date DESC;
@xdhmoore
Copy link

xdhmoore commented Jan 9, 2014

Thanks for posting this. For anyone else who comes across this, here's a script I made for going from

[watchers, repository_name, parsed_date]

to

[date, backbone count, angular.js count, ember.js count, knockout count]

Note I ran the query with different frameworks.

https://gist.github.com/xdhmoore/2251e24346dc93b25d39

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment