products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_2PA8AZSBRNC0"
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_31ZVPKZ82WRG | CNT_15PRRRP38WEG | Searching for My Perfect Brother CNT_2PA8AZSBRNC0 | CNT_2PA8AZSBRNC0 | 2 | 1 | 1 | Volume 4 | [] | Searching for My Perfect Brother 4 | After learning the full truth about her brother, Rize decides to forgive Kairi...but she still keeps from him that she is Masaki's sister. Unbeknownst to her, Kairi has finally put it all together, and disappears into the night after leaving her a farewell note. Desperate to find him, she follows what she hopes are his bike tracks in the snow, praying they won't be covered up by the intensifying blizzard. Meanwhile, detective Tachibana comes to the realization that Rize has been lying to him... | 01KG9PDWJNJK71XQV14PC4H2GF | 4.0 | 2023-12-26T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Searching for My Perfect Brother 4 | Satoshi Morie/Kodansha Ltd. | 2024-01-16T08:00:00.000Z | 0 | 0 | |||||
| PRD_39CBRXR3X930 | CNT_1V5KFVS6RKW0 | Searching for My Perfect Brother CNT_2PA8AZSBRNC0 | CNT_2PA8AZSBRNC0 | 2 | 1 | 1 | Volume 2 | [] | Searching for My Perfect Brother 2 | Rize was horrified and repulsed by Kairi's dark secret, but something kept her from going to the police. He may have killed someone, but he still seemed like the same kind and gentle Kairi she was starting to fall in love with-the one who reminds her of her big brother. The one who's quick to lend a hand and stand up for others, and the one who can't sleep, wracked with guilt and nightmares. But when Rize discovers just who his victim was, she's plunged into doubt and despair, especially when Kairi insists he had no choice... | 01KGASZWNKAR0SPYP6SVDXVX9S | 2.0 | 2023-10-31T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Searching for My Perfect Brother 2 | Satoshi Morie/Kodansha Ltd. | 2023-11-21T08:00:00.000Z | 0 | 0 | |||||
| PRD_3TGMGZQX2WPG | CNT_0TFT4HQQAP9G | Searching for My Perfect Brother CNT_2PA8AZSBRNC0 | CNT_2PA8AZSBRNC0 | 2 | 1 | 1 | Volume 3 | [] | Searching for My Perfect Brother 3 | When Rize finds out that Kairi killed her precious brother, she resolves to bring him to justice. She pretends like everything is fine as they grow closer and closer, all while working to secure evidence of the murder and trying to get Kairi to tell her the full details of what happened. He's reluctant, worried that she won't be able to see him the same way ever again, and she doesn't press him. But after an emotional incident at the supermarket, she senses he's vulnerable. Rize isn't prepared for what she hears. | 01KGAV46NEFQAF37BYCS2Y2KBE | 3.0 | 2023-12-05T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Searching for My Perfect Brother 3 | Satoshi Morie/Kodansha Ltd. | 2023-12-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3V1A6CPK18N0 | CNT_23CZR55T2JP0 | Searching for My Perfect Brother CNT_2PA8AZSBRNC0 | CNT_2PA8AZSBRNC0 | 2 | 1 | 1 | Volume 1 | [] | Searching for My Perfect Brother 1 | There's nothing in the world Rize likes more than to curl up in her warm bed and doze away-just like she used to with her big brother when they were kids, before they were separated by their parents' divorce. Working late shifts at a supermarket while attending university, she dreams of someday finding and reconnecting with her lost-and now grown-up-big brother. Her penchant for being able to nap in the break room draws the attention of Kairi, a co-worker who struggles with insomnia. Something about him reminds her of her big brother, and she finds herself growing closer to him...but when she discovers his secret, her whole world will be turned helter-skelter. | 01KH3GAC4E06AAKWSFQA1YR6QH | 1.0 | 2023-09-26T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Searching for My Perfect Brother 1 | Satoshi Morie/Kodansha Ltd. | 2023-10-17T07: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);