home

content

Custom SQL query

Tables

assets

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

6 rows

datasette_repos

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

141 rows

example_csvs

url, name, table_name, source, source_url, about, about_url, description

2 rows

licenses

key, name, spdx_id, url, node_id

1 row

news

date, body

91 rows

plugin_repos

repo, tags

102 rows

pypi_packages

name, summary, classifiers, description, author, author_email, description_content_type, home_page, keywords, license, maintainer, maintainer_email, package_url, platform, project_url, project_urls, release_url, requires_dist, requires_python, version, yanked, yanked_reason

142 rows

pypi_releases

md5_digest, package, version, packagetype, filename, comment_text, digests, has_sig, python_version, requires_python, size, upload_time, upload_time_iso_8601, url, yanked, yanked_reason

1,778 rows

pypi_versions

id, package, name

1,102 rows

releases

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

1,054 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, allow_forking, visibility, is_template, template_repository, web_commit_signoff_required, has_discussions

142 rows

stats

package, date, downloads

73,273 rows

tool_repos

repo

40 rows

tutorials

path, title, body

3 rows

users

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

8 rows

uses

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

8 rows

... and 20 hidden tables

Views

  • recent_releases
  • plugins
  • tools

Download SQLite DB: content.db 13.8 MB

Powered by Datasette · Queries took 38.133ms