BookWalker

home / database

product_contributors

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

40 rows where contributor_id = "CON_31E33BBJ2G9G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00ECKP4DEQE0,CON_31E33BBJ2G9G,24 Volume 7 PRD_00ECKP4DEQE0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_03KVKMPQSBGG,CON_31E33BBJ2G9G,1 Volume 54 PRD_03KVKMPQSBGG Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_04DTJXSS6GG0,CON_31E33BBJ2G9G,24 Volume 51 PRD_04DTJXSS6GG0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_05WZ0EJY59AG,CON_31E33BBJ2G9G,24 Volume 5 PRD_05WZ0EJY59AG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_0PPV5NF43AP0,CON_31E33BBJ2G9G,24 Volume 40 PRD_0PPV5NF43AP0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_0RNPDK38C240,CON_31E33BBJ2G9G,24 Volume 41 PRD_0RNPDK38C240 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_0VXRY3AWE99G,CON_31E33BBJ2G9G,24 Volume 3 PRD_0VXRY3AWE99G Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_13BW0MGX548G,CON_31E33BBJ2G9G,1 Volume 55 PRD_13BW0MGX548G Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_17JQR0PWQ6VG,CON_31E33BBJ2G9G,24 Volume 42 PRD_17JQR0PWQ6VG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_19S15M42JSXG,CON_31E33BBJ2G9G,24 Volume 44 PRD_19S15M42JSXG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1CQMMX06Y3GG,CON_31E33BBJ2G9G,24 Volume 45 PRD_1CQMMX06Y3GG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1EPXTSQCZ2HG,CON_31E33BBJ2G9G,24 Volume 8 PRD_1EPXTSQCZ2HG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1EZ7079HV5Z0,CON_31E33BBJ2G9G,24 Volume 46 PRD_1EZ7079HV5Z0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1F5P3SG45A7G,CON_31E33BBJ2G9G,24 Volume 43 PRD_1F5P3SG45A7G Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1G33XERTV7HG,CON_31E33BBJ2G9G,24 Volume 49 PRD_1G33XERTV7HG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1HNGK6VGQSH0,CON_31E33BBJ2G9G,24 Volume 1 PRD_1HNGK6VGQSH0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1Q98P3GTRNCG,CON_31E33BBJ2G9G,24 Volume 50 PRD_1Q98P3GTRNCG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1QXBV8M02KM0,CON_31E33BBJ2G9G,2 Volume 35 PRD_1QXBV8M02KM0 Masaya Tsunamoto CON_31E33BBJ2G9G 2  
PRD_1QXBV8M02KM0,CON_31E33BBJ2G9G,24 Volume 35 PRD_1QXBV8M02KM0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_1R7RHQAD6EA0,CON_31E33BBJ2G9G,24 Volume 52 PRD_1R7RHQAD6EA0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_25G7E900QPZG,CON_31E33BBJ2G9G,24 Volume 39 PRD_25G7E900QPZG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2AN67X7WCSN0,CON_31E33BBJ2G9G,1 Volume 16 PRD_2AN67X7WCSN0 Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_2H3003V8DA30,CON_31E33BBJ2G9G,24 Volume 9 PRD_2H3003V8DA30 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2NHVTWNC7PGG,CON_31E33BBJ2G9G,24 Volume 36 PRD_2NHVTWNC7PGG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2P0BE8PNPMEG,CON_31E33BBJ2G9G,24 Volume 48 PRD_2P0BE8PNPMEG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2R50QDN1C9S0,CON_31E33BBJ2G9G,24 Volume 2 PRD_2R50QDN1C9S0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2TDHW6Y967Z0,CON_31E33BBJ2G9G,24 Volume 47 PRD_2TDHW6Y967Z0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2TP8AFGWPA8G,CON_31E33BBJ2G9G,24 Volume 10 PRD_2TP8AFGWPA8G Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_2V5G3D7MPJ5G,CON_31E33BBJ2G9G,1 Volume 14 PRD_2V5G3D7MPJ5G Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_2WD0EQA6KRAG,CON_31E33BBJ2G9G,1 Volume 15 PRD_2WD0EQA6KRAG Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_2X27W45MYM90,CON_31E33BBJ2G9G,1 Volume 12 PRD_2X27W45MYM90 Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_31KZN4NWVS50,CON_31E33BBJ2G9G,24 Volume 53 PRD_31KZN4NWVS50 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_323KMXJA7J30,CON_31E33BBJ2G9G,24 Volume 4 PRD_323KMXJA7J30 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_35YFM89CATS0,CON_31E33BBJ2G9G,24 Volume 38 PRD_35YFM89CATS0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_3705P51XQWX0,CON_31E33BBJ2G9G,24 Volume 6 PRD_3705P51XQWX0 Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_370N5BWZ8R70,CON_31E33BBJ2G9G,1 Volume 13 PRD_370N5BWZ8R70 Masaya Tsunamoto CON_31E33BBJ2G9G 1  
PRD_379M9R4Y2MYG,CON_31E33BBJ2G9G,24 Volume 11 PRD_379M9R4Y2MYG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_3EHGVNZRGFZG,CON_31E33BBJ2G9G,2 Volume 34 PRD_3EHGVNZRGFZG Masaya Tsunamoto CON_31E33BBJ2G9G 2  
PRD_3EHGVNZRGFZG,CON_31E33BBJ2G9G,24 Volume 34 PRD_3EHGVNZRGFZG Masaya Tsunamoto CON_31E33BBJ2G9G 24  
PRD_3J7C8DS6F48G,CON_31E33BBJ2G9G,24 Volume 37 PRD_3J7C8DS6F48G Masaya Tsunamoto CON_31E33BBJ2G9G 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 9.987ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS