BookWalker

home / database

product_contributors

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

56 rows where contributor_id = "CON_2A30Y811GW30"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00TT2H9VNK6G,CON_2A30Y811GW30,24 Volume 6 PRD_00TT2H9VNK6G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_07BNC4BXHJ5G,CON_2A30Y811GW30,24 Volume 7 PRD_07BNC4BXHJ5G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0BR5ZQ57XH4G,CON_2A30Y811GW30,24 Volume 5 PRD_0BR5ZQ57XH4G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0EEM9A79SGBG,CON_2A30Y811GW30,24 Volume 2 PRD_0EEM9A79SGBG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0J29XJMRS83G,CON_2A30Y811GW30,24 Volume 19 PRD_0J29XJMRS83G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0N18TRG51P1G,CON_2A30Y811GW30,24 Volume 15 PRD_0N18TRG51P1G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0PGRF5P35Q2G,CON_2A30Y811GW30,24 Volume 17 PRD_0PGRF5P35Q2G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0SQV4BJFDN0G,CON_2A30Y811GW30,24 Volume 13 PRD_0SQV4BJFDN0G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_0W4BQYFH9M7G,CON_2A30Y811GW30,24 Volume 5 PRD_0W4BQYFH9M7G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_12ZBNCB199MG,CON_2A30Y811GW30,24 Volume 13 PRD_12ZBNCB199MG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_137GDDSHY26G,CON_2A30Y811GW30,1 Volume 2 PRD_137GDDSHY26G Toru Fujisawa CON_2A30Y811GW30 1  
PRD_14SARTYH1HHG,CON_2A30Y811GW30,1 Volume 5 PRD_14SARTYH1HHG Toru Fujisawa CON_2A30Y811GW30 1  
PRD_16BRTTCRDGHG,CON_2A30Y811GW30,24 Volume 11 PRD_16BRTTCRDGHG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_194PSNBHZ9D0,CON_2A30Y811GW30,24 Volume 22 PRD_194PSNBHZ9D0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1AP6E2EFKAE0,CON_2A30Y811GW30,24 Volume 24 PRD_1AP6E2EFKAE0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1CH2Q7BW23EG,CON_2A30Y811GW30,1 Volume 7 PRD_1CH2Q7BW23EG Toru Fujisawa CON_2A30Y811GW30 1  
PRD_1DN1B85VV8C0,CON_2A30Y811GW30,24 Volume 20 PRD_1DN1B85VV8C0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1EMNA8GMSB20,CON_2A30Y811GW30,2 Volume 20 PRD_1EMNA8GMSB20 Toru Fujisawa CON_2A30Y811GW30 2  
PRD_1EMNA8GMSB20,CON_2A30Y811GW30,24 Volume 20 PRD_1EMNA8GMSB20 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1HDQ7G2P1Y9G,CON_2A30Y811GW30,24 Volume 11 PRD_1HDQ7G2P1Y9G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1JS89G748F9G,CON_2A30Y811GW30,1 Volume 1 PRD_1JS89G748F9G Toru Fujisawa CON_2A30Y811GW30 1  
PRD_1JZ4MX1C5ZAG,CON_2A30Y811GW30,24 Volume 4 PRD_1JZ4MX1C5ZAG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1KCDQCZ344C0,CON_2A30Y811GW30,1 Volume 9 PRD_1KCDQCZ344C0 Toru Fujisawa CON_2A30Y811GW30 1  
PRD_1M27H4WRDX8G,CON_2A30Y811GW30,24 Volume 3 PRD_1M27H4WRDX8G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1P6SVT5PNNEG,CON_2A30Y811GW30,1 Volume 3 PRD_1P6SVT5PNNEG Toru Fujisawa CON_2A30Y811GW30 1  
PRD_1RGPWQY29WFG,CON_2A30Y811GW30,24 Volume 9 PRD_1RGPWQY29WFG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1X5PRJS4XPQG,CON_2A30Y811GW30,24 Volume 10 PRD_1X5PRJS4XPQG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_1Z11EAR4NVEG,CON_2A30Y811GW30,24 Volume 8 PRD_1Z11EAR4NVEG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2122VVRRKKP0,CON_2A30Y811GW30,24 Volume 6 PRD_2122VVRRKKP0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_22DJ88YPQMQ0,CON_2A30Y811GW30,24 Volume 8 PRD_22DJ88YPQMQ0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_23A1H8X50RQ0,CON_2A30Y811GW30,24 Volume 17 PRD_23A1H8X50RQ0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_25GX5ET2ZJN0,CON_2A30Y811GW30,24 Volume 1 PRD_25GX5ET2ZJN0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_281DG1M4VHM0,CON_2A30Y811GW30,24 Volume 21 PRD_281DG1M4VHM0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2CQW3MPF7GV0,CON_2A30Y811GW30,24 Volume 3 PRD_2CQW3MPF7GV0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2CZ3G5NF5Y50,CON_2A30Y811GW30,24 Volume 14 PRD_2CZ3G5NF5Y50 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2DWFT1FTQ260,CON_2A30Y811GW30,24 Volume 12 PRD_2DWFT1FTQ260 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2GBHPV7Y78K0,CON_2A30Y811GW30,24 Volume 18 PRD_2GBHPV7Y78K0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2GPZTP35NC20,CON_2A30Y811GW30,1 Volume 8 PRD_2GPZTP35NC20 Toru Fujisawa CON_2A30Y811GW30 1  
PRD_2MR00E103QJ0,CON_2A30Y811GW30,24 Volume 16 PRD_2MR00E103QJ0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2VEGK13AFPH0,CON_2A30Y811GW30,24 Volume 14 PRD_2VEGK13AFPH0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2X76CR1AQ8MG,CON_2A30Y811GW30,24 Volume 16 PRD_2X76CR1AQ8MG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_2ZZ3YNXCBNG0,CON_2A30Y811GW30,24 Volume 12 PRD_2ZZ3YNXCBNG0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_34EZNSZANBYG,CON_2A30Y811GW30,24 Volume 25 PRD_34EZNSZANBYG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_36N1H2B1BVY0,CON_2A30Y811GW30,1 Volume 6 PRD_36N1H2B1BVY0 Toru Fujisawa CON_2A30Y811GW30 1  
PRD_38ZE7CSCHAXG,CON_2A30Y811GW30,24 Volume 23 PRD_38ZE7CSCHAXG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3DAWD81E2WW0,CON_2A30Y811GW30,2 Volume 19 PRD_3DAWD81E2WW0 Toru Fujisawa CON_2A30Y811GW30 2  
PRD_3DAWD81E2WW0,CON_2A30Y811GW30,24 Volume 19 PRD_3DAWD81E2WW0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3FDYJZTPX9WG,CON_2A30Y811GW30,24 Volume 2 PRD_3FDYJZTPX9WG Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3HSH2HTHQPZ0,CON_2A30Y811GW30,1 Volume 4 PRD_3HSH2HTHQPZ0 Toru Fujisawa CON_2A30Y811GW30 1  
PRD_3K4FD7KH3ZT0,CON_2A30Y811GW30,24 Volume 10 PRD_3K4FD7KH3ZT0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3KG88VYX55S0,CON_2A30Y811GW30,24 Volume 18 PRD_3KG88VYX55S0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3QTZRTDVFYS0,CON_2A30Y811GW30,24 Volume 1 PRD_3QTZRTDVFYS0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3QX1FKAPKB7G,CON_2A30Y811GW30,24 Volume 15 PRD_3QX1FKAPKB7G Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3TBEADFXBXR0,CON_2A30Y811GW30,24 Volume 7 PRD_3TBEADFXBXR0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3XE90KB9KVY0,CON_2A30Y811GW30,24 Volume 9 PRD_3XE90KB9KVY0 Toru Fujisawa CON_2A30Y811GW30 24  
PRD_3YSYN097QWZ0,CON_2A30Y811GW30,24 Volume 4 PRD_3YSYN097QWZ0 Toru Fujisawa CON_2A30Y811GW30 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 10.754ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS