Skip to content

Instantly share code, notes, and snippets.

@dissolved
Last active February 14, 2017 03:37
Show Gist options
  • Save dissolved/14cdd8db8f021ba5ff0e to your computer and use it in GitHub Desktop.
Save dissolved/14cdd8db8f021ba5ff0e to your computer and use it in GitHub Desktop.
Number of Events for Active Github Repos (1st Half 2015)

Data Source Information

This CSV file was created using Google interactive query interface BigQuery to access the Github Archive. The query used to generate this file is:

SELECT
  repo.name,
  COUNT(repo.name) AS total_events,
  SUM(CASE WHEN type = 'CommitCommentEvent' THEN 1 ELSE 0 END) commit_comment_count,
  SUM(CASE WHEN type = 'CreateEvent' THEN 1 ELSE 0 END) create_count,
  SUM(CASE WHEN type = 'DeleteEvent' THEN 1 ELSE 0 END) delete_count,
  SUM(CASE WHEN type = 'ForkEvent' THEN 1 ELSE 0 END) fork_count,
  SUM(CASE WHEN type = 'GollumEvent' THEN 1 ELSE 0 END) gollum_count,
  SUM(CASE WHEN type = 'IssueCommentEvent' THEN 1 ELSE 0 END) issue_comment_count,
  SUM(CASE WHEN type = 'IssuesEvent' THEN 1 ELSE 0 END) issues_count,
  SUM(CASE WHEN type = 'MemberEvent' THEN 1 ELSE 0 END) member_count,
  SUM(CASE WHEN type = 'PublicEvent' THEN 1 ELSE 0 END) public_count,
  SUM(CASE WHEN type = 'PullRequestEvent' THEN 1 ELSE 0 END) pull_request_count,
  SUM(CASE WHEN type = 'PullRequestReviewCommentEvent' THEN 1 ELSE 0 END) pull_request_review_comment_count,
  SUM(CASE WHEN type = 'PushEvent' THEN 1 ELSE 0 END) push_count,
  SUM(CASE WHEN type = 'ReleaseEvent' THEN 1 ELSE 0 END) release_count,
  SUM(CASE WHEN type = 'WatchEvent' THEN 1 ELSE 0 END) watch_count,
FROM (TABLE_DATE_RANGE([githubarchive:day.events_], TIMESTAMP('2015-01-01'), TIMESTAMP('2015-06-30') ))
GROUP BY
  repo.name
ORDER BY
  total_events DESC
LIMIT
  100;
