home

Menu
  • ripgrep search
  • Dashboards

github

Custom SQL query

Tables

commits

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

6,687 rows

emojis

name, url, image

1,874 rows

issues

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

3,663 rows

issues_labels

labels_id, issues_id

1,532 rows

labels

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

12 rows

labels_pull_requests

labels_id, pull_requests_id

1,532 rows

licenses

key, name, spdx_id, url, node_id

24 rows

milestones

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

2 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, stack

3,617 rows

raw_authors

id, name, email

97 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, forks_count, archived, disabled, open_issues_count, license, forks, open_issues, watchers, default_branch, permissions, organization, topics, temp_clone_token, network_count, subscribers_count, allow_forking, visibility, is_template, web_commit_signoff_required, 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, has_discussions, security_and_analysis, custom_properties, has_pull_requests, pull_request_creation_policy

1,823 rows

stars

user, repo, starred_at

1,823 rows

users

login, id, node_id, avatar_url, gravatar_id, html_url, type, site_admin, name, company, blog, location, email, hireable, bio, twitter_username, public_repos, public_gists, followers, following, created_at, updated_at, user_view_type

1,545 rows

commits_fts (hidden)

message, commits_fts, rank

Many rows

commits_fts_config (hidden)

k, v

1 row

commits_fts_data (hidden)

id, block

124 rows

commits_fts_docsize (hidden)

id, sz

6,687 rows

commits_fts_idx (hidden)

segid, term, pgno

121 rows

issues_fts (hidden)

title, body, issues_fts, rank

Many rows

issues_fts_config (hidden)

k, v

1 row

issues_fts_data (hidden)

id, block

Many rows

issues_fts_docsize (hidden)

id, sz

3,663 rows

issues_fts_idx (hidden)

segid, term, pgno

2,724 rows

labels_fts (hidden)

name, description, labels_fts, rank

12 rows

labels_fts_config (hidden)

k, v

1 row

labels_fts_data (hidden)

id, block

5 rows

labels_fts_docsize (hidden)

id, sz

12 rows

labels_fts_idx (hidden)

segid, term, pgno

3 rows

licenses_fts (hidden)

name, licenses_fts, rank

24 rows

licenses_fts_config (hidden)

k, v

1 row

licenses_fts_data (hidden)

id, block

6 rows

licenses_fts_docsize (hidden)

id, sz

24 rows

licenses_fts_idx (hidden)

segid, term, pgno

4 rows

milestones_fts (hidden)

title, description, milestones_fts, rank

2 rows

milestones_fts_config (hidden)

k, v

1 row

milestones_fts_data (hidden)

id, block

13 rows

milestones_fts_docsize (hidden)

id, sz

2 rows

milestones_fts_idx (hidden)

segid, term, pgno

11 rows

pull_requests_fts (hidden)

title, body, pull_requests_fts, rank

Many rows

pull_requests_fts_config (hidden)

k, v

Many rows

pull_requests_fts_data (hidden)

id, block

Many rows

pull_requests_fts_docsize (hidden)

id, sz

3,617 rows

pull_requests_fts_idx (hidden)

segid, term, pgno

2,458 rows

repos_fts (hidden)

name, description, repos_fts, rank

1,823 rows

repos_fts_config (hidden)

k, v

1 row

repos_fts_data (hidden)

id, block

168 rows

repos_fts_docsize (hidden)

id, sz

1,823 rows

repos_fts_idx (hidden)

segid, term, pgno

166 rows

users_fts (hidden)

login, name, users_fts, rank

1,545 rows

users_fts_config (hidden)

k, v

1 row

users_fts_data (hidden)

id, block

50 rows

users_fts_docsize (hidden)

id, sz

1,545 rows

users_fts_idx (hidden)

segid, term, pgno

48 rows

Views

  • repos_starred
Powered by Datasette · Queries took 1185.613ms