media
137 rows
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);