Datasetpublic

open-index/open-github-issues

OpenGitHub Issues What is it? The full development metadata of 7 public GitHub repositories, fetched from the GitHub REST API and GraphQL API, converted to Parquet and hosted here for easy access. Right now the archive has 6.0M rows across 8 tables in 699.6 MB of Zstd-compressed Parquet. Every issue, pull request, comment, code review, timeline event, file change, and CI status check is stored as a separate table you can load individually or query together. This… See the full description on the dataset page: https://huggingface.co/datasets/open-index/open-github-issues.

sourceHugging Faceodc-byupdated 4mo agoView on Hugging Face

1likes665downloads

rootcodetop_issue_authors.sql

top_issue_authors.sql12 linesDownload Raw Back to code

1-- Top issue authors across all repos2SELECT3    author,4    COUNT(*) as issue_count,5    COUNT(*) FILTER (WHERE state = 'open') as open,6    COUNT(*) FILTER (WHERE state = 'closed') as closed7FROM read_parquet('hf://datasets/open-index/open-github-issues/data/issues/**/0.parquet')8WHERE is_pull_request = false9GROUP BY author10ORDER BY issue_count DESC11LIMIT 20;12