products

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

3 rows where series_id = "CNT_0M19S0GW38V0"

✎ 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_1PT6YYR1H1MG CNT_13CC5VTEPNZ0 ZAREGOTO CNT_0M19S0GW38V0 CNT_0M19S0GW38V0 2 2 1 SUSPENSION 1 []   SUSPENSION 1   An earnestly honest guy who doesn't even grant pipe dreams to himself, physiologically incapable of letting a single contradiction go, in other words me, got dragged this June to a renowned academy for rich girls, no questions allowed, by the world's strongest contractor. No matter how you put it, no matter how you spin it, there was probably no point to it. Because the case that arose there was, in and of itself, a bit of nonsense.   01KG9D1PBPY7D6WGW3DVPGEJYA 3.0 2020-08-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG SUSPENSION 1 SUSPENSION 2018 NISIOISIN / Kodansha Ltd. All rights reserved.   2020-08-25T07:00:00.000Z   0 0
PRD_1WPZPR1EYAWG CNT_2CC4MZ0Z0F70 ZAREGOTO CNT_0M19S0GW38V0 CNT_0M19S0GW38V0 2 2 1 DECAPITATION 1 []   DECAPITATION 1   A dropout from an elite Houston-based program for teens is on a visit to a private island. Its mistress, virtually marooned there, surrounds herself with geniuses, especially of the young and female kind—one of whom ends up headless one fine morning. The top-selling novelist year by year in his native Japan, prolific palindromic phenomenon NISIOISIN made his debut when he was only twenty with this Mephisto Award winner, a whodunit and locked-room mystery at once old-school and eye-opening. Previously published stateside by Del Rey, the translation has been retitled and revised just in time for the long-requested animated series based on illustrator take's character concepts.   01KG9CBCF6FRNGGXEQBH08ACQV 1.0 2020-08-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG DECAPITATION 1 DECAPITATION 2018 NISIOISIN / Kodansha Ltd. All rights reserved.   2020-08-25T07:00:00.000Z   0 0
PRD_3GJY5M9WK150 CNT_03PNNJZAG6FG ZAREGOTO CNT_0M19S0GW38V0 CNT_0M19S0GW38V0 2 2 1 STRANGULATION 1 []   STRANGULATION 1   When NISIOISIN, Japan's bestselling novelist, writes a murder mystery, it won't be like anything you've ever read before. Now in a new English translation! Whether you're already a fan of Japanese phenom NISIOISIN, or a mystery reader looking for something unusual and compelling, don't wait to get your hands around STRANGULATION: Kubishime Romanticist. This follow-up to Decapitation, and the second part of NISIOISIN's debut Zaregoto series, presents a puzzling murder mystery that tells the story in the voice of a narrator who's trying his hardest to stay out of the action. Now that he's a cool college student, our anti-hero Iichan thinks his crime-solving days are behind him. Cynical, sarcastic and minimally engaged in his studies, Iichan is much more interested in his own feelings of disaffection and isolation. But despite his resolve to remain aloof, he's pulled into the narrative when he encounters and bonds with a serial killer named Hitoshi Zerozaki – a homicidal maniac with the soul of an artist whose talent is on display at the grisly scenes of his crimes. Written by Japan's prolific and top-selling author NISIOISIN, STRANGULATION: Kubishime Romanticist blends a tale of suspense and detection with an edgy exploration of the nature of talent, violence, and ego. This Vertical edition features a revised translation and new art by acclaimed illustrator take.   01KG9D1QHQDR1A3EPDVG59ZJ4W 2.0 2020-08-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG STRANGULATION 1 STRANGULATION 2018 NISIOISIN / Kodansha Ltd. All rights reserved.   2020-08-25T07: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);