BookWalker

home / database

product_contributors

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

55 rows where contributor_id = "CON_3SAMK9CZWKN0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_04NRMEPTFQRG,CON_3SAMK9CZWKN0,2 Volume 28 PRD_04NRMEPTFQRG Ken Akamatsu CON_3SAMK9CZWKN0 2  
PRD_04NRMEPTFQRG,CON_3SAMK9CZWKN0,24 Volume 28 PRD_04NRMEPTFQRG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_0A4WGFAE7310,CON_3SAMK9CZWKN0,1 Volume 17 PRD_0A4WGFAE7310 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0FPHS48K6X8G,CON_3SAMK9CZWKN0,1 Volume 8 PRD_0FPHS48K6X8G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0GR0C9WCGDTG,CON_3SAMK9CZWKN0,1 Volume 16, 17, 18 PRD_0GR0C9WCGDTG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0J1GWQP6M2YG,CON_3SAMK9CZWKN0,1 Volume 13 PRD_0J1GWQP6M2YG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0KQJEQJJJCB0,CON_3SAMK9CZWKN0,1 Volume 12 PRD_0KQJEQJJJCB0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0QEGZWSPWCSG,CON_3SAMK9CZWKN0,1 Volume 10, 11, 12 PRD_0QEGZWSPWCSG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0R92BTM2WGPG,CON_3SAMK9CZWKN0,24 Volume 18 PRD_0R92BTM2WGPG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_0VZ39FVRRBRG,CON_3SAMK9CZWKN0,1 Volume 4, 5, 6 PRD_0VZ39FVRRBRG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_0YDKM2N34AZG,CON_3SAMK9CZWKN0,1 Volume 1 PRD_0YDKM2N34AZG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_10EZ1KNQ2170,CON_3SAMK9CZWKN0,1 Volume 33 PRD_10EZ1KNQ2170 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_14ZFK6QSE060,CON_3SAMK9CZWKN0,1 Volume 31 PRD_14ZFK6QSE060 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1BDYYSH3AF50,CON_3SAMK9CZWKN0,1 Volume 29 PRD_1BDYYSH3AF50 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1BGB6TSEGXAG,CON_3SAMK9CZWKN0,1 Volume 5 PRD_1BGB6TSEGXAG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1E298CK5PE40,CON_3SAMK9CZWKN0,1 Volume 25, 26, 27 PRD_1E298CK5PE40 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1E6VGDTGWW9G,CON_3SAMK9CZWKN0,1 Volume 3 PRD_1E6VGDTGWW9G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1J704QAN2WFG,CON_3SAMK9CZWKN0,1 Volume 6 PRD_1J704QAN2WFG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1JZE1ZWCS8DG,CON_3SAMK9CZWKN0,1 Volume 16 PRD_1JZE1ZWCS8DG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1NA31X61ATDG,CON_3SAMK9CZWKN0,1 Volume 2 PRD_1NA31X61ATDG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1PNGPA4ZEVEG,CON_3SAMK9CZWKN0,1 Volume 4 PRD_1PNGPA4ZEVEG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1Q4B4AG49FNG,CON_3SAMK9CZWKN0,24 Volume 19 PRD_1Q4B4AG49FNG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_1SBWBDYAT310,CON_3SAMK9CZWKN0,1 Volume 37 PRD_1SBWBDYAT310 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1XRCP0RD6200,CON_3SAMK9CZWKN0,1 Volume 35 PRD_1XRCP0RD6200 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_1YHJ9RXMJ360,CON_3SAMK9CZWKN0,24 Volume 22 PRD_1YHJ9RXMJ360 Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_28CHY0GDPRA0,CON_3SAMK9CZWKN0,24 Volume 26 PRD_28CHY0GDPRA0 Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_2DZSJEVG4XR0,CON_3SAMK9CZWKN0,1 Volume 7 PRD_2DZSJEVG4XR0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2H186JEHYCA0,CON_3SAMK9CZWKN0,1 Volume 13, 14, 15 PRD_2H186JEHYCA0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2JGSVZDFJDB0,CON_3SAMK9CZWKN0,1 Volume 19, 20, 21 PRD_2JGSVZDFJDB0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2JQA30MTRV8G,CON_3SAMK9CZWKN0,1 Volume 1 PRD_2JQA30MTRV8G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2NQRG58VTB90,CON_3SAMK9CZWKN0,1 Volume 7, 8, 9 PRD_2NQRG58VTB90 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2QW0H31ADC0G,CON_3SAMK9CZWKN0,1 Volume 14 PRD_2QW0H31ADC0G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2R257BAAKDP0,CON_3SAMK9CZWKN0,1 Volume 11 PRD_2R257BAAKDP0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2R4B3RAY6A80,CON_3SAMK9CZWKN0,1 Volume 1, 2, 3 PRD_2R4B3RAY6A80 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_2Y8FTYHWPJB0,CON_3SAMK9CZWKN0,24 Volume 21 PRD_2Y8FTYHWPJB0 Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_321QF9AJ42QG,CON_3SAMK9CZWKN0,1 Volume 34 PRD_321QF9AJ42QG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_33FSZQ5X0MF0,CON_3SAMK9CZWKN0,24 Volume 20 PRD_33FSZQ5X0MF0 Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_33Q2F68WHS9G,CON_3SAMK9CZWKN0,1 Volume 9 PRD_33Q2F68WHS9G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_354P4F6YC0NG,CON_3SAMK9CZWKN0,1 Volume 30 PRD_354P4F6YC0NG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_36P7TW4M01PG,CON_3SAMK9CZWKN0,1 Volume 32 PRD_36P7TW4M01PG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_38DAPENSCESG,CON_3SAMK9CZWKN0,24 Volume 27 PRD_38DAPENSCESG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_39N6Q2008FMG,CON_3SAMK9CZWKN0,1 Volume 28 PRD_39N6Q2008FMG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_39SKZ3BKYXT0,CON_3SAMK9CZWKN0,1 Volume 4 PRD_39SKZ3BKYXT0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3CBH2N2AMEVG,CON_3SAMK9CZWKN0,1 Volume 22, 23, 24 PRD_3CBH2N2AMEVG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3CE2AP5NTWS0,CON_3SAMK9CZWKN0,1 Volume 2 PRD_3CE2AP5NTWS0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3GC8X1NT0WZ0,CON_3SAMK9CZWKN0,1 Volume 5 PRD_3GC8X1NT0WZ0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3JSZT7GP80DG,CON_3SAMK9CZWKN0,24 Volume 25 PRD_3JSZT7GP80DG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_3Q2V8MQWCVY0,CON_3SAMK9CZWKN0,1 Volume 3 PRD_3Q2V8MQWCVY0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3SNGMYGETYPG,CON_3SAMK9CZWKN0,24 Volume 23 PRD_3SNGMYGETYPG Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_3V2NJ3F5W4HG,CON_3SAMK9CZWKN0,1 Volume 38 PRD_3V2NJ3F5W4HG Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3VH9KNEF6310,CON_3SAMK9CZWKN0,1 Volume 15 PRD_3VH9KNEF6310 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3VKBT7H68TX0,CON_3SAMK9CZWKN0,1 Volume 1 PRD_3VKBT7H68TX0 Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3XPNC804655G,CON_3SAMK9CZWKN0,1 Volume 10 PRD_3XPNC804655G Ken Akamatsu CON_3SAMK9CZWKN0 1  
PRD_3Z35KBHKJYN0,CON_3SAMK9CZWKN0,24 Volume 24 PRD_3Z35KBHKJYN0 Ken Akamatsu CON_3SAMK9CZWKN0 24  
PRD_3ZK4XP9FR3GG,CON_3SAMK9CZWKN0,1 Volume 36 PRD_3ZK4XP9FR3GG Ken Akamatsu CON_3SAMK9CZWKN0 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.359ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS