Skip to content

Instantly share code, notes, and snippets.

@caniszczyk caniszczyk/gist:8135894
Last active Jan 1, 2016

Embed
What would you like to do?
List of organizations (top 100) who open sourced the most private repos on GitHub in 2013 (as of Dec 26th)
quickly gathered using the Github Archive data, thanks @igrigorik
http://www.githubarchive.org/
SELECT repository_organization, count(repository_organization) as opens
FROM [githubarchive:github.timeline]
WHERE type="PublicEvent"
AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC("2013-01-01 00:00:00")
GROUP BY repository_organization
ORDER BY opens DESC
LIMIT 100
repository_organization,opens
tuftsdev,245
Esri,114
sparkfun,97
boxen,97
ninja-coders,86
nokia-developer,77
GoogleCloudPlatform,59
spring-guides,54
facebook,54
Appdynamics,51
Omaze,50
heroku,49
railsrumble,48
IDCubed,46
gameclosure,45
crosswalk-project,44
Netflix,42
yahoo,42
paypal,42
shotgunsoftware,40
strongloop,38
prismicio,38
dnanexus,37
Mirantis,37
HubSpot,35
adafruit,34
meedan,34
segmentio,33
kaltura,31
dotcloud,31
liones-php,31
google,31
square,31
rackerlabs,30
Nuevosmedios,30
hackathon-3d,29
CyanogenMod,29
alphagov,29
nko4,29
liquidware,28
01org,27
openlabs,27
bazaarvoice,27
googleplus,27
AgileDiagnosis,27
quarter-spiral,26
economia,26
twitter,25
mcgill-ecse321,25
CrowdProcess,24
zendesk,24
bitmakerlabs,24
mulesoft,24
nprapps,24
splunk,23
awslabs,23
joyent,23
rcbops,23
socrata,22
flatiron-school,22
goinstant,22
linuxdeepin,22
typesafehub,22
CenterForAssessment,22
puppetlabs,22
WindowsAzure-TrainingKit,21
eMicroGraph,21
cloudfoundry,21
WindowsAzure-Samples,21
blackberry,20
mapbox,20
MSOpenTech,20
Hansoft,20
openxc,20
sipwise,20
couchbaselabs,20
godel-design,19
boxuk,19
Microsoft-Web,19
anattadesign,19
mdsol,19
Automattic,18
github,18
UsabilityDynamics,18
apigee,18
WindowsAzure,18
fabrician,18
ioscourse,18
newrelic-platform,18
gridcentric,18
mozilla-japan,18
avadev,18
iSECPartners,17
mongeral-aegon,17
IntersectAustralia,17
swiftstack,17
altairengineering,17
zendtech,17
3dna,17
cloudpassage,17
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.