repo_name total_events commit_comment_count create_count delete_count fork_count gollum_count issue_comment_count issues_count member_count public_count pull_request_count pull_request_review_comment_count push_count release_count watch_count
direwolf-github/my-app 292774 0 106493 106479 1 0 0 0 0 0 2 0 79799 0 0
KenanSulayman/heartbeat 262713 0 0 0 0 0 0 0 0 0 0 0 262711 0 2
sakai-mirror/melete 127619 0 0 0 0 0 0 0 0 0 0 0 127619 0 0
apache/spark 99937 151 34 18 2188 0 67801 0 0 0 6582 16799 4013 0 2351
GoogleCloudPlatform/kubernetes 86961 216 195 134 1249 33 47336 4950 0 0 9300 16184 4002 37 3325
greatfire/wiki 79871 1 0 0 439 11 282 62 2 0 0 0 77532 0 1542
ashking/phnest 74172 0 0 0 0 0 0 0 0 0 0 0 74172 0 0
rust-lang/rust 73616 1614 19 19 1139 92 37304 6311 0 0 6786 5374 10198 0 4760
docker/docker 64296 79 37 24 2344 32 37229 3960 0 0 5085 8057 1890 0 5559
owncloud/core 62750 222 1606 1513 286 302 42470 4945 0 0 3400 3486 3863 0 657
Door43/d43-en 62067 0 0 0 1 0 0 0 0 0 0 0 62066 0 0
brianchandotcom/liferay-portal 53154 57 13035 12972 0 0 13395 0 0 0 9679 11 4004 0 1
cms-sw/cmssw 52854 26 4868 3703 378 0 31312 294 0 0 5613 1731 4736 132 61
No-CQRT/GooGuns 51923 0 0 0 0 0 0 51923 0 0 0 0 0 0 0
edx/edx-platform 51410 691 2225 2235 337 221 13996 0 0 0 4686 14612 11993 1 413
jtleek/datasharing 50879 2 0 0 49214 0 19 3 0 0 172 0 0 0 1469
chrsmith/bwapi 50550 0 58 0 0 0 38277 12181 33 0 0 0 1 0 0
Homebrew/homebrew 48371 363 14 14 2682 0 18701 2242 0 0 9383 7541 3836 0 3595
CodePipeline-Test/feature-tests 46952 0 12800 12717 0 0 0 0 0 0 0 0 21435 0 0
wmst/wmidbot 45929 0 0 0 1 0 0 0 0 0 0 0 45928 0 0
cn-nytimes/mirrors 43398 0 0 0 29 0 0 2 0 0 0 0 43246 0 121
pbaffiliate1/testRepository 41872 0 3 0 0 0 0 0 0 0 0 0 41869 0 0
chrsmith/google-api-java-client 41335 0 478 0 0 0 21416 19420 21 0 0 0 0 0 0
pbaffiliatetwoop/testRepository 40954 0 5 1 0 0 0 0 0 0 0 0 40948 0 0
openshift/origin 39062 89 27 34 196 0 23334 1808 0 0 3755 7839 1639 21 320
mozilla-b2g/gaia 37815 26 1093 1063 421 0 12428 0 0 0 8797 8811 5011 0 165
JuliaLang/julia 37266 1546 646 602 382 0 22529 2437 0 0 2319 2515 3244 8 1038
tgstation/-tg-station 36077 22 18 12 292 7 24298 3156 0 0 4054 2635 1505 0 78
dchekhonin/testDM 35354 0 14383 14290 1 0 0 0 5 0 0 0 6675 0 0
greatfire/feeds 35056 0 2 0 7 0 0 0 0 0 0 0 35045 0 2
saltstack/salt 35045 113 37 33 652 3 17862 3607 0 0 7629 781 3341 7 980
codeaurora-unoffical/platform-frameworks-opt-telephony 34793 0 17891 16514 0 0 0 0 0 0 0 0 388 0 0
xenim/livestatus-publicpage 34491 0 0 0 0 0 0 0 0 0 0 0 34491 0 0
caskdata/cdap 33489 193 2254 2262 18 0 5199 0 0 0 4418 9887 9211 9 38
dotnet/roslyn 32963 53 31 18 664 65 15134 3309 0 1 3451 5874 1669 2 2692
zx2c4/OpenBSC 32264 0 32264 0 0 0 0 0 0 0 0 0 0 0 0
atom/atom 31555 116 409 353 1778 0 12639 4229 0 0 994 879 2795 47 7316
git-game/git-game-v2 30745 0 20150 10042 9 0 2 2 0 0 2 0 251 0 287
pgroudas/tc_many_branches 30004 0 30002 0 0 0 0 0 0 0 0 0 2 0 0
rdpeng/ProgrammingAssignment2 29884 21 0 0 28960 0 49 12 0 0 628 2 0 0 212
facebook/react-native 29844 71 51 24 2026 0 7819 1868 0 1 1182 523 491 21 15767
keum/data_display 29521 0 1 0 2 0 0 3 0 0 0 0 29515 0 0
simonAllier/benoit-exp-result 29133 0 2 0 0 0 0 0 2 0 0 0 29129 0 0
forgescan/forgescan.github.io 29006 0 3 0 0 0 0 0 0 0 0 0 29003 0 0
servo/servo 28830 4207 100 101 304 158 11916 1171 0 0 2863 325 5950 0 1735
octocat/Spoon-Knife 28596 68 0 0 25051 3 328 90 0 0 2645 28 0 0 383
simonAllier/sosie-exp 27998 0 0 0 0 0 0 0 0 0 0 0 27998 0 0
angular/angular.js 27945 182 41 20 5411 26 8217 1867 0 0 1397 1315 1398 0 8071
iojs/io.js 27210 150 68 42 710 16 13955 1228 0 0 1633 2608 731 0 6069
codeaurora-unoffical/platform-packages-apps-Dialer 26592 0 13868 12493 0 0 0 0 0 0 0 0 231 0 0
rails/rails 26180 460 51 25 2048 0 10654 1687 0 0 3424 2779 2072 0 2980
twbs/bootstrap 25994 137 143 144 6803 0 5925 1656 3 0 948 305 636 3 9291
Microsoft/TypeScript 25972 1374 582 565 432 268 9964 2767 0 0 1323 3917 1990 3 2787
codeaurora-unoffical/platform-frameworks-base 25865 0 22846 2077 2 0 0 0 0 0 0 0 940 0 0
greatfire/z 25792 0 0 0 17 0 1 3 3 0 0 0 25748 0 20
facebook/react 25767 32 16 9 2077 436 6505 1285 0 0 1523 913 782 11 12178
miabot/galleries.csv 25748 25643 0 0 0 0 0 0 0 0 0 0 105 0 0
NixOS/nixpkgs 24931 1352 41 49 386 0 10456 1416 0 0 4515 1400 5044 0 272
InternetDevels/drupalcores 24159 0 0 0 0 0 0 0 0 0 0 0 24159 0 0
ManageIQ/manageiq 23332 26 9 4 54 0 13574 553 0 0 3500 4005 1555 0 52
rydnr/.sails-platzi.rt 22586 0 2 0 0 0 0 0 0 0 0 0 22584 0 0
dimagi/commcare-hq 22565 405 1853 1650 9 0 5008 5 0 0 4295 3678 5654 0 8
Wikia/app 22528 1735 2415 2008 21 0 2575 0 0 0 3662 3609 6490 0 13
openstack/openstack 22204 1 0 0 245 0 2 0 0 0 4 0 21552 0 400
qdm/qdm.github.io 22055 0 0 0 0 0 0 0 0 0 0 0 22055 0 0
CartoDB/cartodb 21726 115 1010 706 66 113 9072 3005 0 0 1948 1377 4122 1 191
codeaurora-unoffical/platform-packages-apps-Mms 21320 0 20807 0 0 0 0 0 0 0 0 0 513 0 0
elastic/elasticsearch 21191 51 38 37 756 0 7847 1828 0 0 1974 4500 2405 0 1755
Khan/khan-i18n 21014 0 0 0 2 0 7 21003 0 0 0 0 0 0 2
codeaurora-unoffical/platform-packages-apps-Contacts 20879 0 20559 0 0 0 0 0 0 0 0 0 320 0 0
pbaffiliate1/repoForTest 20877 0 4 0 0 0 0 0 0 0 0 0 20873 0 0
angular/material 20794 348 164 108 993 0 8195 3776 0 0 738 727 2154 0 3591
symfony/symfony 20788 111 34 10 794 0 9697 1412 0 0 2582 3594 1282 0 1272
codeaurora-unoffical/packages-providers-TelephonyProvider 20655 0 20535 0 0 0 0 0 0 0 0 0 120 0 0
golang/go 20632 28 502 507 666 382 8222 3774 0 0 34 0 2327 0 4190
greatfire/images 20540 0 2 0 10 1 0 0 0 0 0 0 20521 0 6
codeaurora-unoffical/platform-packages-apps-Settings 20201 0 19727 0 0 0 0 0 0 0 0 0 474 0 0
cdtmirrors/m 20140 0 2 0 3 1 1 1 1 0 0 0 20131 0 0
codeaurora-unoffical/packages-services-Telephony 20084 0 10419 9361 0 0 0 0 0 0 0 0 304 0 0
ceph/ceph 20067 425 791 644 351 0 9279 0 0 0 3634 1256 3305 0 382
gorhill/uBlock 19992 340 296 336 347 1067 6085 2076 2 0 211 0 1423 260 7549
angular/angular 19990 143 77 50 1033 12 6414 2214 0 0 2521 2674 1301 0 3551
dotnet/corefx 19867 124 22 19 898 127 8334 1314 0 0 2119 3749 959 2 2200
neovim/neovim 19844 147 3 4 390 396 9871 1067 0 0 1140 3192 435 0 3199
chrsmith/html5rocks 19787 0 403 0 0 0 10853 8520 11 0 0 0 0 0 0
yiisoft/yii2 19713 252 33 20 1641 14 9618 2798 0 0 1570 886 981 3 1897
travis-repos/chirp-org-production 19684 0 5 0 0 0 0 0 0 0 0 0 19679 0 0
laravel/framework 19535 481 50 8 1161 0 8965 2054 0 0 3080 1556 1194 0 986
odoo/odoo 19527 445 14 13 1089 59 6077 1628 0 0 3331 3564 2201 0 1106
spyder-ide/spyder 19425 13 16 5 114 426 12880 4369 0 0 171 833 194 7 397
freeweibo/s 19406 0 2 0 0 0 0 0 1 0 0 0 19403 0 0
xbmc/xbmc 19403 389 17 8 528 0 11865 58 0 0 2539 2375 1107 8 509
maomihz/MyBlog 19302 0 0 0 0 0 0 0 0 0 0 0 19302 0 0
influxdb/influxdb 19254 60 812 768 324 1 6059 1913 0 0 1928 2329 3255 0 1805
joomla/joomla-cms 19003 104 21 11 379 0 12706 1379 0 0 2095 787 1257 10 254
BrewTestBot/homebrew 18879 0 7502 3426 0 0 0 0 0 0 0 0 7951 0 0
paopaonetizen/website 18848 0 2 0 8 1 2 2 1 0 0 0 18826 0 6
aspnet/Mvc 18729 221 517 534 403 2 4341 1108 0 0 1069 7382 2315 5 832
caskroom/homebrew-cask 18728 52 54 41 1106 0 4865 895 0 0 6486 886 2897 9 1437
codeaurora-unoffical/platform-packages-apps-Email 18720 0 18716 0 0 0 0 0 0 0 0 0 4 0 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment