products

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

8 rows where series_id = "CNT_3JVSQC28P6H0"

✎ View and edit SQL

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

CSV options: 

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);