products

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

2 rows where series_id = "CNT_21ER6EDE07VG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_3K9N7ZF0654G CNT_1Y70FTPVH980 Demon Slayer: Kimetsu no Yaiba—Corps Records CNT_21ER6EDE07VG CNT_21ER6EDE07VG 2 1 1 Demon Slayer: Kimetsu no Yaiba—Stories of Water and Flame []   Demon Slayer: Kimetsu no Yaiba—Stories of Water and Flame   Giyu heads north to an area where a band of hunters was killed. He and the Insect Hashira meet Yae, the daughter of a slain hunter, who believes a bear killed her father, but the truth is harder to face. Kyojuro also receives his newest assignment and hopes completing it will prove he's worthy of the title Flame Hashira, which his father abandoned. An explosive battle unfolds as Kyojuro takes on a demon of the Twelve Kizuki who holds a grudge against Kyojuro's father.   01KGBF5ECQS93GZ6S4QC3MWMET 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Demon Slayer: Kimetsu no Yaiba—Stories of Water and Flame KIMETSU NO YAIBA GAIDEN © 2019 by Koyoharu Gotouge, Ryoji Hirano/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3KC6F0PKCKA0 CNT_3DQH7NRQ07BG Demon Slayer: Kimetsu no Yaiba—Corps Records CNT_21ER6EDE07VG CNT_21ER6EDE07VG 2 1 1 Demon Slayer: Kimetsu no Yaiba—Corps Records []   Demon Slayer: Kimetsu no Yaiba—Corps Records   Tanjiro's quest to avenge his family and heal his sister is over! Demon Slayer: Kimetsu no Yaiba took readers on a thrill ride through Taisho-era Japan, as Tanjiro and the rest of the Demon Slayer Corps battled the most fearsome and vicious demons of all time. Now that the dust has settled, Demon Slayer: Kimetsu no Yaiba—Corps Records has all the info a fan could want about the series, as well as a never-before-printed bonus manga!   01KGBET488B9XN5HD5DS1W6MV4 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1JZNEGF5D0DG Demon Slayer: Kimetsu no Yaiba—Corps Records KIMETSU NO YAIBA KOSHIKI FAN BOOK KISATSUTAI KENBUNROKU･NI © 2021 by Koyoharu Gotouge/SHUEISHA Inc.   2024-11-26T08: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);