products

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

13 rows where series_id = "CNT_17PNG0ZQPCGG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description_short, geoblock_id, on_sale_at, add_on, 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_0AP7FBQ7GXZ0 CNT_3T07CXV26RX0 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 5 []   The Detective Is Already Dead, Vol. 5   Reunited with Siesta, Kimihiko is pulled back into action as assistant to the Ace Detective. Together, the two face off against Seed again and, with a little extra help, defeat him. Although that particular crisis may be over, the journey to awaken Natsunagi continues. In search of clues for how to save her, Siesta and Kimihiko travel to New York City. However, instead of answers, they find trouble brewing with the Phantom Thief—and worst of all, Siesta disappears!   01KGB2MSV6KVDPZYEBNX03WMXD 5.0 2022-12-07T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 5     2023-01-17T00:00:00.000Z   0 0
PRD_0KFK64NGWWK0 CNT_2M4M47XXPE90 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 6 []   The Detective Is Already Dead, Vol. 6   Siesta and Kimihiko’s first meeting did not take place during that fateful plane hijacking but rather four years earlier, when the Federation Government tasked Siesta with locating a spy in Japan. During her undercover investigation, she happened upon her future assistant, who had a connection with the spy she was looking for. With Kimihiko as her only lead, she enlisted his help in the search. But Siesta hid her identity with constant disguises, so unbeknownst to Kimihiko, he had already met the Ace Detective. Finally, the story of their true encounter—and the reason behind Siesta’s invitation to Kimihiko on that day in the sky—is revealed in this prequel!   01KGB60YAZJFNS0SNY6PA5KFF1 6.0 2023-03-14T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 6     2023-08-22T00:00:00.000Z   0 0
PRD_0YR9BXZ9BPG0 CNT_1GA4MDXT79RG The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 2 Short Story []   The Detective Is Already Dead, Vol. 2 Short Story [Bonus Item]   Short story for readers who purchase “The Detective Is Already Dead, Vol. 2” (Light Novel). Short story for readers who purchase “The Detective Is Already Dead, Vol. 2” (Light Novel). 01KJP5GZXJVCJJGYC8AK23S3M4 2.5 2021-10-18T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 2 Short Story [Bonus Item] TANTEI HA MO, SHINDEIRU. ©nigozyu 2019 Illustration: Umibouzu KADOKAWA CORPORATION   2021-10-26T07:00:00.000Z   1 0
PRD_10A5HKQB8KE0 CNT_3EQ9FYPB28N0 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 3 []   The Detective Is Already Dead, Vol. 3   What’s wrong with this story? After being kidnapped, Kimizuka, Natsunagi, Saikawa, and Charlie have learned the truth about Siesta’s death...or have they? A girl who looks just like the deceased appears and informs them that the footage they’ve been investigating contains an error. As they hunt for an answer to a mystery that even Siesta couldn’t uncover, the group will learn what it truly means to inherit the legacy of an ace detective. Though the detective may already be dead and the truth of her passing revealed, it’s still too early for the epilogue...   01KGAET6JRJJXSJ3VTSSBB1BKR 3.0 2022-02-18T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 3     2022-04-05T00:00:00.000Z   0 0
PRD_12X8ET0A6JRG CNT_1WVXW1CZJ8D0 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 3 Short Story []   The Detective Is Already Dead, Vol. 3 Short Story [Bonus Item]   Short story for readers who purchase “The Detective Is Already Dead, Vol. 3” (Light Novel). Short story for readers who purchase “The Detective Is Already Dead, Vol. 3” (Light Novel). 01KJP650N9DFDK2ET822S8TC6H 3.5 2022-03-15T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 3 Short Story [Bonus Item] TANTEI HA MO, SHINDEIRU. ©nigozyu 2020 Illustration: Umibouzu KADOKAWA CORPORATION   2022-04-05T07:00:00.000Z   1 0
PRD_1F3VWJ5KQ2TG CNT_1E5SXRGP2JCG The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 8 []   The Detective Is Already Dead, Vol. 8   Kimihiko Kimizuka was once the assistant to two ace detectives, and after achieving a miracle, the sequel was ordinary life. The Ritual of Sacred Return was supposed to be the moment world peace was achieved—but instead, it was discovered that this was a product of false memories. As the search for the truth begins, it seems the memories of another Tuner, Rill, may hold the key...   01KGAXYZECRH3VXRJR9V7AE0E0 8.0 2024-01-25T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 8     2024-07-23T00:00:00.000Z   0 0
PRD_2TWRSW61SD9G CNT_3ARDSQDP286G The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 7 []   The Detective Is Already Dead, Vol. 7   Kimihiko’s adventure with the detective began a thousand meters in the air. They saved clients, solved cases, battled powerful enemies, and traveled the world-and all of it ended the day the detective died. A year later, the story began again, thanks to one girl’s powerful emotions. After many battles and sacrifices-a miracle occurred. Now, Kimihiko is sinking into the routine of daily life again. That’s what comes next, isn’t it? Aren’t they allowed this? No one’s being inconvenienced. After all, the detective is already--   01KGAT2ZG5RYPCGN96ZAKP2TDB 7.0 2023-10-30T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 7     2024-03-19T00:00:00.000Z   0 0
PRD_2XWFBN06QVEG CNT_0MP5FA57V670 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 1 []   The Detective Is Already Dead, Vol. 1   When the story begins without its hero Kimihiko Kimizuka has always been a magnet for trouble and intrigue. For as long as he can remember, he’s been stumbling across murder scenes or receiving mysterious attache cases to transport. When he met Siesta, a brilliant detective fighting a secret war against an organization of pseudohumans, he couldn’t resist the call to become her assistant and join her on an epic journey across the world. …Until a year ago, that is. Now he’s returned to a life that is normal and tepid by comparison, knowing the adventure must be over. After all, the detective is already dead.   01KG9FV0SDPX71D5SAMNMYT1HM 1.0 2021-06-15T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 1     2021-06-29T07:00:00.000Z   0 0
PRD_3EE7VNT1D3DG CNT_2H7MW3JADBYG The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 11 []   The Detective Is Already Dead, Vol. 11   “I want to protect my friends. If I can’t do that, I don’t mind being an enemy of the world instead.”Having learned the truth of the Akashic records, Kimihiko Kimizuka, the Ace Detective, and their companions reach the System, the final piece needed to restore the world’s missing history. There, they recover all their memories of the Great Cataclysm, and Kimihiko is reminded of a promise he once made that will help him awaken the sleeping beauty and get their happy ending. However, the Singularity is forced to make an ultimate choice… The detective is already dead—but there’s no way Kimihiko is going to let it end that way. Even if people end up calling him the Great Cataclysm!   01KP0BC0J472S56H5ZRMJGHC2B 11.0 2025-10-21T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 11     2026-02-10T08:00:00.000Z   0 0
PRD_3KJECFAMHPH0 CNT_3KYTZDXE6SB0 The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 9 []   The Detective Is Already Dead, Vol. 9   “Let me tell you the story of a man who lived and fought through each and every day.”With the world in peril once again, Kimihiko Kimizuka returns to his role as the Ace Detective’s assistant and sets out on a journey to recover the lost memories of humanity. Using the Sacred Relic discovered by the Oracle, he investigates a past global crisis with the Vampire, Scarlet, at the very heart of it. But as Kimihiko delves deeper, harrowing truths once beyond his reach begin to bubble to the surface…   01KGBAZFZRZ8TRNAJSGJ5J26SY 9.0 2024-06-18T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 9     2024-11-26T08:00:00.000Z   0 0
PRD_3S3W3DQSG1TG CNT_0E4XHY57GK9G The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 10 []   The Detective Is Already Dead, Vol. 10   “I’ll keep that promise. I won’t let anyone take anything important from me.”As Kimihiko Kimizuka works alongside the Ace Detectives to recover the lost records of the world, he realizes the Phantom Thief may be the cause of these strange discrepancies. Believing the Phantom Thief’s true identity to be the world’s worst criminal, Abel A. Schoenberg, they seek out the one who once pursued him long ago—the Assassin, Fuubi Kase. What they finally discover is the tale of a battle between justice and an enormous evil—and the truth of the Akashic records hidden away by the world!   01KGBG1MSA8ERY3XJPV3EK1TDQ 10.0 2024-10-23T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 10     2025-06-10T07:00:00.000Z   0 0
PRD_3TZEAQMBCEK0 CNT_15BZXQQK4TVG The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 4 []   The Detective Is Already Dead, Vol. 4   Once the assistant to a great detective, Kimihiko Kimizuka took on a challenge Siesta bequeathed to him after her death and arrived at a conclusion that surpassed his wildest expectations. To bring back the great detective—the stuff of miracles—Kimihiko and Natsunagi fly to London yet again to obtain evidence that can bring down Seed. On the flight there, however, he hears the same words as he did four years ago: “Is there a detective on the plane?”   01KGAJMBQAC3KSBCJBKET2DJ8G 4.0 2022-09-30T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG The Detective Is Already Dead, Vol. 4     2022-10-04T00:00:00.000Z   0 0
PRD_3XJ6ECRSGT70 CNT_3RW3R74A9Y9G The Detective Is Already Dead CNT_17PNG0ZQPCGG CNT_17PNG0ZQPCGG 2 2 1 Volume 2 []   The Detective Is Already Dead, Vol. 2   WHO WERE YOU TO HER? WHO WAS SHE TO YOU? While on an outing one day, Kimihiko Kimizuka and his three friends are kidnapped by…Siesta herself?! But they soon learn there’s more to the story as she reveals the long-forgotten truth about Siesta’s death. Will this be the clue that finally unlocks the secrets of Kimihiko's past?   01KG9H2KZM71CPWY68Q3A6E6R2 2.0 2021-09-21T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 The Detective Is Already Dead, Vol. 2     2021-10-26T07: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);