BookWalker

home / database

product_contributors

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

33 rows where contributor_id = "CON_0CKP2APKQWW0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_04QYS22HVRGG,CON_0CKP2APKQWW0,1 Chapter 29 PRD_04QYS22HVRGG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0A1R3D71WWRG,CON_0CKP2APKQWW0,1 Chapter 11 PRD_0A1R3D71WWRG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0EPBE01BRVZG,CON_0CKP2APKQWW0,1 Chapter 1 PRD_0EPBE01BRVZG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0JAC18PTRKQG,CON_0CKP2APKQWW0,1 Chapter 7 PRD_0JAC18PTRKQG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0N9FYEJ70HNG,CON_0CKP2APKQWW0,1 Chapter 3 PRD_0N9FYEJ70HNG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0PQQM8YERZQG,CON_0CKP2APKQWW0,1 Chapter 23 PRD_0PQQM8YERZQG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0SZY91C9CGMG,CON_0CKP2APKQWW0,1 Chapter 2 PRD_0SZY91C9CGMG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_0WCEMM9K8ZVG,CON_0CKP2APKQWW0,1 Chapter 17 PRD_0WCEMM9K8ZVG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_1DX48Y7NTK00,CON_0CKP2APKQWW0,1 Chapter 8 PRD_1DX48Y7NTK00 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_1K97N9XP640G,CON_0CKP2APKQWW0,1 Chapter 24 PRD_1K97N9XP640G Yoko Ito CON_0CKP2APKQWW0 1  
PRD_1RJEY7AS4T0G,CON_0CKP2APKQWW0,1 Chapter 20 PRD_1RJEY7AS4T0G Yoko Ito CON_0CKP2APKQWW0 1  
PRD_1TAV2DEBN63G,CON_0CKP2APKQWW0,1 Chapter 25 PRD_1TAV2DEBN63G Yoko Ito CON_0CKP2APKQWW0 1  
PRD_1WN6HRDS1FZ0,CON_0CKP2APKQWW0,1 Chapter 21 PRD_1WN6HRDS1FZ0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_21A1RHTTJXA0,CON_0CKP2APKQWW0,1 Chapter 14 PRD_21A1RHTTJXA0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_25RGA4MWYW90,CON_0CKP2APKQWW0,1 Chapter 12 PRD_25RGA4MWYW90 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2704QNKPWB90,CON_0CKP2APKQWW0,1 Chapter 31 PRD_2704QNKPWB90 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2890NQP6TV80,CON_0CKP2APKQWW0,1 Chapter 10 PRD_2890NQP6TV80 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2A3W3K69M2JG,CON_0CKP2APKQWW0,1 Chapter 33 PRD_2A3W3K69M2JG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2GJRBZPN1D5G,CON_0CKP2APKQWW0,1 Chapter 22 PRD_2GJRBZPN1D5G Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2GSS7VQW8210,CON_0CKP2APKQWW0,1 Chapter 26 PRD_2GSS7VQW8210 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2MRZTRW326V0,CON_0CKP2APKQWW0,1 Chapter 27 PRD_2MRZTRW326V0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2Q0754322H60,CON_0CKP2APKQWW0,1 Chapter 4 PRD_2Q0754322H60 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2TV9M8GJSH7G,CON_0CKP2APKQWW0,1 Chapter 32 PRD_2TV9M8GJSH7G Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2VPQGRX4EG50,CON_0CKP2APKQWW0,1 Chapter 19 PRD_2VPQGRX4EG50 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2WCSADVXS9F0,CON_0CKP2APKQWW0,1 Chapter 28 PRD_2WCSADVXS9F0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_2Y762BZEAZ40,CON_0CKP2APKQWW0,1 Chapter 18 PRD_2Y762BZEAZ40 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_31XH7VQQ5RE0,CON_0CKP2APKQWW0,1 Chapter 15 PRD_31XH7VQQ5RE0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_34J1HEHSE7D0,CON_0CKP2APKQWW0,1 Chapter 13 PRD_34J1HEHSE7D0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_38TR4ZRSACBG,CON_0CKP2APKQWW0,1 Chapter 16 PRD_38TR4ZRSACBG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_3FH3FMD5P6K0,CON_0CKP2APKQWW0,1 Chapter 9 PRD_3FH3FMD5P6K0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_3JWCZBX1R8F0,CON_0CKP2APKQWW0,1 Chapter 30 PRD_3JWCZBX1R8F0 Yoko Ito CON_0CKP2APKQWW0 1  
PRD_3QY1MF49RAFG,CON_0CKP2APKQWW0,1 Chapter 5 PRD_3QY1MF49RAFG Yoko Ito CON_0CKP2APKQWW0 1  
PRD_3T5AQ1PNBDBG,CON_0CKP2APKQWW0,1 Chapter 6 PRD_3T5AQ1PNBDBG Yoko Ito CON_0CKP2APKQWW0 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.191ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS