search

CulturedCheese / thesis-project

4 stars 4 forks source link

Get sample data from BigQuery #8

Closed ClimbsRocks closed 9 years ago

ClimbsRocks commented 9 years ago

A list of repos by language for the month of January. Aggregated to the country level if possible. Definitely aggregated to the location level.

ClimbsRocks commented 9 years ago

Here's the sample query. Saving here because BigQuery is non-responsive.

select repository_url, repository_language, actor_attributes_login, actor_attributes_location from [githubarchive:month.201412] where ( type = 'PushEvent' OR type = 'ForkEvent' OR (type = 'IssuesEvent' AND (payload_action="opened" OR payload_action=="reopened")) OR (type = 'CreateEvent' AND payload_ref_type="repository") OR type = 'WatchEvent' ) AND repository_language !='' AND repository_url != '' group by repository_url, repository_language, actor_attributes_login, actor_attributes_location

ClimbsRocks commented 9 years ago

got it! and saved to google cloud storage.