BookWalker

home / database

product_contributors

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

34 rows where contributor_id = "CON_1JSRPDV2FF6G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_01QAYJXMAWDG,CON_1JSRPDV2FF6G,1 Chapter 19 PRD_01QAYJXMAWDG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_044585ZYPVCG,CON_1JSRPDV2FF6G,1 Chapter 17 PRD_044585ZYPVCG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_0758HSQNA3XG,CON_1JSRPDV2FF6G,2 Volume 5 PRD_0758HSQNA3XG Kana Nakatsuki CON_1JSRPDV2FF6G 2  
PRD_0758HSQNA3XG,CON_1JSRPDV2FF6G,24 Volume 5 PRD_0758HSQNA3XG Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_08TNVRS0JVKG,CON_1JSRPDV2FF6G,1 Chapter 15 PRD_08TNVRS0JVKG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_0907QZ9Z7780,CON_1JSRPDV2FF6G,2 Volume 1 PRD_0907QZ9Z7780 Kana Nakatsuki CON_1JSRPDV2FF6G 2  
PRD_0907QZ9Z7780,CON_1JSRPDV2FF6G,24 Volume 1 PRD_0907QZ9Z7780 Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_0AYGB5B3R38G,CON_1JSRPDV2FF6G,24 Volume 2 PRD_0AYGB5B3R38G Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_0D1505A5QHTG,CON_1JSRPDV2FF6G,24 Volume 3 PRD_0D1505A5QHTG Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_0GWSSJ8SYHAG,CON_1JSRPDV2FF6G,1 Chapter 11 PRD_0GWSSJ8SYHAG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_0JGHEH4ZA3HG,CON_1JSRPDV2FF6G,1 Chapter 2 PRD_0JGHEH4ZA3HG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_10CHP4QZX470,CON_1JSRPDV2FF6G,2 Volume 2 PRD_10CHP4QZX470 Kana Nakatsuki CON_1JSRPDV2FF6G 2  
PRD_10CHP4QZX470,CON_1JSRPDV2FF6G,24 Volume 2 PRD_10CHP4QZX470 Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_1BGPA2288MN0,CON_1JSRPDV2FF6G,1 Chapter 16 PRD_1BGPA2288MN0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1CENHGR04QS0,CON_1JSRPDV2FF6G,1 Chapter 9 PRD_1CENHGR04QS0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1EX21NXTZEPG,CON_1JSRPDV2FF6G,2 Volume 4 PRD_1EX21NXTZEPG Kana Nakatsuki CON_1JSRPDV2FF6G 2  
PRD_1EX21NXTZEPG,CON_1JSRPDV2FF6G,24 Volume 4 PRD_1EX21NXTZEPG Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_1KP90W5P1WEG,CON_1JSRPDV2FF6G,1 Chapter 13 PRD_1KP90W5P1WEG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1KTT8XD1MAC0,CON_1JSRPDV2FF6G,1 Chapter 12 PRD_1KTT8XD1MAC0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1RKDN0NX8CGG,CON_1JSRPDV2FF6G,1 Chapter 3 PRD_1RKDN0NX8CGG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1V181X53CDQ0,CON_1JSRPDV2FF6G,1 Chapter 5 PRD_1V181X53CDQ0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_1XZRWJYNA5CG,CON_1JSRPDV2FF6G,1 Chapter 21 PRD_1XZRWJYNA5CG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_23E248JQCXY0,CON_1JSRPDV2FF6G,1 Chapter 20 PRD_23E248JQCXY0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_27WJQVCS8WX0,CON_1JSRPDV2FF6G,1 Chapter 18 PRD_27WJQVCS8WX0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_293WC185GT30,CON_1JSRPDV2FF6G,1 Chapter 14 PRD_293WC185GT30 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_2GWAFWZFYG6G,CON_1JSRPDV2FF6G,1 Chapter 1 PRD_2GWAFWZFYG6G Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_2QDQEPMCCNZ0,CON_1JSRPDV2FF6G,1 Chapter 10 PRD_2QDQEPMCCNZ0 Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_2YAZKTRPMSMG,CON_1JSRPDV2FF6G,1 Chapter 7 PRD_2YAZKTRPMSMG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_37W89A77CKE0,CON_1JSRPDV2FF6G,24 Volume 1 PRD_37W89A77CKE0 Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_3DFWXXW3VZFG,CON_1JSRPDV2FF6G,2 Volume 3 PRD_3DFWXXW3VZFG Kana Nakatsuki CON_1JSRPDV2FF6G 2  
PRD_3DFWXXW3VZFG,CON_1JSRPDV2FF6G,24 Volume 3 PRD_3DFWXXW3VZFG Kana Nakatsuki CON_1JSRPDV2FF6G 24  
PRD_3FAQZ0CRA7NG,CON_1JSRPDV2FF6G,1 Chapter 6 PRD_3FAQZ0CRA7NG Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_3SEGT7M0AC6G,CON_1JSRPDV2FF6G,1 Chapter 8 PRD_3SEGT7M0AC6G Kana Nakatsuki CON_1JSRPDV2FF6G 1  
PRD_3YRME942PB00,CON_1JSRPDV2FF6G,1 Chapter 4 PRD_3YRME942PB00 Kana Nakatsuki CON_1JSRPDV2FF6G 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 11.7ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS