Skip to content

Instantly share code, notes, and snippets.

@trevoro
Last active Dec 17, 2015
Embed
What would you like to do?
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