BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_0VR06R06EP50"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00ZN20EF9A80,CON_0VR06R06EP50,1 Chapter 10 PRD_00ZN20EF9A80 hacone CON_0VR06R06EP50 1  
PRD_035G46ZJXQB0,CON_0VR06R06EP50,1 Chapter 1 PRD_035G46ZJXQB0 hacone CON_0VR06R06EP50 1  
PRD_0HJG7HHJSJY0,CON_0VR06R06EP50,1 Chapter 6 PRD_0HJG7HHJSJY0 hacone CON_0VR06R06EP50 1  
PRD_0SEKSYF8CTNG,CON_0VR06R06EP50,1 Chapter 5 PRD_0SEKSYF8CTNG hacone CON_0VR06R06EP50 1  
PRD_0VSW7C2KQBSG,CON_0VR06R06EP50,1 Chapter 7 PRD_0VSW7C2KQBSG hacone CON_0VR06R06EP50 1  
PRD_0WQ1TJ28H840,CON_0VR06R06EP50,1 Chapter 3 PRD_0WQ1TJ28H840 hacone CON_0VR06R06EP50 1  
PRD_10MY0VCTKRY0,CON_0VR06R06EP50,1 Chapter 8 PRD_10MY0VCTKRY0 hacone CON_0VR06R06EP50 1  
PRD_12E207A7RS60,CON_0VR06R06EP50,1 Chapter 5 PRD_12E207A7RS60 hacone CON_0VR06R06EP50 1  
PRD_17DYBB7S17AG,CON_0VR06R06EP50,1 Chapter 2 PRD_17DYBB7S17AG hacone CON_0VR06R06EP50 1  
PRD_1A1JT5398AM0,CON_0VR06R06EP50,1 Chapter 3 PRD_1A1JT5398AM0 hacone CON_0VR06R06EP50 1  
PRD_1A2EPY13D69G,CON_0VR06R06EP50,1 Chapter 1 PRD_1A2EPY13D69G hacone CON_0VR06R06EP50 1  
PRD_1J7NGZAQ1JDG,CON_0VR06R06EP50,1 Chapter 1 PRD_1J7NGZAQ1JDG hacone CON_0VR06R06EP50 1  
PRD_1N2DYC902350,CON_0VR06R06EP50,1 Chapter 6 PRD_1N2DYC902350 hacone CON_0VR06R06EP50 1  
PRD_1S491A1X9320,CON_0VR06R06EP50,1 Chapter 6 PRD_1S491A1X9320 hacone CON_0VR06R06EP50 1  
PRD_1WSS3XN5N03G,CON_0VR06R06EP50,1 Chapter 4 PRD_1WSS3XN5N03G hacone CON_0VR06R06EP50 1  
PRD_222ZYMDYRGZ0,CON_0VR06R06EP50,1 Chapter 7 PRD_222ZYMDYRGZ0 hacone CON_0VR06R06EP50 1  
PRD_22PD9QZABBRG,CON_0VR06R06EP50,1 Chapter 11 PRD_22PD9QZABBRG hacone CON_0VR06R06EP50 1  
PRD_22W9KWDDZ8VG,CON_0VR06R06EP50,1 Chapter 2 PRD_22W9KWDDZ8VG hacone CON_0VR06R06EP50 1  
PRD_2ARB59AB2GK0,CON_0VR06R06EP50,1 Chapter 3 PRD_2ARB59AB2GK0 hacone CON_0VR06R06EP50 1  
PRD_2NGME3GE9BA0,CON_0VR06R06EP50,1 Chapter 8 PRD_2NGME3GE9BA0 hacone CON_0VR06R06EP50 1  
PRD_2YFS09KBK9MG,CON_0VR06R06EP50,1 Chapter 4 PRD_2YFS09KBK9MG hacone CON_0VR06R06EP50 1  
PRD_32BQVRH4H02G,CON_0VR06R06EP50,1 Chapter 8 PRD_32BQVRH4H02G hacone CON_0VR06R06EP50 1  
PRD_3CZNY2FGJ8AG,CON_0VR06R06EP50,1 Chapter 2 PRD_3CZNY2FGJ8AG hacone CON_0VR06R06EP50 1  
PRD_3GG66YCARFKG,CON_0VR06R06EP50,1 Chapter 5 PRD_3GG66YCARFKG hacone CON_0VR06R06EP50 1  
PRD_3Q249G61HZD0,CON_0VR06R06EP50,1 Chapter 4 PRD_3Q249G61HZD0 hacone CON_0VR06R06EP50 1  
PRD_3R66S3JWHZC0,CON_0VR06R06EP50,1 Chapter 9 PRD_3R66S3JWHZC0 hacone CON_0VR06R06EP50 1  
PRD_3SGBWBSRYVQG,CON_0VR06R06EP50,1 Chapter 7 PRD_3SGBWBSRYVQG hacone CON_0VR06R06EP50 1  
PRD_3VE5VM3G67AG,CON_0VR06R06EP50,1 Chapter 12 PRD_3VE5VM3G67AG hacone CON_0VR06R06EP50 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 8.638ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS