BookWalker

home / database

product_contributors

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

39 rows where contributor_id = "CON_1FYVD3BME43G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0ENYHE7KFB50,CON_1FYVD3BME43G,1 Volume 2 PRD_0ENYHE7KFB50 Aya Kanno CON_1FYVD3BME43G 1  
PRD_0MF09T310HR0,CON_1FYVD3BME43G,1 Volume 13 PRD_0MF09T310HR0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_0RXGVEXBCGZ0,CON_1FYVD3BME43G,1 Volume 11 PRD_0RXGVEXBCGZ0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_0WKWZ2CTZF10,CON_1FYVD3BME43G,1 Volume 12 PRD_0WKWZ2CTZF10 Aya Kanno CON_1FYVD3BME43G 1  
PRD_0ZJ361ZD8ZY0,CON_1FYVD3BME43G,1 Volume 9 PRD_0ZJ361ZD8ZY0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_11FCKJZ1PP5G,CON_1FYVD3BME43G,1 Volume 18 PRD_11FCKJZ1PP5G Aya Kanno CON_1FYVD3BME43G 1  
PRD_122T11TG7NF0,CON_1FYVD3BME43G,1 Volume 9 PRD_122T11TG7NF0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_12X98Z5AH540,CON_1FYVD3BME43G,1 Volume 2 PRD_12X98Z5AH540 Aya Kanno CON_1FYVD3BME43G 1  
PRD_1505Y7PWFKD0,CON_1FYVD3BME43G,1 Volume 5 PRD_1505Y7PWFKD0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_15S2N4HRC770,CON_1FYVD3BME43G,1 Volume 16 PRD_15S2N4HRC770 Aya Kanno CON_1FYVD3BME43G 1  
PRD_16KNCMMT3ME0,CON_1FYVD3BME43G,1 Volume 8 PRD_16KNCMMT3ME0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_18JE8RVDYMBG,CON_1FYVD3BME43G,1 Volume 17 PRD_18JE8RVDYMBG Aya Kanno CON_1FYVD3BME43G 1  
PRD_1C0BKCAX13DG,CON_1FYVD3BME43G,1 Volume 3 PRD_1C0BKCAX13DG Aya Kanno CON_1FYVD3BME43G 1  
PRD_1F0YTBMQTKAG,CON_1FYVD3BME43G,1 Volume 15 PRD_1F0YTBMQTKAG Aya Kanno CON_1FYVD3BME43G 1  
PRD_1HRRFM3ZQ9B0,CON_1FYVD3BME43G,1 Volume 17 PRD_1HRRFM3ZQ9B0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_1M98S8X1K8A0,CON_1FYVD3BME43G,1 Volume 16 PRD_1M98S8X1K8A0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_1RZV4VZBZQ90,CON_1FYVD3BME43G,1 Volume 14 PRD_1RZV4VZBZQ90 Aya Kanno CON_1FYVD3BME43G 1  
PRD_1XB102WCGZCG,CON_1FYVD3BME43G,1 Volume 2 PRD_1XB102WCGZCG Aya Kanno CON_1FYVD3BME43G 1  
PRD_1YCYXCB0N650,CON_1FYVD3BME43G,1 Volume 4 PRD_1YCYXCB0N650 Aya Kanno CON_1FYVD3BME43G 1  
PRD_1Z9SEDH2MRAG,CON_1FYVD3BME43G,1 Volume 11 PRD_1Z9SEDH2MRAG Aya Kanno CON_1FYVD3BME43G 1  
PRD_1ZCBPESDVP80,CON_1FYVD3BME43G,1 Volume 10 PRD_1ZCBPESDVP80 Aya Kanno CON_1FYVD3BME43G 1  
PRD_209TAXBMJXCG,CON_1FYVD3BME43G,1 Volume 8 PRD_209TAXBMJXCG Aya Kanno CON_1FYVD3BME43G 1  
PRD_212SE9RMCNAG,CON_1FYVD3BME43G,1 Volume 1 PRD_212SE9RMCNAG Aya Kanno CON_1FYVD3BME43G 1  
PRD_212SE9RMCNAG,CON_1FYVD3BME43G,2 Volume 1 PRD_212SE9RMCNAG Aya Kanno CON_1FYVD3BME43G 2  
PRD_24YANG5YYXKG,CON_1FYVD3BME43G,1 Volume 7 PRD_24YANG5YYXKG Aya Kanno CON_1FYVD3BME43G 1  
PRD_2B88Z3ZNMDD0,CON_1FYVD3BME43G,1 Volume 6 PRD_2B88Z3ZNMDD0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_2BF57370TWJG,CON_1FYVD3BME43G,1 Volume 5 PRD_2BF57370TWJG Aya Kanno CON_1FYVD3BME43G 1  
PRD_2MWFSHPJW58G,CON_1FYVD3BME43G,1 Volume 1 PRD_2MWFSHPJW58G Aya Kanno CON_1FYVD3BME43G 1  
PRD_2SAVDQC8AZEG,CON_1FYVD3BME43G,1 Volume 10 PRD_2SAVDQC8AZEG Aya Kanno CON_1FYVD3BME43G 1  
PRD_2TM824J6EGFG,CON_1FYVD3BME43G,1 Volume 12 PRD_2TM824J6EGFG Aya Kanno CON_1FYVD3BME43G 1  
PRD_30A2TA5N5NYG,CON_1FYVD3BME43G,1 Volume 7 PRD_30A2TA5N5NYG Aya Kanno CON_1FYVD3BME43G 1  
PRD_3364S8CW8QP0,CON_1FYVD3BME43G,1 Volume 1 PRD_3364S8CW8QP0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_34RX5X7Z1MXG,CON_1FYVD3BME43G,1 Volume 6 PRD_34RX5X7Z1MXG Aya Kanno CON_1FYVD3BME43G 1  
PRD_39SBH9PC21J0,CON_1FYVD3BME43G,1 Volume 1 PRD_39SBH9PC21J0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_3B9DGG11DKWG,CON_1FYVD3BME43G,1 Volume 4 PRD_3B9DGG11DKWG Aya Kanno CON_1FYVD3BME43G 1  
PRD_3D81CM7MRKT0,CON_1FYVD3BME43G,1 Volume 14 PRD_3D81CM7MRKT0 Aya Kanno CON_1FYVD3BME43G 1  
PRD_3P000YJWN9TG,CON_1FYVD3BME43G,1 Volume 13 PRD_3P000YJWN9TG Aya Kanno CON_1FYVD3BME43G 1  
PRD_3TPGKHC6H8SG,CON_1FYVD3BME43G,1 Volume 15 PRD_3TPGKHC6H8SG Aya Kanno CON_1FYVD3BME43G 1  
PRD_3WM6QPT5K6MG,CON_1FYVD3BME43G,1 Volume 3 PRD_3WM6QPT5K6MG Aya Kanno CON_1FYVD3BME43G 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 11.055ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS