Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/commits_and_authors.sql

Created February 26, 2017 08:19
Show Gist options
  • Save dankohn/b2389bb68f21df3277e5e7182cbe1d05 to your computer and use it in GitHub Desktop.
Save dankohn/b2389bb68f21df3277e5e7182cbe1d05 to your computer and use it in GitHub Desktop.
Download ZIP
Commits and authors
Raw
commits_and_authors.sql
SELECT
repo.name AS repository,
COUNT(repo.name) AS commits,
EXACT_COUNT_DISTINCT(actor.login) AS committers,
EXACT_COUNT_DISTINCT(JSON_EXTRACT(payload, '$.commits[0].author.email')) AS authors
FROM
[githubarchive:year.2016]
WHERE
type IN ("PushEvent")
GROUP BY
repository
HAVING
committers > 10
ORDER BY
authors DESC
LIMIT
50
Raw
results.csv
repository commits committers authors
DefinitelyTyped/DefinitelyTyped 4588 27 2295
caskroom/homebrew-cask 10367 11 1951
neveragaindottech/neveragaindottech.github.io 3257 28 1481
Homebrew/homebrew-core 6668 17 1444
NixOS/nixpkgs 12820 77 1149
facebook/react-native 5028 34 1144
githubschool/open-enrollment-classes-introduction-to-github 3284 983 1002
Azure/azure-content 1932 18 945
saltstack/salt 4690 15 870
kubernetes/kubernetes 8703 59 868
TheOdinProject/curriculum 2649 11 711
hashicorp/terraform 13353 26 702
nodejs/node 4699 72 699
docker/docker 4466 36 671
rails/rails 3400 27 654
ansible/ansible 4204 26 615
JuliaLang/METADATA.jl 2622 37 606
tensorflow/tensorflow 1894 32 599
Homebrew/homebrew 1756 11 575
django/django 2713 21 522
kubernetes/kubernetes.github.io 1529 42 500
ceph/ceph 7190 63 492
ansible/ansible-modules-extras 1511 25 490
servo/servo 16298 15 465
ansible/ansible-modules-core 1796 21 456
elastic/elasticsearch 8029 74 428
apple/swift 8724 75 414
FreeCodeCamp/FreeCodeCamp 1799 21 413
Azure/azure-quickstart-templates 1242 15 413
odoo/odoo 4889 47 411
facebook/react 1738 22 405
fastlane/fastlane 3224 11 390
Automattic/wp-calypso 22655 170 386
turingschool/portfolios 1328 25 367
scikit-learn/scikit-learn 860 15 360
w3c/web-platform-tests 2116 52 359
dotnet/coreclr 3492 92 358
dotnet/corefx 5091 101 356
liferay/liferay-portal 17879 16 352
PokemonGoF/PokemonGo-Bot 2012 41 349
angular/angular 3990 29 340
systemd/systemd 1350 15 336
duckduckgo/zeroclickinfo-goodies 1560 19 332
odoo-dev/odoo 19156 111 328
home-assistant/home-assistant 3372 26 323
turingschool/ruby-submissions 2829 24 321
JuliaLang/julia 7192 45 319
aburasali/cs362sp16 2379 128 311
ampproject/amphtml 3176 24 309
edx/edx-platform 16554 126 308
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment