BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_2JGCAG6ZA600"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_03M05PJ97R8G,CON_2JGCAG6ZA600,24 Volume 7 PRD_03M05PJ97R8G Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_07PYT376CTVG,CON_2JGCAG6ZA600,24 Volume 11 PRD_07PYT376CTVG Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_0P77MQBGYEJ0,CON_2JGCAG6ZA600,2 Volume 16 PRD_0P77MQBGYEJ0 Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_0P77MQBGYEJ0,CON_2JGCAG6ZA600,24 Volume 16 PRD_0P77MQBGYEJ0 Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_0X8YRZ0A9J3G,CON_2JGCAG6ZA600,1 Volume 1 PRD_0X8YRZ0A9J3G Taku Kuwabara CON_2JGCAG6ZA600 1  
PRD_11RADPEGV0D0,CON_2JGCAG6ZA600,24 Volume 9 PRD_11RADPEGV0D0 Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_17F2TMKNHFXG,CON_2JGCAG6ZA600,24 Volume 6 PRD_17F2TMKNHFXG Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_19VCQ3ASR6XG,CON_2JGCAG6ZA600,24 Volume 5 PRD_19VCQ3ASR6XG Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_1CJ6MBJGF0Y0,CON_2JGCAG6ZA600,1 Volume 17 PRD_1CJ6MBJGF0Y0 Taku Kuwabara CON_2JGCAG6ZA600 1  
PRD_1CJ6MBJGF0Y0,CON_2JGCAG6ZA600,2 Volume 17 PRD_1CJ6MBJGF0Y0 Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_1E1B0JHJHSKG,CON_2JGCAG6ZA600,1 Volume 3 PRD_1E1B0JHJHSKG Taku Kuwabara CON_2JGCAG6ZA600 1  
PRD_1Z704THDKY20,CON_2JGCAG6ZA600,2 Volume 15 PRD_1Z704THDKY20 Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_1Z704THDKY20,CON_2JGCAG6ZA600,24 Volume 15 PRD_1Z704THDKY20 Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_27985ZDNKDR0,CON_2JGCAG6ZA600,1 Volume 2 PRD_27985ZDNKDR0 Taku Kuwabara CON_2JGCAG6ZA600 1  
PRD_2VFF3MJD4VJG,CON_2JGCAG6ZA600,24 Volume 8 PRD_2VFF3MJD4VJG Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_2YY0STA1PT6G,CON_2JGCAG6ZA600,2 Volume 14 PRD_2YY0STA1PT6G Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_2YY0STA1PT6G,CON_2JGCAG6ZA600,24 Volume 14 PRD_2YY0STA1PT6G Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_2ZM8RP8Q2V7G,CON_2JGCAG6ZA600,24 Volume 10 PRD_2ZM8RP8Q2V7G Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_3130GA24SJN0,CON_2JGCAG6ZA600,2 Volume 13 PRD_3130GA24SJN0 Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_3130GA24SJN0,CON_2JGCAG6ZA600,24 Volume 13 PRD_3130GA24SJN0 Taku Kuwabara CON_2JGCAG6ZA600 24  
PRD_39QE1RBRR9QG,CON_2JGCAG6ZA600,1 Volume 4 PRD_39QE1RBRR9QG Taku Kuwabara CON_2JGCAG6ZA600 1  
PRD_39QE1RBRR9QG,CON_2JGCAG6ZA600,2 Volume 4 PRD_39QE1RBRR9QG Taku Kuwabara CON_2JGCAG6ZA600 2  
PRD_3NX3TY04NTA0,CON_2JGCAG6ZA600,24 Volume 12 PRD_3NX3TY04NTA0 Taku Kuwabara CON_2JGCAG6ZA600 24  

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