BookWalker

home / database

product_contributors

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

39 rows where contributor_id = "CON_15V8PVHFM9N0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0197C6FQ8KW0,CON_15V8PVHFM9N0,1 Volume 23 PRD_0197C6FQ8KW0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0329Q2CVKJGG,CON_15V8PVHFM9N0,1 Volume 15 PRD_0329Q2CVKJGG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_05M99W33NSBG,CON_15V8PVHFM9N0,1 Volume 12 PRD_05M99W33NSBG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0B7GNW8G7NV0,CON_15V8PVHFM9N0,1 Volume 9 PRD_0B7GNW8G7NV0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0D26K37SDAJ0,CON_15V8PVHFM9N0,1 Volume 21 PRD_0D26K37SDAJ0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0K2A5R10148G,CON_15V8PVHFM9N0,1 Volume 22 PRD_0K2A5R10148G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0NXJ8VPE9M30,CON_15V8PVHFM9N0,1 Volume 20 PRD_0NXJ8VPE9M30 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0W8Q8TR2V630,CON_15V8PVHFM9N0,1 Volume 14 PRD_0W8Q8TR2V630 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_0YS5TFEC0VHG,CON_15V8PVHFM9N0,1 Volume 4 PRD_0YS5TFEC0VHG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_15D7V91K3M50,CON_15V8PVHFM9N0,1 Volume 4 PRD_15D7V91K3M50 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_168GEFZ3KY2G,CON_15V8PVHFM9N0,1 Volume 10 PRD_168GEFZ3KY2G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_19GSXDPYY3K0,CON_15V8PVHFM9N0,1 Volume 24 PRD_19GSXDPYY3K0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_1AWH2BVCBT3G,CON_15V8PVHFM9N0,1 Volume 5 PRD_1AWH2BVCBT3G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_1CGTJRQTH17G,CON_15V8PVHFM9N0,1 Volume 3 PRD_1CGTJRQTH17G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_1RWNM65DDZFG,CON_15V8PVHFM9N0,1 Volume 1 PRD_1RWNM65DDZFG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_1VGPSJDVYTJ0,CON_15V8PVHFM9N0,1 Volume 19 PRD_1VGPSJDVYTJ0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2246HKVN8260,CON_15V8PVHFM9N0,1 Volume 2 PRD_2246HKVN8260 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_25HW7306S990,CON_15V8PVHFM9N0,1 Volume 6 PRD_25HW7306S990 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_28PA7BY72MP0,CON_15V8PVHFM9N0,1 Volume 25 PRD_28PA7BY72MP0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2BYXKZAVZE70,CON_15V8PVHFM9N0,1 Volume 10 PRD_2BYXKZAVZE70 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2EQ204XZ04EG,CON_15V8PVHFM9N0,1 Volume 3 PRD_2EQ204XZ04EG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2FTC2ECK2JKG,CON_15V8PVHFM9N0,1 Volume 11 PRD_2FTC2ECK2JKG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2HDP58NY0CRG,CON_15V8PVHFM9N0,1 Volume 12 PRD_2HDP58NY0CRG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2T4MTHD95E4G,CON_15V8PVHFM9N0,1 Volume 8 PRD_2T4MTHD95E4G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2V4MXPSQW120,CON_15V8PVHFM9N0,1 Volume 2 PRD_2V4MXPSQW120 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_2XKQRFAQX0E0,CON_15V8PVHFM9N0,1 Volume 18 PRD_2XKQRFAQX0E0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_30Y0TD91YSPG,CON_15V8PVHFM9N0,1 Volume 7 PRD_30Y0TD91YSPG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_34BEEM6WKH80,CON_15V8PVHFM9N0,1 Volume 26 PRD_34BEEM6WKH80 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_34DW916G6Z20,CON_15V8PVHFM9N0,1 Volume 11 PRD_34DW916G6Z20 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_371J94AWG3T0,CON_15V8PVHFM9N0,1 Volume 13 PRD_371J94AWG3T0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_38W9116GV2HG,CON_15V8PVHFM9N0,1 Volume 7 PRD_38W9116GV2HG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3H4WBN40PHQ0,CON_15V8PVHFM9N0,1 Volume 8 PRD_3H4WBN40PHQ0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3KST2M6YTTNG,CON_15V8PVHFM9N0,1 Volume 27 PRD_3KST2M6YTTNG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3N68NP718G6G,CON_15V8PVHFM9N0,1 Volume 16 PRD_3N68NP718G6G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3RD7NZKBRMFG,CON_15V8PVHFM9N0,1 Volume 9 PRD_3RD7NZKBRMFG Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3RVB74WFKHY0,CON_15V8PVHFM9N0,1 Volume 5 PRD_3RVB74WFKHY0 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3W5BJW3DGY4G,CON_15V8PVHFM9N0,1 Volume 6 PRD_3W5BJW3DGY4G Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3WA61FDGP360,CON_15V8PVHFM9N0,1 Volume 1 PRD_3WA61FDGP360 Yuri Kitayama CON_15V8PVHFM9N0 1  
PRD_3YCHMNMPR5MG,CON_15V8PVHFM9N0,1 Volume 17 PRD_3YCHMNMPR5MG Yuri Kitayama CON_15V8PVHFM9N0 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.801ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS