copy
133 rows
This data as json, CSV (advanced)
Suggested facets: location_id, ownership, read_status, rating, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 130d4b8ac5d84991986419e1ac672165 | Brennendes Wasser 3 | 5 5 | own | unread | 2026-11-11T17:02:55.997Z | ||||||
| 7 | 74c1b36d43ed668d852271df3faeb32d | Eine Woche für die Ewigkeit 2 | 5 5 | own | unread | 2026-11-11T17:02:14.944Z | ||||||
| 13 | 0b1a2db74f6e929db02c08fe10857e30 | Drohnenland 1 | 5 5 | own | unread | 2026-11-11T17:02:16.509Z | ||||||
| 14 | 31ed8a0b53666aa8f564705b6158413a | Heavenly Tyrant 4 | 5 5 | own | next | 2026-11-14T21:32:54.210Z | ||||||
| 16 | 9babe0c8fcaeeaabefb058f253243e29 | Finale 5 | 5 5 | borrowed_in | unread | 2026-11-12T08:58:29.517Z | ||||||
| 17 | 76464fdaa9cf411b1c10804076a99fa4 | Finale Left Beyond 6 | 5 5 | borrowed_in | reading | 2026-11-14T21:18:41.359Z | 70 | |||||
| 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 | ||||||
| 22 | 6420fa6dce1229173b6bbd6087486668 | Wortschatzblock Englisch: [222 spannende Lektionen ; für Anfänger und Wiedereinsteiger ; so macht Englisch lernen Spaß] 11 | 4 4 | own | unread | 2026-11-11T16:30:22.690Z | ||||||
| 23 | c2edf9a7a3991cce809569dc35b55e98 | Digitale Fotografie: Grundlagen und Fotopraxis 12 | 4 4 | own | unread | 2026-11-11T16:30:37.044Z | ||||||
| 24 | ff6d68b3ded4c188b9eec203bf59c7c2 | Die Sonnenfinsternis am 11. August 1999: das Phänomen und seine spirituelle Dimension 13 | 4 4 | own | unread | 2026-11-11T16:31:44.238Z | ||||||
| 25 | fcab5e09541b51368be69a9130049fa1 | Der Kleine Prinz - Le Petit Prince: Zweisprachig: Französisch-Deutsch 14 | 4 4 | own | reading | 2026-11-12T12:28:27.567Z | 10 | |||||
| 26 | bd9bfa6d69d23683df2aa41ccf96a8d5 | Schiller und die Freiheit des Geistes 15 | 4 4 | own | read | 2026-11-16T14:07:19.802Z | 2020-07-06 | |||||
| 27 | 639811f6ad24fc4dfb57ad5f5769ed29 | Karate kinderleicht erklärt 16 | 4 4 | own | unread | 2026-11-11T16:36:54.896Z | ||||||
| 28 | 923f4732c0ef0067a9387da5ce65726f | Tschick 17 | 5 5 | own | unread | 2026-11-11T16:37:52.610Z | ||||||
| 29 | f2185abf03452689dd7d2c70b637c8bc | Dead Poets Society 18 | 5 5 | own | unread | 2026-11-11T16:38:54.537Z | ||||||
| 30 | 9f12421243f199c6cefac3831b25d240 | Sinnlos?: gibt es einen Gott? Wozu lebt der Mensch? Was ist nach dem Tod? ; [auf der Suche nach dem Sinn des Lebens] 19 | 5 5 | own | unread | 2026-11-11T16:39:00.064Z | ||||||
| 31 | 00ad4e9520f0363e435be1e2bb27030d | Boy Queen 20 | 5 5 | own | dropped | 2026-11-11T16:59:06.158Z | ||||||
| 32 | c6d51546f69430280e5c2f750e00e85a | Magicians: the New Class 21 | 5 5 | own | unread | 2026-11-16T14:05:26.559Z | 2026-11-16 | 128 | ||||
| 33 | b0c6cf8ed19c16f523d113c9b65fe019 | Deadpool Classic 22 | 5 5 | own | unread | 2026-11-11T16:39:37.316Z | ||||||
| 34 | a8c2289de57dfc74ac84098a9c8b8567 | Shelter 23 | 5 5 | own | reading | 2026-11-11T16:58:44.189Z | ||||||
| 35 | 50b106e4c9d2129088153804ac5c1586 | Aquamarin 24 | 5 5 | own | unread | 2026-11-11T16:39:56.972Z | ||||||
| 36 | 6438508df3da769581b99a8d344ba412 | The resurrectionist: the lost work of Dr. Spencer Black 25 | 5 5 | own | unread | 2026-11-11T16:40:03.230Z | ||||||
| 37 | 8472dfd113716ee81ad7ea19947153d1 | Der Fall Jesus: ein Journalist auf der Suche nach der Wahrheit 26 | 5 5 | borrowed_in | unread | 2026-11-11T16:40:48.345Z | ||||||
| 38 | 62351dfae6bca99c1365060858e18c94 | Morland 27 | 5 5 | own | unread | 2026-11-11T16:58:08.592Z | ||||||
| 39 | 3ad0af9ed0100773d1f4ca06e060b578 | Die Rache des Feuerdämons 28 | 5 5 | own | unread | 2026-11-11T16:57:53.563Z | ||||||
| 40 | 2a024062e0d353234119518d80eff961 | Blackhearts 29 | 5 5 | own | unread | 2026-11-11T16:52:30.265Z | ||||||
| 41 | 258b17566db628e69bd57edee320a208 | Fayra: das Herz der Phönixtochter 30 | 5 5 | own | unread | 2026-11-11T16:57:59.713Z | ||||||
| 42 | 130e0d31403678fcdc396810f9984559 | Die Fünf Tore: Teufelsstern 31 | 5 5 | own | unread | 2026-11-11T16:52:42.768Z | ||||||
| 43 | f1cec000772941647dd27fd856abef53 | Shadow Falls Camp 01. Geboren um Mitternacht 32 | 5 5 | own | unread | 2026-11-11T16:58:15.661Z | ||||||
| 44 | 597b6abac3cf9c2f454932878f746250 | Allstar 33 | 5 5 | own | reading | 2026-11-12T08:55:42.492Z | ||||||
| 45 | 0c5a48ff59391d29ac048187e273b2e9 | Ich bin Circe 34 | 5 5 | borrowed_in | unread | 2026-11-11T16:47:58.413Z | ||||||
| 46 | 3e5dff3aa44edbc9fae02c5ac9c7ed8c | Stadtgeschichten 35 | 5 5 | borrowed_in | reading | 2026-11-11T16:58:26.211Z | ||||||
| 47 | 9137cb56fc43e04bea7320efce818803 | Children of Blood and Bone 36 | 24 24 | own | next | 2026-11-11T17:16:21.267Z | ||||||
| 48 | fefb66e291fd20bad84f75737b957651 | Die Therapie 37 | 5 5 | own | unread | 2026-11-11T17:32:08.238Z | ||||||
| 49 | fbb1d93b9e2fe6553035eac3a99da41c | Hell Followed with Us 38 | 24 24 | own | next | 2026-11-11T17:34:14.807Z | ||||||
| 50 | fe0f496475b9f60d417cb225a905ce86 | The Magicians: The Complete Series 39 | 13 13 | own | unread | 2026-11-11T17:36:15.441Z | ||||||
| 52 | 7ec7710c2bb72252c5fb2d8462d9efb2 | The Danish Girl 41 | 13 13 | own | read | 2026-11-11T17:50:19.078Z | ||||||
| 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 |
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);