labels

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

8 rows where publisher_id = "PUB_01TF1RKXDYN0"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ publisher_id geoblock_id name aliases
LAB_214WC1P7080G PUB_01TF1RKXDYN0   Noir Caesar []
LAB_23GBKFDXE8K0 PUB_01TF1RKXDYN0   International Women of Manga []
LAB_24SD9M39TBG0 PUB_01TF1RKXDYN0   Manga Quest []
LAB_2C2B4XAHKSHG PUB_01TF1RKXDYN0   Tokyopop []
LAB_3RJRTQD8R62G PUB_01TF1RKXDYN0   Disney Manga []
LAB_3TY7S40666N0 PUB_01TF1RKXDYN0   LoveLove []
LAB_3XVTHW0MM93G PUB_01TF1RKXDYN0   TOKYOPOP Classics []
LAB_3Y79M9QJJ9J0 PUB_01TF1RKXDYN0   TOKYOPOP Kids []

Advanced export

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

CSV options: 

CREATE TABLE labels (
      id TEXT PRIMARY KEY,
      publisher_id TEXT NOT NULL,
      geoblock_id TEXT,
      name TEXT NOT NULL,
      aliases TEXT NOT NULL,
      FOREIGN KEY (publisher_id) REFERENCES publishers(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_labels_publisher ON labels(publisher_id);
CREATE INDEX idx_labels_geoblock ON labels(geoblock_id);