products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
9 rows where series_id = "CNT_1G0QF822C35G"
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_023KNS9JGKXG | CNT_1V12MJE1N2X0 | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 4 | [] | A Tropical Fish Yearns for Snow, Vol. 4 | A sudden fever keeps Koyuki from participating at the Aquarium Club open house during the Nanahama High School culture festival. After a successful solo amberjack show, Konatsu stops by to wish Koyuki well and teasingly compares her to the salamander from a short story. Now Koyuki can't stop thinking about how Konatsu once compared herself to the frog from that story. As school obligations keep them apart, Koyuki and Konatsu start to realize just how important they are to each other. | 01KGB7VKXCW92WH5Q54ZC5YVTZ | 4.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 4 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_06G27CBMWJWG | CNT_3TBZMW4A01Y0 | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 7 | [] | A Tropical Fish Yearns for Snow, Vol. 7 | Konatsu senses that she and Koyuki, the only two members of the Aquarium Club, are connected by loneliness, and she's afraid that her bond with Koyuki is weakening as it gradually changes. When Konatsu's feelings finally erupt, Koyuki resolves to face her head-on, leading to a clash of feelings before the girls can confirm how important they are to each other. | 01KGB7VHMD3FZ6BCTM5Y4B3GAF | 7.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 7 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_0ZD3A6C8MMYG | CNT_3VPNN0SS63W0 | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 9 | [] | A Tropical Fish Yearns for Snow, Vol. 9 | Even though life is changing for Koyuki and Konatsu, the Aquarium Club and the little salamander that brought them together will remain a special, immutable link between them in the days ahead. As autumn arrives and Koyuki's graduation looms, Konatsu summons all her courage to confront one lingering doubt—must their friendship end just because their stories are diverging? | 01KGB7VMSRAD04EFG6FM2CKGGE | 9.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 9 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_15WZ1AE6YA50 | CNT_2430R9V2KT6G | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 1 | [] | A Tropical Fish Yearns for Snow, Vol. 1 | Konatsu is doing her best to adapt to her new school, but being required to join a club has introduced additional pressures. Her friendly classmate Kaede invites her to join the Home Ec Club, but Konatsu hasn't even had time to consider which club she's interested in. Meanwhile, Koyuki is like a ray of sunshine in Konatsu's cloudy world. Will Konatsu join the Aquarium Club? | 01KGB6V5JA7B0TYMCJ596KR54V | 1.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 1 | © MAKOTO HAGINO 2017 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_18DECX88T940 | CNT_07DXVVHAYS7G | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 8 | [] | A Tropical Fish Yearns for Snow, Vol. 8 | The Aquarium Club is finally coming alive after welcoming new members, but summer is nearing and Koyuki has started studying hard for exams. Working up her resolve, Koyuki invites Konatsu on a moonlit walk on the beach where she bares her heart about an important choice. Graduation is approaching and the time they have left together is more precious than ever, but how does Konatsu respond to hearing Koyuki's decision? | 01KGB7VVQ8NE5H0JEGQ2Q1K458 | 8.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 8 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_208TE3RQYJD0 | CNT_2TPS4V95VJEG | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 3 | [] | A Tropical Fish Yearns for Snow, Vol. 3 | Koyuki and Konatsu, each lonely in her own way, are the only two members of the Nanahama High School Aquarium Club. As they spend time together, they discover that they are increasingly drawn to each other. When they go to the town summer festival together, Konatsu is finally able to ask why Koyuki spoke to her that first day at the aquarium open house. But Koyuki doesn't have an easy answer, and her stumbling reply makes the mood uncomfortable. Will this new awkwardness force a distance between them? | 01KGB7VKD9V2PMHSP85VGMZXHF | 3.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 3 | © Makoto Hagino 2018 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_2TQ86931AN80 | CNT_0RQ1TC8CJN3G | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 6 | [] | A Tropical Fish Yearns for Snow, Vol. 6 | Koyuki and Konatsu have both started to see the other as important, but they're still unable to be honest about their feelings. This leads to frustrating days when they're never in sync, and they begin to drift apart. Then one day Konatsu sees Koyuki and her classmate Kaede spending time together as if they're the best of friends, and she can't contain her agitation. Konatsu and Koyuki feel so strongly about each other that they feel uneasy even when there's nothing to worry about. | 01KGB7VPV8SYK4K8V43PC33TED | 6.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 6 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_2XTBWGZDJKE0 | CNT_0VCC59MXCKDG | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 2 | [] | A Tropical Fish Yearns for Snow, Vol. 2 | From the moment they met at the Aquarium Club's open house, Konatsu has admired Koyuki and treated her like she wasn't a distant figure on a pedestal. In turn, Koyuki has been open and welcoming to the new girl who stirs her heart. When the time comes to pick a club, Konatsu chooses the Aquarium Club with Koyuki. And even though it's just the two of them, they manage to host a successful open house. What's next for Koyuki and Konatsu, now that the shared experience has deepened the bond between them? | 01KGB7VMB949VSD72YF1KR7JKW | 2.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 2 | © MAKOTO HAGINO 2018 / KADOKAWA CORPORATION | 2023-05-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_37QQ81Z1GBNG | CNT_14EA871YDAN0 | A Tropical Fish Yearns for Snow CNT_1G0QF822C35G | CNT_1G0QF822C35G | 2 | 1 | 1 | Volume 5 | [] | A Tropical Fish Yearns for Snow, Vol. 5 | The day of the Aquarium Club's open house has finally arrived, and the shark show is a great success. Koyuki is so thrilled by the victory that she actually jumps for joy. But baring her feelings in front of everyone is too much for her to handle, and she ends up running away. Thankfully Koyuki's family and Konatsu accept her just the way she is. And as Koyuki and Konatsu spend more time together, each of the girls finds a place in her heart for the other. | 01KGB7VY2PR0XDCQBBPKG4X7S4 | 5.0 | 2023-05-19T07:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | A Tropical Fish Yearns for Snow, Vol. 5 | © Makoto Hagino 2019 / KADOKAWA CORPORATION | 2023-05-20T07: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);