BookWalker

home / database

product_contributors

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

21 rows where contributor_id = "CON_2TFWBFTHG790"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_01ECPVGVSABG,CON_2TFWBFTHG790,24 Volume 20 PRD_01ECPVGVSABG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_08YVZGZJ1J6G,CON_2TFWBFTHG790,1 Volume 8 PRD_08YVZGZJ1J6G Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_0EJ7EZMRSCDG,CON_2TFWBFTHG790,24 Volume 12 PRD_0EJ7EZMRSCDG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_0FFA93SMDH5G,CON_2TFWBFTHG790,1 Volume 6 PRD_0FFA93SMDH5G Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_0KJ9H2R3SGMG,CON_2TFWBFTHG790,24 Volume 16 PRD_0KJ9H2R3SGMG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_1EMHD5FMZH60,CON_2TFWBFTHG790,24 Volume 17 PRD_1EMHD5FMZH60 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_1FDB0894X8RG,CON_2TFWBFTHG790,24 Volume 9 PRD_1FDB0894X8RG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_1KXTMPVY9G4G,CON_2TFWBFTHG790,1 Volume 4 PRD_1KXTMPVY9G4G Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_1PJN69N0NZBG,CON_2TFWBFTHG790,1 Volume 2 PRD_1PJN69N0NZBG Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_1TQ85D7RHMDG,CON_2TFWBFTHG790,24 Volume 18 PRD_1TQ85D7RHMDG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_2963GSEQFJP0,CON_2TFWBFTHG790,1 Volume 7 PRD_2963GSEQFJP0 Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_2B99TH0RPR60,CON_2TFWBFTHG790,24 Volume 21 PRD_2B99TH0RPR60 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_2DMJ2C8SBHN0,CON_2TFWBFTHG790,1 Volume 5 PRD_2DMJ2C8SBHN0 Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_2MXK53PQ33M0,CON_2TFWBFTHG790,24 Volume 13 PRD_2MXK53PQ33M0 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_31CR7P8PW2P0,CON_2TFWBFTHG790,24 Volume 15 PRD_31CR7P8PW2P0 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_36G27GCC3H20,CON_2TFWBFTHG790,24 Volume 19 PRD_36G27GCC3H20 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_38SKMZZ57TWG,CON_2TFWBFTHG790,24 Volume 14 PRD_38SKMZZ57TWG Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_3943FZY7Z890,CON_2TFWBFTHG790,24 Volume 10 PRD_3943FZY7Z890 Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_3G5DDZA3QGM0,CON_2TFWBFTHG790,1 Volume 3 PRD_3G5DDZA3QGM0 Tadashi Kawashima CON_2TFWBFTHG790 1  
PRD_3HBT5R6DMH2G,CON_2TFWBFTHG790,24 Volume 11 PRD_3HBT5R6DMH2G Tadashi Kawashima CON_2TFWBFTHG790 24  
PRD_3MVXRJ45KZV0,CON_2TFWBFTHG790,1 Volume 1 PRD_3MVXRJ45KZV0 Tadashi Kawashima CON_2TFWBFTHG790 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.732ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS