BookWalker

home / database

product_contributors

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

23 rows where contributor_id = "CON_19S5VHF215X0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_07Q5VHVF13K0,CON_19S5VHF215X0,0 Volume 2 PRD_07Q5VHVF13K0 Jessica Lange CON_19S5VHF215X0 0  
PRD_08EBYZ9M7110,CON_19S5VHF215X0,0 Volume 1 PRD_08EBYZ9M7110 Jessica Lange CON_19S5VHF215X0 0  
PRD_16CY4C8DNSDG,CON_19S5VHF215X0,0 Volume 5 PRD_16CY4C8DNSDG Jessica Lange CON_19S5VHF215X0 0  
PRD_171VHQMDJHZ0,CON_19S5VHF215X0,0 Volume 6 PRD_171VHQMDJHZ0 Jessica Lange CON_19S5VHF215X0 0  
PRD_18SD4DPVYC40,CON_19S5VHF215X0,0 Side Story PRD_18SD4DPVYC40 Jessica Lange CON_19S5VHF215X0 0  
PRD_1B4RZD9X1DX0,CON_19S5VHF215X0,0 Volume 1 PRD_1B4RZD9X1DX0 Jessica Lange CON_19S5VHF215X0 0  
PRD_1Q39QVSQAZNG,CON_19S5VHF215X0,9 Volume 11 PRD_1Q39QVSQAZNG Jessica Lange CON_19S5VHF215X0 9  
PRD_1TGNGB1CQD50,CON_19S5VHF215X0,0 Volume 4 PRD_1TGNGB1CQD50 Jessica Lange CON_19S5VHF215X0 0  
PRD_1Z9ZF6C1DVFG,CON_19S5VHF215X0,0 Volume 2 PRD_1Z9ZF6C1DVFG Jessica Lange CON_19S5VHF215X0 0  
PRD_23Z0J7KQF0Y0,CON_19S5VHF215X0,0 Volume 7 PRD_23Z0J7KQF0Y0 Jessica Lange CON_19S5VHF215X0 0  
PRD_272PK7DF9V3G,CON_19S5VHF215X0,0 Volume 6 PRD_272PK7DF9V3G Jessica Lange CON_19S5VHF215X0 0  
PRD_2DSJJ04F0M0G,CON_19S5VHF215X0,0 Volume 4 PRD_2DSJJ04F0M0G Jessica Lange CON_19S5VHF215X0 0  
PRD_2GH61W3739GG,CON_19S5VHF215X0,9 Volume 10 PRD_2GH61W3739GG Jessica Lange CON_19S5VHF215X0 9  
PRD_2M32QKX56W30,CON_19S5VHF215X0,0 Volume 2 PRD_2M32QKX56W30 Jessica Lange CON_19S5VHF215X0 0  
PRD_2T01MM5YW360,CON_19S5VHF215X0,9 Volume 7 PRD_2T01MM5YW360 Jessica Lange CON_19S5VHF215X0 9  
PRD_302DPD6SVDFG,CON_19S5VHF215X0,0 Volume 5 PRD_302DPD6SVDFG Jessica Lange CON_19S5VHF215X0 0  
PRD_308P3QMYCX9G,CON_19S5VHF215X0,9 Volume 8 PRD_308P3QMYCX9G Jessica Lange CON_19S5VHF215X0 9  
PRD_3BWA3ZTAGRBG,CON_19S5VHF215X0,0 Volume 4 PRD_3BWA3ZTAGRBG Jessica Lange CON_19S5VHF215X0 0  
PRD_3BX6KH5DPD50,CON_19S5VHF215X0,0 Volume 3 PRD_3BX6KH5DPD50 Jessica Lange CON_19S5VHF215X0 0  
PRD_3DB3NWMGN1A0,CON_19S5VHF215X0,9 Volume 12 PRD_3DB3NWMGN1A0 Jessica Lange CON_19S5VHF215X0 9  
PRD_3K6X7WPA6R8G,CON_19S5VHF215X0,0 Volume 1 PRD_3K6X7WPA6R8G Jessica Lange CON_19S5VHF215X0 0  
PRD_3NFYA7A1PZGG,CON_19S5VHF215X0,0 Volume 3 PRD_3NFYA7A1PZGG Jessica Lange CON_19S5VHF215X0 0  
PRD_3W84TXAS7CA0,CON_19S5VHF215X0,0 Volume 3 PRD_3W84TXAS7CA0 Jessica Lange CON_19S5VHF215X0 0  

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.636ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS