home / bibliothek

copy

13 rows where location_id = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: read_status, updated_at (date)

id ▼ uuid media_id location_id ownership read_status notes updated_at deleted_at rating read_at progress_page progress_chapter
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      
65 96054ec8a94ed345a0cc004b37bbf794 Aus dem Schatten ins Licht 54 32 32 own read   2026-11-11T18:38:32.119Z          
66 3e6da35efd56dd41834231daba6a08df Staub 55 32 32 own read   2026-11-11T18:38:57.831Z          
67 e6cf2c353c527fd43e7561207b7612f6 Twenty One Pilots - Trench - Music & Performance - CD 56 32 32 own read   2026-11-11T18:39:06.257Z          

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