BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_38AC8TPW2ACG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_02ETYP5TZ1W0,CON_38AC8TPW2ACG,1 Volume 12 PRD_02ETYP5TZ1W0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_07S46Z11T1Y0,CON_38AC8TPW2ACG,1 Volume 17 PRD_07S46Z11T1Y0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0EY46N454C8G,CON_38AC8TPW2ACG,1 Volume 14 PRD_0EY46N454C8G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0G4Z68J1YB8G,CON_38AC8TPW2ACG,1 Volume 5 PRD_0G4Z68J1YB8G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0GWPHC8R0NM0,CON_38AC8TPW2ACG,1 Volume 11 PRD_0GWPHC8R0NM0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0MDZY89BFJE0,CON_38AC8TPW2ACG,1 Volume 7 PRD_0MDZY89BFJE0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0NBYN5GRMMVG,CON_38AC8TPW2ACG,1 Volume 10 PRD_0NBYN5GRMMVG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0NCK3NCDC400,CON_38AC8TPW2ACG,1 Volume 2 PRD_0NCK3NCDC400 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0TWSS9KHDZR0,CON_38AC8TPW2ACG,1 Volume 6 PRD_0TWSS9KHDZR0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0V2RX26FXQ6G,CON_38AC8TPW2ACG,1 Volume 10 PRD_0V2RX26FXQ6G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0WTR8XTG1E90,CON_38AC8TPW2ACG,1 Volume 8 PRD_0WTR8XTG1E90 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_0ZG9499NJMA0,CON_38AC8TPW2ACG,1 Volume 1 PRD_0ZG9499NJMA0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_108EV4BDAF4G,CON_38AC8TPW2ACG,1 Volume 8 PRD_108EV4BDAF4G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_13130YF86040,CON_38AC8TPW2ACG,1 Volume 9 PRD_13130YF86040 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1404SX0MTD40,CON_38AC8TPW2ACG,1 Volume 7 PRD_1404SX0MTD40 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_152V71KQ7S5G,CON_38AC8TPW2ACG,1 Volume 18 PRD_152V71KQ7S5G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_17TX4WGR4DY0,CON_38AC8TPW2ACG,1 Volume 20 PRD_17TX4WGR4DY0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_18A7ZTRHGMHG,CON_38AC8TPW2ACG,1 Volume 11 PRD_18A7ZTRHGMHG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1EZGT93KJQ50,CON_38AC8TPW2ACG,1 Volume 13 PRD_1EZGT93KJQ50 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1GTTHXNFMTY0,CON_38AC8TPW2ACG,1 Volume 4 PRD_1GTTHXNFMTY0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1KK17J7FRZ00,CON_38AC8TPW2ACG,1 Volume 13 PRD_1KK17J7FRZ00 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1YDQJ1TBV5P0,CON_38AC8TPW2ACG,1 Volume 19 PRD_1YDQJ1TBV5P0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_1ZYF7CW1CJC0,CON_38AC8TPW2ACG,1 Volume 15 PRD_1ZYF7CW1CJC0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2005604S8PXG,CON_38AC8TPW2ACG,1 Volume 5 PRD_2005604S8PXG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2CVDWJDZ83M0,CON_38AC8TPW2ACG,1 Volume 21 PRD_2CVDWJDZ83M0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2D4840TWEKPG,CON_38AC8TPW2ACG,1 Volume 12 PRD_2D4840TWEKPG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2N32TQ9KHZRG,CON_38AC8TPW2ACG,1 Volume 4 PRD_2N32TQ9KHZRG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2VVZFBQTAK40,CON_38AC8TPW2ACG,1 Volume 1 PRD_2VVZFBQTAK40 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_2Y0Z7BJ3VT9G,CON_38AC8TPW2ACG,1 Volume 3 PRD_2Y0Z7BJ3VT9G Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_30SZGWNZXDR0,CON_38AC8TPW2ACG,1 Volume 3 PRD_30SZGWNZXDR0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_37NJ8EKAMKD0,CON_38AC8TPW2ACG,1 Volume 6 PRD_37NJ8EKAMKD0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_3FCDW2HG1WQ0,CON_38AC8TPW2ACG,1 Volume 9 PRD_3FCDW2HG1WQ0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_3NM5CDR4TWKG,CON_38AC8TPW2ACG,1 Volume 2 PRD_3NM5CDR4TWKG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_3SVKHE8QRGA0,CON_38AC8TPW2ACG,1 Volume 14 PRD_3SVKHE8QRGA0 Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_3TY8D3E7KFEG,CON_38AC8TPW2ACG,1 Volume 16 PRD_3TY8D3E7KFEG Tsunehiko Watanabe CON_38AC8TPW2ACG 1  
PRD_3YHX8BG51JQG,CON_38AC8TPW2ACG,1 Volume 15 PRD_3YHX8BG51JQG Tsunehiko Watanabe CON_38AC8TPW2ACG 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.558ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS