Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/pull_requests.sql

Last active May 21, 2017 00:49
Show Gist options
  • Save dankohn/18f6ef5a16b993d698cfd64a1576f94a to your computer and use it in GitHub Desktop.
Save dankohn/18f6ef5a16b993d698cfd64a1576f94a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. dankohn revised this gist Feb 26, 2017. 2 changed files with 31 additions and 1 deletion.
    2 changes: 1 addition & 1 deletion pull_requests.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -14,4 +14,4 @@ HAVING
    ORDER BY
    pull_requests DESC
    LIMIT
    20
    50
    30 changes: 30 additions & 0 deletions results.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -19,3 +19,33 @@ DefinitelyTyped/DefinitelyTyped,5187,2184
    deadlyvipers/dojo_rules,4849,3046
    dimagi/commcare-hq,4601,31
    rust-lang/rust,4461,703
    cockroachdb/cockroach,4258,70
    dotnet/coreclr,3945,225
    guardian/frontend,3883,82
    cms-sw/cmssw,3842,330
    dotnet/roslyn,3773,149
    nodejs/node,3653,731
    EFForg/https-everywhere,3626,275
    elastic/elasticsearch,3620,436
    mapsme/omim,3473,66
    openshift/origin,3452,184
    Devbootcamp/phase-0-tracks,3400,799
    tgstation/tgstation,3394,156
    octocat/Spoon-Knife,3325,3028
    ampproject/amphtml,3284,289
    ros/rosdistro,3276,248
    udacity/create-your-own-adventure,3230,2625
    laravel/framework,3178,1015
    CleverRaven/Cataclysm-DDA,3178,194
    servo/servo,3126,377
    edx/edx-platform,3106,202
    JuliaLang/METADATA.jl,3096,379
    odoo/odoo,3085,474
    rails/rails,3067,913
    hashicorp/terraform,3036,695
    ansible/ansible,2950,892
    joomla/joomla-cms,2935,270
    facebook/react-native,2837,1171
    grpc/grpc,2820,202
    JuliaLang/julia,2811,275
    Wikia/app,2780,86
  2. dankohn created this gist Feb 26, 2017.
    17 changes: 17 additions & 0 deletions pull_requests.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    SELECT
    repo.name AS repository,
    COUNT(*) AS pull_requests,
    EXACT_COUNT_DISTINCT(actor.login) AS contributors
    FROM
    [githubarchive:year.2016]
    WHERE
    type IN ( 'PullRequestEvent')
    AND JSON_EXTRACT(payload, '$.action') IN ('"opened"')
    GROUP BY
    repository
    HAVING
    contributors > 10
    ORDER BY
    pull_requests DESC
    LIMIT
    20
    21 changes: 21 additions & 0 deletions results.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,21 @@
    repository,pull_requests,contributors
    brianchandotcom/liferay-portal,11954,128
    kubernetes/kubernetes,10909,890
    caskroom/homebrew-cask,10677,1695
    jlord/patchwork,8111,6880
    Homebrew/homebrew-core,7435,1476
    NixOS/nixpkgs,6987,744
    jsdelivr/jsdelivr,6729,416
    code-dot-org/code-dot-org,6308,35
    ManageIQ/manageiq,6194,169
    apache/spark,5878,699
    dotnet/corefx,5782,266
    apple/swift,5644,330
    ceph/ceph,5602,367
    Automattic/wp-calypso,5482,212
    docker/docker,5345,710
    saltstack/salt,5199,671
    DefinitelyTyped/DefinitelyTyped,5187,2184
    deadlyvipers/dojo_rules,4849,3046
    dimagi/commcare-hq,4601,31
    rust-lang/rust,4461,703