BigQuery - number of contributors per project
I'm looking to get some data for my master's thesis on the economic analysis of open source from BigQuery.
I'm hoping to obtain a dataset on Github Archive for the number of contributors (if possible, unique contributors) to each of the top 1000 (or perhaps top 1 million) projects. In doing so, I want to see if there is a scalable limit to the size of open source communities, sort of like a Dunbar's number, though, perhaps not.
What should I write into the query editor to find this dataset, if it is available? Thanks for any assistance or direction.
google-bigquery
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
add a comment |
I'm looking to get some data for my master's thesis on the economic analysis of open source from BigQuery.
I'm hoping to obtain a dataset on Github Archive for the number of contributors (if possible, unique contributors) to each of the top 1000 (or perhaps top 1 million) projects. In doing so, I want to see if there is a scalable limit to the size of open source communities, sort of like a Dunbar's number, though, perhaps not.
What should I write into the query editor to find this dataset, if it is available? Thanks for any assistance or direction.
google-bigquery
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25
add a comment |
I'm looking to get some data for my master's thesis on the economic analysis of open source from BigQuery.
I'm hoping to obtain a dataset on Github Archive for the number of contributors (if possible, unique contributors) to each of the top 1000 (or perhaps top 1 million) projects. In doing so, I want to see if there is a scalable limit to the size of open source communities, sort of like a Dunbar's number, though, perhaps not.
What should I write into the query editor to find this dataset, if it is available? Thanks for any assistance or direction.
google-bigquery
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
I'm looking to get some data for my master's thesis on the economic analysis of open source from BigQuery.
I'm hoping to obtain a dataset on Github Archive for the number of contributors (if possible, unique contributors) to each of the top 1000 (or perhaps top 1 million) projects. In doing so, I want to see if there is a scalable limit to the size of open source communities, sort of like a Dunbar's number, though, perhaps not.
What should I write into the query editor to find this dataset, if it is available? Thanks for any assistance or direction.
google-bigquery
google-bigquery
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
asked Nov 13 '18 at 0:50
Don LimDon Lim
1
1
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25
add a comment |
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272207%2fbigquery-number-of-contributors-per-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272207%2fbigquery-number-of-contributors-per-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
how about googling for something like "BigQuery public dataset for Github Archive"? most likely first few links will give you what you need. so then when you try something and have problem - you can get back here with specific issue and we will help you :o)
– Mikhail Berlyant
Nov 13 '18 at 1:25