products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_3ZJ07SCDG450"
This data as json, CSV (advanced)
Suggested facets: listed_at, on_sale_at, 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_0G7RFF3XATRG | CNT_0ECVATPWPWVG | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 4 | [] | Sunshine Sketch, Vol. 4 | Nothing much has changed at the Hidamari Apartments for some time: Miyako's her usual, wacky self; Sae's still writing novels; Hiro's worrying about her weight; and Yuno's still as thoughtful and adorable as ever! But believe it or not, time has been passing, and Yuno starts thinking about what the future holds for her, her friends, and her art as graduation looms ever closer. The immediate future of the Hidamari residents, however, involves two new first-year neighbors - the shy, polite Nazuna, and outspoken computer whiz Nori! Do these newbies have any idea what they're in for?! | 01KG9865BV3MXJY30BKA3YBQ1H | 4.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 4 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0MM8T3X7PSZG | CNT_21Q8A4B55W4G | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 2 | [] | Sunshine Sketch, Vol. 2 | Daily life at the Hidamari Apartments goes on as the girls continuetheir art studies. Trips to the zoo, onsen excursions, and schoolprojects fill their days as yuno, Miya, Sae, and Hiro's friendshipsdeepen. Take another peek into the lives of these memorable artstudents in the second installment of Sunshine Sketch! | 01KG986310B1AB03FZM8H3AVT0 | 2.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 2 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0W93ZCB5GBWG | CNT_25QGGC6Z806G | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 9 | [] | Sunshine Sketch, Vol. 9 | Yuno is thinking so hard about her future prospects, it's even haunting her dreams! But the cure for a furrowed brow is good friends, and the girls at Hidamari Apartments (including their newest tenant Matsuri!) aren't about to let Yuno stress out alone. Whether it's an unexpected encounter on a college visit, a swimsuit shopping adventure, or a school trip to Kyoto, Nara, and Osaka, the days are getting a little more out of the ordinary...and a lot more fun! | 01KGA3JSF7ESPA7YM7JJSC9DCN | 9.0 | 2018-09-18T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 9 | 2018-09-18T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1F814KPP0VA0 | CNT_1FCQV65G5E90 | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 7 | [] | Sunshine Sketch, Vol. 7 | With Sae and Hiro staring their college entrance exams straight in the face, the underclassmen of Hidamari Apartments are reminded that their own graduation is just a short time away...but there's still plenty of time for the girls to make fun memories in the meanwhile! | 01KG9867JSQ6ESTS092HW6R460 | 7.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 7 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_217V2KE8GJZ0 | CNT_329BZNP7161G | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 10 | [] | Sunshine Sketch, Vol. 10 | The final summer vacation, the final sports festival, the final cultural festival…As Yuno’s senior year at Yamabuki marches on, she becomes acutely aware of how precious these high school moments are. Even though the upcoming entrance exams weigh heavily on her, Yuno’s not going to let these last months with her Hidamari friends go to waste! There’s still plenty of time for sushi outings, pool parties, and stargazing-but maybe the bug catching is best left to Miyako… | 01KG9H2ZTXQYVKGHMY08DB94TC | 10.0 | 2021-09-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 10 | 2021-10-05T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2KYHP6GRCT90 | CNT_3EQ4THVRGDA0 | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 5 | [] | Sunshine Sketch, Vol. 5 | With the innocent first-years Nazuna-chan and Nori-chan rounding out the quirky cast of residents at the Hidamari Apartments, every day is shaping up to be quite...erm, interesting! When Yuno manages to lose a battle with a toilet for her house key, her clumsiness leads to, among other things, a sleepover, which in turn becomes something of a habit. But with homesickness making the rounds through Hidamari, school trips for some residents resulting in others being left to their own wacky devices, and the pressures of college entrance exams looming, a girl like Yuno can use all the dedicated friends and fun sleepovers she can get! Grab a pillow and settle in for another sunny, heartwarming romp through Hidamari! | 01KG98663K87T0XWKES837SX2B | 5.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 5 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2PF01SJ28S80 | CNT_1E1HT3G0ZCB0 | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 3 | [] | Sunshine Sketch, Vol. 3 | The adventures of Yuno and company continue in the third volume of this hilarious 4-koma series. Yuno is a high school student attending a school which specializes in the arts. With a group of quirky friends and crazy teachers, Yuno feels more and more like she is part of a family at the Hidamari Apartments. | 01KG9863P3X8NF0KRSM0YMNSPH | 3.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 3 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2TXGKCC4MRF0 | CNT_31CETD69ABM0 | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 1 | [] | Sunshine Sketch, Vol. 1 | Accepted to a high school specializing in the arts, Yuno moves into anearby apartment complex to make her commute easier. Just a few daysinto her new routine, she quickly discovers that creativity doesn't endwith the art school bell! Her neighbors - Sae, Hiro, and Miya -are allfellow students, and each has her own hilarious quirks. Andeccentricity clearly rules this school; Yuno's homeroom teach is acosplay otaku and the principal is just...weird. Will the quiet Yuno be able to handle this creatively kooky cast of characters? | 01KG6ZHHGABA5SVS7A5W3AB0ZZ | 1.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 1 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_390YJ97H2WTG | CNT_0FQHBXABWYSG | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 8 | [] | Sunshine Sketch, Vol. 8 | All good things must come to an end, and with Sae and Hiro's graduation, the two girls bid farewell to Hidamari Apartments. But they aren't the only ones who have to face the future head-on. Yuno, now in her third year, is struggling with career uncertainty herself! And when a new first-year, Matsuri, moves into the building and old friends make way for the new, how will timid Yuno handle her new role as senpai?! | 01KG98683NGMNWZTY2G1SB7GYG | 8.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 8 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3DH9XW1VEVSG | CNT_2F2EBF0MBXTG | Sunshine Sketch CNT_3ZJ07SCDG450 | CNT_3ZJ07SCDG450 | 2 | 1 | 1 | Volume 6 | [] | Sunshine Sketch, Vol. 6 | Real life and growingup are bearing down fast upon the residents of the Hidamari apartments, but they'regoing to make time for one last summer together, full of fun in the sun! AmidstYuno deciding on the topic of her self-assigned summer project and Sae and Hiroattending summer sessions to help focus their goals for life after high school,the girls will really have to go all out to make sure it's a summer they'llnever forget! | 01KG9866PVYFTCW93G5V7KE8SV | 6.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sunshine Sketch, Vol. 6 | 2016-08-18T15: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);