Skip to content

Instantly share code, notes, and snippets.

@askmeegs

askmeegs/ghstats-aug20.txt

Created August 16, 2020 13:31
Show Gist options
  • Save askmeegs/c8b2da2e5805685f7992e7c47bb5a875 to your computer and use it in GitHub Desktop.
Save askmeegs/c8b2da2e5805685f7992e7c47bb5a875 to your computer and use it in GitHub Desktop.
Download ZIP
Megan's github stats - Oct '19 - Aug '20
Raw
ghstats-aug20.txt
SELECT repository, type, event AS status, COUNT(*) AS count
FROM (
SELECT type, repo.name as repository, actor.login,
JSON_EXTRACT(payload, '$.action') AS event, created_at
FROM `githubarchive.day.20*`
WHERE actor.login = 'askmeegs' AND
created_at BETWEEN TIMESTAMP('2019-10-19') AND
TIMESTAMP('2020-08-16')
)
GROUP BY repository, type, status ORDER BY repository, type, status;
9 Releases across 1 repos
97 PRs opened across 11 repos
51 PR comments across 4 repos
64 issues opened across 6 repos
31 issues closed across 7 repos
59 issue comments across 11 repos
827 pushes across 39 repos
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment