Custom SQL query

_analyze_tables_

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

315 rows

commits

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

2,459 rows

contributors

repo_id, user_id, contributions

70 rows

dependents

repo, dependent, first_seen_utc

452 rows

emojis

name, url, image

1,799 rows

issue_comments

html_url, issue_url, id, node_id, user, created_at, updated_at, author_association, body...

4,754 rows

issues

id, node_id, number, title, user, state, locked, assignee, milestone...

1,558 rows

issues_labels

labels_id, issues_id

1,652 rows

jobs

id, workflow, name, repo, runs-on, strategy, needs, if

31 rows

labels

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

79 rows

labels_pull_requests

labels_id, pull_requests_id

39 rows

licenses

key, name, spdx_id, url, node_id

8 rows

milestones

id, title, description, creator, repo, html_url, node_id, number, open_issues...

24 rows

pull_requests

id, node_id, number, state, locked, title, user, body, created_at...

268 rows

raw_authors

id, name, email

59 rows

releases

html_url, id, node_id, tag_name, target_commitish, name, draft, author, prerelease...

241 rows

repos

id, node_id, name, full_name, private, owner, html_url, description, fork...

366 rows

stars

user, repo, starred_at

5,451 rows

steps

id, seq, job, repo, uses, name, with, run, env...

155 rows

tags

repo, name, sha

265 rows

users

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

5,235 rows

workflows

id, filename, name, on, repo

23 rows

commits_fts (hidden)

message, commits_fts, rank

2,459 rows

commits_fts_config (hidden)

k, v

1 row

commits_fts_data (hidden)

id, block

30 rows

commits_fts_docsize (hidden)

id, sz

2,459 rows

commits_fts_idx (hidden)

segid, term, pgno

28 rows

issue_comments_fts (hidden)

body, issue_comments_fts, rank

4,754 rows

issue_comments_fts_config (hidden)

k, v

1 row

issue_comments_fts_data (hidden)

id, block

297 rows

issue_comments_fts_docsize (hidden)

id, sz

4,754 rows

issue_comments_fts_idx (hidden)

segid, term, pgno

357 rows

issues_fts (hidden)

title, body, issues_fts, rank

1,558 rows

issues_fts_config (hidden)

k, v

1 row

issues_fts_data (hidden)

id, block

177 rows

issues_fts_docsize (hidden)

id, sz

1,558 rows

issues_fts_idx (hidden)

segid, term, pgno

175 rows

labels_fts (hidden)

name, description, labels_fts, rank

79 rows

labels_fts_config (hidden)

k, v

1 row

labels_fts_data (hidden)

id, block

3 rows

labels_fts_docsize (hidden)

id, sz

79 rows

labels_fts_idx (hidden)

segid, term, pgno

1 row

licenses_fts (hidden)

name, licenses_fts, rank

8 rows

licenses_fts_config (hidden)

k, v

1 row

licenses_fts_data (hidden)

id, block

3 rows

licenses_fts_docsize (hidden)

id, sz

8 rows

licenses_fts_idx (hidden)

segid, term, pgno

1 row

milestones_fts (hidden)

title, description, milestones_fts, rank

24 rows

milestones_fts_config (hidden)

k, v

1 row

milestones_fts_data (hidden)

id, block

3 rows

milestones_fts_docsize (hidden)

id, sz

24 rows

milestones_fts_idx (hidden)

segid, term, pgno

1 row

pull_requests_fts (hidden)

title, body, pull_requests_fts, rank

268 rows

pull_requests_fts_config (hidden)

k, v

1 row

pull_requests_fts_data (hidden)

id, block

34 rows

pull_requests_fts_docsize (hidden)

id, sz

268 rows

pull_requests_fts_idx (hidden)

segid, term, pgno

32 rows

releases_fts (hidden)

name, body, releases_fts, rank

241 rows

releases_fts_config (hidden)

k, v

1 row

releases_fts_data (hidden)

id, block

27 rows

releases_fts_docsize (hidden)

id, sz

241 rows

releases_fts_idx (hidden)

segid, term, pgno

25 rows

repos_fts (hidden)

name, description, repos_fts, rank

366 rows

repos_fts_config (hidden)

k, v

1 row

repos_fts_data (hidden)

id, block

9 rows

repos_fts_docsize (hidden)

id, sz

366 rows

repos_fts_idx (hidden)

segid, term, pgno

7 rows

users_fts (hidden)

login, name, users_fts, rank

5,235 rows

users_fts_config (hidden)

k, v

1 row

users_fts_data (hidden)

id, block

26 rows

users_fts_docsize (hidden)

id, sz

5,235 rows

users_fts_idx (hidden)

segid, term, pgno

24 rows

Views

Download SQLite DB: github.db 23.0 MB