copy
48 rows where location_id = 16
This data as json, CSV (advanced)
Suggested facets: read_status, read_at, progress_page, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82 | 27d0d979ce0cd22862821b506ff11774 | Der Sonne nach 70 | 16 16 | own | read | 2026-11-16T14:03:35.335Z | 2021-07-16 | 155 | ||||
| 83 | 32bd40799e45ab5832e0b24fcee78b49 | Der Forst der Finsternis 71 | 16 16 | own | unread | 2026-11-15T21:57:55.935Z | ||||||
| 84 | b797bf5eb9ce0daa7f68c0fe345ff07b | Merlin: Wie alles begann 72 | 16 16 | own | unread | 2026-11-15T00:39:28.240Z | ||||||
| 85 | f882721d2af8bc2f8f2c15c23b131c4d | Das Ungeheuer im Bodensee 73 | 16 16 | own | unread | 2026-11-15T00:41:19.223Z | ||||||
| 86 | 9afdc0f8e35c8d260362047625d028ef | In die Zukunft blicken: Traumdeutung / Gerald Drews 74 | 16 16 | own | unread | 2026-11-15T00:41:46.338Z | ||||||
| 87 | f3abeb72e67d525628dfbfd2c59afb76 | Die Sprache der Dornen: Mitternachtsgeschichten 75 | 16 16 | own | next | 2026-11-15T17:47:41.330Z | ||||||
| 88 | cd4d80762bcdf845eeb88e404306282e | Gedichte zum Gruseln 76 | 16 16 | own | unread | 2026-11-15T00:44:38.530Z | ||||||
| 89 | 5a1c59cf1838a1cbb3292477553fedcd | Germanische Göttersagen 77 | 16 16 | own | unread | 2026-11-15T00:45:46.062Z | ||||||
| 90 | 22e1224fe6ebf627c5fb1bdd40e7bedc | Die Bücherdiebin 78 | 16 16 | own | unread | 2026-11-15T00:47:01.123Z | ||||||
| 91 | f373960160310c355a5fe95334bee157 | Sagenhafte Rittergeschichten 79 | 16 16 | own | unread | 2026-11-15T00:47:45.512Z | ||||||
| 92 | b0a322c00e63a1ac48741413f68e90d8 | Drachengift - Magische Geschichten (German Edition) 80 | 16 16 | own | unread | 2026-11-15T00:47:51.838Z | ||||||
| 93 | 528215fda67c43e2a93034982ab636a4 | Elfenblut: zauberhafte Geschichten 81 | 16 16 | own | unread | 2026-11-15T00:47:54.986Z | ||||||
| 94 | 5fe3fe58df127e749172f5fdf7e3bf05 | Das kleine weiße Pferd 82 | 16 16 | own | unread | 2026-11-15T00:48:13.946Z | ||||||
| 95 | 5453251264abccc3345f011ea48021d3 | Sir Francis Drake. Pirat der sieben Meere. 83 | 16 16 | own | unread | 2026-11-15T00:48:21.270Z | ||||||
| 96 | 65db407fc99dcd9784c3327a261ba084 | Das Licht in den Blättern 84 | 16 16 | own | unread | 2026-11-15T21:56:52.254Z | ||||||
| 97 | 7ee97417fb7b8a9f4333a9281deba7ee | Phantastische Tierwesen und wo sie zu finden sind 85 | 16 16 | own | read | 2026-11-16T14:06:13.256Z | 2020-11-16 | 87 | ||||
| 98 | cbc4376244d682ec784b0a3ade0aa376 | Elfen - Die zauberhaftesten Geschichten 86 | 16 16 | own | unread | 2026-11-15T00:49:07.687Z | ||||||
| 99 | cc3795e2cbb2756e691b424a6e7682c5 | Keltische Mythen: der Mensch und seine Anderswelt 87 | 16 16 | own | unread | 2026-11-15T00:49:19.259Z | ||||||
| 100 | 30e7e4ed7534ee88b1ca6737aa847452 | Märchenschatz: das große Buch der deutschen Märchen 88 | 16 16 | own | unread | 2026-11-15T00:50:57.415Z | ||||||
| 101 | 7dd89cdb08225efd62908d3d894a9f7d | Im Düsterwald 89 | 16 16 | own | unread | 2026-11-15T00:51:52.627Z | ||||||
| 102 | 25d4cab171ce635d5da02a01944676b5 | Der Apfelkönig vom Bodensee 90 | 16 16 | own | unread | 2026-11-15T00:52:04.863Z | ||||||
| 103 | cb557de3f2bf062aec8c0b65d93df6b6 | Griechische Götter- und Heldensagen 91 | 16 16 | own | unread | 2026-11-15T13:43:06.361Z | ||||||
| 104 | c692d0358b31709d1793cea80b7ee52e | Heldensagen aus aller Welt 92 | 16 16 | own | unread | 2026-11-15T14:50:41.962Z | ||||||
| 105 | 1dcd73e2e7b367512cc0cdb064c4fd68 | Märchen und Sagen 93 | 16 16 | own | unread | 2026-11-15T17:40:53.750Z | ||||||
| 106 | ebd255af28d238ec5b28dea21e956a9f | Sagen des klassischen Altertums 94 | 16 16 | own | unread | 2026-11-15T13:46:36.205Z | ||||||
| 107 | 88540c1eecc9ff18eec964ae518848b8 | König Arthur: ein Fernsehbuch 95 | 16 16 | own | unread | 2026-11-15T13:47:11.045Z | ||||||
| 108 | d9ebbffd17a24ddf8979558cdbe108ef | Tscha-Tscha, der erste Mensch: Mythen u. Erzählungen d. Buschmänner 96 | 16 16 | own | unread | 2026-11-15T15:24:41.553Z | ||||||
| 110 | 46368d46f8fd5651f3a66728d154626e | Störtebeker 97 | 16 16 | own | unread | 2026-11-15T17:43:44.657Z | ||||||
| 111 | 5cca6615a314b9a40037cf8047c9ece9 | Sagen der Griechen und Römer 98 | 16 16 | own | unread | 2026-11-15T15:27:33.739Z | ||||||
| 112 | fcfee29fcc308feeb534997098d148a4 | Robinson: Leben u. Abenteuer auf e. einsamen Insel 99 | 16 16 | own | unread | 2026-11-15T21:58:11.199Z | ||||||
| 113 | efe1ca08321ca1a2ad33f2ccad7e642b | Till Eulenspiegel 100 | 16 16 | own | read | 2026-11-16T14:08:11.005Z | 2012-11-16 | 89 | ||||
| 116 | 81f8f5c1cbf95f3141a62597afa50ad6 | Catweazle 103 | 16 16 | own | unread | 2026-11-15T15:37:26.818Z | ||||||
| 117 | 0254b4004e245f82235f705277208156 | Catweazle sucht die magischen Zeichen 104 | 16 16 | own | unread | 2026-11-15T15:37:32.799Z | ||||||
| 118 | e2412bcb282214a235e4cd451b6d1905 | Deutsche Märchen und Sagen 105 | 16 16 | own | unread | 2026-11-15T15:39:52.205Z | ||||||
| 119 | 471575adcbeb59e5c106ea2fd69a97cf | Zen in der Kunst des Bogenschiessens 106 | 16 16 | own | unread | 2026-11-15T15:40:58.855Z | ||||||
| 121 | c7ff38d25bdced39a3c46904ae5d1329 | Weshalb der Vogt Popolius Mayer als Burggeist Poppele vom Hohenkrähen im Hegau umgehen muß, und was für Streiche er den Leuten dort spielt bis auf den heutigen Tag 107 | 16 16 | own | unread | 2026-11-15T18:49:07.946Z | ||||||
| 122 | 3104d02c5bab02c35bfa9fe578c0d98a | Deutsches Gedichtbuch 109 | 16 16 | own | unread | 2026-11-15T17:39:52.469Z | ||||||
| 124 | 69a26f525faf78b29a18d39a57e03766 | Merlin's Ring 110 | 16 16 | own | unread | 2026-11-15T17:42:29.481Z | ||||||
| 125 | 398d498800277ff542c97825b6d32c11 | Lyrische Parodien: vom Mittelalter bis zur Gegenwart 112 | 16 16 | own | unread | 2026-11-15T17:39:25.013Z | ||||||
| 126 | c6acddb9da7afd62eea73428b7c2f968 | Märchen: Eine Auswahl der schönsten Volksmärchen 113 | 16 16 | own | unread | 2026-11-15T17:39:08.431Z | ||||||
| 127 | 8451b1b3ced4e1e810c41bc1766f4e84 | Die Drei Musketiere 114 | 16 16 | own | unread | 2026-11-15T17:24:10.369Z | ||||||
| 128 | ec469f204ae8c66e86ba19f27b433be7 | Cherubinischer Staub 115 | 16 16 | own | unread | 2026-11-15T18:15:14.581Z | ||||||
| 133 | 2db5d605d5c100d626935019c9754ae3 | Lichtgrüsse vor der unendlichen Nacht: Antoine de Saint-Exupéry als Begleiter 120 | 16 16 | own | unread | 2026-11-15T21:53:13.011Z | ||||||
| 147 | f2d5e912a364b31fd27f646ece8d9ad8 | Die Magie der Hexen: das umfassende Handbuch der weißmagischen Künste 134 | 16 16 | own | unread | 2026-11-15T18:22:01.938Z | ||||||
| 148 | 39d27719b6931a687d9b522779882803 | Magician King: A Novel 135 | 16 16 | own | read | 2026-11-16T14:05:40.830Z | 2022-11-16 | 432 | ||||
| 149 | 303336fa3e75d877815fd57c30ed2680 | The Magicians: A Novel 136 | 16 16 | own | read | 2026-11-16T14:07:57.102Z | 2022-11-16 | 416 | ||||
| 150 | 728b7667ddc5b36b933c425ff6130a27 | Magician's Land: A Novel 137 | 16 16 | own | read | 2026-11-16T14:05:49.350Z | 2022-11-20 | 416 | ||||
| 157 | e08522f0e94782e45589e0ae733560a1 | It Can't Happen Here 144 | 16 16 | own | reading | 2026-11-16T14:05:12.129Z |
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);