BookWalker

home / database

product_contributors

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

28 rows where contributor_id = "CON_2SXVY9EAYF10"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_id, role

Link product_id contributor_id role name_override
PRD_02TSP6G5K4W0,CON_2SXVY9EAYF10,0 Volume 2 PRD_02TSP6G5K4W0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_03DQ9WYCWJZ0,CON_2SXVY9EAYF10,9 Volume 1 PRD_03DQ9WYCWJZ0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_07Y9DPA6VJN0,CON_2SXVY9EAYF10,9 Volume 8 PRD_07Y9DPA6VJN0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_0GB5W6YKGQVG,CON_2SXVY9EAYF10,0 Volume 5 PRD_0GB5W6YKGQVG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_0H7W8QH4FQJ0,CON_2SXVY9EAYF10,9 Volume 2 PRD_0H7W8QH4FQJ0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_0NSZZY0XB2V0,CON_2SXVY9EAYF10,0 Volume 4 PRD_0NSZZY0XB2V0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_0REEAH27Q1T0,CON_2SXVY9EAYF10,24 Volume 2 PRD_0REEAH27Q1T0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 24  
PRD_0SY2V4BAH2F0,CON_2SXVY9EAYF10,0 Volume 1 PRD_0SY2V4BAH2F0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_0VFQA7ZY79QG,CON_2SXVY9EAYF10,0 Volume 11 PRD_0VFQA7ZY79QG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_1623Z8JZBRWG,CON_2SXVY9EAYF10,9 Volume 6 PRD_1623Z8JZBRWG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_1A2ASWW33CDG,CON_2SXVY9EAYF10,0 Volume 1 PRD_1A2ASWW33CDG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_1CTD7V6HV7T0,CON_2SXVY9EAYF10,0 Volume 2 PRD_1CTD7V6HV7T0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_1Q9EQWFSH9HG,CON_2SXVY9EAYF10,0 Volume 1 PRD_1Q9EQWFSH9HG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_1RE738YEJ560,CON_2SXVY9EAYF10,0 Volume 2 PRD_1RE738YEJ560 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_1X07VXBNXSDG,CON_2SXVY9EAYF10,9 Volume 4 PRD_1X07VXBNXSDG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_205JDST99N6G,CON_2SXVY9EAYF10,0 Secretly, I've Been Suffering About Being Sexless PRD_205JDST99N6G Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_2JAE7P0AXYNG,CON_2SXVY9EAYF10,0 Caterpillar Girl and Bad Texter Boy PRD_2JAE7P0AXYNG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_2JAE7P0AXYNG,CON_2SXVY9EAYF10,24 Caterpillar Girl and Bad Texter Boy PRD_2JAE7P0AXYNG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 24  
PRD_2T17G8K291AG,CON_2SXVY9EAYF10,0 Volume 3 PRD_2T17G8K291AG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_2YQP3VD4N09G,CON_2SXVY9EAYF10,0 Volume 1 PRD_2YQP3VD4N09G Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_2Z04E95FXRT0,CON_2SXVY9EAYF10,0 Volume 5 PRD_2Z04E95FXRT0 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_34549Y9T7J60,CON_2SXVY9EAYF10,0 Volume 3 PRD_34549Y9T7J60 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_38VMMHBW3H50,CON_2SXVY9EAYF10,9 Volume 1 PRD_38VMMHBW3H50 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_3ED5EJMCX7AG,CON_2SXVY9EAYF10,0 Volume 4 PRD_3ED5EJMCX7AG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_3FQZY7W8FACG,CON_2SXVY9EAYF10,0 Volume 3 PRD_3FQZY7W8FACG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_3PMAJ4DAKF50,CON_2SXVY9EAYF10,0 Volume 12 PRD_3PMAJ4DAKF50 Alexandra McCullough-Garcia CON_2SXVY9EAYF10 0  
PRD_3X7CNMVKQ8AG,CON_2SXVY9EAYF10,9 Volume 1 PRD_3X7CNMVKQ8AG Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  
PRD_3XFN6BHEAC1G,CON_2SXVY9EAYF10,9 Volume 2 PRD_3XFN6BHEAC1G Alexandra McCullough-Garcia CON_2SXVY9EAYF10 9  

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