home / content

Menu
  • GraphQL API

content

Database actions Database actions
  • GraphQL API for content

17 tables3 views1 query21.6 MB

Custom SQL query

Queries

1 query →
  • Datasette News and Blog with feed_items as ( select 'tag:datasette.io,' || date as atom_id, 'Datasette News: ' || date as...

Tables and views

Schema →
  • assets 1,662 rows

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

    links to releases, users

  • blog_posts 7 rows

    path, year, slug, source_path, title, datetime_utc, body, html, summary, author, author_url

  • datasette_repos 203 rows

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

  • example_csvs 2 rows

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

  • licenses 2 rows

    key, name, spdx_id, url, node_id

    full-text searchlinks to repos

  • news 118 rows

    date, body

  • plugin_repos 157 rows

    repo, tags, extra_search

  • pypi_packages 270 rows

    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

    links to pypi_releases, pypi_versions

  • pypi_releases 3,595 rows

    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, core-metadata

    links to pypi_packages, pypi_versions

  • pypi_versions 2,097 rows

    id, package, name

    links to pypi_packages, pypi_releases

  • releases 1,893 rows

    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

    full-text searchlinks to assets, repos, users

  • repos 200 rows

    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, has_pull_requests, pull_request_creation_policy, 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, security_and_analysis

    full-text searchlinks to licenses, releases, users

  • stats 93,896 rows

    package, date, downloads

  • tool_repos 46 rows

    repo, tags, extra_search

  • tutorials 6 rows

    path, title, body

  • users 14 rows

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

    full-text searchlinks to assets, releases, repos

  • uses 8 rows

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

  • plugins view
  • recent_releases view
  • tools view

… and 4 hidden tables

Download SQLite DB: content.db 21.6 MB

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