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
Raw
pull_requests.sql
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
50
Raw
results.csv
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
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment