products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
13 rows where series_id = "CNT_1M1535FXVYWG"
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_0GY65QMN1PYG | CNT_1T7KGRNK9V4G | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 4 | [] | CITY Volume 4 | Niikura chases after the cat that ran off with her precious pendant, and Nagumo quickly follows, determined to discover whatever secret Niikura has stashed away inside--when suddenly she is whisked away to a mysterious tower where she must conquer a series of challenges or be honored with a most sumptuous feast... wait, what? And so the residents of the CITY take part in revelries... | 01KG9ATJRWV0RQ04BWMM1R85J2 | 4.0 | 2018-11-27T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY Volume 4 | (C) Keiichi Arawi / Kodansha Ltd. | 2018-12-11T08:00:00.000Z | 0 | 0 | |||||
| PRD_0PGZA3P2MYK0 | CNT_2VBB7V8V4Z9G | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 8 | [] | CITY 8 | The big day is finally here: The 4th Local City Race is upon us! Eight pairs will enter, each more absurd and unexpected than the last, but only one will emerge victorious to claim the 1-million-yen prize. All of CITY's heavy hitters are here: Nagumo, Granny, Dr. Adatara, the Self-Proclaimed Quiz King... Wait, what?! Who even is that??! And why weren't the rest of us allowed to enter???! The scattershot charm of Keiichi Arawi's masterpiece comes together with laser focus to bring you the biggest, craziest, funniest volume of CITY yet! | 01KGA92SCEQS6DXX3ERX7YKPE7 | 8.0 | 2020-05-07T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 8 | Keiichi Arawi / Kodansha Ltd. | 2020-05-12T07:00:00.000Z | 0 | 0 | |||||
| PRD_0PR2RMN2JWX0 | CNT_1Z9A9061J150 | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 3 | [] | CITY Volume 3 | Niikura wakes up to find Nagumo and Wako camping out in her apartment, and the lure of buried treasure brings out everyone’s competitive side. The Adatara family has a boisterous breakfast routine that Mom handles like an orchestra conductor. Tanabe is on a mission to reward the Man Who Is Too Nice. Ecchan and Matsuri invent their own two-person club, and the City South Eleven vow to protect their MVP. And so the days roll by in the City… | 01KGA56HAHBDN6R4RW2R4B9K5R | 3.0 | 2018-09-05T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY Volume 3 | (C) Keiichi Arawi / Kodansha Ltd. | 2018-09-18T07:00:00.000Z | 0 | 0 | |||||
| PRD_0QGZD739FG8G | CNT_0VHSD1FWVJ30 | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 7 | [] | CITY 7 | The City Three Crows try to make the best of summer in the face of overwhelming odds, while Ecchan and Matsuri inevitably waste their time by trying to make the most of it. Niikura reveals her shameful midnight snacking habits even as she tortures Nagumo with unwanted ghost stories, while on the plus side, Nagumo's rent problems may finally be solved when an Edo-period bandit comes to the rescue?! The soccer team's roster of stupendous characters still can't win a game, the barber makes an accidental fortune and loses it again, Wako resists manga stardom, everyone in town has a crush on her little sister Riko, and the mysterious quadrennial CITY race approaches... Return once again to the charming, mind-bending, always unpredictable world of life in the big CITY. | 01KGA8K1J8EDV4R8XYQ1RVY19J | 7.0 | 2020-02-04T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 7 | Keiichi Arawi / Kodansha Ltd. | 2020-02-11T08:00:00.000Z | 0 | 0 | |||||
| PRD_0SJ1SHWYZW80 | CNT_1JJ0AGRJG0R0 | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 10 | [] | CITY 10 | Summer is in full swing, and Nagumo is as desperate as ever to make a buck. Makabe's is closed, so apart from an appearance in Troupe Tekaridake's latest masterwork, she's got no source of income—and no choice but to turn to the internet. With Niikura behind the camera, what could go wrong? But Nagumo's public humiliation leads to some unexpected reunions... Summer in the CITY doesn't mean lazy days for everyone, however: Class 2-3's make-up exam is postponed indefinitely as they devote their energy to a Guinness world record, the Surprising Shogi championship grips fans with its preposterous thrills, and Wako joins forces with Kamaboko Oni to save "Mr. Bummer" from the threat of cancellation. Need a vacation from normal life? Why not spend summer in the CITY? | 01KG9DKG0AT1B84DQ5PWTVGKY8 | 10.0 | 2020-12-15T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 10 | Keiichi Arawi / Kodansha Ltd. | 2021-01-05T08:00:00.000Z | 0 | 0 | |||||
| PRD_18BSNPRGK1JG | CNT_2MKF849X6CNG | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 1 | [] | CITY Volume 1 | From the creator of nichijou, this surreal-slapstick series revolves around a penniless college student, Midori Nagumo, who lives in an ordinary city filled with not-quite-ordinary people. And as this reckless girl runs about, she sets the city in motion. Midori is in a bit of a bind. She is in debt, and her landlady is trying to shake her down for unpaid rent. Her best friend refuses to loan her cash since she's wised up to her tricks. Maybe some bullying would help. Or a bit of petty theft? Neither is sustainable. Maybe getting a job would settle things... But working means less time for fun adventures in the big city... | 01KGA3KPFNP2P18XJBNW5G75Z6 | 1.0 | 2018-03-12T15:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY Volume 1 | (C) Keiichi Arawi / Kodansha Ltd. | 2018-03-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_29A5WMW7XAEG | CNT_37JW8A9YDZMG | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 2 | [] | CITY Volume 2 | Niikura reflects on how her friendship with Nagumo began. Wako Izumi is intrigued by Nagumo, and gets a totally wrong idea about her relationship with Niikura. Tatewaku Makabe scores a dubious point during a soccer game, and his father tries to game a peculiar restaurant. Meanwhile, super-strong Granny continues to be unbeatable... | 01KGA4J920YRRQ40DFPE207E7V | 2.0 | 2018-05-29T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY Volume 2 | (C) Keiichi Arawi / Kodansha Ltd. | 2018-06-12T07:00:00.000Z | 0 | 0 | |||||
| PRD_34N2WD0QAA0G | CNT_0QAACANMRF30 | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 9 | [] | CITY 9 | The big race is over, and everything is back to "normal" in the CITY - as normal as it ever gets, anyway: Shia attempts to simultaneously take the advertising world by storm and annoy her way into Tatsuta Adatara's heart, the City Three Crows continue their ongoing quest for the perfect summer vacation, and Tatewaku, Matsuri, and Ecchan tackle the impossible challenge of finding a band name that isn't already taken. Meanwhile, Nagumo's endless quest for cash takes her through various games of skill and chance: a watermelon seed-spitting contest, bobbing for gold bars at the summer festival, even the 7th Annual CITY Quiz Championship. We've got spies, we've got love (or is it like?), we even have the perils of...THE BOUTIQUE?! We've got it all here in the CITY - where nothing is ever as normal as it seems. | 01KG9CTM3279D3AT8F5XT5YZ5X | 9.0 | 2020-07-17T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 9 | Keiichi Arawi / Kodansha Ltd. | 2020-07-23T07:00:00.000Z | 0 | 0 | |||||
| PRD_36393EAC7M60 | CNT_3E4QS1DBG66G | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 6 | [] | CITY 6 | Nagumo is in a bit of a bind. She's a college student, and like many people in her situation, is struggling with money. She is in debt and her landlord is trying to shake her down for rent. Asking her friends no longer works! They know her deal and they do not have the cash to prop her up, even temporarily. So what is she supposed to do under these circumstances? Well maybe bullying would help. Maybe petty theft? Neither one is realistic. Maybe getting a job would settle things... But that means working and not having fun in the big city. That also means not spending all your earnings before paying your rent. Life in the city is an adventure. Thankfully its a fruitful and entertaining one at that! | 01KG9BW9DBH4YVZ94N5CX3K4G8 | 6.0 | 2019-10-21T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 6 | Keiichi Arawi / Kodansha Ltd. | 2019-10-29T07:00:00.000Z | 0 | 0 | |||||
| PRD_375R72QEJE50 | CNT_14NFDQ53K8SG | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 12 | [] | CITY, 12 | Some changes are coming to the CITY—with Ecchan departing for good and Nagumo finally ready to pay Granny back (if she'll accept the money), things won't be the same around the neighborhood. Meanwhile, Captain Obina agrees to a soccer shootout with the fate of Gongenyama hanging in the balance, an unexpected prize-winning photograph creates another unexpected celebrity, and even the mysterious creatures living in the sewers don't know what to make of a bizarre newcomer. Surprised? Don't be. Everyone should know by now that all bets are off in the CITY! | 01KG9G8CKGVK5YM3267MY32ZZY | 12.0 | 2021-07-08T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY, 12 | Keiichi Arawi / Kodansha Ltd. | 2021-07-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_3GBCAF34NJFG | CNT_2QTASYXDJD60 | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 11 | [] | CITY 11 | Riko Izumi is about to go on the greatest adventure of her life—and she won't even remember it! Tatewaku's crush gets him into hot water, cold water, and every kind in between as he tries to keep her safe, and maybe even get her to reciprocate his feelings. Love! Friendship! Death! Robots! Pirates! Extraterrestrial cephalopods! Pop songs! Welcome to the most epic volume of CITY ever, at least since the last one. Keiichi Arawi takes us out of the CITY and on a high-seas adventure that no one will ever forget (except Riko). | 01KG9FGEW0AG70N5H72SQ97G6D | 11.0 | 2021-05-19T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 11 | Keiichi Arawi / Kodansha Ltd. | 2021-05-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3MC65JDW0Y20 | CNT_0MNH7ANGSTCG | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 5 | [] | CITY Volume 5 | Niikura tries to catch Nagumo in a compromising position. The Tekaridake Theatre Troupe tries to recruit a new member, as Niikura recruits help in finding her still-missing pendant. A night full of shooting stars gives the residents of Sweet Olive Manor something to wish for, and Ecchan and Matsuri hatch a plan to bring about world peace. But a few folks have very close calls with the Grim Reaper... | 01KGA6X2JF6A1DNH1QFTXESCJX | 5.0 | 2019-04-19T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY Volume 5 | (C) Keiichi Arawi / Kodansha Ltd. | 2019-04-30T07:00:00.000Z | 0 | 0 | |||||
| PRD_3P0QGW4XF81G | CNT_25AQJXW67X2G | CITY CNT_1M1535FXVYWG | CNT_1M1535FXVYWG | 2 | 1 | 1 | Volume 13 | [] | CITY 13 | It's the tail end of summer, but the whole city is set in motion as the heavy hitters join the mayoral race to stop Granny, who vows to turn the CITY into an elderly dictatorship, from becoming the next mayor. Keiichi Arawi wraps up his masterpiece with the grandest and craziest volume yet. And it's one filled with laughter and tears! The story ends here. But the CITY and its people will live on forever! | 01KGADBX4MCZG7N95RFZ3GJ07Z | 13.0 | 2022-01-21T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | CITY 13 | CITY Keiichi Arawi/Kodansha Ltd. | 2022-02-01T08: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);