products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_39PAKZBDHM5G"
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_0E2NEYXZFQ7G | CNT_2WV3MY4VJNG0 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 1 | [] | One Warm Spring, Chapter 1 | Kasuga enters high school with one goal in mind -- to get himself a girlfriend! His plans do get pushed back due to a minor car accident, but no worries...! The day he returns to school, he catches sight of Morikawa, a first-year, and it's love at first sight. Learning that she prefers the calm and stoic type, he takes drastic measures and forces a "cool guy" act. To his surprise, things seem to work in his favor. That is, until... | 01KGBTN5CFNHEASM85A00B1BZ8 | 1.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 1 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_13E36HRFAFF0 | CNT_0CA2EF89JDSG | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 6 | [] | One Warm Spring, Chapter 6 | Kasuga's been invited over to Morikawa's house. A little nervousness isn't about to get in the way of his excitement though! Upon arrival, Kasuga greets Morikawa's dad with his usual perkiness and wins him over almost immediately. But when the young couple finally has some time to themselves, Morikawa reveals why she really wanted Kasuga to come over... | 01KGBTM7847K7XAG6S9RAAXY8X | 6.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 6 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_17WKG4NHPEE0 | CNT_2FMZ9TYJ1CTG | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 3 | [] | One Warm Spring, Chapter 3 | Kasuga and Morikawa are enjoying their date, watching the dolphin show and taking photos at the aquarium. But when Kasuga mentions how much fun he's having, Morikawa begins to well up...! *Bonus comic included. | 01KGBTM5DDAA9YJQR0KRPTR122 | 3.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 3 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1RB08BW32190 | CNT_0DNREKXRRFZG | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 9 | [] | One Warm Spring, Chapter 9 | Morikawa and fellow volleyball club members Marin and Risa plan a trip to the local water park, but Kasuga overhears! Unable to contain himself at the thought of seeing Morikawa in a swimsuit, he runs to Satoshi and Kitamu, suggesting that they have their own day of aquatic fun! | 01KGBTM9A4SW27TAEATQAM1B9B | 9.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 9 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2V5Z0P8PE9G0 | CNT_23KDBF04F70G | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 2 | [] | One Warm Spring, Chapter 2 | Though they hit a little snag along the way, Kasuga and Morikawa are now official. But boy does Kasuga move fast! When walking home together after club the next day, he asks her out on their first date! However, Morikawa isn't as excited as she should be... | 01KGBSKBDJP2EN0YRCDMXPGA9C | 2.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 2 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_31QBZTBC8FYG | CNT_1FZRSG3DRX90 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 4 | [] | One Warm Spring, Chapter 4 | Morikawa suggests studying together at Kasuga. When she finally meets his lively family though, she thinks about how different her situation at home is. Unable to bear Morikawa's fading smile, Kasuga gets up and reaches towards her... | 01KGBTM60P07GJW1CXYKT75GTZ | 4.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 4 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_32ZXW6SKK4MG | CNT_05MAE89EB230 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 8 | [] | One Warm Spring, Chapter 8 | When Kasuga tries to apologize to Morikawa about not being able to go to the summer festival with her, he's shocked to learn that she had planned on going with her friends anyway. On the evening of the festival, our two groups run into each other, along with an unexpected guest... | 01KGBTNPA38N83GWFZ6YHH4QDB | 8.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 8 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3T3SQ1DY42SG | CNT_3A01Z92MK0E0 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 10 | [] | One Warm Spring, Chapter 10 | Kasuga's and Morikawa's birthdays are only a day apart, so it's only natural that Kasuga is extra ecstatic about celebrating. Unfortunately, Morikawa has already made plans with her friends. Feeling bad about not being able to spend time with Kasuga, she invites him as well. Her friends are a little less than thrilled. but perhaps they just need some more time to warm up to him. *Bonus comic included | 01KGBTMACFY8QS1XERDSXKEK8R | 10.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 10 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3X6VC79AC0ZG | CNT_3CNBY6D5DY80 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 5 | [] | One Warm Spring, Chapter 5 | Finals are over, and An suggests celebrating with some karaoke! With Kasuga's weird singing and a giant sundae on the table, laughter and antics are all around. Then, on the way home, Morikawa asks Kasuga a question, catching him completely off guard! | 01KGBTM7RBBKJMWHX368K73ARC | 5.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 5 | (C)Kanato Ooima/COMPASS | 2025-08-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3YG82MF001RG | CNT_1DAYYMRWYZF0 | One Warm Spring CNT_39PAKZBDHM5G | 3 | 1 | 1 | Chapter 7 | [] | One Warm Spring, Chapter 7 | Worried about Kasuga's grades, Morikawa sets up a study session, inviting An and Kitamu as well. Seeing that neither Kasuga nor An are taking their session seriously, however, he tells them off in anger. Now alone for the first time with Kitamu, Morikawa musters up the courage and tells him about her feelings...for Kasuga! | 01KGBTM8QZ1XZ7ZEN96W3BWZQT | 7.0 | 2025-05-16T07:00:00.000Z | COMPASS LAB_1D0R022A7YRG | GEO_1PKAG51AEAQG | One Warm Spring, Chapter 7 | (C)Kanato Ooima/COMPASS | 2025-08-08T07: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);