database: products: 16 rows where series_id = "CNT

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

16 rows where series_id = "CNT_311SD8B3ECT0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_03CQD1FFRQZG	CNT_3HSV00WS3HV0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 4	[]	Non Non Biyori Vol. 4	The adventures of rural Asahigaoka Branch School and it's handful of students continues!		01K5GB0DKX7DKEEJDXS5AGRKZY	4.0	2016-05-30T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 4	(C) Atto 2010	2016-05-30T15:00:00.000Z
PRD_0AXVAA59PXBG	CNT_12GR3GGR08F0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 3	[]	Non Non Biyori Vol. 3	Summer break is over, which means that's time to return to Asashigoaka Branch school with its leaky roof, single grade-combined classroom, and a teacher who just wants to sleep all the time. School isn't forever though and no one knows that better than those who've graduated, like Kaede who runs the local sweet shop. But before the girls of Asahigoaka Branch can see that far ahead, Natsumi learns what happens when you put off studying for exams, Hotaru gets lost in the woods, and everyone takes a turn participating in the school festival. Learn the true meaning of autumn in volume 3 of Non Non Biyori!		01K5GAWJWVH8FQMFP7VRHBT542	3.0	2016-01-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 3	(C) Atto 2010	2016-01-25T15:00:00.000Z
PRD_0BXH0ETQA7Y0	CNT_14X8F0VZRK0G	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 12	[]	Non Non Biyori Vol. 12	Miyauchi Renge: First grader, the youngest of the five students at Asahigaoka Branch School. She only wears the shirt she wore camping on sunny days. Koshigaya Natsumi: Seventh grader at Asahigaoka Branch School. When she goes camping, she gets worried that she’ll be bitten by too many mosquitos and run out of blood. Ichijo Hotaru: Fifth grade transfer student from Tokyo. Of everyone who went camping, she’s the one who is least bothered by bugs. Koshigaya Komari: Eighth grader at Asahigaoka Branch School. Even while camping, she makes sure tosteel herself to be a responsible older sister.		01KGA7DMFZ920ZV0PVWZYK1Q48	12.0	2019-07-25T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 12	Atto 2018	2019-09-03T07:00:00.000Z
PRD_0T514NJ3S800	CNT_20VCAJ1B9C8G	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 15	[]	Non Non Biyori Vol. 15	Miyauchi Renge: First grader, the youngest of the five students at Asahigaoka Branch School. "If Koma-chan keeps lying to herself, she'll never really grow up." Koshigaya Natsumi: Seventh grader at Asahigaoka Branch School. The key to building a snowman is a strong foundation! She'll take on this task and give it her all this winter. Koshigaya Komari: Eighth grader at Asahigaoka Branch School. This year, she finally graduates from the carefree world of childhood. Kamakura snow forts, snowmen, snowball fights...goodbye to them all. Ichijo Hotaru: Fifth grade transfer student from Tokyo. She's never seen this kind of snow in the city, so it makes her very happy! It's so pretty and soft that she wants to stuff a bunch of it away and keep it forever!		01KG9GKN0TD6XF0TP9H8WQEDMC	15.0	2021-08-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 15	Atto 2020	2021-10-12T07:00:00.000Z
PRD_0TG8DJE4466G	CNT_27NAFPBW1VD0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 13	[]	Non Non Biyori Vol. 13	Koshigaya Natsumi: Seventh grader at Asahigaoka Branch School. If she found the last ice cream treat, then it's hers. That's a Natsumi-ism. Koshigaya Komari: Eighth grader at Asahigaoka Branch School. She really wants some ice cream, but she's the oneesan so she's being strong. But she does want some...but she's strong... Miyauchi Renge: First grader, the youngest of the five students at Asahigaoka Branch School. The question of how she can make Natsun's ice cream her own is the puzzle of the century for Ren-chon now. Ichijo Hotaru: Fifth grade transfer student from Tokyo. She seems like she's cool as can be, but she wants to eat that ice cream more than anyone else. But she can't say that. She really can't say that.		01KGA7YXCR0DYN3NSPAR64D0CF	13.0	2020-05-20T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 13	Atto 2018	2020-06-23T07:00:00.000Z
PRD_1ZPZKMM07Q70	CNT_24X779YBVBH0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 14	[]	Non Non Biyori Vol. 14	Miyauchi Renge: First grader, the youngest of the five students at Asahigaoka Branch School. With a dozen pencils as a prize, sports day at Asahigaoka's a big event, huh...? Koshigaya Natsumi: Seventh grader at Asahigaoka Branch School. She's been waiting and watching with a sharp eye...for this chance to get revenge on the graduates! Well, she doesn't have any secret strategy, but she's totally going to win!! Ichijo Hotaru: Fifth grade transfer student from Tokyo. There aren't enough people, so she keeps getting stuck in all the events. Sports day at Asahigaoka is super hard!! Koshigaya Komari: Eighth grader at Asahigaoka Branch School. She likes tug-of-war best of all the events where everyone joins together. "My strength's not useless. It's not...right?"		01KG9DFGGCGTMSACM81MV0SQFZ	14.0	2020-11-13T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 14	Atto 2019	2021-01-05T08:00:00.000Z
PRD_2CA9Z5XXAPHG	CNT_178GWKG68FCG	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 7	[]	Non Non Biyori Vol. 7	Koshigaya Natsumi Seventh grader at Ashigaoka Branch School. The lies in her journal are constantly exposed, since she sees a certain someone every day. She laments the small world of the countryside. Miyauchi Renge First grader, the youngest of the five students at Ashigaoka Branch School. “When I asked Nee-nee what 'dressed up' is, she got all hung up on the question.” Koshigaya Komari Natsumi's older sister, grade eight student. She decided on “the creatures around me” as her research subject, but there are just too many of them, so she shed some tears over it. Ichijo Hotaru Fifth grader, transfer student from Tokyo. The summer version of the Koma shuffle... well, turns out it's not school-safe.		01KG9Z13ZA40QBRYPX67QKZV85	7.0	2017-05-28T05:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 7	(C) Atto 2014	2017-05-28T05:00:00.000Z
PRD_2SV21DPDAK5G	CNT_09FZYC3VAED0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 2	[]	Non Non Biyori Vol. 2	Ah, summer in the country... School is out and there's nothing to do but have fun. Well, except for summer homework. Or tests of courage gone horribly wrong. Or having to explain your terrible grades to your mother. Maybe summer isn't so great after all! Still, there are plenty of delightful summer adventures for the few students and one teacher of Asashigoaka Branch School. Join Natsumi, Komari, Renge, Hotaru, and the rest of the gang as they take a trip to the beach, hunt cicadas, make new friends, and try to figure out what else to do on their long, hot summer days. It's (almost) all fun and games...	Big adventures in a small town!	01K5GAP7N0XSRMD372SSJ41H3G	2.0	2015-10-26T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 2	(C) Atto	2015-10-26T15:00:00.000Z
PRD_2WBSSMVFP3G0	CNT_2B2AN0PH65K0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 5	[]	Non Non Biyori Vol. 5	The adventures of rural Asahigaoka Branch School and it's handful of students continues!		01KG983VTDCB62B9C0J0Q92QYM	5.0	2016-09-06T06:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 5	(C) Atto 2010	2016-09-06T06:00:00.000Z
PRD_37Z36HS259V0	CNT_205ZCA9ADDZ0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 10	[]	Non Non Biyori Vol. 10	Koshigaya Natsumi Seventh grader at Asahigaoka Branch School. The Hina dolls are dressed up all stuffy. Must be hot and hard to breathe. She totally couldn't stand it. Ichijo Hotaru Fifth grade transfer student from Tokyo. Someday, she wants to make a Hina doll set with Senpai as the Empress! Miyauchi Renge First grader, the youngest student at Asahigaoka Branch School. “Are all the Hina dolls musicians? They look like they're having so much fun playing their music!” Koshigaya Komari Natsumi's older sister. Eighth grader at Asahigaoka Branch School. She adores the Empress doll, because she's royalty and definitely the most stylish.		01KGA4V4WMV7J15T52NFBYMZY7	10.0	2018-06-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 10	Atto 2016	2018-07-31T07:00:00.000Z
PRD_39T2PTE52GR0	CNT_06K8C6S3NTVG	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 1	[]	Non Non Biyori Vol. 1	Welcome to the countryside village of Asahigaoka, a quaint town far-removed from the hustle-and-bustle of the big city. You couldn’t imagine a more isolated setting in all of Japan. So when Tokyo-raised elementary school student Hotaru Ichijo transfers to the tiny Asahigaoka Branch School due to her father’s job, she’s in the for the culture shock of her life! Join Hotaru and her new friends, the eccentric Renge, and the mischevious sisters Natsumi and Komari, as they share daily adventures in the idyllic Japanese countryside.	Big adventures in a small town!	01K5G9S6Q1D0Z4E78PYJ5MTTEB	1.0	2015-10-04T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 1	(C) Atto 2010	2015-10-04T15:00:00.000Z
PRD_3A2Z6GECJM20	CNT_3B82QJ5GH6VG	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 16	[]	Non Non Biyori Vol. 16	Ichijo Hotaru Fifth grade transfer student from Tokyo. Ever since she came here, every season has passed so quickly and so happily. She'll be graduating in the blink of an eye. Koshigaya Komari Eighth grader at Asahigaoka Branch School. Graduation, huh...? Maybe she'll cry when it's her turn. She hasn't given up on growing into a tall, proud woman by then. Miyauchi Renge First grader, the youngest of the five students at Asahigaoka Branch School. Nii-nii's graduation makes her a teensy bit sad, even though she can see him any old time. Koshigaya Natsumi Seventh grader at Asahigaoka Branch School. Normally, graduation has you bawling your eyes out, right? She's got nothing but great memories of school...except for tests.		01KGAGR1TBGA9J1KASTFHP8ZTY	16.0	2022-05-30T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 16	Atto 2021	2022-07-05T07:00:00.000Z
PRD_3BWCSVT9KN4G	CNT_3G7CR9YTEESG	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 8	[]	Non Non Biyori Vol. 8	Koshigaya Natsumi Seventh grader at Asahigaoka Branch School. Uses a green/red memorization ruler (which blocks the red answers in the textbook). Never once has she used it as originally intended. Miyauchi Renge First grader, the youngest of the five students at Asahigaoka Branch School uses an orthodox plastic ruler. Also uses it for arithmetic. Koshigaya Komari Natsumi's older sister, eighth grader at Asahigaoka Branch School. Uses a bamboo ruler. A gem that she inherited from her mother, it's been passed down through the generations of the Koshigaya family. Ichijo Hotaru Fifth grade transfer student from Tokyo. Uses an isosceles triangle ruler from a ruler set. It was selected with balance in mind.		01KG9ZBV3VD7M296R527C4K3YT	8.0	2017-08-24T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 8	(C) Atto 2015	2017-09-12T04:00:00.000Z
PRD_3KYXTZB0W1FG	CNT_255EBVHJWMMG	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 6	[]	Non Non Biyori Vol. 6	Welcome to the countryside village of Asahigaoka, a quaint town far removed from the hustle-and-bustle of the big city. You couldn't imagine a more isolated setting in all of Japan. So when Tokyo-raised elementary school student Hotaru Ichijo transfers to the tiny Asahigaoka Branch School due to her father's job, she's in for the culture shock of her life! Join Hotaru and her new friends, the eccentric Renge and the mischievous sisters Natsumi and Komari, as they share daily adventures in the idyllic Japanese countryside.		01KG98ARTZBVS5Z1DE5ZDB66S5	6.0	2017-01-17T04:59:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 6	(C) Atto 2010	2017-01-17T04:59:00.000Z
PRD_3QSJDWG7P51G	CNT_2PCTW0HPQ1C0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 11	[]	Non Non Biyori Vol. 11	Ichijo Hotaru: Fifth grade transfer student from Tokyo. With the daily log, she can remember the events of the day pretty quickly, so she likes writing and reading it a fair bit. Koshigaya Komari: Natsumi's older sister. Eighth grader at Asahigaoka Branch School. If only you didn't have to erase the blackboard on day duty, it wouldn't be so bad... Miyauchi Renge: First grader, the youngest of the five students at Asahigaoka Branch School. She tried disposable chopsticks and bamboo strips, but toothpicks really hold it together the best. Koshigaya Natsumi: Seventh grader at Asahigaoka Branch School. Kinda weird that the logbook goes around once every three days, huh?		01KGA5NDSQ8MGJZYQ8AD60K8JA	11.0	2019-02-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 11	Atto 2017	2019-04-02T07:00:00.000Z
PRD_3XNQBE6H1ZD0	CNT_3SVX9A0TJBA0	Non Non Biyori CNT_311SD8B3ECT0	CNT_311SD8B3ECT0	2	1	1	Volume 9	[]	Non Non Biyori Vol. 9	Koshigaya Natsumi Seventh grader attending Asahigaoka Branch School. She tends not to get enough sleep at New Year's because she sits in front of the TV from morning until night watching the special New Year's shows.?Miyauchi Renge First grader, the youngest student at Asahigaoka Branch School. For her first calligraphy of the year, she wrote “Search for Truth.” Koshigaya Komari Eighth grader attending Asahigaoka Branch School. She wants to buy an “eye phone” with her otoshidama, but she's not sure she has enough... Ichijo Hotaru Fifth grade transfer student from Tokyo. When it snows, familiar landscapes are turned completely white. It's like an illusion!		01KGA3DWHEXVTC4FDN579TWMAD	9.0	2018-04-18T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Non Non Biyori Vol. 9	(C) Atto 2015	2018-04-20T07:00:00.000Z

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