Skip to content

Instantly share code, notes, and snippets.

@abo-abo

abo-abo/query.sql

Last active September 8, 2020 08:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abo-abo/9607099 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abo-abo/9607099 to your computer and use it in GitHub Desktop.
Download ZIP
Use https://developers.google.com/bigquery/ to select top 100 repos by number of commits
Raw
query.sql
select repository_name, count(repository_name) as pushes, repository_description, repository_url
from [githubarchive:github.timeline]
where type="PushEvent"
and repository_language="Emacs Lisp"
and parse_utc_usec(created_at) >= parse_utc_usec('2014-01-01 00:00:00')
group by repository_name, repository_description, repository_url
order by pushes desc
limit 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment