products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_3JVSQC28P6H0"
This data as json, CSV (advanced)
Suggested facets: copyright, 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_00RZNX63J3V0 | CNT_39VKQABTAQR0 | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 2 | [] | With You and the Rain 2 | On a rainy summer evening, a woman and a "dog" happened to meet each other, and life has never been the same since. What new adventures await this unusual duo as summer turns to fall? | 01KGADY01M6GGF965SYDZV0H53 | 2.0 | 2021-12-15T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 2 | With You and the Rain Ko Nikaido/Kodansha Ltd. | 2021-12-28T08:00:00.000Z | 0 | 0 | |||||
| PRD_01B6MRQEVAR0 | CNT_02S1S0BATQEG | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 3 | [] | With You and the Rain 3 | On a rainy summer night, I met a little friend. It's cold out now, but we're enjoying a warm winter together. The cozy, precious days continue in Volume 3! | 01KGAJFQTJ863JR4N2TMD8TYH8 | 3.0 | 2022-08-16T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 3 | With You and the Rain Ko Nikaido/Kodansha Ltd. | 2022-08-23T07:00:00.000Z | 0 | 0 | |||||
| PRD_0AX4B7MEVJTG | CNT_3KS5WB2J1WHG | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 5 | [] | With You and the Rain 5 | A woman and a critter met on a rainy summer day. As they savored the changing seasons, foods, and conversations together, a year passed and the rainy season came around again.... | 01KG9P131CH7P7WTM4XS4WV31R | 5.0 | 2023-08-16T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 5 | Ko Nikaido/Kodansha Ltd. | 2023-08-29T07:00:00.000Z | 0 | 0 | |||||
| PRD_0C3JYWZHE420 | CNT_2178TKTA21C0 | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 4 | [] | With You and the Rain 4 | On a rainy summer night, I met a little friend. We seem to get along, and before we knew it, it was spring. Let's enjoy another 365 days together. | 01KGB4HEEQTKSA97ASBKVG60Y8 | 4.0 | 2023-02-14T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 4 | Ko Nikaido/Kodansha Ltd. | 2023-02-28T08:00:00.000Z | 0 | 0 | |||||
| PRD_0CD6RM4AY4W0 | CNT_29SE0KMGXRCG | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 1 | [] | With You and the Rain 1 | If it looks like a dog and acts like a dog and insists it's a dog, it's...a dog? Probably? She adopted it anyway, and her life with this "dog" will never be boring! | 01KGADDEXAWSHM6HBRX534H6MZ | 1.0 | 2021-11-04T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 1 | With You and the Rain Ko Nikaido/Kodansha Ltd. | 2021-11-23T08:00:00.000Z | 0 | 0 | |||||
| PRD_13ATEX1SEC80 | CNT_3Z9PQBQAWNP0 | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 8 | [] | With You and the Rain 8 | On a rainy summer evening, a woman and a "dog" happened to meet each other. This time around, Fuji is in for a big, big change... | 01KGC1V745JRPE63XQ4VJ8YYPQ | 8.0 | 2025-11-18T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 8 | Ko Nikaido/KODANSHA LTD. | 2025-12-09T08:00:00.000Z | 0 | 0 | |||||
| PRD_15N4Z65EDWM0 | CNT_3KNY85E39VKG | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 7 | [] | With You and the Rain 7 | On a rainy summer evening, a woman and a "dog" happened to meet each other. After living together for over a year, the two have become something like family... | 01KG9QNVEVYD9H8T7Q5M5DDACH | 7.0 | 2025-02-06T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 7 | Ko Nikaido/Kodansha Ltd. | 2025-02-11T08:00:00.000Z | 0 | 0 | |||||
| PRD_15T7SWJJQK80 | CNT_0XD5HZRJHP9G | With You and the Rain CNT_3JVSQC28P6H0 | CNT_3JVSQC28P6H0 | 2 | 1 | 1 | Volume 6 | [] | With You and the Rain 6 | A woman and a critter met on a rainy summer day. As they savored the changing seasons, foods, and conversations together, a year passed and the rainy season came around again. But even the most tranquil days can conceal unease, and awkward encounters can become beautiful connections... | 01KGBA233B6XD6G5YQEJQGTTRS | 6.0 | 2024-05-16T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | With You and the Rain 6 | Ko Nikaido/Kodansha Ltd. | 2024-05-28T07: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);