products

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

4 rows where series_id = "CNT_0QAGD870ZWB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, 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_0DFECFR9S1MG CNT_363Z7000FWGG Doomsday with My Dog CNT_0QAGD870ZWB0 CNT_0QAGD870ZWB0 2 1 1 Volume 2 []   Doomsday with My Dog, Vol. 2   A single teenage girl, the last of her kind, continues her journeys through Japan with the adoring and bright Shiba Inu Haru—and they’re not alone! From the aloof beauty Snow White to the friendly neighborhood aliens, they’ve got plenty of fellow wanderers to meet, swap stories, and get into misadventures with. Who knew the apocalypse could be such a party?   01KGB3YQXMVEGP90KRM6GMTC7T 2.0 2022-12-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Doomsday with My Dog, Vol. 2     2023-04-18T00:00:00.000Z   0 0
PRD_2E7K6X1WZWN0 CNT_37PHQRFP5BPG Doomsday with My Dog CNT_0QAGD870ZWB0 CNT_0QAGD870ZWB0 2 1 1 Volume 3 []   Doomsday with My Dog, Vol. 3   When a lone high school girl decided to hole up in her room with her trusty canine companion, she never could’ve dreamed they would become a pair of adventurers exploring everything postapocalyptic Japan has to offer! Whether they’re enjoying a barbecue with Anubis or trying to survive a night in a haunted mansion, life after doomsday is one heck of a roller coaster—and this duo is strapped in for the ride!   01KGB6GZX6A0JSC607FY46F2X4 3.0 2023-05-16T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Doomsday with My Dog, Vol. 3     2023-08-29T00:00:00.000Z   0 0
PRD_2F3AK41SMK7G CNT_1AXQZW30PF5G Doomsday with My Dog CNT_0QAGD870ZWB0 CNT_0QAGD870ZWB0 2 1 1 Volume 1 []   Doomsday with My Dog, Vol. 1   A single teenage girl journeys through the crumbling ruins of civilization—the last human on Earth, exploring the concrete jungle that has outlived mankind. Keeping her company is woman’s best friend—the ever-adorable and quick-witted Shiba Inu Haru, who is ready to stick with her through thick and thin! With such a pleasant conversation partner to keep the postapocalyptic doldrums at bay, the end of the world might not be so bad after all!   01KGB2ZE1AT9W7J7C5CAQBYPV3 1.0 2022-12-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Doomsday with My Dog, Vol. 1     2023-01-17T00:00:00.000Z   0 0
PRD_3YZ5H8CDC0P0 CNT_18X5RKMCWTN0 Doomsday with My Dog CNT_0QAGD870ZWB0 CNT_0QAGD870ZWB0 2 1 1 Volume 4 []   Doomsday with My Dog, Vol. 4   A high school girl—the last human on Earth—and her loyal canine companion make their way through the prefectures of postapocalyptic Japan, taking in the spectacular sights and meeting the locals—from the furry to the intimidating to the outright bizarre! After all, when there’s no destination, the journey is all the fun!   01KH3G6XVDXMKQCH0EK6MH9RYQ 4.0 2023-08-21T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Doomsday with My Dog, Vol. 4     2024-02-20T00: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);