home / bibliothek

copy

23 rows where location_id = 15

✎ View and edit SQL

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

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