BookWalker

home / database

product_contributors

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

35 rows where contributor_id = "CON_0HXC1XKVVTD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_06RJY5ZGQFYG,CON_0HXC1XKVVTD0,1 Volume 9 PRD_06RJY5ZGQFYG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0790XC04GZV0,CON_0HXC1XKVVTD0,1 Volume 2 PRD_0790XC04GZV0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_079D2E0518AG,CON_0HXC1XKVVTD0,1 Volume 11 PRD_079D2E0518AG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0BZK8Z2EWYT0,CON_0HXC1XKVVTD0,1 Volume 8 PRD_0BZK8Z2EWYT0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0CBEVCSHK27G,CON_0HXC1XKVVTD0,1 Volume 4 PRD_0CBEVCSHK27G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0DV00W6MCA50,CON_0HXC1XKVVTD0,1 Volume 6 PRD_0DV00W6MCA50 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0E5NTPBM0XR0,CON_0HXC1XKVVTD0,1 Volume 16 PRD_0E5NTPBM0XR0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0EC3VKZGRXS0,CON_0HXC1XKVVTD0,1 Volume 3 PRD_0EC3VKZGRXS0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0PPQRDFA4MG0,CON_0HXC1XKVVTD0,1 Volume 12 PRD_0PPQRDFA4MG0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0SNPPKAPCJP0,CON_0HXC1XKVVTD0,1 Volume 7 PRD_0SNPPKAPCJP0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0W87SNX0STS0,CON_0HXC1XKVVTD0,1 Volume 10 PRD_0W87SNX0STS0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_0WNCT0HHNH3G,CON_0HXC1XKVVTD0,1 Volume 12 PRD_0WNCT0HHNH3G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_13PJ24BAA9XG,CON_0HXC1XKVVTD0,1 Volume 11 PRD_13PJ24BAA9XG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_167DDQ5CP8WG,CON_0HXC1XKVVTD0,1 Volume 2 PRD_167DDQ5CP8WG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_19ACAX0RYP2G,CON_0HXC1XKVVTD0,1 Volume 5 PRD_19ACAX0RYP2G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_1HK2GSVX0VZ0,CON_0HXC1XKVVTD0,1 Volume 3 PRD_1HK2GSVX0VZ0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_1X3VRBKCFDAG,CON_0HXC1XKVVTD0,1 Volume 5 PRD_1X3VRBKCFDAG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_1Z03GH90EAYG,CON_0HXC1XKVVTD0,1 Volume 1 PRD_1Z03GH90EAYG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2CNACWEP6W8G,CON_0HXC1XKVVTD0,1 Volume 1 PRD_2CNACWEP6W8G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2G9F74W56M0G,CON_0HXC1XKVVTD0,1 Volume 9 PRD_2G9F74W56M0G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2J7BJNXYKPD0,CON_0HXC1XKVVTD0,1 Volume 16 PRD_2J7BJNXYKPD0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2KB7ZGZMTZW0,CON_0HXC1XKVVTD0,1 Volume 15 PRD_2KB7ZGZMTZW0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2KQQB61208NG,CON_0HXC1XKVVTD0,1 Volume 8 PRD_2KQQB61208NG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2P4Q5ZY61KYG,CON_0HXC1XKVVTD0,1 Volume 13 PRD_2P4Q5ZY61KYG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2QXMS6G9CD60,CON_0HXC1XKVVTD0,1 Volume 1 PRD_2QXMS6G9CD60 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2RAAR8374D3G,CON_0HXC1XKVVTD0,1 Volume 15 PRD_2RAAR8374D3G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_2ZNK3QVNN3NG,CON_0HXC1XKVVTD0,1 Volume 2 PRD_2ZNK3QVNN3NG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_31ZTVETF88D0,CON_0HXC1XKVVTD0,1 Volume 4 PRD_31ZTVETF88D0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_37PQC6CWW0P0,CON_0HXC1XKVVTD0,1 Volume 13 PRD_37PQC6CWW0P0 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_3BJB8XPPE90G,CON_0HXC1XKVVTD0,1 Volume 7 PRD_3BJB8XPPE90G Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_3BJB8XPPE90G,CON_0HXC1XKVVTD0,2 Volume 7 PRD_3BJB8XPPE90G Kentaro Sato CON_0HXC1XKVVTD0 2  
PRD_3HBCEMFKCN50,CON_0HXC1XKVVTD0,1 Volume 14 PRD_3HBCEMFKCN50 Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_3KBTYF8R2VFG,CON_0HXC1XKVVTD0,1 Volume 6 PRD_3KBTYF8R2VFG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_3N7BPCD5J8TG,CON_0HXC1XKVVTD0,1 Volume 14 PRD_3N7BPCD5J8TG Kentaro Sato CON_0HXC1XKVVTD0 1  
PRD_3YRVY8Y30AF0,CON_0HXC1XKVVTD0,1 Volume 10 PRD_3YRVY8Y30AF0 Kentaro Sato CON_0HXC1XKVVTD0 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.773ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS