BookWalker

home / database

product_contributors

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

40 rows where contributor_id = "CON_0KBH720DT45G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_027P6PZ3Z55G,CON_0KBH720DT45G,0 Volume 9 PRD_027P6PZ3Z55G Luke Hutton CON_0KBH720DT45G 0  
PRD_03CBA4G821VG,CON_0KBH720DT45G,9 Volume 2 PRD_03CBA4G821VG Luke Hutton CON_0KBH720DT45G 9  
PRD_0K5DBQNX9YS0,CON_0KBH720DT45G,9 Volume 3 PRD_0K5DBQNX9YS0 Luke Hutton CON_0KBH720DT45G 9  
PRD_0SSQ6QX0J1S0,CON_0KBH720DT45G,0 Volume 1 PRD_0SSQ6QX0J1S0 Luke Hutton CON_0KBH720DT45G 0  
PRD_0T4Y0A3VES4G,CON_0KBH720DT45G,0 Volume 7 PRD_0T4Y0A3VES4G Luke Hutton CON_0KBH720DT45G 0  
PRD_0V8XT7RJDVYG,CON_0KBH720DT45G,9 Volume 7 PRD_0V8XT7RJDVYG Luke Hutton CON_0KBH720DT45G 9  
PRD_0WMXFF7FD6HG,CON_0KBH720DT45G,9 Volume 1 PRD_0WMXFF7FD6HG Luke Hutton CON_0KBH720DT45G 9  
PRD_0ZNASZ5BR150,CON_0KBH720DT45G,9 Volume 2 PRD_0ZNASZ5BR150 Luke Hutton CON_0KBH720DT45G 9  
PRD_16KPQHKSSVJ0,CON_0KBH720DT45G,9 Volume 4 PRD_16KPQHKSSVJ0 Luke Hutton CON_0KBH720DT45G 9  
PRD_19KQNH8S6E8G,CON_0KBH720DT45G,9 Volume 1 PRD_19KQNH8S6E8G Luke Hutton CON_0KBH720DT45G 9  
PRD_1AR4TAK15CY0,CON_0KBH720DT45G,0 Volume 1 PRD_1AR4TAK15CY0 Luke Hutton CON_0KBH720DT45G 0  
PRD_1M1DDB36217G,CON_0KBH720DT45G,9 Volume 4 PRD_1M1DDB36217G Luke Hutton CON_0KBH720DT45G 9  
PRD_1M5ZNCAH8Z50,CON_0KBH720DT45G,9 Volume 6 PRD_1M5ZNCAH8Z50 Luke Hutton CON_0KBH720DT45G 9  
PRD_1MNY7Q2DY40G,CON_0KBH720DT45G,0 Volume 1 PRD_1MNY7Q2DY40G Luke Hutton CON_0KBH720DT45G 0  
PRD_1PZ49GQPSBGG,CON_0KBH720DT45G,0 Volume 1 PRD_1PZ49GQPSBGG Luke Hutton CON_0KBH720DT45G 0  
PRD_1QKTMDCE5SAG,CON_0KBH720DT45G,9 Volume 3 PRD_1QKTMDCE5SAG Luke Hutton CON_0KBH720DT45G 9  
PRD_1VE2WCP1JSV0,CON_0KBH720DT45G,9 Volume 2 PRD_1VE2WCP1JSV0 Luke Hutton CON_0KBH720DT45G 9  
PRD_20GA1PZGDAEG,CON_0KBH720DT45G,9 Volume 5 PRD_20GA1PZGDAEG Luke Hutton CON_0KBH720DT45G 9  
PRD_24Q12BT74D9G,CON_0KBH720DT45G,0 Volume 6 PRD_24Q12BT74D9G Luke Hutton CON_0KBH720DT45G 0  
PRD_29YSW6Z97AY0,CON_0KBH720DT45G,0 Volume 1 PRD_29YSW6Z97AY0 Luke Hutton CON_0KBH720DT45G 0  
PRD_2BK1YTEHNT2G,CON_0KBH720DT45G,0 Volume 2 PRD_2BK1YTEHNT2G Luke Hutton CON_0KBH720DT45G 0  
PRD_2BY91WFTAVCG,CON_0KBH720DT45G,0 Volume 6 PRD_2BY91WFTAVCG Luke Hutton CON_0KBH720DT45G 0  
PRD_2HMVZD4NTV2G,CON_0KBH720DT45G,9 Volume 7 PRD_2HMVZD4NTV2G Luke Hutton CON_0KBH720DT45G 9  
PRD_2HNXH4QSHK30,CON_0KBH720DT45G,9 Volume 5 PRD_2HNXH4QSHK30 Luke Hutton CON_0KBH720DT45G 9  
PRD_2KNNWNYAHHSG,CON_0KBH720DT45G,0 Volume 2 PRD_2KNNWNYAHHSG Luke Hutton CON_0KBH720DT45G 0  
PRD_2N2G9B0A3QT0,CON_0KBH720DT45G,9 Volume 1 PRD_2N2G9B0A3QT0 Luke Hutton CON_0KBH720DT45G 9  
PRD_2Q3W2TGS82AG,CON_0KBH720DT45G,0 Volume 8 PRD_2Q3W2TGS82AG Luke Hutton CON_0KBH720DT45G 0  
PRD_2RH7A15CTZ4G,CON_0KBH720DT45G,9 Volume 1 PRD_2RH7A15CTZ4G Luke Hutton CON_0KBH720DT45G 9  
PRD_2TD78Y3EM15G,CON_0KBH720DT45G,0 Volume 8 PRD_2TD78Y3EM15G Luke Hutton CON_0KBH720DT45G 0  
PRD_2VQ31FHFY9J0,CON_0KBH720DT45G,0 Volume 10 PRD_2VQ31FHFY9J0 Luke Hutton CON_0KBH720DT45G 0  
PRD_300PSZT3WS60,CON_0KBH720DT45G,0 Volume 3 PRD_300PSZT3WS60 Luke Hutton CON_0KBH720DT45G 0  
PRD_30EHR7D7AGX0,CON_0KBH720DT45G,0 Volume 5 PRD_30EHR7D7AGX0 Luke Hutton CON_0KBH720DT45G 0  
PRD_33EMG00R34G0,CON_0KBH720DT45G,9 Volume 4 PRD_33EMG00R34G0 Luke Hutton CON_0KBH720DT45G 9  
PRD_37P1W8TW20F0,CON_0KBH720DT45G,0 Volume 6 PRD_37P1W8TW20F0 Luke Hutton CON_0KBH720DT45G 0  
PRD_3DK87KDK8510,CON_0KBH720DT45G,9 Volume 3 PRD_3DK87KDK8510 Luke Hutton CON_0KBH720DT45G 9  
PRD_3EGDFWTV25H0,CON_0KBH720DT45G,0 Volume 6 PRD_3EGDFWTV25H0 Luke Hutton CON_0KBH720DT45G 0  
PRD_3NH3WDNS1ETG,CON_0KBH720DT45G,9 Volume 5 PRD_3NH3WDNS1ETG Luke Hutton CON_0KBH720DT45G 9  
PRD_3NNW4EX4QWR0,CON_0KBH720DT45G,9 Volume 5 PRD_3NNW4EX4QWR0 Luke Hutton CON_0KBH720DT45G 9  
PRD_3SM8J9FAA6F0,CON_0KBH720DT45G,0 Volume 7 PRD_3SM8J9FAA6F0 Luke Hutton CON_0KBH720DT45G 0  
PRD_3W8P89AM3NF0,CON_0KBH720DT45G,0 Volume 8 PRD_3W8P89AM3NF0 Luke Hutton CON_0KBH720DT45G 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.275ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS