products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
9 rows where series_id = "CNT_2W05C30ANGPG"
This data as json, CSV (advanced)
Suggested facets: 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_004D1C2VFWEG | CNT_0SBGQ82QQZNG | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 9 | [] | No. 6 Volume 9 | THE SKY IS BURNING. With Rat critically injured protecting him, Shion finally returns to NO. 6. But what he finds there is not the tranquil utopia he left behind, but a city in the grip of panic and chaos. As the ""holy city"" collapses in on itself, Shion and Rat put the future of humanity - and their future together - on the line in the shocking final volume of NO. 6! | 01KG997WWN4V5RFDM65S4R0V6Q | 9.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 9 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_04TWC0WXBVDG | CNT_2RPDPVQ02YPG | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 7 | [] | No. 6 Volume 7 | SHION! WHAT ARE YOU TRYING TO DO?! Safu is a prisoner on the top floor of the Correctional Facility. Shion and Rat manage to slip back in amid the chaos sown by Dogkeeper, but what they find is almost too terrifying to conceive... countless neatly organized rows of corpses, with their brains removed! Backed into a corner, Rat is ready for death, but Shion seizes a weapon, and insists on surviving at any cost-! Includes special bonus story! From the Trade Paperback edition. | 01KG997VMXN91EE9TM0RBKDCBH | 7.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 7 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_0BBCZKY7QTCG | CNT_0R0TP5D8HXQG | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 5 | [] | No. 6 Volume 5 | ""THE MANHUNT IS HERE!"" ? The rumors were true! Armored vehicles from No. 6 roar through the gate into West Block, massacring the helpless and arresting everyone else. Amid the chaos, Shion and Rat realize this could be their only chance to get into the Correctional Facility and save Safu. But when they do make it inside, what they find is worse than anyone could have imagined... ? PRAISE FOR THE ANIME ? ""Sadly beautiful in places, hauntingly violent in others, No. 6 [is] worth your time."" - Anime News Network ? ""No. 6 is science fiction the way it's meant to be - boundary pushing... and completely spellbinding."" -Inside AX | 01KG997TJMYGGGEHK2BKJSGXMS | 5.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 5 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_0FSZ96R9KTKG | CNT_2VAQHQ3GWWGG | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 3 | [] | No. 6 Volume 3 | I'M WITH YOU, NO MATTER WHAT. ? On the run from No. 6, Shion begins moves in with Rat in West Block. Though life outside the comfort of the city is a trial, Shion learns to survive. Meanwhile, back in Chronos, the elite core of No. 6, Safu begins to look into his disappearance only to find herself under arrest! And what can Shion possibly do from exile to help his lifelong friend? | 01KG997RDMBYCQ1ZV2KBWWZH15 | 3.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 3 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1JEFMSNKZSJG | CNT_0TN4H2SSBVHG | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 1 | [] | No. 6 Volume 1 | A PERFECT LIFE, IN A PERFECT CITY For Shion, an elite student in the technologically sophisticated city No. 6, life is carefully choreographed. School, study, and the occasional visit with his friend and classmate Safu. One fateful day, however, he takes a misstep, sheltering an injured boy his age from a typhoon. Known only as Rat, this boy is a VC - a fugitive living outside the computerized tapestry of city control - and helping him will throw Shion's life into chaos and start him down a path to discovering the appalling secrets behind the superficial perfection of No. 6. | 01KG98DDT66MCW1CDZT8KT4PGF | 1.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 1 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_252459F29VX0 | CNT_3RB46WJ4BE60 | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 6 | [] | No. 6 Volume 6 | TO OBLITERATE NO. 6... THAT'S WHY I'VE COME. A series of strange incidents cast a pall over No. 6 as it prepares to celebrate its ""Holy Day."" Meanwhile, in the tunnels beneath the Correctional Facility, Shion and Rat meet with the mysterious ""Elder,"" who reveals the perverse origins of No. 6, and their connection to Rat's past. How will Rat react when Shion begins to touch his most secret scars? PRAISE FOR THE ANIME ? ""Sadly beautiful in places, hauntingly violent in others, No. 6 [is] worth your time."" - Anime News Network ? ""No. 6 is science fiction the way it's meant to be - boundary pushing... and completely spellbinding."" -Inside AX | 01KG997V5NA4ZGCWC51PY3Z78D | 6.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 6 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_26DNVPDRDWY0 | CNT_1S0Q6JXVWF50 | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 8 | [] | No. 6 Volume 8 | I LOVE YOU, SHION. MORE THAN ANYTHING. Risking everything, Shion and Rat have finally made it to the top floor of the Correctional Facility, where Shion is finally reunited with Safu! But has Shion's rescue attempt come too late? Is the Safu he once knew gone forever? As Rat rushes to find a way out, Shion must make a heartbreaking decision: Leave, saving Rat and himself from capture, or stay, and find another solution? Either way, Shion may lose a friend, or his own life! The tale of No. 6 builds to a climax in its second-to-last volume! Includes special bonus story! | 01KG997W3YG50QZXDH7XT7P32J | 8.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 8 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_29GMGW94NTW0 | CNT_1VNH6E8CPD70 | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 4 | [] | No. 6 Volume 4 | ""OUR CHANCES OF SURVIVAL ARE ROUGHLY ZERO PERCENT."" ? Shion accidentally learning that his childhood friend Safu is under arrest - and all because of him! Not wanting to get Rat involved, Shion sets out alone to save her. But how can he possibly infiltrate No. 6's secure correctional facility and escape with a high-priority prisoner all on his own? | 01KG997T1V324ZHJKX6KF0BX67 | 4.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 4 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_2C172FBEHS30 | CNT_3V0E1SYN5C00 | No. 6 CNT_2W05C30ANGPG | CNT_2W05C30ANGPG | 2 | 1 | 1 | Volume 2 | [] | No. 6 Volume 2 | I KNEW NOTHING BEFORE TODAY. ? With the help of the enigmatic Rat, Shion becomes a fugitive, escaping No. 6 and getting his first glimpse of the desperation and violence that are facts of life outside the city wall. And as Shion learns more about the secret that forced him into exile, his loyalty to the people he left behind and Rat's thirst for revenge threaten to tear the pair apart! | 01KG997QYQG1SQD2EAR1B1Z2JB | 2.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | No. 6 Volume 2 | (C) Atsuko Asano / Hinoki Kino / Kodansha Ltd. | 2016-10-25T07: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);