BookWalker

home / database

product_contributors

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

46 rows where contributor_id = "CON_0CN4E90RQYCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_02D7QJP40KZG,CON_0CN4E90RQYCG,1 Volume 14 PRD_02D7QJP40KZG Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_03CJQ5F8STYG,CON_0CN4E90RQYCG,1 Volume 11 PRD_03CJQ5F8STYG Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_03KP6CPNTNJG,CON_0CN4E90RQYCG,2 Volume 15 PRD_03KP6CPNTNJG Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_03KP6CPNTNJG,CON_0CN4E90RQYCG,24 Volume 15 PRD_03KP6CPNTNJG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_03PAVEN24WV0,CON_0CN4E90RQYCG,2 Volume 10 PRD_03PAVEN24WV0 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_03PAVEN24WV0,CON_0CN4E90RQYCG,24 Volume 10 PRD_03PAVEN24WV0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_04DH6NSYVTJ0,CON_0CN4E90RQYCG,2 Volume 11 PRD_04DH6NSYVTJ0 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_04DH6NSYVTJ0,CON_0CN4E90RQYCG,24 Volume 11 PRD_04DH6NSYVTJ0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_055RE784H5TG,CON_0CN4E90RQYCG,2 Volume 16 PRD_055RE784H5TG Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_055RE784H5TG,CON_0CN4E90RQYCG,24 Volume 16 PRD_055RE784H5TG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_07PQD28591GG,CON_0CN4E90RQYCG,2 Volume 14 PRD_07PQD28591GG Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_07PQD28591GG,CON_0CN4E90RQYCG,24 Volume 14 PRD_07PQD28591GG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_0ARTTXJMS7V0,CON_0CN4E90RQYCG,2 Volume 12 PRD_0ARTTXJMS7V0 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_0ARTTXJMS7V0,CON_0CN4E90RQYCG,24 Volume 12 PRD_0ARTTXJMS7V0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_0D47ZB8JZB20,CON_0CN4E90RQYCG,1 Volume 13 PRD_0D47ZB8JZB20 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_0NGWMHRYHP3G,CON_0CN4E90RQYCG,1 Volume 4 PRD_0NGWMHRYHP3G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_0NW5NWDFDD60,CON_0CN4E90RQYCG,1 Volume 8 PRD_0NW5NWDFDD60 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_0R1F64T0XN2G,CON_0CN4E90RQYCG,1 Volume 2 PRD_0R1F64T0XN2G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_0XJ5A6M1X2J0,CON_0CN4E90RQYCG,1 Volume 19 PRD_0XJ5A6M1X2J0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_101AG4PQMW4G,CON_0CN4E90RQYCG,1 Volume 10 PRD_101AG4PQMW4G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_159MQNGW3R30,CON_0CN4E90RQYCG,1 Volume 16 PRD_159MQNGW3R30 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_1B4209Q2S17G,CON_0CN4E90RQYCG,24 Volume 7 PRD_1B4209Q2S17G Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_1BP7H7TPADBG,CON_0CN4E90RQYCG,24 Volume 3 PRD_1BP7H7TPADBG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_1E12RKTJASR0,CON_0CN4E90RQYCG,24 Volume 8 PRD_1E12RKTJASR0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_1H326D00VP3G,CON_0CN4E90RQYCG,24 Volume 4 PRD_1H326D00VP3G Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_1RMFAFFJPWGG,CON_0CN4E90RQYCG,1 Volume 12 PRD_1RMFAFFJPWGG Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_1ZQG4A7BTF7G,CON_0CN4E90RQYCG,24 Volume 6 PRD_1ZQG4A7BTF7G Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_20GCZJZQC7FG,CON_0CN4E90RQYCG,24 Volume 2 PRD_20GCZJZQC7FG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_25JZD0XTE9H0,CON_0CN4E90RQYCG,1 Volume 9 PRD_25JZD0XTE9H0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_266J1YCJ0A1G,CON_0CN4E90RQYCG,1 Volume 7 PRD_266J1YCJ0A1G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2AQDCHEMC90G,CON_0CN4E90RQYCG,1 Volume 6 PRD_2AQDCHEMC90G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2C39H7J7YWDG,CON_0CN4E90RQYCG,24 Volume 1 PRD_2C39H7J7YWDG Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_2MTQM88SH3C0,CON_0CN4E90RQYCG,2 Volume 17 PRD_2MTQM88SH3C0 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_2MTQM88SH3C0,CON_0CN4E90RQYCG,24 Volume 17 PRD_2MTQM88SH3C0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_2Q3R5QFSE8EG,CON_0CN4E90RQYCG,1 Volume 18 PRD_2Q3R5QFSE8EG Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2QBM279SKPC0,CON_0CN4E90RQYCG,1 Volume 5 PRD_2QBM279SKPC0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2T9ZGB8R8E6G,CON_0CN4E90RQYCG,1 Volume 20 PRD_2T9ZGB8R8E6G Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2TWE5NB7Q8G0,CON_0CN4E90RQYCG,24 Volume 5 PRD_2TWE5NB7Q8G0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_2VR7DTB3ZPK0,CON_0CN4E90RQYCG,1 Volume 3 PRD_2VR7DTB3ZPK0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_2YEQZD55VNJ0,CON_0CN4E90RQYCG,1 Volume 1 PRD_2YEQZD55VNJ0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_3CEQPY5QSJZ0,CON_0CN4E90RQYCG,2 Volume 13 PRD_3CEQPY5QSJZ0 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_3CEQPY5QSJZ0,CON_0CN4E90RQYCG,24 Volume 13 PRD_3CEQPY5QSJZ0 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_3JXH6166SS60,CON_0CN4E90RQYCG,2 Volume 9 PRD_3JXH6166SS60 Soichiro Yamamoto CON_0CN4E90RQYCG 2  
PRD_3JXH6166SS60,CON_0CN4E90RQYCG,24 Volume 9 PRD_3JXH6166SS60 Soichiro Yamamoto CON_0CN4E90RQYCG 24  
PRD_3K92RSF6BSP0,CON_0CN4E90RQYCG,1 Volume 15 PRD_3K92RSF6BSP0 Soichiro Yamamoto CON_0CN4E90RQYCG 1  
PRD_3XQN83K8T050,CON_0CN4E90RQYCG,1 Volume 17 PRD_3XQN83K8T050 Soichiro Yamamoto CON_0CN4E90RQYCG 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 10.193ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS