BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_2CVR9154C5YG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_09S8HS7TXH60,CON_2CVR9154C5YG,2 Volume 3 PRD_09S8HS7TXH60 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0DC10ACEPC0G,CON_2CVR9154C5YG,2 Volume 1 PRD_0DC10ACEPC0G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0EPHP0W4FVK0,CON_2CVR9154C5YG,2 Volume 2 PRD_0EPHP0W4FVK0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0GTCSW74KX60,CON_2CVR9154C5YG,2 Volume 4 PRD_0GTCSW74KX60 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0J9ZARN2ZWCG,CON_2CVR9154C5YG,2 Volume 1 PRD_0J9ZARN2ZWCG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0MS4RMXVVAGG,CON_2CVR9154C5YG,2 Volume 17 PRD_0MS4RMXVVAGG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0PM983DK9T3G,CON_2CVR9154C5YG,12 Volume 6 PRD_0PM983DK9T3G Eiri Shirai CON_2CVR9154C5YG 12  
PRD_0YNXX1RYZBY0,CON_2CVR9154C5YG,2 Volume 20 PRD_0YNXX1RYZBY0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_0ZBSQ71J52QG,CON_2CVR9154C5YG,12 Volume 4 PRD_0ZBSQ71J52QG Eiri Shirai CON_2CVR9154C5YG 12  
PRD_11ZSG4DR1HTG,CON_2CVR9154C5YG,12 Volume 2 PRD_11ZSG4DR1HTG Eiri Shirai CON_2CVR9154C5YG 12  
PRD_1CT210BJNA5G,CON_2CVR9154C5YG,12 Volume 3 PRD_1CT210BJNA5G Eiri Shirai CON_2CVR9154C5YG 12  
PRD_1E0WGZ7FRMJ0,CON_2CVR9154C5YG,2 Volume 16 PRD_1E0WGZ7FRMJ0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1GQ3XQ10ZQ4G,CON_2CVR9154C5YG,2 Volume 21 PRD_1GQ3XQ10ZQ4G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1H39BP52KCE0,CON_2CVR9154C5YG,2 Volume 2 PRD_1H39BP52KCE0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1J93N1CF5QF0,CON_2CVR9154C5YG,2 Volume 6 PRD_1J93N1CF5QF0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1MKQ8K6M2XS0,CON_2CVR9154C5YG,2 Volume 22 PRD_1MKQ8K6M2XS0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1NQ829TJ6JG0,CON_2CVR9154C5YG,2 Volume 2 PRD_1NQ829TJ6JG0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_1NS71F1AMTX0,CON_2CVR9154C5YG,2 Volume 11 PRD_1NS71F1AMTX0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_230T16JEQVC0,CON_2CVR9154C5YG,2 Volume 18 PRD_230T16JEQVC0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_251TYQ4B7410,CON_2CVR9154C5YG,2 Volume 12 PRD_251TYQ4B7410 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_2C7WQ4NJ47C0,CON_2CVR9154C5YG,2 Volume 3 PRD_2C7WQ4NJ47C0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_2D08P14JKQZ0,CON_2CVR9154C5YG,2 Volume 9 PRD_2D08P14JKQZ0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_2XHF9Y4R7AYG,CON_2CVR9154C5YG,12 Volume 1 PRD_2XHF9Y4R7AYG Eiri Shirai CON_2CVR9154C5YG 12  
PRD_2YHGADMW475G,CON_2CVR9154C5YG,2 Volume 1 PRD_2YHGADMW475G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_2ZAYMS0WN86G,CON_2CVR9154C5YG,2 Volume 14++ PRD_2ZAYMS0WN86G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_376ESQN798VG,CON_2CVR9154C5YG,2 Volume 8 PRD_376ESQN798VG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3A77ZSE6RFN0,CON_2CVR9154C5YG,2 Volume 7 PRD_3A77ZSE6RFN0 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3F14TCZ9ABKG,CON_2CVR9154C5YG,12 Volume 5 PRD_3F14TCZ9ABKG Eiri Shirai CON_2CVR9154C5YG 12  
PRD_3J4PQ32BCN7G,CON_2CVR9154C5YG,2 Volume 14 PRD_3J4PQ32BCN7G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3QHFS1VBNYBG,CON_2CVR9154C5YG,2 Volume 1 PRD_3QHFS1VBNYBG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3QP1KQAF8P40,CON_2CVR9154C5YG,2 Volume 15 PRD_3QP1KQAF8P40 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3RP1AE5S74FG,CON_2CVR9154C5YG,2 Volume 13 PRD_3RP1AE5S74FG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3TCTC4XCR3HG,CON_2CVR9154C5YG,2 Volume 14+ PRD_3TCTC4XCR3HG Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3TE82KJAKQ7G,CON_2CVR9154C5YG,2 Volume 19 PRD_3TE82KJAKQ7G Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3TY8KY56RW30,CON_2CVR9154C5YG,2 Volume 10 PRD_3TY8KY56RW30 Eiri Shirai CON_2CVR9154C5YG 2  
PRD_3XY9HY25S0SG,CON_2CVR9154C5YG,2 Volume 5 PRD_3XY9HY25S0SG Eiri Shirai CON_2CVR9154C5YG 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 9.622ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS