products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_29HVVA895KQG"
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_130JVGW6EE9G | CNT_1AJ5H8R0J2B0 | Hard-Boiled Cop and Dolphin CNT_29HVVA895KQG | CNT_29HVVA895KQG | 2 | 1 | 1 | Volume 5 | [] | Hard-Boiled Cop and Dolphin, Vol. 5 | The battle in the undersea ruins continues. Chako is brought into the midst of the fighting and her presence allows the inner sanctum to be opened, revealing the weapon that Kamuro has been searching for: the hand of Poseidon! And with it comes the power to sink the whole world into the depths of the sea. In this final confrontation, the history of how Orpheus and Kamuro went from friends to bitter enemies is revealed... Don't miss the exciting and heart-wrenching conclusion of Hard-Boiled Cop and Dolphin! | 01KGBFBKECAWYFWYZZHR9ZN6HE | 5.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Hard-Boiled Cop and Dolphin, Vol. 5 | SHAKUNETSU NO NIRAI KANAI © 2020 by Ryuhei Tamura/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1A7XGPVJPCFG | CNT_1D7FG44HC0N0 | Hard-Boiled Cop and Dolphin CNT_29HVVA895KQG | CNT_29HVVA895KQG | 2 | 1 | 1 | Volume 2 | [] | Hard-Boiled Cop and Dolphin, Vol. 2 | Ocean crime is on the rise and it's keeping the Anegashima police department very busy. Samejima and Orpheus get a personal call from Captain Jinguji of the mysterious Foreign Ocean Affairs Section Seven's Mobile Investigations Unit. According to her sources, several members from the ocean gang known as the Osawara Family are on the move. And many of these bad-boy fishmen have it out for Orpheus, including one of their higher-ups, Kinnosuke Kaji. But what could this fiendish marlin be after on land? And more trouble is brewing when Jura accuses her boss—a former member of the Cult of the Sea—of trying to murder her coworker and friend Yukari! | 01KGBFBGCBS95PTJS2ZDPZPBJD | 2.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Hard-Boiled Cop and Dolphin, Vol. 2 | SHAKUNETSU NO NIRAI KANAI © 2020 by Ryuhei Tamura/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2ASDZ0NES8KG | CNT_0R3KCB361VH0 | Hard-Boiled Cop and Dolphin CNT_29HVVA895KQG | CNT_29HVVA895KQG | 2 | 1 | 1 | Volume 3 | [] | Hard-Boiled Cop and Dolphin, Vol. 3 | Yukari Okina has vanished into the sunken ruins off the coast of Anegashima. Public safety officers declare her dead and pin everything on her friend Hamura. Hamura tries to tell them that Kamuro and the Cult of the Sea are behind the disappearance, but no one is willing to hear her out—except for Samejima, who is determined to help her. Soon after, the Marine Mobile Investigations Unit arrives on the scene and quickly recruits Samejima and Orpheus to begin their own investigation! | 01KGBFCTQGCW308CM63QTAJY8F | 3.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Hard-Boiled Cop and Dolphin, Vol. 3 | SHAKUNETSU NO NIRAI KANAI © 2020 by Ryuhei Tamura/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3185CSFBCES0 | CNT_2A7W0HK4RJ4G | Hard-Boiled Cop and Dolphin CNT_29HVVA895KQG | CNT_29HVVA895KQG | 2 | 1 | 1 | Volume 4 | [] | Hard-Boiled Cop and Dolphin, Vol. 4 | Samejima, Orpheus, and the MIU agents continue their investigation by diving into undersea ruins. But they aren't alone... Kamuro and his gang are there too, along with some of the baddest and roughest mermen yet! Hope for victory dwindles when Samejima is poisoned in battle and Chako is kidnapped by cult members while in police custody on land. Meanwhile, Kamuro inches ever closer to his prize, the Left Hand of Poseidon. | 01KGBFBJVT4YCQJFY4QN450ZYD | 4.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Hard-Boiled Cop and Dolphin, Vol. 4 | SHAKUNETSU NO NIRAI KANAI © 2020 by Ryuhei Tamura/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_35YNYC9D8DR0 | CNT_0DJ9039D7H5G | Hard-Boiled Cop and Dolphin CNT_29HVVA895KQG | CNT_29HVVA895KQG | 2 | 1 | 1 | Volume 1 | [] | Hard-Boiled Cop and Dolphin, Vol. 1 | Boyle Samejima is a tough-as-nails cop with a love for hard-boiled action. He's so hard-boiled that his inner-monologue boxes have blood splatters on them! But after he punches a suspect in the middle of a hostage situation, he's shipped off to the remote island of Anegashima near Okinawa. Soon after he arrives, he learns that this island is anything but quiet and peaceful... The precinct is in the middle of an investigation involving the mass disappearance of a cult that worshipped a little girl who is said to have been raised by a dolphin, and that little girl is in their custody. But when Samejima arrives for his first day of work, he's faced with the shock of his life! His new partner, the father of that little girl, really is a dolphin! It's okay, though, the dolphin can walk on land and has two hands...and can talk! | 01KGBETQZYQM37HJDKRK3JS47M | 1.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Hard-Boiled Cop and Dolphin, Vol. 1 | SHAKUNETSU NO NIRAI KANAI © 2020 by Ryuhei Tamura/SHUEISHA Inc. | 2024-11-26T08: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);