copy
23 rows where location_id = 15
This data as json, CSV (advanced)
Suggested facets: read_status, read_at, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129 | 23aa0c16ad79826e9dce179e13257580 | Frankenstein 116 | 15 15 | own | unread | 2026-11-15T18:15:56.937Z | ||||||
| 130 | d05db967120ae96e4f0dd976d6a4bb5f | The Hyde Park Headsman 117 | 15 15 | own | unread | 2026-11-15T21:55:40.980Z | ||||||
| 131 | 8b7bbb99f0c657f5a2dbc698e6775361 | Fear Street 118 | 15 15 | own | unread | 2026-11-15T18:16:54.664Z | ||||||
| 132 | c9f6223319119bc6de35682aa4230e34 | R. L. Stine's Schattenwelt 119 | 15 15 | own | unread | 2026-11-15T18:17:30.366Z | ||||||
| 134 | 0e1705b057aa20c015ef3672526b5001 | Schattenwelt. Verhängnisvolle Flaschenpost. 121 | 15 15 | own | unread | 2026-11-15T18:18:29.203Z | ||||||
| 135 | 365f7a4c45fd2863ed5b7fb1914868c7 | Schattenwelt. Fatale Neugier. 122 | 15 15 | own | unread | 2026-11-15T18:18:48.450Z | ||||||
| 136 | 5346b2c01e5eedb20b00dde4321f0c4c | Bones and All 123 | 15 15 | own | read | 2026-11-16T14:01:51.462Z | 2023-11-16 | 304 | ||||
| 137 | 79f0e6842093b296479a3f3b467ed76a | Roter Drache 124 | 15 15 | own | read | 2026-11-16T14:06:38.743Z | 2024-11-16 | 446 | ||||
| 138 | 73b4d4291602d217a6bf8a14875391ff | Rachsüchtig: Warum tust du mir das an? 125 | 15 15 | own | unread | 2026-11-15T18:19:07.834Z | ||||||
| 139 | 551b5e3a5a5e86d794088d2ab788cb7b | Hühnerzauber 126 | 15 15 | own | unread | 2026-11-15T18:19:14.251Z | ||||||
| 140 | 9cea6628694eddc76a3b556d4ed9476a | Der Sandmann 127 | 15 15 | own | read | 2026-11-16T14:03:10.292Z | 2024-02-16 | 77 | ||||
| 141 | 3fdbddd4d65b0cdecf176c85c2f22096 | Schattenwelt. Der Club der 13. 128 | 15 15 | own | unread | 2026-11-15T18:19:22.740Z | ||||||
| 142 | bdff590fd5437dc643ebccdb06af5a31 | Der Lovecraft-Zirkel 129 | 15 15 | own | unread | 2026-11-15T18:19:37.615Z | ||||||
| 143 | 932ab4a440cdfb487ffe85ec7f026254 | Gänsehaut - der Werwolf aus den Fiebersümpfen 130 | 15 15 | own | unread | 2026-11-15T18:19:40.956Z | ||||||
| 144 | 54a636d3d6bcbb26ba688872282729f0 | Die Babysitterin. 131 | 15 15 | own | unread | 2026-11-15T18:19:48.711Z | ||||||
| 145 | cc4106bd02a4a7f3e153fc649be09116 | Der Anhalter. 132 | 15 15 | own | unread | 2026-11-15T18:19:55.051Z | ||||||
| 146 | 94a6302eb78d8b6885776a487553e1f1 | Gänsehaut 46. Der Ring des Bösen. 133 | 15 15 | own | unread | 2026-11-15T18:19:57.926Z | ||||||
| 151 | 7d0774a3da8382b7b407b69a86eb556a | Die dunklen Berge und sieben andere Novellen 138 | 15 15 | own | unread | 2026-11-15T21:59:59.624Z | ||||||
| 152 | 5f694f59b0bb72baedc6a9878cb4ab36 | Die Schattenhand 139 | 15 15 | own | unread | 2026-11-15T22:00:29.826Z | ||||||
| 153 | a598520def566a697af24b155bc2bb32 | Die Tote in der Bibliothek 140 | 15 15 | own | unread | 2026-11-15T22:01:38.459Z | ||||||
| 154 | e1d5724c355f6db8ff45d2962aa01dba | Das Schweigen der Lämmer 141 | 15 15 | own | read | 2026-11-16T14:02:42.524Z | 2023-06-16 | |||||
| 155 | 1bd57fae5358608de6387073fa486f53 | 1984 142 | 15 15 | own | read | 2026-11-16T13:55:19.395Z | 2024-11-16 | |||||
| 156 | 3ee94e5e5f8b2215ceff93455fbb833b | Schöne neue Welt 143 | 15 15 | own | read | 2026-11-16T14:07:30.669Z | 2023-11-16 |
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);