BookWalker

home / database

product_contributors

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

46 rows where contributor_id = "CON_2PM5NK51C4AG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0136C5YD5S00,CON_2PM5NK51C4AG,1 Volume 38 PRD_0136C5YD5S00 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_02JQ2JWAST10,CON_2PM5NK51C4AG,1 Volume 41 PRD_02JQ2JWAST10 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0381998YDZ4G,CON_2PM5NK51C4AG,1 Volume 10 PRD_0381998YDZ4G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_03CKHAG9GDA0,CON_2PM5NK51C4AG,1 Volume 28 PRD_03CKHAG9GDA0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_055NW4DBCJ00,CON_2PM5NK51C4AG,1 Volume 1 PRD_055NW4DBCJ00 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_06SRW3EP8XX0,CON_2PM5NK51C4AG,1 Volume 43 PRD_06SRW3EP8XX0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_06VQTJVCQ16G,CON_2PM5NK51C4AG,1 Volume 2 PRD_06VQTJVCQ16G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_07YHMWA09YBG,CON_2PM5NK51C4AG,1 Volume 26 PRD_07YHMWA09YBG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_090DS39R4AF0,CON_2PM5NK51C4AG,1 Volume 24 PRD_090DS39R4AF0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0AKXFGFNRB80,CON_2PM5NK51C4AG,1 Volume 7 PRD_0AKXFGFNRB80 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0JHM4AQ3HM1G,CON_2PM5NK51C4AG,1 Volume 33 PRD_0JHM4AQ3HM1G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0WVPZPEM1G5G,CON_2PM5NK51C4AG,1 Volume 29 PRD_0WVPZPEM1G5G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0WY37QP7MEB0,CON_2PM5NK51C4AG,1 Volume 11 PRD_0WY37QP7MEB0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_0Z2WFRSJTW8G,CON_2PM5NK51C4AG,1 Volume 12 PRD_0Z2WFRSJTW8G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_11S03F2MVJ9G,CON_2PM5NK51C4AG,1 Volume 36 PRD_11S03F2MVJ9G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_12AW1NMHP7KG,CON_2PM5NK51C4AG,1 Volume 22 PRD_12AW1NMHP7KG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_16ZSV9Y6RMG0,CON_2PM5NK51C4AG,1 Volume 2 PRD_16ZSV9Y6RMG0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_182RGFNK0JP0,CON_2PM5NK51C4AG,1 Volume 18 PRD_182RGFNK0JP0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_19YE8EJ7T4GG,CON_2PM5NK51C4AG,1 Volume 1 PRD_19YE8EJ7T4GG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_1CCYV1CA63QG,CON_2PM5NK51C4AG,1 Volume 17 PRD_1CCYV1CA63QG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_1CKB32QNCHN0,CON_2PM5NK51C4AG,1 Volume 15 PRD_1CKB32QNCHN0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_1FJJB9RBFZEG,CON_2PM5NK51C4AG,1 Volume 37 PRD_1FJJB9RBFZEG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_1G0JE9XRSTFG,CON_2PM5NK51C4AG,1 Volume 6 PRD_1G0JE9XRSTFG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_1ZRYY22TGPJ0,CON_2PM5NK51C4AG,1 Volume 42 PRD_1ZRYY22TGPJ0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_20VZVVF87TGG,CON_2PM5NK51C4AG,1 Volume 39 PRD_20VZVVF87TGG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_21H93KV3BZM0,CON_2PM5NK51C4AG,1 Volume 9 PRD_21H93KV3BZM0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_21NTBK3EYDSG,CON_2PM5NK51C4AG,1 Volume 27 PRD_21NTBK3EYDSG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_247RD6N5QYV0,CON_2PM5NK51C4AG,1 Volume 8 PRD_247RD6N5QYV0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_24AAN7WGTCRG,CON_2PM5NK51C4AG,1 Volume 25 PRD_24AAN7WGTCRG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2GX96MEC22PG,CON_2PM5NK51C4AG,1 Volume 16 PRD_2GX96MEC22PG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2QKSG7BPE1NG,CON_2PM5NK51C4AG,1 Volume 32 PRD_2QKSG7BPE1NG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2T083T5RA0MG,CON_2PM5NK51C4AG,1 Volume 13 PRD_2T083T5RA0MG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2T75BVDBGYT0,CON_2PM5NK51C4AG,1 Volume 14 PRD_2T75BVDBGYT0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2VXZVS2D7JQ0,CON_2PM5NK51C4AG,1 Volume 31 PRD_2VXZVS2D7JQ0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_2X0YG0SSFGN0,CON_2PM5NK51C4AG,1 Volume 30 PRD_2X0YG0SSFGN0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_30PH2ZF1TM0G,CON_2PM5NK51C4AG,1 Volume 40 PRD_30PH2ZF1TM0G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_33CTRMM2N9Y0,CON_2PM5NK51C4AG,1 Volume 3 PRD_33CTRMM2N9Y0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3AMV7CFW5HR0,CON_2PM5NK51C4AG,1 Volume 35 PRD_3AMV7CFW5HR0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3BH7Q432W410,CON_2PM5NK51C4AG,1 Volume 4 PRD_3BH7Q432W410 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3BNGZ5BE2J6G,CON_2PM5NK51C4AG,1 Volume 19 PRD_3BNGZ5BE2J6G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3E35TQNSNN2G,CON_2PM5NK51C4AG,1 Volume 34 PRD_3E35TQNSNN2G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3E7P2RX4R300,CON_2PM5NK51C4AG,1 Volume 20 PRD_3E7P2RX4R300 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3PCQ8KM9A8WG,CON_2PM5NK51C4AG,1 Volume 23 PRD_3PCQ8KM9A8WG Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3SF5XR8AFRX0,CON_2PM5NK51C4AG,1 Volume 5 PRD_3SF5XR8AFRX0 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3SKP5SKNJP2G,CON_2PM5NK51C4AG,1 Volume 21 PRD_3SKP5SKNJP2G Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 1  
PRD_3SP3DTV0S400,CON_2PM5NK51C4AG,1 Volume 3 PRD_3SP3DTV0S400 Mitsutoshi Shimabukuro CON_2PM5NK51C4AG 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 8.418ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS