BookWalker

home / database

product_contributors

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

50 rows where contributor_id = "CON_18T8V14JNTH0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0CGW9XWHH1HG,CON_18T8V14JNTH0,1 Volume 27 PRD_0CGW9XWHH1HG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0FMHHSAMZ3FG,CON_18T8V14JNTH0,2 Volume 44 PRD_0FMHHSAMZ3FG Chuya Koyama CON_18T8V14JNTH0 2  
PRD_0FMHHSAMZ3FG,CON_18T8V14JNTH0,24 Volume 44 PRD_0FMHHSAMZ3FG Chuya Koyama CON_18T8V14JNTH0 24  
PRD_0J8EXKA3C2ZG,CON_18T8V14JNTH0,1 Volume 9 PRD_0J8EXKA3C2ZG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0NF9TS6FM0XG,CON_18T8V14JNTH0,1 Volume 5 PRD_0NF9TS6FM0XG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0P7KETXJ9GR0,CON_18T8V14JNTH0,24 Volume 39 PRD_0P7KETXJ9GR0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_0PYSF64581YG,CON_18T8V14JNTH0,1 Volume 7 PRD_0PYSF64581YG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0SXR4C3HGFWG,CON_18T8V14JNTH0,1 Volume 3 PRD_0SXR4C3HGFWG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0WHQK701MJTG,CON_18T8V14JNTH0,24 Volume 38 PRD_0WHQK701MJTG Chuya Koyama CON_18T8V14JNTH0 24  
PRD_0WJ8Q0XVWE3G,CON_18T8V14JNTH0,1 Volume 1 PRD_0WJ8Q0XVWE3G Chuya Koyama CON_18T8V14JNTH0 1  
PRD_0Y5SMEV1NSV0,CON_18T8V14JNTH0,1 Volume 33 PRD_0Y5SMEV1NSV0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_13S5HX05Y640,CON_18T8V14JNTH0,1 Volume 18 PRD_13S5HX05Y640 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_15RB19XVYWV0,CON_18T8V14JNTH0,24 Volume 35 PRD_15RB19XVYWV0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_16FMWG2FT5B0,CON_18T8V14JNTH0,1 Volume 16 PRD_16FMWG2FT5B0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_19JQSQSM2390,CON_18T8V14JNTH0,1 Volume 12 PRD_19JQSQSM2390 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1AB8Z741CFNG,CON_18T8V14JNTH0,1 Volume 30 PRD_1AB8Z741CFNG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1AW7E4ZJ64A0,CON_18T8V14JNTH0,1 Volume 14 PRD_1AW7E4ZJ64A0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1C36BAVYE280,CON_18T8V14JNTH0,1 Volume 10 PRD_1C36BAVYE280 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1HMVZH9D1T00,CON_18T8V14JNTH0,1 Volume 26 PRD_1HMVZH9D1T00 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1HVFZKNR19J0,CON_18T8V14JNTH0,24 Volume 40 PRD_1HVFZKNR19J0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_1M5A94AQDS70,CON_18T8V14JNTH0,1 Volume 24 PRD_1M5A94AQDS70 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1RVTMQ4S9R60,CON_18T8V14JNTH0,1 Volume 22 PRD_1RVTMQ4S9R60 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_1Z8N6A63J750,CON_18T8V14JNTH0,1 Volume 20 PRD_1Z8N6A63J750 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_24RSFY6PAS70,CON_18T8V14JNTH0,1 Volume 29 PRD_24RSFY6PAS70 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2949JJ8T5BM0,CON_18T8V14JNTH0,2 Volume 45 PRD_2949JJ8T5BM0 Chuya Koyama CON_18T8V14JNTH0 2  
PRD_2949JJ8T5BM0,CON_18T8V14JNTH0,24 Volume 45 PRD_2949JJ8T5BM0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_2EBNGKJCK120,CON_18T8V14JNTH0,1 Volume 28 PRD_2EBNGKJCK120 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2FGH376TM96G,CON_18T8V14JNTH0,1 Volume 32 PRD_2FGH376TM96G Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2GHPPXN0A1F0,CON_18T8V14JNTH0,1 Volume 8 PRD_2GHPPXN0A1F0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2Q611GQAP0E0,CON_18T8V14JNTH0,1 Volume 6 PRD_2Q611GQAP0E0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2V1QBJVB50A0,CON_18T8V14JNTH0,24 Volume 37 PRD_2V1QBJVB50A0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_2VMHK3HCJFD0,CON_18T8V14JNTH0,1 Volume 4 PRD_2VMHK3HCJFD0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_2Y50YPJPYEC0,CON_18T8V14JNTH0,1 Volume 2 PRD_2Y50YPJPYEC0 Chuya Koyama CON_18T8V14JNTH0 1  
PRD_306CA7KAW6VG,CON_18T8V14JNTH0,1 Volume 17 PRD_306CA7KAW6VG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_31R254X7RJ80,CON_18T8V14JNTH0,24 Volume 36 PRD_31R254X7RJ80 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_34MWNTDCR5TG,CON_18T8V14JNTH0,1 Volume 15 PRD_34MWNTDCR5TG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_37YD9XKY8BPG,CON_18T8V14JNTH0,2 Volume 41 PRD_37YD9XKY8BPG Chuya Koyama CON_18T8V14JNTH0 2  
PRD_37YD9XKY8BPG,CON_18T8V14JNTH0,24 Volume 41 PRD_37YD9XKY8BPG Chuya Koyama CON_18T8V14JNTH0 24  
PRD_39RMVG7FYZ20,CON_18T8V14JNTH0,2 Volume 43 PRD_39RMVG7FYZ20 Chuya Koyama CON_18T8V14JNTH0 2  
PRD_39RMVG7FYZ20,CON_18T8V14JNTH0,24 Volume 43 PRD_39RMVG7FYZ20 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_3B47YR5JQDJ0,CON_18T8V14JNTH0,2 Volume 42 PRD_3B47YR5JQDJ0 Chuya Koyama CON_18T8V14JNTH0 2  
PRD_3B47YR5JQDJ0,CON_18T8V14JNTH0,24 Volume 42 PRD_3B47YR5JQDJ0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_3B5F7DEQ44SG,CON_18T8V14JNTH0,1 Volume 13 PRD_3B5F7DEQ44SG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3FVZJ08S03RG,CON_18T8V14JNTH0,1 Volume 11 PRD_3FVZJ08S03RG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3GBQGHY59CJG,CON_18T8V14JNTH0,1 Volume 31 PRD_3GBQGHY59CJG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3QH8Y3V428V0,CON_18T8V14JNTH0,24 Volume 34 PRD_3QH8Y3V428V0 Chuya Koyama CON_18T8V14JNTH0 24  
PRD_3QW3GVVJFTQG,CON_18T8V14JNTH0,1 Volume 25 PRD_3QW3GVVJFTQG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3S3DD1QYQRNG,CON_18T8V14JNTH0,1 Volume 21 PRD_3S3DD1QYQRNG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3TJJ2ENMBSPG,CON_18T8V14JNTH0,1 Volume 23 PRD_3TJJ2ENMBSPG Chuya Koyama CON_18T8V14JNTH0 1  
PRD_3XHXRMH0G7MG,CON_18T8V14JNTH0,1 Volume 19 PRD_3XHXRMH0G7MG Chuya Koyama CON_18T8V14JNTH0 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 9.737ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS