Skip to content

Instantly share code, notes, and snippets.

@paulrossman

paulrossman/forkcount.sql

Created October 20, 2015 06:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save paulrossman/34791dac81c3a6c612b6 to your computer and use it in GitHub Desktop.
Save paulrossman/34791dac81c3a6c612b6 to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery sql for GitHub Archive dataset: fork count per repo
Raw
forkcount.sql
/* fork count per repo */
SELECT
REGEXP_REPLACE(repo.name, 'MyOrg/', '') AS repo,
COUNT (*) AS cnt
FROM (
SELECT
type,
repo.name,
FROM
TABLE_DATE_RANGE([githubarchive:day.events_], TIMESTAMP('2015-01-01'), TIMESTAMP('2015-10-15') )
WHERE
type = 'ForkEvent'
AND repo.name CONTAINS 'MyOrg/'
AND NOT REGEXP_MATCH(repo.name,'^MyOrg/SomeRepo$') )
GROUP BY
repo
ORDER BY
cnt DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment