Skip to content

Instantly share code, notes, and snippets.

@dankohn

dankohn/commits.sql

Created February 26, 2017 03:07
Show Gist options

  • Select an option

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

Select an option

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

Revisions

  1. dankohn created this gist Feb 26, 2017.
    14 changes: 14 additions & 0 deletions commits.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    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
    ORDER BY
    commits DESC
    LIMIT
    100
    101 changes: 101 additions & 0 deletions results.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,101 @@
    repository,commits,contributors
    KenanSulayman/heartbeat,787597,1
    CodePipeline-Test/feature-tests,511568,1
    digimatic/ogre,366729,1
    OpenLocalizationTestOrg/olhandback-e2e,302468,1
    OpenLocalizationTestOrg/olhandoff-e2e,300454,1
    Lombiq/Associativy-Core,244117,1
    Lombiq/Combinator,239424,1
    firehol/blocklist-ipsets,236275,1
    OpenLocalizationTestOrg/ol-test1-handback,235605,1
    OpenLocalizationTestOrg/ol-test1-handoff,234892,1
    direwolf-github/my-app,212486,1
    hqtogit/Combinator,207246,1
    Lombiq/Helpful-Libraries,200267,1
    flameserver/downloads,169549,3
    hqtogit/HelpfulLibraries,165840,1
    teku45/Web-DROP,162597,1
    Lombiq/Helpful-Extensions,159443,1
    OpenLocalizationTestOrg/ol-test1-zhcn,154682,1
    OpenLocalizationTestOrg/ol-test1-dede,154367,1
    Lombiq/Lombiq-Fields,153822,1
    Lombiq/Orchard-Azure-Application-Insights,149865,1
    enkidevs/commit,149170,4
    Lombiq/Associativy-Administration,148657,1
    OpenLocalizationTestOrg/oltest-dede-fly,145853,1
    OpenLocalizationTestOrg/oltest-zhcn-fly,145558,1
    Lombiq/Pretty-Good-Bootstrap-Base-Theme,143680,1
    synkee/monitoring-github,142611,2
    miatribe/pipvpspy,142475,1
    ssbattousai/Cuda14,139818,1
    Door43/d43-en,139411,4
    xheomar/xheomar.github.io,130983,1
    Lombiq/Associativy-Extensions,129577,1
    Lombiq/Associativy-Frontend-Engines,129388,1
    Lombiq/Responsive-Pretty-Good-Base-Theme,126937,1
    Lombiq/Orchard-Simple-Analytics,126855,1
    ssbattousai/Cuda12,126690,1
    ssbattousai/Cuda13,126349,1
    Lombiq/Orchard-Facebook-Suite,126214,1
    toxtli/dailypush,125426,1
    avsm/mirage-ci-logs,125343,1
    Lombiq/Orchard-Theme-Override,124865,1
    Lombiq/Pretty-Good-Base-Theme,124494,1
    Lombiq/Orchard-Liquid-Markup,124160,1
    Lombiq/Orchard-Avatars,121090,1
    Lombiq/Associativy-Notions-Demo-Instance,120059,1
    Lombiq/Orchard-User-Notifications,119959,1
    Lombiq/Orchard-Distributed-Events,118788,1
    Lombiq/Orchard-Download-As,118272,1
    Lombiq/Orchard-BBCode,117350,1
    Lombiq/Orchard-Target-Blank,116514,1
    ssbattousai/Cuda11,115368,1
    ssbattousai/Cuda15,115106,1
    Lombiq/Associativy-Wikipedia-Instance,112997,1
    Lombiq/Orchard-External-Pages,111216,1
    Lombiq/Orchard-Ace-Editor,110641,1
    Lombiq/Orchard-Azure-Indexing,110133,1
    ryanniehaus/open_source_package_builder,109647,1
    micahwhitetech/VaultData81,106142,1
    Lombiq/Orchard-Facebook-Suite-Connect,103737,1
    Lombiq/Associativy-Tag-Nodes,103066,1
    Lombiq/Associativy-Web-Services,102984,1
    keum/data_display,102669,1
    Lombiq/Associativy-Neo4j-Driver,101647,1
    Lombiq/Smart-Notifications,101210,1
    Lombiq/Orchard-Abstractions,100673,1
    Lombiq/Combinator-CoffeeScript-Preprocessor,100663,1
    Lombiq/Orchard-Scripting-Extensions-PHP,100595,1
    Lombiq/Orchard-Recipe-Remote-Executor,100592,1
    Lombiq/Orchard-Security,100278,1
    suzutan0s2/contribution-calender,99076,1
    Lombiq/Orchard-Token-Title,97946,1
    Lombiq/Orchard-Training-Demo-Module,97772,2
    Lombiq/Orchard-Scripting-Extensions,97763,1
    Lombiq/Orchard-Watcher,97693,1
    Lombiq/Orchard-Shoutbox,97600,1
    Lombiq/Orchard-Route-Permissions,97168,1
    Lombiq/Associativy-Tags-Adapter,96883,1
    jikker/lineage_monitor,96820,1
    Lombiq/Associativy-Internal-Link-Graph-Builder,96701,1
    Lombiq/Associativy-Frontend-Engines-Administration,96665,1
    ICGC-TCGA-PanCancer/ceph_transfer_ops,96646,6
    Lombiq/Orchard-Antispam,96585,1
    OpenLocalizationTestOrg/oltest,96398,1
    Lombiq/Associativy-Taxonomies-Adapter,95504,1
    ssbattousai/Cuda16,94554,1
    Lombiq/Orchard-Login-as-Anybody,94265,1
    Lombiq/Orchard-Read-only,94198,1
    Lombiq/Combinator-TypeScript-Preprocessor,94149,1
    Lombiq/Orchard-Background-Task-Viewer,94143,1
    Lombiq/Orchard-Confirm-Leave,94090,1
    Lombiq/Orchard-Abstractions-Examples,94074,1
    Lombiq/Orchard-Scripting-Extensions-JavaScript,94063,1
    Lombiq/Orchard-Scripting-Extensions-DotNet,94046,1
    Lombiq/Orchard-Content-Types,93881,1
    Lombiq/Orchard-RestSharp,93192,1
    Lombiq/Orchard-Module-Profiles,92857,1
    Lombiq/Orchard-Content-Widgets,92657,1
    ssbattousai/Cuda19,91739,1
    Lombiq/Orchard-Facebook-SDK,90858,1
    Lombiq/Pretty-Good-Bootstrap-Base-Theme-Sample,90204,1