BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_2EJ8YW7A7WFG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_07QPFRP9JR4G,CON_2EJ8YW7A7WFG,24 Volume 3 PRD_07QPFRP9JR4G Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_0RVVN0DHQBQ0,CON_2EJ8YW7A7WFG,1 Volume 7 PRD_0RVVN0DHQBQ0 Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_0SX1869PVAQG,CON_2EJ8YW7A7WFG,1 Volume 6 PRD_0SX1869PVAQG Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_0TFSC39G0FX0,CON_2EJ8YW7A7WFG,1 Volume 3 PRD_0TFSC39G0FX0 Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_1CAM3HAP9B1G,CON_2EJ8YW7A7WFG,24 Volume 4 PRD_1CAM3HAP9B1G Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_1HCG8RKHTDSG,CON_2EJ8YW7A7WFG,1 Volume 1 PRD_1HCG8RKHTDSG Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_1T2QFJHFGZ5G,CON_2EJ8YW7A7WFG,24 Volume 2 PRD_1T2QFJHFGZ5G Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_1VM84C34CJAG,CON_2EJ8YW7A7WFG,2 Volume 7 PRD_1VM84C34CJAG Yae Utsumi CON_2EJ8YW7A7WFG 2  
PRD_1VM84C34CJAG,CON_2EJ8YW7A7WFG,24 Volume 7 PRD_1VM84C34CJAG Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_1VXB8TBB6E20,CON_2EJ8YW7A7WFG,2 Volume 6 PRD_1VXB8TBB6E20 Yae Utsumi CON_2EJ8YW7A7WFG 2  
PRD_1VXB8TBB6E20,CON_2EJ8YW7A7WFG,24 Volume 6 PRD_1VXB8TBB6E20 Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_2MAP9RCWHB50,CON_2EJ8YW7A7WFG,2 Volume 8 PRD_2MAP9RCWHB50 Yae Utsumi CON_2EJ8YW7A7WFG 2  
PRD_2MAP9RCWHB50,CON_2EJ8YW7A7WFG,24 Volume 8 PRD_2MAP9RCWHB50 Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_2QMCCD78A1CG,CON_2EJ8YW7A7WFG,1 Volume 5 PRD_2QMCCD78A1CG Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_2S4RN2J6J9FG,CON_2EJ8YW7A7WFG,1 Volume 4 PRD_2S4RN2J6J9FG Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_2Z9EZR8FBDMG,CON_2EJ8YW7A7WFG,1 Volume 2 PRD_2Z9EZR8FBDMG Yae Utsumi CON_2EJ8YW7A7WFG 1  
PRD_350GPRTDR1S0,CON_2EJ8YW7A7WFG,24 Volume 1 PRD_350GPRTDR1S0 Yae Utsumi CON_2EJ8YW7A7WFG 24  
PRD_3VSASF8A6HM0,CON_2EJ8YW7A7WFG,24 Volume 5 PRD_3VSASF8A6HM0 Yae Utsumi CON_2EJ8YW7A7WFG 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 12.02ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS