top projects per country, no matter where stars are coming from
Got it. Don’t you think we are missing this information as well: top projects per country, no…
Igor
1

That would be awesome. I did one analysis, but I’ll be very happy to see different analysis from different people. The alternatives are endless, we only need more hands.

For example, what else did the starrers of ‘oblac/jodd’ star in 2016?

GitHub users who starred ‘oblac/jodd’. What else did they star in 2016?
#standardSQL
SELECT repo, COUNT(*) c FROM (
SELECT actor.login, ARRAY_AGG(DISTINCT repo.name) repos
FROM `githubarchive.year.2016`
WHERE type="WatchEvent" GROUP BY 1
HAVING ARRAY_LENGTH(repos) BETWEEN 3 AND 30000 # if you star too much, your vote doesn't count
AND 'oblac/jodd' IN UNNEST(repos)
), UNNEST(repos) repo
GROUP BY 1 ORDER BY 2 DESC
LIMIT 30
Show your support

Clapping shows how much you appreciated Felipe Hoffa’s story.