products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_1Z6Q0PREDWK0"
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_0WNSE7DC7QN0 | CNT_0JXD8J2RKM1G | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 4 | [] | Burn the House Down 4 | Anzu Murata, assuming the false name of Shizuka Yamauchi, sneaks into the Mitarai household under the guise of a housekeeper in order to ascertain the truth behind the fire 13 years ago — a fire for which her mother took all the blame. Selling herself to Makiko, the hard-to-please second wife of her father, Dr. Mitarai, she continues scouring the Mitarai household for clues as she gradually gains Makiko's trust. Her real identity having been deduced by Makiko's older son, Kiichi, Anzu finds herself in a dilemma when Kiichi offers her a surprising overture: "I'll tell you what happened on the day of the fire." What could his true intentions be behind this?! | 01KGB1TMZGAJCZ29R5E55SB3FN | 4.0 | 2022-09-08T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 4 | Burn the House Down Moyashi Fujisawa/Kodansha Ltd. | 2022-09-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_1MGHF4BZJ11G | CNT_24X85JNM53V0 | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 1 | [] | Burn the House Down 1 | Shizuka Yamauchi, 25, housekeeper. Makiko Mitarai, 46, amateur model and perfect housewife. Though strangers on the outside, the two share a past—one Shizuka feels she needs to set right, to bring her mother justice. But Makiko has secrets of her own, and Shizuka will need to tread carefully if she's to get to the bottom of it all without getting burned. | 01KGAH14Q3SDBCZXMAZP6NWTR4 | 1.0 | 2022-06-09T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 1 | Burn the House Down Moyashi Fujisawa/Kodansha Ltd. | 2022-06-28T07:00:00.000Z | 0 | 0 | |||||
| PRD_1RKTC4FZGQE0 | CNT_2TG29SQG13E0 | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 7 | [] | Burn the House Down 7 | Anzu Murata sneaks into the Mitarai household under the guise of a housekeeper and overcomes danger after danger as she becomes Makiko's manager, narrowly snatching the two sisters from the brink of disaster while she continues her search of the truth behind the fire 13 years ago-a fire for which her mother was labeled the criminal behind its outbreak. "Mujina," a follower of Makiko's Wixi in the past, suddenly appears online. Using her, Anzu discovers the integral truth of Makiko's connection to the fire and finally reveals her true identity to Makiko! | 01KGB41S7D46DHRX5EVZT8HVH5 | 7.0 | 2022-12-09T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 7 | Moyashi Fujisawa/Kodansha Ltd. | 2022-12-27T08:00:00.000Z | 0 | 0 | |||||
| PRD_1W13QG4KX8VG | CNT_0QD8GXXKG4VG | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 8 | [] | Burn the House Down 8 | Anzu Murata sneaks into the Mitarai household under the guise of a housekeeper, suspicious that the second woman her father married, Makiko, was the culprit behind the fire 13 years ago - a fire for which her mother was labeled the criminal behind its outbreak. After overcoming many dangers, getting Makiko cornered is finally within sight...but it turns out the real culprit is someone else! After experiencing betrayal after betrayal, just what is the truth behind the fire? | 01KG9KG7DCPCJ8REND1E0KKMN6 | 8.0 | 2023-01-10T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 8 | Moyashi Fujisawa/Kodansha Ltd. | 2023-01-24T08:00:00.000Z | 0 | 0 | |||||
| PRD_25EWS6H9DG50 | CNT_0THYT18ZQW70 | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 6 | [] | Burn the House Down 6 | Anzu Murata, assuming a false name, sneaks into the Mitarai household under the guise of a housekeeper in search of the truth behind the fire 13 years ago-a fire for which her mother was labeled the criminal behind its outbreak. Operating independently, Anzu's younger sister, Yuzu, reunites with their estranged father and presses him for information, but Makiko finds out about their clandestine meetings. Anzu takes action to keep their father quiet about their plans and becomes Makiko's manager, narrowly snatching the two sisters from the brink of disaster. While feigning disinterest in the Mitarai house, Yuzu secretly continues the search for the truth by looking into Makiko's fans from 13 years past! | 01KGB2EGMYKGPG68E8E085G97S | 6.0 | 2022-11-07T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 6 | Moyashi Fujisawa/Kodansha Ltd. | 2022-11-22T08:00:00.000Z | 0 | 0 | |||||
| PRD_2R4JAYAZMQYG | CNT_3VNDR8FKF4F0 | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 5 | [] | Burn the House Down 5 | Anzu Murata, assuming a false name, sneaks into the Mitarai household under the guise of a housekeeper in search of the truth behind the fire 13 years ago-a fire for which her mother was labeled the criminal behind its outbreak. Makiko, the second wife of her father, Dr. Mitarai, receives Anzu into the house, and Anzu continues scouring the Mitarai home for clues behind the scenes as she gains Makiko's trust. With the cooperation of Makiko's older son, Kiichi, she closes in on the shared past between her mother and Makiko. Operating independently, Anzu's younger sister, Yuzu, reunites with their estranged father and presses him for help in determining the truth...but Makiko appears at the cafe where they're meeting! | 01KGB24ZW69Z4S5YTYTJ00H4JZ | 5.0 | 2022-10-12T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 5 | Burn the House Down Moyashi Fujisawa/Kodansha Ltd. | 2022-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3HTB7ES49PKG | CNT_17RCB3XGQ2T0 | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 3 | [] | Burn the House Down 3 | Anzu Murata, assuming the false name of Shizuka Yamauchi, sneaks into the Mitarai household under the guise of a housekeeper in order to ascertain the truth behind the fire 13 years ago — a fire for which her mother took all the blame. Selling herself to Makiko, the hard-to-please second wife of her father, Dr. Mitarai, she continues scouring the Mitarai household for clues as she gradually gains Makiko's trust. Just as she's on the verge of finding proof that would connect Makiko to the fire, Anzu's real identity is deduced by Makiko's son, Kiichi! | 01KGAJFP7VH8FN74CX02DFSBC0 | 3.0 | 2022-08-16T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 3 | Burn the House Down Moyashi Fujisawa/Kodansha Ltd. | 2022-08-23T07:00:00.000Z | 0 | 0 | |||||
| PRD_3WRFJFXPTYM0 | CNT_0BG9QFJBZ0HG | Burn the House Down CNT_1Z6Q0PREDWK0 | CNT_1Z6Q0PREDWK0 | 2 | 1 | 1 | Volume 2 | [] | Burn the House Down 2 | Anzu Murata snuck into the Mitarai residence under the guise of a housekeeper in order to ascertain the truth behind the fire 13 years ago – a fire for which her mother took all the blame. Sneaking behind the back of Makiko Mitarai, the harsh second wife of her father, Anzu expands her search of the house up to the forbidden second floor. There, she meets a suspicious shut-in and, thinking to take advantage of him, she attempts to make contact with him. But because of a certain mistake, she brings down Makiko's wrath...! | 01KGAJ5HYHDG1MBQMB4WHN0GWV | 2.0 | 2022-07-06T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Burn the House Down 2 | Burn the House Down Moyashi Fujisawa/Kodansha Ltd. | 2022-07-26T07: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);