home / bibliothek

media

137 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: media_type, meta_status, language, series, series_no, updated_at (date)

id ▼ uuid media_type title creator barcode isbn13 publisher year cover_path meta_status updated_at deleted_at language series series_no pages pages_source
1 8b5bcad1b236a9658cb4b6539ec37a76 book Drohnenland Tom Hillenbrand 9783462046625 9783462046625 Kiepenheuer & Witsch 2014 9783462046625.jpg ok 2026-11-16T13:53:34.487Z   ger     422 auto
2 8637071746568c705f7ead573c821837 book Eine Woche für die Ewigkeit Nina LaCour, David Levithan 9783551583628 9783551583628 Carlsen Verlag GmbH 2017 9783551583628.jpg ok 2026-11-16T13:53:34.957Z   ger     283 auto
3 9583c202a4e6e152fa096b7e31d0df60 book Brennendes Wasser Lukas Erler 9783401069357 9783401069357 Arena Verlag GmbH 2014 9783401069357.jpg ok 2026-11-16T13:53:35.483Z   ger     272 auto
4 331f4ee9967b440d9e22338f4d8eccbb book Heavenly Tyrant Xiran Jay Zhao 9780735269989 9780735269989 Tundra Books 2023 9780735269989.jpg ok 2026-11-16T13:53:38.796Z   eng Iron Widow 2 400 auto
5 42449ea006c6e2e030ae48f4b9ff6bff book Finale Tim LaHaye 9783894902148 9783894902148 GerthMedien 1997 9783894902148.jpg ok 2026-11-16T13:53:39.259Z   ger Finale 2 334 auto
6 58c23b9ccfb7a9bc54fcc0aea67ebae8 book Finale Left Beyond Tim LaHaye 9783894901394 9783894901394 GerthMedien 1996 9783894901394.jpg ok 2026-11-16T13:53:39.717Z   ger Finale 1 355 auto
7 c13be626493e661e85e3bb077553e6b7 book City of trees Chantal-Fleur Sandjon 9783522202879 9783522202879 Thienemann 2024 9783522202879.jpg ok 2026-11-16T13:53:40.200Z   ger     394 auto
8 20e0a70846d18c5a2e70838b100f0ebc book Level 4: Die Stadt der Kinder Andreas Schlüter 9783357007977 9783357007977 Altberliner Verlag 1994 9783357007977.jpg ok 2026-11-16T13:53:40.661Z   ger     235 auto
9 ea29cdfb323a14af49b24910dd10f0f7 book Die Mitte der Welt: Roman Andreas Steinho fel 9783551353153 9783551353153 Carlsen 2004 9783551353153.jpg ok 2026-11-16T13:53:41.138Z   ger     476 auto
10 5d480922e060df1e98a16080121e5f7f book Corpus Delicti: Ein Prozess Juli Zeh 9783895614347 9783895614347 Schöffling 2009 9783895614347.jpg ok 2026-11-16T13:53:41.604Z   ger     263 auto
11 736a1757a3e301dda4122d6a6282659c book Wortschatzblock Englisch: [222 spannende Lektionen ; für Anfänger und Wiedereinsteiger ; so macht Englisch lernen Spaß] [Grammatikübungen: Annette Schmitz. Vokabeln und Beispielsätze: Chris Ioannou ...] 9783625120230 9783625120230 NGV 2008 9783625120230.jpg ok 2026-11-16T13:53:21.160Z   ger,eng        
12 3f57721e04dc0b48ea436b002c92c7d0 book Digitale Fotografie: Grundlagen und Fotopraxis von Jacqueline Esen 9783842100183 9783842100183 Vierfarben 2011 9783842100183.jpg ok 2026-11-16T13:53:42.073Z   ger     303 auto
13 f7895d268e857535d0bc58ffdc276b7c book Die Sonnenfinsternis am 11. August 1999: das Phänomen und seine spirituelle Dimension Wolfgang Held 9783772518539 9783772518539 Verl. Freies Geistesleben 1999 9783772518539.jpg ok 2026-11-16T14:41:13.657Z   ger     77 auto
14 1080309663cdbe276d9153355062d93b book Der Kleine Prinz - Le Petit Prince: Zweisprachig: Französisch-Deutsch Antoine de Saint-Exupéry 9783946571018 9783946571018 aionas 2016 9783946571018.jpg ok 2026-11-16T13:53:43.019Z   ger,fre     151 auto
15 b588247950b710383a32b3b90c65b23c book Schiller und die Freiheit des Geistes Andreas Venzke 9783401062181 9783401062181 Arena 2009 9783401062181.jpg ok 2026-11-16T14:07:19.794Z   ger     109 auto
16 d66adb45f2ce1c0c39a42b0aea982c8a book Karate kinderleicht erklärt Klaus Hirsch 9783938037225 9783938037225 Gloor-Verl. 2006 9783938037225.jpg ok 2026-11-16T13:53:44.217Z   ger     110 auto
17 6446cd4f3ab36c3879f79d7c620a3c33 book Tschick Wolfgang Herrndorf 9783499216510 9783499216510 Rowohlt Taschenbuch Verlag GmbH 2018 9783499216510.jpg ok 2026-11-16T13:53:44.715Z   ger     253 auto
18 e98a2b071186750e0fe0df86fc4810ff book Dead Poets Society N. H. Kleinbaum 9783125796904 9783125796904 Klett Sprachen GmbH 2005 9783125796904.jpg ok 2026-11-16T13:53:45.200Z   eng     112 auto
19 79cf0ace4697f8e441f25fa77e51b92a book Sinnlos?: gibt es einen Gott? Wozu lebt der Mensch? Was ist nach dem Tod? ; [auf der Suche nach dem Sinn des Lebens]   9783038110095 9783038110095 Beröa-Verl. 2013 9783038110095.jpg ok 2026-11-16T13:53:45.670Z   ger     160 auto
20 a5703330ff69a2d083453b99ba7f32e5 book Boy Queen George Lester 9781529042115 9781529042115 Pan Macmillan 2020 9781529042115.jpg ok 2026-11-16T14:31:40.364Z   eng     320 auto
21 e2d9c67cf854801ecd25e752800a8932 book Magicians: the New Class Lev Grossman 9781684155651 9781684155651 Boom! Studios 2020 9781684155651.jpg ok 2026-11-16T13:53:48.089Z   eng     128 auto
22 254e172d3cce755e616d4c0659b7bab0 book Deadpool Classic Fabian Nicieza 9780785131243 9780785131243 Marvel Comics 2008 9780785131243.jpg ok 2026-11-16T13:53:49.148Z   eng     264 auto
23 e83ce05f18bab2f83ca80d0429d2e1dd book Shelter Ursula Poznanski 9783743200517 9783743200517 Loewe Jugendbücher 2021 9783743200517.jpg ok 2026-11-16T13:53:49.617Z   ger     429 auto
24 b970fa7c031f289177023e1d95463b45 book Aquamarin Andreas Eschbach 9783401600222 9783401600222 Arena Verlag GmbH 2015 9783401600222.jpg ok 2026-11-16T13:53:50.078Z   ger     399 auto
25 bde2910a881222ec99642c8e41fcd000 book The resurrectionist: the lost work of Dr. Spencer Black E. B. Hudspeth 9781594746161 9781594746161 Quirk Books 2013 9781594746161.jpg ok 2026-11-16T13:53:51.172Z   eng     191 auto
26 2a665c81843e0c0466f0c246047db5f6 book Der Fall Jesus: ein Journalist auf der Suche nach der Wahrheit Lee Strobel 9783894902742 9783894902742 Projektion J 1999 9783894902742.jpg ok 2026-11-16T13:53:51.635Z   ger     319 auto
27 a089b539812a6f4521b7c5889fd8d574 book Morland Peter Schwindt 9783473353026 9783473353026 Ravensburger Buchverl. 2009 9783473353026.jpg ok 2026-11-16T13:53:52.105Z   ger     396 auto
28 f8b182d5651e42015ba22b59c93b99f1 book Die Rache des Feuerdämons Dorothy Hoobler, Thomas Hoobler 9783473582518 9783473582518 Ravensburger Buchverl. 2007 9783473582518.jpg ok 2026-11-16T13:53:52.608Z   ger Samurai Mystery 2 217 auto
29 b8e92fd77bf41e8acbd91b7c9c33b864 book Blackhearts Chuck Wendig 9783404207428 9783404207428 Lübbe 2013 9783404207428.jpg ok 2026-11-16T13:53:53.096Z   ger     347 auto
30 cbb079754476d571c089d556b2d6dbfe book Fayra: das Herz der Phönixtochter Nina Blazon 9783570164938 9783570164938 cbt 2017 9783570164938.jpg ok 2026-11-16T13:53:53.566Z   ger     460 auto
31 5135fbecb54cad171d135389abf789d4 book Die Fünf Tore: Teufelsstern Anthony Horowitz 9783785566398 9783785566398 Loewe 2009 9783785566398.jpg ok 2026-11-16T13:53:54.033Z   ger Die fünf Tore 2 364 auto
32 ba669d4b44622f41677f0eecf325f587 book Shadow Falls Camp 01. Geboren um Mitternacht C. C. Hunter 9783841421272 9783841421272 FISCHER FJB 2012 9783841421272.jpg ok 2026-11-16T13:53:54.547Z   ger Shadow Falls Camp 1 503 auto
33 2a3eeae69ff8b7dc0af4897dec5495a5 book Allstar Jukka Parkkinen 9783551580160 9783551580160 Carlsen 1997 9783551580160.jpg ok 2026-11-16T14:41:05.174Z   ger     264 auto
34 41f039f4e0be37e25511197b5ff1916e book Ich bin Circe Madeline Miller 9783961610952 9783961610952 Eisele 2020 9783961610952.jpg ok 2026-11-16T13:53:55.464Z   ger     516 auto
35 0776c39b7de661af12c5a6af8852c367 book Stadtgeschichten Armistead Maupin 9783499134425 9783499134425 Rowohlt Taschenbuch Verlag 1995 9783499134425.jpg ok 2026-11-16T13:53:55.943Z   ger     325 auto
36 504bbaafca92c90bebe283319fb9089c book Children of Blood and Bone Tomi Adeyemi 9781250194121 9781250194121 Holt & Company, Henry 2018 9781250194121.jpg ok 2026-11-16T13:53:57.145Z   eng Legacy of Orïsha 1 622 auto
37 46e7eceee3bfa509c0398b2a11d265c6 book Die Therapie Sebastian Fitzek 9783692670447 9783692670447 shelfie.audio 2027 9783692670447.jpg ok 2026-11-16T13:53:58.470Z   ger     304 auto
38 9a693a27be7651f4064e6f746afad8d5 book Hell Followed with Us Andrew Joseph White 9781682633243 9781682633243 Peachtree Publishing Company Inc., Peachtree Teen 2022 9781682633243.jpg ok 2026-11-16T14:31:36.376Z   eng     384 auto
39 e60dcccd47a429f24616d9d6a3f44d17 dvd The Magicians: The Complete Series SDS 0191329143483       0191329143483.jpg ok 2026-11-16T14:44:40.627Z            
40 c5cd9175a881204e71a630286c5b3e99 book Unbekannt (4009750391259)   4009750391259         pending 2026-11-11T17:36:36.437Z            
41 bd8042f4af05055119937254f9d6d08a dvd The Danish Girl   5053083065720       5053083065720.jpg ok 2026-11-16T14:41:02.105Z            
42 d0b3da1ca0b3ff08b55330227e94781d cd WHEN WE ALL FALL ASLEEP, WHERE DO WE GO? Billie Eilish 0602508556517     2019 0602508556517.jpg ok 2026-11-16T14:32:44.328Z            
43 4074fef09f5631c2f569c46e2378eac1 cd BONES UK BONES 0810016760504     2019 0810016760504.jpg ok 2026-11-16T14:32:42.682Z            
44 f6e1c4486e0445723e9022b8f2bb65aa cd Der König der Löwen: Das Broadway Musical im Hamburger Hafen Elton John 0743219195128     2003 0743219195128.jpg ok 2026-11-16T14:32:44.008Z            
45 af4cc4723bdea3b44da539a9b5a28d8c cd Schock Eisbrecher 0888750346124     2015 0888750346124.jpg ok 2026-11-16T14:40:56.967Z            
46 a8949f68a9c813e77c6a8dc53d7b43ac cd Poesiealbum Julia Engelmann 0602557943528     2017 0602557943528.jpg ok 2026-11-16T14:32:55.041Z            
47 45a7dac97c892bdfaa995f3e192741e8 cd The Battle at Garden’s Gate Greta Van Fleet 0602435623849     2021 0602435623849.jpg ok 2026-11-16T14:32:57.590Z            
48 7cbccaeda39720211d73ab9e5bec1d8c cd American Tragedy Hollywood Undead 0602527621425     2011 0602527621425.jpg ok 2026-11-16T14:32:59.992Z            
49 cdee3836aed0b38a0dcf59881bf88af6 cd Five IMPORTS 4050538320206       4050538320206.jpg ok 2026-11-16T14:33:23.889Z            
50 c411933a8431086c6ce94bbaf4bfbb76 cd Evolve Imagine Dragons 0602557680867     2017 0602557680867.jpg ok 2026-11-16T14:33:19.412Z            

Next page

Advanced export

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

CSV options:

CREATE TABLE "media" (
  id          INTEGER PRIMARY KEY,
  uuid        TEXT NOT NULL UNIQUE DEFAULT (lower(hex(randomblob(16)))),
  media_type  TEXT NOT NULL DEFAULT 'book' CHECK (media_type IN ('book','ebook','dvd','cd','game')),
  title       TEXT NOT NULL,
  creator     TEXT,
  barcode     TEXT,
  isbn13      TEXT,
  publisher   TEXT,
  year        INTEGER,
  cover_path  TEXT,
  meta_status TEXT NOT NULL DEFAULT 'ok' CHECK (meta_status IN ('ok','pending')),
  updated_at  TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  deleted_at  TEXT,
  language    TEXT,
  series      TEXT,
  series_no   TEXT,
  pages       INTEGER
, pages_source TEXT CHECK (pages_source IN ('auto', 'manual')));
CREATE INDEX ix_media_barcode  ON media(barcode);
CREATE INDEX ix_media_isbn13   ON media(isbn13);
CREATE INDEX ix_media_title    ON media(title COLLATE NOCASE);
CREATE INDEX ix_media_language ON media(language);
Powered by Datasette · Queries took 12.91ms