5.7.1.2.3. View all users who starred a repository on GitHub including those who unstarred
The Chilling effect (寒蝉效应) is extremelly visible on GitHub.
Ciro Santilli (三西猴, anti-CCP fanatic, 反中共狂热, stupid cunt, 傻屄, CIA agent, CIA特工, 肏你妈的) is able to see this easily because the star notification remains in the GitHub dashboard even after unstarring.
However, star events are also publicly visible permanently on events API under the WatchEvent: https://docs.github.com/en/developers/webhooks-and-events/events/github-event-types#watchevent
This appears to get them all from GitHub Archive's Google BigQuery up to the last whole month:
SELECT actor.login, MAX(created_at)
FROM `githubarchive.month.*`
WHERE type = 'WatchEvent'
AND repo.name = 'cirosantilli/china-dictatorship'
GROUP BY actor.login
ORDER BY MAX(created_at) DESC
Ciro verified that does include people who unstarred.
That one exceeds the free data limits as of December 2021 however, so you need to select more specific months/years at a time. Note that year data is only released once every year.
The following ranges manage to get all data as December 2021 for free:
FROM `githubarchive.year.201*`
FROM `githubarchive.year.202*`
FROM `githubarchive.month.2021*`
supposing that unique starrers
You can then "Save results" as CSV to view all users.
There don’t appear to be unstar events however. You can see single people star multiple times, which means that each new star gives a new row, which is why we do the GROUP BY.
The Chilling effect (寒蝉效应) is extremelly visible on GitHub.
Ciro Santilli (三西猴, anti-CCP fanatic, 反中共狂热, stupid cunt, 傻屄, CIA agent, CIA特工, 肏你妈的) is able to see this easily because the star notification remains in the GitHub dashboard even after unstarring.
However, star events are also publicly visible permanently on events API under the WatchEvent: https://docs.github.com/en/developers/webhooks-and-events/events/github-event-types#watchevent
This appears to get them all from GitHub Archive's Google BigQuery up to the last whole month:
SELECT actor.login, MAX(created_at) FROM `githubarchive.month.*` WHERE type = 'WatchEvent' AND repo.name = 'cirosantilli/china-dictatorship' GROUP BY actor.login ORDER BY MAX(created_at) DESC
Ciro verified that does include people who unstarred.
That one exceeds the free data limits as of December 2021 however, so you need to select more specific months/years at a time. Note that year data is only released once every year.
The following ranges manage to get all data as December 2021 for free:
FROM `githubarchive.year.201*` FROM `githubarchive.year.202*` FROM `githubarchive.month.2021*`
supposing that unique starrers
You can then "Save results" as CSV to view all users.
There don’t appear to be unstar events however. You can see single people star multiple times, which means that each new star gives a new row, which is why we do the GROUP BY.