Skip to content

Instantly share code, notes, and snippets.

@dankohn dankohn/commits.sql
Created Feb 26, 2017

Embed
What would you like to do?
GitHub Commits
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
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.