products

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

3 rows where series_id = "CNT_38ST5E5P5KKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_22MWV7ECG6AG CNT_040T618FM810 PENGUINDRUM CNT_38ST5E5P5KKG CNT_38ST5E5P5KKG 2 2 1 Volume 1 []   PENGUINDRUM Vol. 1   Brothers Kanba and Shoma adore their terminally ill little sister, Himari, and aren't prepared to lose her. They're definitely not prepared for a family trip to the aquarium, source of many of Himari's fondest memories, to suddenly turn tragic when Himari collapses and dies. What happens next, however, is beyond the siblings' wildest imaginations--as Himari miraculously returns from the dead, sporting a penguin-shaped hat, and accompanied by some magical new friends! A Life... For A Drum?! 01KG9BT69QPBVD0QJ98A1MJVFM 1.0 2020-04-14T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 PENGUINDRUM Vol. 1 2011 IKUHARA KUNIHIKO / TAKAHASHI KEI / GENTOSHA COMICS INC.   2020-05-26T07:00:00.000Z   0 0
PRD_2W20Y2SEMB30 CNT_0G2B5N2WV5KG PENGUINDRUM CNT_38ST5E5P5KKG CNT_38ST5E5P5KKG 2 2 1 Volume 3 []   PENGUINDRUMVol. 3   Himari's out of the hospital again, and things are finally getting back to normal--except Kanba's been sneaking out at night to meet up with a mysterious person. When tension between the siblings erupts into an argument that drives Kanba away for good, it's up to Shoma to fix what has been broken. What is the Penguindrum, really? What does it mean to be family? The answers lie in Himari's past... BACK TO WHERE IT ALL BEGAN 01KG9F0V59CT96NN47YXMG3C82 3.0 2021-03-23T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 PENGUINDRUMVol. 3 2012 IKUHARA KUNIHIKO / TAKAHASHI KEI / GENTOSHA COMICS INC.   2021-04-22T07:00:00.000Z   0 0
PRD_3DEW12DZ7M80 CNT_192K1BFCBSMG PENGUINDRUM CNT_38ST5E5P5KKG CNT_38ST5E5P5KKG 2 2 1 Volume 2 []   PENGUINDRUM Vol. 2   Shoma and Kanba seek out a girl named Oginome Ringo, who owns a strange diary that might be able to predict the future. Ringo is willing to trade them the diary--but only if they help her pull off an elaborate scheme of her own. Can the brothers assist Ringo with her quest in time to complete their own--or is the clock doomed to run out on Himari's second chance at life?! DEAR, DEAR DIARY 01KG9DAQKTFFAYSYHABSV94CK1 2.0 2020-10-15T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 PENGUINDRUM Vol. 2 2011 IKUHARA KUNIHIKO / TAKAHASHI KEI / GENTOSHA COMICS INC.   2020-12-08T08:00:00.000Z   0 0

Advanced export

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

CSV options: 

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);