Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/README.md

Last active Oct 7, 2020
Embed
What would you like to do?
Contributor email domain distributions

Contributors by Email Domain

AskGit is a tool looking for more (interesting) use cases. This gist takes a look at the email domains of contributors to two major open source code bases (Linux and Kubernetes). askgit-query.sql can be piped into the askgit command to produce the output in k8s-SHA.txt and linux-SHA.txt

  • Commit Count is the total number of commits by contributors with an email address from Domain
  • Unique Emails is the number of unique contributors with an email from Domain
  • Domain is the email domain
SELECT sum(num) AS commit_count, count(DISTINCT author_email) AS unique_emails, domain FROM (
SELECT
count(*) AS num,
author_email,
substr(author_email, instr(author_email, '@')+1) AS domain
FROM commits GROUP BY author_email ORDER BY count(*) DESC
) GROUP BY domain ORDER BY unique_emails DESC LIMIT 100
+--------------+---------------+--------------------------+
| COMMIT COUNT | UNIQUE EMAILS | DOMAIN |
+--------------+---------------+--------------------------+
| 14400 | 1094 | gmail.com |
| 27604 | 322 | google.com |
| 8858 | 170 | redhat.com |
| 27414 | 158 | users.noreply.github.com |
| 1021 | 69 | vmware.com |
| 823 | 46 | microsoft.com |
| 1443 | 42 | huawei.com |
| 1171 | 38 | zte.com.cn |
| 445 | 35 | qq.com |
| 533 | 32 | intel.com |
| 188 | 31 | hotmail.com |
| 497 | 29 | coreos.com |
| 178 | 29 | 163.com |
| 100 | 27 | outlook.com |
| 134 | 25 | daocloud.io |
| 256 | 22 | us.ibm.com |
| 97 | 21 | amazon.com |
| 95 | 17 | tencent.com |
| 121 | 15 | mirantis.com |
| 144 | 15 | cn.ibm.com |
| 121 | 15 | baidu.com |
| 24 | 11 | yahoo.com |
| 28 | 11 | sap.com |
| 53 | 11 | pivotal.io |
| 430 | 11 | cn.fujitsu.com |
| 180 | 11 | canonical.com |
| 145 | 11 | caicloud.io |
| 58 | 10 | ebay.com |
| 28 | 10 | alauda.io |
| 158 | 9 | zju.edu.cn |
| 91 | 9 | live.com |
| 43 | 9 | docker.com |
| 18 | 9 | 126.com |
| 58 | 8 | suse.com |
| 172 | 8 | mesosphere.io |
| 14 | 8 | ghostcloud.cn |
| 38 | 7 | tigera.io |
| 87 | 7 | qiniu.com |
| 185 | 7 | ibm.com |
| 17 | 7 | hpe.com |
| 67 | 7 | heptio.com |
| 137 | 7 | easystack.cn |
| 31 | 7 | datadoghq.com |
| 50 | 7 | cmss.chinamobile.com |
| 90 | 7 | cisco.com |
| 23 | 7 | apcera.com |
| 19 | 6 | rackspace.com |
| 11 | 6 | me.com |
| 8 | 6 | kinvolk.io |
| 17 | 6 | inspur.com |
| 15 | 6 | est.fujitsu.com |
| 204 | 6 | beyondcent.com |
| 278 | 5 | weave.works |
| 18 | 5 | ts.fujitsu.com |
| 7 | 5 | spotify.com |
| 7 | 5 | samsung.com |
| 40 | 5 | salesforce.com |
| 18 | 5 | metaswitch.com |
| 14 | 5 | linux.com |
| 19 | 5 | india.nec.com |
| 65 | 5 | in.ibm.com |
| 12 | 5 | icloud.com |
| 15 | 5 | foxmail.com |
| 128 | 5 | cloudbasesolutions.com |
| 109 | 5 | apprenda.com |
| 157 | 5 | apache.org |
| 45 | 5 | alibaba-inc.com |
| 10 | 4 | zalando.de |
| 7 | 4 | yeah.net |
| 8 | 4 | vn.fujitsu.com |
| 7 | 4 | squareup.com |
| 15 | 4 | rancher.com |
| 8 | 4 | protonmail.com |
| 29 | 4 | portworx.com |
| 24 | 4 | oracle.com |
| 13 | 4 | lyft.com |
| 192 | 4 | ii.coop |
| 23 | 4 | hp.com |
| 23 | 4 | googlemail.com |
| 19 | 4 | globant.com |
| 14 | 4 | endocode.com |
| 6 | 4 | cern.ch |
| 80 | 4 | amadeus.com |
| 6 | 3 | zlab.co.jp |
| 5 | 3 | wanda.cn |
| 7 | 3 | soundcloud.com |
| 10 | 3 | sky.uk |
| 5 | 3 | netapp.com |
| 3 | 3 | navercorp.com |
| 26 | 3 | jp.fujitsu.com |
| 83 | 3 | infoblox.com |
| 8 | 3 | golang.org |
| 70 | 3 | atlassian.com |
| 26 | 3 | arm.com |
| 2 | 2 | yandex.ru |
| 3 | 2 | windriver.com |
| 37 | 2 | umich.edu |
| 2 | 2 | uk.ibm.com |
| 7 | 2 | twosigma.com |
| 3 | 2 | syseleven.de |
+--------------+---------------+--------------------------+
+--------------+---------------+-----------------------+
| COMMIT COUNT | UNIQUE EMAILS | DOMAIN |
+--------------+---------------+-----------------------+
| 90350 | 5207 | gmail.com |
| 53978 | 1221 | intel.com |
| 52777 | 509 | redhat.com |
| 12262 | 464 | google.com |
| 19500 | 422 | amd.com |
| 6102 | 328 | codeaurora.org |
| 9999 | 304 | huawei.com |
| 10964 | 295 | linux.vnet.ibm.com |
| 14583 | 284 | ti.com |
| 12693 | 278 | samsung.com |
| 5552 | 232 | freescale.com |
| 23531 | 229 | linaro.org |
| 20558 | 208 | linux.intel.com |
| 3362 | 206 | marvell.com |
| 7334 | 201 | broadcom.com |
| 14206 | 185 | oracle.com |
| 5155 | 172 | chromium.org |
| 10517 | 171 | mellanox.com |
| 4632 | 158 | nxp.com |
| 5997 | 153 | nvidia.com |
| 3544 | 142 | gmx.de |
| 2868 | 139 | googlemail.com |
| 8542 | 137 | arm.com |
| 2887 | 132 | us.ibm.com |
| 2092 | 126 | mediatek.com |
| 2857 | 123 | nokia.com |
| 1134 | 108 | stericsson.com |
| 3232 | 105 | linux.ibm.com |
| 2233 | 103 | hp.com |
| 3008 | 102 | qlogic.com |
| 23586 | 98 | kernel.org |
| 19315 | 94 | suse.de |
| 5386 | 93 | canonical.com |
| 2991 | 92 | st.com |
| 5356 | 89 | suse.com |
| 5336 | 88 | de.ibm.com |
| 387 | 87 | yahoo.com |
| 1726 | 83 | cavium.com |
| 2365 | 82 | windriver.com |
| 2649 | 78 | sgi.com |
| 722 | 76 | gmx.net |
| 3359 | 69 | cisco.com |
| 3432 | 67 | cn.fujitsu.com |
| 1273 | 65 | xilinx.com |
| 3323 | 64 | fb.com |
| 530 | 63 | web.de |
| 1259 | 61 | vmware.com |
| 2006 | 60 | synopsys.com |
| 282 | 59 | hotmail.com |
| 5463 | 57 | renesas.com |
| 2315 | 57 | qca.qualcomm.com |
| 1838 | 57 | microchip.com |
| 1627 | 55 | free.fr |
| 498 | 55 | debian.org |
| 540 | 50 | linux.alibaba.com |
| 1595 | 48 | rock-chips.com |
| 2803 | 48 | iki.fi |
| 2407 | 47 | imgtec.com |
| 671 | 44 | mvista.com |
| 1135 | 44 | gentoo.org |
| 1165 | 44 | citrix.com |
| 435 | 42 | csr.com |
| 362 | 41 | mentor.com |
| 2281 | 39 | microsoft.com |
| 1574 | 39 | chelsio.com |
| 520 | 38 | 163.com |
| 608 | 37 | novell.com |
| 645 | 37 | axis.com |
| 517 | 36 | hisilicon.com |
| 356 | 36 | amazon.com |
| 359 | 35 | zte.com.cn |
| 1698 | 35 | users.sourceforge.net |
| 310 | 35 | hpe.com |
| 158 | 35 | fau.de |
| 2046 | 35 | analog.com |
| 436 | 34 | qti.qualcomm.com |
| 1540 | 34 | jp.fujitsu.com |
| 1355 | 34 | collabora.com |
| 1507 | 32 | realtek.com |
| 764 | 32 | mail.ru |
| 177 | 32 | dell.com |
| 146 | 31 | yandex.ru |
| 5214 | 31 | suse.cz |
| 230 | 31 | alliedtelesis.co.nz |
| 5406 | 30 | pengutronix.de |
| 2813 | 30 | netapp.com |
| 2565 | 30 | atmel.com |
| 981 | 29 | tieto.com |
| 1134 | 29 | emulex.com |
| 2613 | 29 | baylibre.com |
| 1036 | 28 | wdc.com |
| 133 | 28 | cypress.com |
| 514 | 28 | caviumnetworks.com |
| 300 | 27 | avagotech.com |
| 299 | 26 | ubuntu.com |
| 173 | 26 | ni.com |
| 469 | 26 | in.ibm.com |
| 550 | 26 | android.com |
| 113 | 25 | unisoc.com |
| 833 | 25 | ericsson.com |
+--------------+---------------+-----------------------+
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.