Custom SQL query

assets

url, id, node_id, name, label, uploader, content_type, state, size, download_count, created_at, updated_at, browser_download_url, release

1 row

datasette_repos

id, nameWithOwner, createdAt, openGraphImageUrl, usesCustomOpenGraphImage, openIssueCount, closedIssueCount, releaseCount, topics, latest_commit

97 rows

licenses

key, name, spdx_id, url, node_id

1 row

news

date, body

77 rows

plugin_repos

repo

67 rows

releases

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

764 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, topics, forks, open_issues, watchers, default_branch, permissions, temp_clone_token, organization, network_count, subscribers_count, readme, readme_html

98 rows

stats

package, date, downloads

20,688 rows

tool_repos

repo

31 rows

users

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

4 rows

uses

_id, _path, text, html, title, summary, order

7 rows

... and 20 hidden tables

Views

Queries

Download SQLite DB: content.db 4.6 MB