products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
9 rows where series_id = "CNT_2Z35VKW20D80"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_0H2HN6YPGD2G | CNT_246G6RFE5RRG | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 6.5 | [] | Chitose Is in the Ramune Bottle, Vol. 6.5 | Reaching for the moonThe summer of Chitose’s second year in high school was unforgettable, lit up with encounters like fireworks across the short-lived night sky. The end of the season may be near, but that just opens the way for new beginnings. In this collection of vignettes from four different girls, that summer will last just a little longer before this chapter of their lives closes for good. | 01KH3QK9M1ET6K5F22VGJGTG7B | 6.5 | 2024-04-02T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1MXE9VYAYQ0G | Chitose Is in the Ramune Bottle, Vol. 6.5 | 2024-09-17T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0JCJXNQEFG9G | CNT_2VYFZFA9FNAG | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 1 | [] | Chitose Is in the Ramune Bottle, Vol. 1 | Being popular isn’t easy. It’s hard to beat Saku Chitose. The most popular kid in his high school? Check. An ironclad reputation that can weather even vicious online attacks? Check. A group of friends as attractive on the outside as they are inside? Check. But when a teacher asks for his help bringing back a student who has been shut away in his room for months, Saku’s perfect world will never be the same. What is this, some kind of normie harem story...? | 01KGADHMGF78GD4ZKZ6DZQCKXY | 1.0 | 2022-01-18T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 1 | 2022-03-15T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0ZTKXSK93CR0 | CNT_2DQH9BX2QPQ0 | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 6 | [] | Chitose Is in the Ramune Bottle, Vol. 6 | Everything changed-suddenly, dramatically, and ruthlessly. But she wouldn't let me give in to the gloominess. One year ago, I was just Chitose and Yua was still Uchida. I remember the night our relationship truly began. Our summer isn't over yet. | 01KGAT30BPDBWPCBT9H0M3EDWD | 6.0 | 2023-10-30T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 6 | 2024-04-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1HV5JJYZDZF0 | CNT_3C0WSK8KXFCG | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 5 | [] | Chitose Is in the Ramune Bottle, Vol. 5 | This moment won’t last forever, but we’ll always remember it. Summer vacation is here, and so is Fuji High’s annual overnight study camp—that is to say, a great opportunity for second-years to enjoy the break with their friends. Blue sky and ocean as far as the eye can see, girls in bikinis, intimate conversations, and chats in the bath with the guys. You can enjoy the sunlight or squint to keep it out of your eyes—either way, hold on to those memories before they get away. | 01KH3FVM3EY66XJNAXSZJ22ECX | 5.0 | 2023-05-31T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 5 | 2023-11-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_24A2E1WQCFA0 | CNT_1ETG4SY2HB20 | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 3 | [] | Chitose Is in the Ramune Bottle, Vol. 3 | Summer is near, and that means planning for what comes after graduation. For a second-year like Chitose, this is the first step towards envisioning his future, but for his third-year friend Asuka, it’s the beginning of the end of high school. The two have been meeting up more and more, going on outings that feel suspiciously like dates; Chitose should be happy, but it just makes the ache in his heart stronger. If Asuka decides to pursue her dreams, she’ll be leaving for Tokyo soon to help weave other people’s stories—and Chitose’s not sure he’ll be able smile as he lets her go. | 01KGB2NQ99FYSNZSSRWWR779B0 | 3.0 | 2022-12-07T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 3 | 2023-02-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_259DBGHBS0TG | CNT_33CPAZ82Z94G | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 8 | [] | Chitose Is in the Ramune Bottle, Vol. 8 | Mirror, mirror, on the wall—who does he care for most of all?The peace of September has ended, October has arrived, and cultural festival preparations are in full swing. The plot of Class Five’s play has been decided: the tale of Princesses Snow White and Dark Cloud, played by Yuuko Hiiragi and Yuzuki Nanase, with Saku Chitose as the prince who must choose between them. Yuuko is the Snow White everyone knows and loves, of course, while Yuzuki’s Dark Cloud is a witch with a familiar magic mirror. But the story of the indecisive prince isn’t only for the stage; after her confrontation with Kureha, Yuzuki Nanase is ready to dip a bright red apple in poison and step into the spotlight herself. | 01KPTYS0Y7J1AV6F6QEHYYPKH1 | 8.0 | 2025-11-19T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 8 | 2026-05-12T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2KH5SPPZVWBG | CNT_04RFGYN35F10 | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 2 | [] | Chitose Is in the Ramune Bottle, Vol. 2 | L is for the way you lie to me...If a girl tells you she’s dying to go out with you, you’d probably want to take her at face value, especially when she’s as drop-dead gorgeous as Yuzuki Nanase. But if it seems too good to be true, it probably is—which is how Saku Chitose ends up pretending to be Yuzuki’s boyfriend to catch a stalker. But as is so often the case with Yuzuki, there’s more to her request than meets the eye. The couple’s fake dating gambit may unearth some other truths that are very, very real… | 01KGAGX120PPZ5AT6X03FV1C0Q | 2.0 | 2022-08-01T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 2 | 2022-08-16T00:00:00.000Z | 0 | 0 | ||||||
| PRD_2QV8BTEPWSQ0 | CNT_1V7DMTWA0CRG | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 7 | [] | Chitose Is in the Ramune Bottle, Vol. 7 | Stalemate.It’s September, the month after summer vacation, the transition into fall. It’s also time to start getting ready for the culture festival, and Chitose’s group teams up with two girls from other grades—Asuka from third year and a first-year named Kureha—to prep for some of the events. After everything that happened this summer, no one is eager to upset the delicate, hard-won balance. But how long can they afford to go without change…? | 01KGBP6GJBFFNKEW1T94QR8Z35 | 7.0 | 2025-05-02T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1MXE9VYAYQ0G | Chitose Is in the Ramune Bottle, Vol. 7 | 2025-10-21T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3JPXF71RFYT0 | CNT_37DHKDV0WB40 | Chitose Is in the Ramune Bottle CNT_2Z35VKW20D80 | CNT_2Z35VKW20D80 | 2 | 2 | 1 | Volume 4 | [] | Chitose Is in the Ramune Bottle, Vol. 4 | SWING FOR THE FENCES, SHOOT FOR THE STARS! July is here, and so are the prelims for the Inter-High Tournament. Haru is the new captain of the basketball club, hoping to lead her team to glory; for Chitose, watching the baseball players butt heads and work toward their dreams, it’s hard not to have some doubts about his previous decision to leave. To make matters worse, when their new star batter is injured, the team approaches Chitose and begs him to come back. What will he choose…and what will finally give him closure? | 01KGB4FYAHS3VKZZF8SEWM0AEQ | 4.0 | 2023-02-07T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1GSR46W5XAYG | Chitose Is in the Ramune Bottle, Vol. 4 | 2023-06-20T00: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);