BookWalker

home / database

product_contributors

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

46 rows where contributor_id = "CON_3JB3ZFNM2560"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_03A0HVKNWP0G,CON_3JB3ZFNM2560,2 Volume 26 PRD_03A0HVKNWP0G Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_057CXGM11CDG,CON_3JB3ZFNM2560,24 Volume 2 PRD_057CXGM11CDG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_062YGNDHHPB0,CON_3JB3ZFNM2560,24 Volume 10 PRD_062YGNDHHPB0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_07MPBJ1EQ340,CON_3JB3ZFNM2560,2 Volume 28 PRD_07MPBJ1EQ340 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_0824PA4FE2Z0,CON_3JB3ZFNM2560,24 Volume 12 PRD_0824PA4FE2Z0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_08R52WPEMM20,CON_3JB3ZFNM2560,24 Volume 11 PRD_08R52WPEMM20 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_0DAJFYVNMG3G,CON_3JB3ZFNM2560,24 Volume 1 PRD_0DAJFYVNMG3G Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_0DK4V79T60XG,CON_3JB3ZFNM2560,24 Volume 15 PRD_0DK4V79T60XG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_0EGAPJ83BJVG,CON_3JB3ZFNM2560,24 Volume 9 PRD_0EGAPJ83BJVG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_0FBHZDD4PCRG,CON_3JB3ZFNM2560,2 Volume 19 PRD_0FBHZDD4PCRG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_0M6766P1FR5G,CON_3JB3ZFNM2560,24 Volume 8 PRD_0M6766P1FR5G Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_0TV8MV73N0H0,CON_3JB3ZFNM2560,2 Volume 37 PRD_0TV8MV73N0H0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_0WR8GDSR4860,CON_3JB3ZFNM2560,2 Volume 33 PRD_0WR8GDSR4860 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_0XW27CVQD4M0,CON_3JB3ZFNM2560,2 Volume 34 PRD_0XW27CVQD4M0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_1271N8V9WQJG,CON_3JB3ZFNM2560,2 Volume 21 PRD_1271N8V9WQJG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_16MX92AFN41G,CON_3JB3ZFNM2560,24 Volume 3 PRD_16MX92AFN41G Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_181J0FRYTFF0,CON_3JB3ZFNM2560,2 Volume 20 PRD_181J0FRYTFF0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_183KBY3NWDVG,CON_3JB3ZFNM2560,24 Volume 5 PRD_183KBY3NWDVG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1ANRWKBGADE0,CON_3JB3ZFNM2560,2 Volume 31 PRD_1ANRWKBGADE0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_1EBC9XW4DMZG,CON_3JB3ZFNM2560,2 Volume 17 PRD_1EBC9XW4DMZG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_1F9BCFWVRZCG,CON_3JB3ZFNM2560,24 Volume 10 PRD_1F9BCFWVRZCG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1H0E55E5J770,CON_3JB3ZFNM2560,24 Volume 8 PRD_1H0E55E5J770 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1KHGH3HJ1BJ0,CON_3JB3ZFNM2560,24 Volume 4 PRD_1KHGH3HJ1BJ0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1SABXPN5WJA0,CON_3JB3ZFNM2560,24 Volume 13 PRD_1SABXPN5WJA0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1SCWV1NRK6CG,CON_3JB3ZFNM2560,24 Volume 6 PRD_1SCWV1NRK6CG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1T3P88YKTQSG,CON_3JB3ZFNM2560,24 Volume 7 PRD_1T3P88YKTQSG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_1YD9A2ZBM52G,CON_3JB3ZFNM2560,2 Volume 38 PRD_1YD9A2ZBM52G Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_1YVXT17EMY5G,CON_3JB3ZFNM2560,24 Volume 9 PRD_1YVXT17EMY5G Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_20VJPSFFQ010,CON_3JB3ZFNM2560,2 Volume 25 PRD_20VJPSFFQ010 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_21QRF8F6AYHG,CON_3JB3ZFNM2560,2 Volume 36 PRD_21QRF8F6AYHG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_224P0RPQDE80,CON_3JB3ZFNM2560,24 Volume 5 PRD_224P0RPQDE80 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_2677BF0M26R0,CON_3JB3ZFNM2560,24 Volume 1 PRD_2677BF0M26R0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_293F3Q8B5ADG,CON_3JB3ZFNM2560,24 Volume 3 PRD_293F3Q8B5ADG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_2AV4ZCW4T2S0,CON_3JB3ZFNM2560,24 Volume 6 PRD_2AV4ZCW4T2S0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_2X1P5M8WNY60,CON_3JB3ZFNM2560,2 Volume 29 PRD_2X1P5M8WNY60 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_2XGKZ7GMQJHG,CON_3JB3ZFNM2560,24 Volume 7 PRD_2XGKZ7GMQJHG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_30KYGT7NPKW0,CON_3JB3ZFNM2560,2 Volume 22 PRD_30KYGT7NPKW0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_3557KAZ1SJYG,CON_3JB3ZFNM2560,2 Volume 32 PRD_3557KAZ1SJYG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_363VGN1E9AZG,CON_3JB3ZFNM2560,24 Volume 14 PRD_363VGN1E9AZG Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_38ZD2ASC0GE0,CON_3JB3ZFNM2560,24 Volume 2 PRD_38ZD2ASC0GE0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_3FHTBT70EVR0,CON_3JB3ZFNM2560,24 Volume 11 PRD_3FHTBT70EVR0 Yusuke Nomura CON_3JB3ZFNM2560 24  
PRD_3GMA60RNVXXG,CON_3JB3ZFNM2560,2 Volume 30 PRD_3GMA60RNVXXG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_3Q3J3FB0T6A0,CON_3JB3ZFNM2560,2 Volume 27 PRD_3Q3J3FB0T6A0 Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_3TA8ES1SYZVG,CON_3JB3ZFNM2560,2 Volume 23 PRD_3TA8ES1SYZVG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_3VQPJ96H59VG,CON_3JB3ZFNM2560,2 Volume 24 PRD_3VQPJ96H59VG Yusuke Nomura CON_3JB3ZFNM2560 2  
PRD_3W2B64MGZ8C0,CON_3JB3ZFNM2560,2 Volume 35 PRD_3W2B64MGZ8C0 Yusuke Nomura CON_3JB3ZFNM2560 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 12.564ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS