BookWalker

home / database

product_contributors

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

26 rows where contributor_id = "CON_00KDDQDNQXJG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_034DY8PCMTH0,CON_00KDDQDNQXJG,1 Volume 17 PRD_034DY8PCMTH0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_0B85K79AXSXG,CON_00KDDQDNQXJG,1 Volume 24 PRD_0B85K79AXSXG Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_0S7VSVHJDXSG,CON_00KDDQDNQXJG,1 Volume 25 PRD_0S7VSVHJDXSG Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_1137CNFVXAM0,CON_00KDDQDNQXJG,1 Volume 5 PRD_1137CNFVXAM0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_12JM12DHHBN0,CON_00KDDQDNQXJG,1 Volume 7 PRD_12JM12DHHBN0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_13D85FGVHWF0,CON_00KDDQDNQXJG,1 Volume 22 PRD_13D85FGVHWF0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_15HQY89XS9V0,CON_00KDDQDNQXJG,1 Volume 3 PRD_15HQY89XS9V0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_163RG2JXXVE0,CON_00KDDQDNQXJG,1 Volume 20 PRD_163RG2JXXVE0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_18669VB058T0,CON_00KDDQDNQXJG,1 Volume 1 PRD_18669VB058T0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_188M48BV8NC0,CON_00KDDQDNQXJG,2 3 Years Since That Day PRD_188M48BV8NC0 Tomoko Ninomiya CON_00KDDQDNQXJG 2  
PRD_1DQARV8C1SK0,CON_00KDDQDNQXJG,1 Volume 19 PRD_1DQARV8C1SK0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_1G8AFPTS1FH0,CON_00KDDQDNQXJG,1 Volume 15 PRD_1G8AFPTS1FH0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_1MYTS9M3DEG0,CON_00KDDQDNQXJG,1 Volume 13 PRD_1MYTS9M3DEG0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_1VFN4WP59DQ0,CON_00KDDQDNQXJG,1 Volume 11 PRD_1VFN4WP59DQ0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_1ZW5PFGFNCP0,CON_00KDDQDNQXJG,1 Volume 9 PRD_1ZW5PFGFNCP0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_2GF0VGND74N0,CON_00KDDQDNQXJG,1 Volume 18 PRD_2GF0VGND74N0 Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_30VWTCWPZA4G,CON_00KDDQDNQXJG,1 Volume 6 PRD_30VWTCWPZA4G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_31TGZR3RZWYG,CON_00KDDQDNQXJG,1 Volume 21 PRD_31TGZR3RZWYG Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_378F5ZYRV9BG,CON_00KDDQDNQXJG,1 Volume 4 PRD_378F5ZYRV9BG Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3BYZGJR378AG,CON_00KDDQDNQXJG,1 Volume 2 PRD_3BYZGJR378AG Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3J33NCBM3F1G,CON_00KDDQDNQXJG,1 Volume 16 PRD_3J33NCBM3F1G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3N62KJ70BD7G,CON_00KDDQDNQXJG,1 Volume 12 PRD_3N62KJ70BD7G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3PHJ0Z5YFE0G,CON_00KDDQDNQXJG,1 Volume 14 PRD_3PHJ0Z5YFE0G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3SMXX51AQC6G,CON_00KDDQDNQXJG,1 Volume 10 PRD_3SMXX51AQC6G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3W5C8R3CKB5G,CON_00KDDQDNQXJG,1 Volume 8 PRD_3W5C8R3CKB5G Tomoko Ninomiya CON_00KDDQDNQXJG 1  
PRD_3X40C51PKXZG,CON_00KDDQDNQXJG,1 Volume 23 PRD_3X40C51PKXZG Tomoko Ninomiya CON_00KDDQDNQXJG 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.161ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS