copy
4 rows where location_id = 19
This data as json, CSV (advanced)
Suggested facets: read_status, updated_at (date), read_at (date)
| id ▼ | uuid | media_id | location_id | ownership | read_status | notes | updated_at | deleted_at | rating | read_at | progress_page | progress_chapter |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | b18acc4494e8ca846fa59df2a9004f52 | City of trees 7 | 19 19 | own | read | 2026-11-12T08:57:09.695Z | 5 | 2024-07-12 | ||||
| 19 | 9fa413c4fdae13645d9141c7f18a6680 | Level 4: Die Stadt der Kinder 8 | 19 19 | own | unread | 2026-11-11T17:01:50.096Z | ||||||
| 20 | c8a1ee3fc6b241ab2db5b59e2f3d146d | Die Mitte der Welt: Roman 9 | 19 19 | own | read | 2026-11-12T08:57:51.071Z | 5 | 2024-06-12 | ||||
| 21 | e22ff2d7d8716cb28b61699972257e5e | Corpus Delicti: Ein Prozess 10 | 19 19 | own | read | 2026-11-11T17:02:47.461Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "copy" (
id INTEGER PRIMARY KEY,
uuid TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
media_id INTEGER NOT NULL REFERENCES media(id),
location_id INTEGER REFERENCES location(id),
ownership TEXT NOT NULL DEFAULT 'own' CHECK (ownership IN ('own','borrowed_in','returned')),
read_status TEXT NOT NULL DEFAULT 'unread'
CHECK (read_status IN ('unread','next','reading','read','dropped')),
notes TEXT,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
deleted_at TEXT,
rating INTEGER CHECK (rating BETWEEN 0 AND 7),
read_at TEXT
, progress_page INTEGER, progress_chapter TEXT);
CREATE INDEX ix_copy_media ON copy(media_id);
CREATE INDEX ix_copy_location ON copy(location_id);