Skip to content

Instantly share code, notes, and snippets.

View github_archive_query.sql
/* Fetch data from GitHub Archive using Google's BigQuery */
select actor, repository_language, count(repository_language) as pushes
from [githubarchive:github.timeline]
where type='PushEvent'
and repository_language != ''
and PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-01-01 00:00:00')
and PARSE_UTC_USEC(created_at) < PARSE_UTC_USEC('2013-01-01 00:00:00')
group by actor, repository_language;
keyboardsurfer / .gitignore
Last active Dec 11, 2019
Android gitignore
View .gitignore
# Copyright: Benjamin Weiss (keyboardsurfer)
# Under CC-BY-SA V3.0 (
# built application files
# lint folder