github

Tables

_analyze_tables_

table, column, total_rows, num_null, num_blank, num_distinct, most_common, least_common

307 rows

commits

sha, message, author_date, committer_date, raw_author, raw_committer, repo, author, committer

5,096 rows

contributors

repo_id, user_id, contributions

445 rows

issue_comments

html_url, issue_url, id, node_id, user, created_at, updated_at, author_association, body, reactions, performed_via_github_app, issue

30,000 rows

id, node_id, number, title, user, state, locked, assignee, milestone, comments, created_at, updated_at, closed_at, author_association, active_lock_reason, draft, pull_request, body, reactions, performed_via_github_app, state_reason, repo, type

8,178 rows

issues_labels

labels_id, issues_id

6,532 rows

labels

id, node_id, url, name, color, default, description

62 rows

labels_pull_requests

labels_id, pull_requests_id

2,228 rows

licenses

key, name, spdx_id, url, node_id

1 row

milestones

id, title, description, creator, repo, html_url, node_id, number, open_issues, closed_issues, state, created_at, updated_at, due_on, closed_at

23 rows

pull_requests

id, node_id, number, state, locked, title, user, body, created_at, updated_at, closed_at, merged_at, merge_commit_sha, assignee, milestone, draft, head, base, author_association, auto_merge, repo, url, merged_by

4,034 rows

raw_authors

id, name, email

552 rows

releases

html_url, id, author, node_id, tag_name, target_commitish, name, draft, prerelease, created_at, published_at, body, reactions, mentions_count, repo

91 rows

repos

id, node_id, name, full_name, private, owner, html_url, description, fork, created_at, updated_at, pushed_at, homepage, size, stargazers_count, watchers_count, language, has_issues, has_projects, has_downloads, has_wiki, has_pages, has_discussions, forks_count, archived, disabled, open_issues_count, license, allow_forking, is_template, web_commit_signoff_required, topics, visibility, forks, open_issues, watchers, default_branch, permissions, temp_clone_token, allow_squash_merge, allow_merge_commit, allow_rebase_merge, allow_auto_merge, delete_branch_on_merge, allow_update_branch, use_squash_pr_title_as_default, squash_merge_commit_message, squash_merge_commit_title, merge_commit_message, merge_commit_title, organization, security_and_analysis, network_count, subscribers_count, custom_properties

1 row

stars

user, repo, starred_at

3,434 rows

users

login, id, node_id, avatar_url, gravatar_id, html_url, type, site_admin, name

4,908 rows

... and 50 hidden tables

Views

Download SQLite DB: github.db 92.4 MB