home

Menu
  • GraphQL API
  • Search all tables

Content

Table actions
  • GraphQL API for content
Writing catalog - blog, essays, fiction, verse, notes, papers, and educational material

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

Custom SQL query

Tables

blog

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, cover_position, cover_scale, audio_url

17 rows

categories

id, slug, title, preview, importance, state, created_at

Many rows

content_tags

id, content_type, content_id, tag_id

922 rows

courses

id, slug, title, author, rating, thumbnail, preview, category_slug, status, confidence, importance, state, created_at, updated_at, total_hours, total_lectures, description, audio_url

12 rows

diary

id, slug, title, preview, cover_image, category_slug, start_date, end_date, state, created_at, updated_at, audio_url

4 rows

documents

id, slug, title, author, date, abstract, doi, source_url, file_path, file_type, file_size, page_count, topic_path, annotation, annotation_tier, confidence, importance, state, created_at, updated_at

Many rows

essays

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, cover_position, cover_scale, audio_url

14 rows

fiction

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, collection, state, created_at, updated_at, audio_url

6 rows

lectures

id, slug, title, preview, cover_image, code, credits, category_slug, status, confidence, importance, syllabus_url, start_date, state, created_at, updated_at, audio_url

16 rows

news

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

11 rows

notes

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, cover_position, cover_scale, audio_url

95 rows

ocs

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

30 rows

papers

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

17 rows

progymnasmata

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

14 rows

prompts

id, slug, title, description, model, category, file_path, file_type, file_size, date, state, created_at, updated_at

14 rows

research

id, slug, title, preview, cover_image, category_slug, authors, subject, keywords, bibliography, pdf_url, source_url, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

3 rows

reviews

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at, audio_url

59 rows

sequence_content

id, sequence_id, content_type, content_slug, position, section_title, section_order

164 rows

sequence_tags

sequence_id, tag_id

158 rows

sequences

id, slug, title, preview, cover_url, category_slug, status, confidence, importance, start_date, end_date, state, created_at, updated_at

59 rows

sqlite_sequence

name, seq

23 rows

tags

id, slug, title, preview, importance, state, created_at

288 rows

textbooks

id, slug, title, subtitle, author, preview, cover_image, subject, category_slug, status, confidence, importance, pdf_url, start_date, state, created_at, updated_at, field, audio_url

12 rows

verse

id, slug, title, preview, cover_image, category_slug, status, confidence, importance, start_date, end_date, verse_type, collection, state, created_at, updated_at, audio_url

89 rows

workbooks

id, slug, title, subtitle, author, preview, cover_image, subject, category_slug, status, confidence, importance, latex_url, pdf_url, start_date, state, created_at, updated_at, field, audio_url

13 rows

... and 35 hidden tables

Powered by Datasette · 354.963ms · krisyotam.com