home

kskb

Custom SQL query

Queries

  • Search everything
  • Items for a role, with their evidence label
  • What kind of evidence each role is reading
  • Decisions recorded in the meeting minutes
  • Repositories and what they depend on
  • Coverage by topic
  • Authors with the most items
  • Items not checked in ninety days

Tables

access

id, meaning

5 rows

build

built, tier, cards, notes

1 row

document_sources

id, siteName, category, raw_file, documents, records, chars, card, license, license_read, show

77 rows

documents

id, source, siteName, category, title, url, creationDate, author, mediaType, records, chars, first_heading, raw_file, level_proposed, kind, source_id, text_path, license, show, text_url

5,107 rows

evidence

id, meaning

7 rows

kinds

id, label, meaning

13 rows

levels

id, label, meaning

4 rows

links

kind, from_kind, from_id, to_kind, to_id

1,190 rows

notes

path, title, type, status, classification, words, body

139 rows

resource_authors

resource_id, name

439 rows

resource_roles

resource_id, role, how

2,278 rows

resource_topics

resource_id, topic

1,867 rows

resources

id, type, name, url, maintainer, status, last_checked, date, year, level, evidence, access, abstract, authors, series, chair, minutes, recording, media, decisions, version, language, license, release, pushed, depends, since, via, summary, note, has_abstract, has_summary, kind, sector, country, products

823 rows

role_topics

role, topic

35 rows

roles

id, label, does, questions, trust, show_evidence, start

10 rows

sectors

id, label

9 rows

statuses

id, meaning

5 rows

topics

id, n, label

17 rows

types

id, label

15 rows

... and 6 hidden tables

Download SQLite DB: kskb.db 6.3 MB

Powered by Datasette · Queries took 3600.475ms