# github-explorer

**Repository Path**: mirrors_ClickHouse/github-explorer

## Basic Information

- **Project Name**: github-explorer
- **Description**: Everything You Always Wanted To Know About GitHub (But Were Afraid To Ask)
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-10-22
- **Last Updated**: 2026-01-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

We prepared a dataset from the [GH Archive](https://www.gharchive.org/) that contains all the events in all GitHub repositories since 2011 in a structured format. The dataset was uploaded into [ClickHouse](https://clickhouse.tech/), where it contains 3.1 billion records. We redistribute it for research purposes and it can be downloaded at this [direct link](https://ghe.clickhouse.tech/#download-the-dataset). This dataset can help answer almost any question about GitHub that you can imagine.

- [Counting stars](https://ghe.clickhouse.tech/#counting-stars)
- [Top repositories by stars](https://ghe.clickhouse.tech/#top-repositories-by-stars)
- [Distribution of repositories by star count](https://ghe.clickhouse.tech/#distribution-of-repositories-by-star-count)
- [The total number of repositories on GitHub](https://ghe.clickhouse.tech/#the-total-number-of-repositories-on-github)
- [How has the list of top repositories changed over the years?](https://ghe.clickhouse.tech/#how-has-the-list-of-top-repositories-changed-over-the-years)
- [How has the total number of stars changed over time?](https://ghe.clickhouse.tech/#how-has-the-total-number-of-stars-changed-over-time)
- [Who are all those people giving stars?](https://ghe.clickhouse.tech/#who-are-all-those-people-giving-stars)
- [Repository affinity list](https://ghe.clickhouse.tech/#repository-affinity-list)
- [Finding friends through counting stars](https://ghe.clickhouse.tech/#finding-friends-through-counting-stars)
- [Affinity by issues and PRs](https://ghe.clickhouse.tech/#affinity-by-issues-and-prs)
- [Repositories with the most stars over one day](https://ghe.clickhouse.tech/#epositories-with-the-most-stars-over-one-day)
- [Repositories with the highest growth YoY](https://ghe.clickhouse.tech/#repositories-with-the-highest-growth-yoy)
- [Repositories with the worst stagnation](https://ghe.clickhouse.tech/#repositories-with-the-worst-stagnation)
- [Repositories with the most steady growth over time](https://ghe.clickhouse.tech/#repositories-with-the-most-steady-growth-over-time)
- [What is the best day of the week to catch a star?](https://ghe.clickhouse.tech/#what-is-the-best-day-of-the-week-to-catch-a-star)
- [The total number of users on GitHub](https://ghe.clickhouse.tech/#the-total-number-of-users-on-github)
- [Stars from heavy GitHub users](https://ghe.clickhouse.tech/#stars-from-heavy-github-users)
- [Repositories with the maximum amount of pull requests](https://ghe.clickhouse.tech/#repositories-with-the-maximum-amount-of-pull-requests)
- [Repositories with the maximum amount of issues](https://ghe.clickhouse.tech/#repositories-with-the-maximum-amount-of-issues)
- [Repositories with the most people who have push access](https://ghe.clickhouse.tech/#repositories-with-the-most-people-who-have-push-access)
- [Repositories with the maximum number of accepted invitations](https://ghe.clickhouse.tech/#repositories-with-the-maximum-number-of-accepted-invitations)
- [Most forked repositories](https://ghe.clickhouse.tech/#most-forked-repositories)
- [Proportions between stars and forks](https://ghe.clickhouse.tech/#proportions-between-stars-and-forks)
- [Issues with the most comments](https://ghe.clickhouse.tech/#issues-with-the-most-comments)
- [Top commented issues for each of the top repositories](https://ghe.clickhouse.tech/#top-commented-issues-for-each-of-the-top-repositories)
- [Commits with the most comments](https://ghe.clickhouse.tech/#commits-with-the-most-comments)
- [The most tough code reviews](https://ghe.clickhouse.tech/#the-most-tough-code-reviews)
- [Authors with the most pushes](https://ghe.clickhouse.tech/#authors-with-the-most-pushes)
- [Organizations by the number of stars](https://ghe.clickhouse.tech/#organizations-by-the-number-of-stars)
- [Organizations by the number of repositories](https://ghe.clickhouse.tech/#organizations-by-the-number-of-repositories)
- [Organizations by the size of community](https://ghe.clickhouse.tech/#organizations-by-the-size-of-community)
- [Repositories by amount of modified code](https://ghe.clickhouse.tech/#repositories-by-amount-of-modified-code)
- [Repositories by the number of pushes](https://ghe.clickhouse.tech/#repositories-by-the-number-of-pushes)
- [Authors with the most code reviews](https://ghe.clickhouse.tech/#authors-with-the-most-code-reviews)
- [Top labels](https://ghe.clickhouse.tech/#top-labels)
- [The longest repository names](https://ghe.clickhouse.tech/#the-longest-repository-names)
- [The shortest repository names](https://ghe.clickhouse.tech/#the-shortest-repository-names)
- [Repositories with ClickHouse-related comments](https://ghe.clickhouse.tech/#repositories-with-clickhouse-related-comments)
- [Most popular comments on GitHub](https://ghe.clickhouse.tech/#most-popular-comments-on-github)
- [GitHub roulette](https://ghe.clickhouse.tech/#github-roulette)

[Read the article](https://ghe.clickhouse.tech/)