BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_01R0XZ49TYGG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00RM8WB2YAG0,CON_01R0XZ49TYGG,1 Volume 6 PRD_00RM8WB2YAG0 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_0235YNQG8Q00,CON_01R0XZ49TYGG,1 Volume 11 PRD_0235YNQG8Q00 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_09JFJ0BKWP6G,CON_01R0XZ49TYGG,1 Volume 4 PRD_09JFJ0BKWP6G Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_0Y7894DRMA40,CON_01R0XZ49TYGG,1 Volume 17 PRD_0Y7894DRMA40 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_1NSJVSW5Q960,CON_01R0XZ49TYGG,1 Volume 5 PRD_1NSJVSW5Q960 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_214GP8SC6G80,CON_01R0XZ49TYGG,1 Volume 1 PRD_214GP8SC6G80 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_238EHWTFCD9G,CON_01R0XZ49TYGG,1 Volume 14 PRD_238EHWTFCD9G Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2CQ39JWDCDD0,CON_01R0XZ49TYGG,1 Volume 10 PRD_2CQ39JWDCDD0 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2GANQ4SSD6FG,CON_01R0XZ49TYGG,1 Volume 2 PRD_2GANQ4SSD6FG Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2JAM9T0BV1MG,CON_01R0XZ49TYGG,1 Volume 3 PRD_2JAM9T0BV1MG Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2NY7Y6FG26Z0,CON_01R0XZ49TYGG,1 Volume 16 PRD_2NY7Y6FG26Z0 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2TF6GGA66R1G,CON_01R0XZ49TYGG,1 Volume 7 PRD_2TF6GGA66R1G Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2XFEXP36N8EG,CON_01R0XZ49TYGG,1 Volume 13 PRD_2XFEXP36N8EG Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_2Y0GZKRWZRH0,CON_01R0XZ49TYGG,1 Volume 18 PRD_2Y0GZKRWZRH0 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_329ZR75E229G,CON_01R0XZ49TYGG,1 Volume 8 PRD_329ZR75E229G Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_3A198PTRKPK0,CON_01R0XZ49TYGG,1 Volume 15 PRD_3A198PTRKPK0 Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_3KVY729NCEJG,CON_01R0XZ49TYGG,1 Volume 12 PRD_3KVY729NCEJG Yu Hashimoto CON_01R0XZ49TYGG 1  
PRD_3X6DVYJFDHPG,CON_01R0XZ49TYGG,1 Volume 9 PRD_3X6DVYJFDHPG Yu Hashimoto CON_01R0XZ49TYGG 1  

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.925ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS