home / bibliothek

copy

26 rows where location_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ownership, read_status, 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  
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          
48 fefb66e291fd20bad84f75737b957651 Die Therapie 37 5 5 own unread   2026-11-11T17:32:08.238Z          

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 9.461ms