Skip to content

Instantly share code, notes, and snippets.

@caniszczyk
Last active January 1, 2016 11:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save caniszczyk/8135894 to your computer and use it in GitHub Desktop.
Save caniszczyk/8135894 to your computer and use it in GitHub Desktop.
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