Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/by_commit.sql

Created February 26, 2017 06:06
Show Gist options
  • Save dankohn/82ba35375219eb512da5a7de2460cc3a to your computer and use it in GitHub Desktop.
Save dankohn/82ba35375219eb512da5a7de2460cc3a to your computer and use it in GitHub Desktop.
Download ZIP
By commit
Raw
by_commit.sql
SELECT
repo_name AS repository,
EXACT_COUNT_DISTINCT(author.name) AS authors,
EXACT_COUNT_DISTINCT(committer.name) AS committers,
COUNT(*) AS commits
FROM
[bigquery-public-data:github_repos.commits]
WHERE
committer.date >= TIMESTAMP("2016-01-01 00:00:00")
AND committer.date < TIMESTAMP("2017-01-01 00:00:00")
GROUP BY
repository
ORDER BY
authors DESC
LIMIT
50
Raw
results.csv
repository authors committers commits
jlord/patchwork 5913 5867 23212
valterlucena/patchwork 5328 5290 21152
spacehaven/patchwork 4766 4739 18720
albsierra/patchwork 4645 4623 18185
elzbeth/patchwork 4303 4285 16592
diegobust4545/patchwork 4270 4252 16439
Soumya08pragya/patchwork 4178 4161 15987
sergey-senozhatsky/linux-next-ss 4066 276 77424
ColinIanKing/linux-next-mirror 4063 276 77278
Reichl/linux-odroid 4063 276 77277
jpirko/linux_mlxsw 4037 273 76463
bendikro/net-next 4037 273 76462
mkahola/drm-intel-mika 4037 273 76763
alaahl/linux 4037 273 76465
rib/linux 4037 273 76763
sourabgu/linux 4035 273 76677
openSUSE/kernel 4035 293 76765
davidker/unisys 4033 273 76364
jeffmerkey/linux-stable 4031 275 76363
jeffmerkey/linux 4031 275 76707
iQuestria/linux 4030 275 76334
NigelCunningham/tuxonice-kernel 4030 276 76351
reinforce/linux-sunxi 4030 273 76379
sfjro/aufs4-linux 4030 274 76376
Endika/linux 4030 275 76349
masami256/linux 4030 274 76343
KutuSystems/linux 4030 274 76344
mvduin/linux 4030 274 76447
LeoK12/linux 4029 273 76330
tombriden/linux 4029 273 76332
maurossi/linux 4029 273 76329
pratyushanand/linux 4029 273 76312
lfd/PreemptRT 4029 273 76329
Noltari/linux 4029 273 76332
ajdiaz/linux 4029 273 76330
ceph/ceph-client 4029 273 76299
PKRoma/linux 4029 273 76332
dledford/linux 4029 273 76332
djwong/linux 4029 273 76330
francois-wellenreiter/linux 4029 273 76312
kdave/btrfs-devel 4029 273 76332
kronat/linux 4029 273 76332
rhvgoyal/linux 4029 273 76330
RobertCNelson/linux-stable-rcn-ee 4029 273 76332
jh80chung/dw-mmc 4029 273 76332
AlbanBedel/linux 4029 273 76332
phhusson/linux 4029 273 76329
zhiyisun/linux 4029 273 76332
backbone/backbone-sources 4029 273 76332
akhandual/linux 4029 273 76330
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment