Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/commits_and_authors.sql

Created February 26, 2017 08:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dankohn/b2389bb68f21df3277e5e7182cbe1d05 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dankohn/b2389bb68f21df3277e5e7182cbe1d05 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. dankohn created this gist Feb 26, 2017.
    17 changes: 17 additions & 0 deletions commits_and_authors.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    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
    51 changes: 51 additions & 0 deletions results.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,51 @@
    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