products

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

7 rows where series_id = "CNT_2G1WQ24WEWEG"

✎ View and edit SQL

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_071DSP6AHM70 CNT_0FCTR34S6QC0 Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 6 []   Black Bullet, Vol. 6   Rentaro is still a fugitive, running from the law for a murder he didn't commit. He and Hotaru are bruised, bleeding, and barely on speaking terms, but they're equally desperate to uncover the identity of Suibara's killer. However, Police Superintendent Hitsuma hasn't given up on pursuing Rentaro! With Hitsuma's impending marriage to heartbroken Kisara advancing closer and closer, will Rentaro clear his name and rescue her in time? And what does saving Kisara mean for their future?   01KG9Z04DY1H5498NJXBAG7BDV 6.0 2017-04-17T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 6     2017-04-17T15:00:00.000Z   0 0
PRD_0DF759R8B460 CNT_3B78EK2D8DZ0 Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 7 []   Black Bullet, Vol. 7   The Akasaka Palace reception hall is playing host to a summit welcoming the leaders of Japan's five governmental Areas. The Seitenshi, host and head of Tokyo Area, greets her equivalents from Osaka, Sendai, Hakata, and Hokkaido, and few are willing to lend a sympathetic ear to her attempts at brokering peace.The conference falls into chaos, the Seitenshi shocked that someone leaked out a state secret. The fallout soon brings the two Areas down the path to all-out war with each other--just as the Seitenshi vanishes from the palace!   01KG9ZCW60EB5QR2P18YRRWCAB 7.0 2017-09-18T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 7     2017-09-18T15:00:00.000Z   0 0
PRD_167HZT0DTVQ0 CNT_2EE8726CCNWG Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 3 []   Black Bullet, Vol. 3   (Volume 1)The future--where a terrible battle against a parasitic virus called "Gastrea" has been fought, and lost. Humanity is cornered, and lives in despair. Rentaro and Enju face constant danger in their work as a team anti-Gastrea specialists known as "Civil Security." If the daily fight against oblivion weren't enough, they'll soon face a threat that could destroy all of Tokyo...   01K5G9XQ8WD4DNJYSV1NHDNY0Q 3.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_342MG1GXJJRG CNT_1W1BPGR2HCT0 Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 1 []   Black Bullet, Vol. 1   The World Has Already Ended.The future--where a terrible battle against a parasitic virus called "Gastrea" has been fought...and lost. Humanity is cornered and lives in despair. Rentaro and Enju face constant danger in their work as a team of anti-Gastrea specialists known as "civil security officers." As if the daily fight against oblivion weren't enough, they'll soon face a threat that could destroy all of Tokyo...   01KG94JY7Y522N04EB54H44JQ1 1.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_39A42BQFZRXG CNT_2PRJVVE2YV6G Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 4 []   Black Bullet, Vol. 4   One of the giant Monoliths that protects Tokyo Area from the virally superpowered Gastrea creatures has been destroyed. And right on schedule, the Stage Four Gastrea Aldebaran leads an invading army of the monsters into the city. The elite self-defense forces are sent to face them, and the terrible sounds of war echo across a newly christened battlefield--but soon a tense silence falls. What is it that appears before the eyes of Rentaro and his friends? The near-future thriller of post-apocalyptic survival continues!   01KG98463YF51WRW4AJ3TCRBG0 4.0 2016-08-29T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 4     2016-08-29T15:00:00.000Z   0 0
PRD_3QD133ESKKRG CNT_22EC5AGFGDT0 Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 2 []   Black Bullet, Vol. 2   The World Has Already Ended.Following Rentaro Satomi's defeat of the Stage Five Gastrea, Tokyo Area returns to uneasy normalcy. When the ambitious leader of Osaka Area, Sougen Saitake, demands a visit with Lady Seitenshi, she needs a new bodyguard--and who should she pick but the city's new hero, Rentaro. However, dark forces are conspiring against Lady Seitenshi, and their origin is closer to home than anyone dares to imagine. Rentaro and Enju will have to confront a new kind of threat in order to protect the tenuous peace they've won--but how do you fight an enemy you can't even see?   01KG95HGA3Y53BPPK0VZZ7VBGM 2.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_3R7ZJXJ33KXG CNT_0G7SVCZHA66G Black Bullet CNT_2G1WQ24WEWEG CNT_2G1WQ24WEWEG 2 2 1 Volume 5 []   Black Bullet, Vol. 5   With the chaos of the Third Kanto Battle subsiding, peace is finally returning to the Tendo Civil Security Agency, and Rentaro, Kisara, Enju, and Tina are taking full advantage of the quiet. But when an old friend from Rentaro's childhood reappears, their bright days turn suddenly dark--and Rentaro finds himself imprisoned for a senseless murder. He plans a desperate escape, but his enemies keep coming, and they are like nothing he's ever fought before...   01KG98ANCT55X9NTC1VSC6CSWB 5.0 2016-12-27T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Black Bullet, Vol. 5     2016-12-27T15:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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