home / bibliothek

copy

133 rows

✎ View and edit SQL

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      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 10.406ms