Megan's github stats - Oct '19 - Aug '20

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