products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_0PZVBC33DP30"
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_019VDE1JY2RG | CNT_24R9YG3CCCKG | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 8 | [] | Tokyo ESP Vol. 8 | The Final Curtain Rises Once the board members of Ares have gathered, Claudia uses Touko to awaken the Messiah and receive its benediction- a massive magnification of her ESP- just as Rinka, Kobushi, Minami and Nadja storm in, setting off the biggest ESP battle in Tokyo's history. Then an old enemy shows up, and alliances are strained as allegiances are tested. Can Rinka and her friends take down the power-drunk Claudia before Tokyo is wiped off the map...? | 01KH3H6XK2EVVQHE7BTD240SXM | 8.0 | 2021-01-05T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 8 | Hajime SEGAWA | 2021-01-05T08:00:00.000Z | 0 | 0 | |||||
| PRD_0CYRD7QNZHR0 | CNT_3B6G1W2A2BK0 | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 1 | [] | Tokyo ESP Vol. 1 | There's a New Heroine in Town. Rinka Urushiba's world is turned upside down when she wakes up one day-after falling right through the floor. Encouraged by another ESPer who believes that Rinka's destiny is to become a hero of justice, she soon learns to use her powers for good. And not a moment too soon, as those with less-than-admirable ambitions descend on Tokyo with their own sets of superpowers. As the mysterious glowing fish flitting through the city skies gift powers seemingly at random, foes become friends and alliances are made and broken. And what about that flying penguin? | 01KH3GADDAT44156JS466EFKBR | 1.0 | 2020-11-17T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 1 | Hajime SEGAWA | 2020-11-17T08:00:00.000Z | 0 | 0 | |||||
| PRD_0F07X87C8X30 | CNT_1J7HHT6147R0 | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 2 | [] | Tokyo ESP Vol. 2 | The Professor Appears Schools of flying, glowing fish, a flying penguin, now a flying hippo? As Murasaki wrestles with how to effectively use her newfound powers, Rinka and Kyotaro continue to train with the wise (and wicked) Youdani, who introduces a boy with a unique type of precognition, which is put to the test when he has to make a difficult decision when a conservative family member is threatened by supernatural powers. The enigmatic Professor, the ringleader of delinquent superhumans, appears with a tantalizing piece of the ESP puzzle and an invitation to the other side... | 01KH3H5M3BGTBKPZX6M7RVFYV6 | 2.0 | 2020-11-24T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 2 | Hajime SEGAWA | 2020-11-24T08:00:00.000Z | 0 | 0 | |||||
| PRD_1KN0GW81VA7G | CNT_112Z90Y5254G | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 7 | [] | Tokyo ESP Vol. 7 | The True Wire-Pullers The Macabre Lady and the rest of the major players in Ares Security, a global PMSC, set their sights on Kozuki, who has squirreled away the Ark, and Ren, whose ESP is the key to unlocking the Ark itself. Rinka teams up with her old frenemy Kobushi (and even forms a tentative alliance with Minami) to take down Ares from the inside. And Murasaki's ESP may turn out to be just the thing they need to win the battle, before the Messiah is reawakened... | 01KH3H4MQ28KMED6V7DPC1HMYN | 7.0 | 2020-12-29T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 7 | Hajime SEGAWA | 2020-12-29T08:00:00.000Z | 0 | 0 | |||||
| PRD_27NWFSR32ZDG | CNT_0KXH6M0C5TEG | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 6 | [] | Tokyo ESP Vol. 6 | Thicker than Blood The battle in Hong Kong's black market tournament culminates with Rinka facing off with someone very close to the big bad boss… and Rinka winds up having to face some harsh truths about the choices she has made up until this point. Meanwhile, Kobushi makes a decision about her path in the criminal world with potentially fatal consequences. Back in Tokyo, Ren had expected life at the ESP Academy to return to normal, except a certain student has gone missing, and another classmate finds herself swept up by the immense aura of a new evil presence that has set foot in the metropolis… | 01KH3H5RAJRPFMXSD1CYQ6KDJW | 6.0 | 2020-12-22T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 6 | Hajime SEGAWA | 2020-12-22T08:00:00.000Z | 0 | 0 | |||||
| PRD_2AACSCT5EYCG | CNT_2K8E67PMGSFG | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 4 | [] | Tokyo ESP Vol. 4 | A New Generation of ESPers… Nearly a year and a half after the battle with The Professor where countless glowing fish filled the skies of Tokyo, 20% of the population in the Kanto region are now superhumans. As society grapples with the dramatic changes in the populace, a special ESP Academy is established so superhumans can attend school. Among the students is one Ren Jomaku, a girl who can create blocks of ice- and perhaps something much darker... | 01KH3H5PPCF7RFQZHEB3XQW07Z | 4.0 | 2020-12-08T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 4 | Hajime SEGAWA | 2020-12-08T08:00:00.000Z | 0 | 0 | |||||
| PRD_2EZ8C0ZTHCH0 | CNT_2E3BYCEREPA0 | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 5 | [] | Tokyo ESP Vol. 5 | Old Allies, New Enemies Rinka, who had gone missing, arrives back in Tokyo to put a stop to the plans of a terrorist organization that threatens Tokyo with a dangerous weapon, and rescue Ren and Marume from their evil clutches. But where had Rinka been that whole time? And what had she been doing? The truth is darker than the White Girl could have imagined... | 01KH3H4Q1WQRXYRH4Z5PC0YQVJ | 5.0 | 2020-12-15T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 5 | Hajime SEGAWA | 2020-12-15T08:00:00.000Z | 0 | 0 | |||||
| PRD_39NA3A02Q5TG | CNT_38G02EF8NFHG | Tokyo ESP CNT_0PZVBC33DP30 | CNT_0PZVBC33DP30 | 2 | 1 | 1 | Volume 3 | [] | Tokyo ESP Vol. 3 | The White Girl is Dead. Long Live the White Girl! Rinka is targeted by The Professor's minions at school, with life-threatening consequences. Azuma wakes up, alone, on a deserted island, too far to help anyone. After we get a glimpse of The Professor's past and the true nature of the stone that creates the glowing fish, the terrorist gang's hijacking of the Diet building (by sending it flying through the skies) further enrages the government, which has already created a detention center for everyone with ESP. The Professor's ultimate act will have long-lasting repercussions, as the trap he set closes in on himself… | 01KH3H571AT6MG97Z7BENHEBQZ | 3.0 | 2020-12-01T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Tokyo ESP Vol. 3 | Hajime SEGAWA | 2020-12-01T08:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);