BookWalker

home / database

product_contributors

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

17 rows where contributor_id = "CON_3NARWS0ZPSBG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0F40P4KXTFYG,CON_3NARWS0ZPSBG,2 Volume 14 PRD_0F40P4KXTFYG Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_182DZ6YGE2D0,CON_3NARWS0ZPSBG,2 Volume 15 PRD_182DZ6YGE2D0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_18N7EFA9W1S0,CON_3NARWS0ZPSBG,2 Volume 5 PRD_18N7EFA9W1S0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_1CC5RMHE60FG,CON_3NARWS0ZPSBG,2 Volume 3 PRD_1CC5RMHE60FG Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_1GNVQ7FBB2A0,CON_3NARWS0ZPSBG,2 Volume 13 PRD_1GNVQ7FBB2A0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_1QD03QXAF1A0,CON_3NARWS0ZPSBG,2 Volume 10 PRD_1QD03QXAF1A0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_2M4HGAQM0210,CON_3NARWS0ZPSBG,2 Volume 9 PRD_2M4HGAQM0210 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_2PS7HYTQ52F0,CON_3NARWS0ZPSBG,2 Volume 16 PRD_2PS7HYTQ52F0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_2QV21PENZPG0,CON_3NARWS0ZPSBG,2 Volume 17 PRD_2QV21PENZPG0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_2SFYZ9BXJSAG,CON_3NARWS0ZPSBG,2 Volume 20 PRD_2SFYZ9BXJSAG Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_2Z1HW6EE9N7G,CON_3NARWS0ZPSBG,2 Volume 7 PRD_2Z1HW6EE9N7G Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_31CAQRPP22F0,CON_3NARWS0ZPSBG,2 Volume 18 PRD_31CAQRPP22F0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_31D4181RAYS0,CON_3NARWS0ZPSBG,2 Volume 12 PRD_31D4181RAYS0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_372HC38G2WY0,CON_3NARWS0ZPSBG,2 Volume 19 PRD_372HC38G2WY0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_3B49BS0KB6N0,CON_3NARWS0ZPSBG,2 Volume 8 PRD_3B49BS0KB6N0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_3C50M7K0WCS0,CON_3NARWS0ZPSBG,2 Volume 11 PRD_3C50M7K0WCS0 Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  
PRD_3NMAWJQ6ZRNG,CON_3NARWS0ZPSBG,2 Volume 4 PRD_3NMAWJQ6ZRNG Shizu Yamauchi (cover illustrator) Noriko Kanagami (cover designer) CON_3NARWS0ZPSBG 2  

Advanced export

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

CSV options:

CREATE TABLE product_contributors (
      product_id TEXT NOT NULL,
      contributor_id TEXT NOT NULL,
      role INTEGER NOT NULL,
      name_override TEXT,
      PRIMARY KEY (product_id, contributor_id, role),
      FOREIGN KEY (product_id) REFERENCES products(id),
      FOREIGN KEY (contributor_id) REFERENCES contributors(id)
    );
CREATE INDEX idx_product_contributors_contributor ON product_contributors(contributor_id);
Powered by Datasette · Queries took 7.942ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS