GitHub Public repo history tool

GitHub Public repo history tool

I built this Observable Notebook to run queries against the GH Archive (via ClickHouse) to try to answer questions about repository history - in particular, were they ever made public as opposed to private in the past.

It works by combining together PublicEvent event (moments when a private repo was made public) with the most recent PushEvent event for each of a user's repositories.

Via TIL: Reviewing your history of public GitHub repositories using ClickHouse

clickhouse event github history moments notebook observable projects public queries questions together tool via