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

rootcodemost_reviewed_prs.sql

most_reviewed_prs.sql11 linesDownload Raw Back to code

1-- Most reviewed PRs by number of review submissions2SELECT3    r.pr_number,4    COUNT(*) as review_count,5    COUNT(*) FILTER (WHERE r.state = 'APPROVED') as approvals,6    COUNT(*) FILTER (WHERE r.state = 'CHANGES_REQUESTED') as changes_requested7FROM read_parquet('hf://datasets/open-index/open-github-issues/data/reviews/**/0.parquet') r8GROUP BY r.pr_number9ORDER BY review_count DESC10LIMIT 20;11