Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/over_10_contributors.sql

Last active February 26, 2017 05:05
Show Gist options
  • Save dankohn/2e68fbe066ff68c1a0452ee01daa0778 to your computer and use it in GitHub Desktop.
Save dankohn/2e68fbe066ff68c1a0452ee01daa0778 to your computer and use it in GitHub Desktop.
Download ZIP
More than 10 contributors
Raw
over_10_contributors.sql
SELECT
repo.name AS repository,
COUNT(repo.name) AS commits,
EXACT_COUNT_DISTINCT(actor.login) AS contributors
FROM
[githubarchive:year.2016]
WHERE
type IN ("PushEvent")
GROUP BY
repository
HAVING
contributors > 10
ORDER BY
commits DESC
LIMIT
50
Raw
results.csv
repository commits contributors
commitwars/commitwars 36336 58
cloudfoundry/buildpacks-ci 25003 16
Automattic/wp-calypso 22655 170
odoo-dev/odoo 19156 111
e-government-ua/i 18025 84
liferay/liferay-portal 17879 16
edx/edx-platform 16554 126
servo/servo 16298 15
code-dot-org/code-dot-org 15298 25
TonyMiloro/Pr-cticas-Preprofesionales 13830 30
Wikia/app 13625 92
dimagi/commcare-hq 13446 24
hashicorp/terraform 13353 26
NixOS/nixpkgs 12820 77
Pratilipi/pratilipi 11753 17
caskdata/cdap 11515 35
guardian/frontend 10846 75
mantidproject/mantid 10524 47
sauron-demo/sauron-demo 10474 12
caskroom/homebrew-cask 10367 11
facebook/buck 10074 19
CartoDB/cartodb 9896 35
JetBrains/kotlin 9727 29
keybase/client 9384 24
Microsoft/CNTK 9370 77
ethcore/parity 8923 14
exodev/social 8732 25
apple/swift 8724 75
kubernetes/kubernetes 8703 59
Microsoft/vscode 8681 25
h2oai/h2o-3 8642 49
Wikia/mercury 8505 59
department-of-veterans-affairs/vets-website 8177 53
elastic/elasticsearch 8029 74
voidlinux/void-packages 7983 12
exodev/integration 7901 18
eclipse/che 7721 37
mapbox/mapbox-gl-native 7662 41
arangodb/arangodb 7648 17
exodev/ecms 7490 24
akeneo/pim-community-dev 7477 27
ticketmaster-api-staging/ticketmaster-api-staging.github.io 7372 14
ManageIQ/manageiq 7199 22
JuliaLang/julia 7192 45
ceph/ceph 7190 63
exodev/platform 7115 23
gradle/gradle 7098 31
gridgain/apache-ignite 7067 38
dchbx/enroll 7032 32
Automattic/jetpack 6862 52
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment