BookWalker

home / database

product_contributors

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

40 rows where contributor_id = "CON_0XXEZTTK0EE0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_0A5FX5SH62YG,CON_0XXEZTTK0EE0,2 Volume 1 PRD_0A5FX5SH62YG Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_0A5FX5SH62YG,CON_0XXEZTTK0EE0,24 Volume 1 PRD_0A5FX5SH62YG Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_0JBQ481SAT5G,CON_0XXEZTTK0EE0,2 Volume 19 PRD_0JBQ481SAT5G Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_0JBQ481SAT5G,CON_0XXEZTTK0EE0,24 Volume 19 PRD_0JBQ481SAT5G Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_0NKJM0QVE2V0,CON_0XXEZTTK0EE0,2 Volume 14 PRD_0NKJM0QVE2V0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_0NKJM0QVE2V0,CON_0XXEZTTK0EE0,24 Volume 14 PRD_0NKJM0QVE2V0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_12VH4QYHJ3FG,CON_0XXEZTTK0EE0,2 Volume 9 PRD_12VH4QYHJ3FG Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_12VH4QYHJ3FG,CON_0XXEZTTK0EE0,24 Volume 9 PRD_12VH4QYHJ3FG Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_14XZT0CWVJF0,CON_0XXEZTTK0EE0,2 Volume 15 PRD_14XZT0CWVJF0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_14XZT0CWVJF0,CON_0XXEZTTK0EE0,24 Volume 15 PRD_14XZT0CWVJF0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_16V194PTMKKG,CON_0XXEZTTK0EE0,2 Volume 6 PRD_16V194PTMKKG Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_16V194PTMKKG,CON_0XXEZTTK0EE0,24 Volume 6 PRD_16V194PTMKKG Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_1FERZEATY7P0,CON_0XXEZTTK0EE0,2 Volume 11 PRD_1FERZEATY7P0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_1FERZEATY7P0,CON_0XXEZTTK0EE0,24 Volume 11 PRD_1FERZEATY7P0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_1HC1VRSGKM30,CON_0XXEZTTK0EE0,2 Volume 5 PRD_1HC1VRSGKM30 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_1HC1VRSGKM30,CON_0XXEZTTK0EE0,24 Volume 5 PRD_1HC1VRSGKM30 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_1QD22X6BPE50,CON_0XXEZTTK0EE0,2 Volume 17 PRD_1QD22X6BPE50 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_1QD22X6BPE50,CON_0XXEZTTK0EE0,24 Volume 17 PRD_1QD22X6BPE50 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_1WN5EVPSASV0,CON_0XXEZTTK0EE0,2 Volume 12 PRD_1WN5EVPSASV0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_1WN5EVPSASV0,CON_0XXEZTTK0EE0,24 Volume 12 PRD_1WN5EVPSASV0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_1ZZGE216A3B0,CON_0XXEZTTK0EE0,2 Volume 4 PRD_1ZZGE216A3B0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_1ZZGE216A3B0,CON_0XXEZTTK0EE0,24 Volume 4 PRD_1ZZGE216A3B0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_298238N9RG10,CON_0XXEZTTK0EE0,2 Volume 7 PRD_298238N9RG10 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_298238N9RG10,CON_0XXEZTTK0EE0,24 Volume 7 PRD_298238N9RG10 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_2BH2VH8VTTH0,CON_0XXEZTTK0EE0,1 Volume 20 PRD_2BH2VH8VTTH0 Shiori Hanatsuka CON_0XXEZTTK0EE0 1  
PRD_2BH2VH8VTTH0,CON_0XXEZTTK0EE0,2 Volume 20 PRD_2BH2VH8VTTH0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_2DT71RF018K0,CON_0XXEZTTK0EE0,2 Volume 2 PRD_2DT71RF018K0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_2DT71RF018K0,CON_0XXEZTTK0EE0,24 Volume 2 PRD_2DT71RF018K0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_2FWPVYP6K91G,CON_0XXEZTTK0EE0,2 Volume 8 PRD_2FWPVYP6K91G Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_2FWPVYP6K91G,CON_0XXEZTTK0EE0,24 Volume 8 PRD_2FWPVYP6K91G Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_2SXFJYW0MB00,CON_0XXEZTTK0EE0,2 Volume 10 PRD_2SXFJYW0MB00 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_2SXFJYW0MB00,CON_0XXEZTTK0EE0,24 Volume 10 PRD_2SXFJYW0MB00 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_2TTX5N680C60,CON_0XXEZTTK0EE0,2 Volume 16 PRD_2TTX5N680C60 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_2TTX5N680C60,CON_0XXEZTTK0EE0,24 Volume 16 PRD_2TTX5N680C60 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_30GVHQPTV8K0,CON_0XXEZTTK0EE0,2 Volume 18 PRD_30GVHQPTV8K0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_30GVHQPTV8K0,CON_0XXEZTTK0EE0,24 Volume 18 PRD_30GVHQPTV8K0 Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_35XQPJFTG77G,CON_0XXEZTTK0EE0,2 Volume 13 PRD_35XQPJFTG77G Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_35XQPJFTG77G,CON_0XXEZTTK0EE0,24 Volume 13 PRD_35XQPJFTG77G Shiori Hanatsuka CON_0XXEZTTK0EE0 24  
PRD_3JD40FG8EZH0,CON_0XXEZTTK0EE0,2 Volume 3 PRD_3JD40FG8EZH0 Shiori Hanatsuka CON_0XXEZTTK0EE0 2  
PRD_3JD40FG8EZH0,CON_0XXEZTTK0EE0,24 Volume 3 PRD_3JD40FG8EZH0 Shiori Hanatsuka CON_0XXEZTTK0EE0 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.11ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS