copy
13 rows where location_id = 32
This data as json, CSV (advanced)
Suggested facets: read_status, updated_at (date)
| id ▼ | uuid | media_id | location_id | ownership | read_status | notes | updated_at | deleted_at | rating | read_at | progress_page | progress_chapter |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 92c2bd8834814c1cb19bd92854d59966 | WHEN WE ALL FALL ASLEEP, WHERE DO WE GO? 42 | 32 32 | own | read | 2026-11-11T18:39:07.778Z | ||||||
| 54 | 26762c45a7e9d9bf2c4fd4ad2bc7523e | BONES UK 43 | 32 32 | own | read | 2026-11-11T18:38:35.608Z | ||||||
| 55 | f1481af8cc05b55fd83dd0f561fc3019 | Der König der Löwen: Das Broadway Musical im Hamburger Hafen 44 | 32 32 | own | read | 2026-11-11T18:38:37.551Z | ||||||
| 56 | fbb95731d1142842dcec447c99a3cc57 | Schock 45 | 32 32 | own | read | 2026-11-11T18:38:56.005Z | ||||||
| 57 | a6ea66414451dc4d290170f217a55f97 | Poesiealbum 46 | 32 32 | own | read | 2026-11-11T18:38:54.193Z | ||||||
| 58 | b7ef745662cba7f9b3387c76b67accfc | The Battle at Garden’s Gate 47 | 32 32 | own | unread | 2026-11-11T17:56:24.668Z | ||||||
| 59 | 01070c280a51727500de82666e776862 | American Tragedy 48 | 32 32 | own | read | 2026-11-11T18:38:30.281Z | ||||||
| 60 | a0c74f198a73f1b12e7e5b9fca1cf2ab | Five 49 | 32 32 | own | read | 2026-11-11T18:38:41.417Z | ||||||
| 61 | f2e7623b4498742bcd52c70e8eb73df6 | Evolve 50 | 32 32 | own | read | 2026-11-11T18:38:39.968Z | ||||||
| 62 | a08d51055f02007554b8ecbed9cde92d | Origins 51 | 32 32 | own | read | 2026-11-12T08:55:15.255Z | 4 | |||||
| 65 | 96054ec8a94ed345a0cc004b37bbf794 | Aus dem Schatten ins Licht 54 | 32 32 | own | read | 2026-11-11T18:38:32.119Z | ||||||
| 66 | 3e6da35efd56dd41834231daba6a08df | Staub 55 | 32 32 | own | read | 2026-11-11T18:38:57.831Z | ||||||
| 67 | e6cf2c353c527fd43e7561207b7612f6 | Twenty One Pilots - Trench - Music & Performance - CD 56 | 32 32 | own | read | 2026-11-11T18:39:06.257Z |
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);