home

Menu
  • GraphQL API

content

Table actions
  • GraphQL API for content

Custom SQL query

Queries

  • Datasette News

Tables

assets

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

1,604 rows

datasette_repos

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

203 rows

example_csvs

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

2 rows

licenses

key, name, spdx_id, url, node_id

2 rows

news

date, body

111 rows

plugin_repos

repo, tags, extra_search

158 rows

pypi_packages

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

208 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

2,899 rows

pypi_versions

id, package, name

1,745 rows

releases

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

1,760 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, template_repository, network_count, subscribers_count, organization, custom_properties, temp_clone_token, readme, readme_html

200 rows

stats

package, date, downloads

66,753 rows

tool_repos

repo, tags, extra_search

46 rows

tutorials

path, title, body

6 rows

users

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

14 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 15.9 MB

Powered by Datasette · How this site works · Code of conduct
Advertisement