BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_18PG6JDT1FPG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_0570TKS1B69G,CON_18PG6JDT1FPG,7 Chapter 60 PRD_0570TKS1B69G Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_06PGF0ZZF7AG,CON_18PG6JDT1FPG,7 Chapter 68 PRD_06PGF0ZZF7AG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_09NK46VBQ58G,CON_18PG6JDT1FPG,7 Chapter 65 PRD_09NK46VBQ58G Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_0CA3QSNDK4FG,CON_18PG6JDT1FPG,7 Chapter 64 PRD_0CA3QSNDK4FG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_0G5Z23X6JP80,CON_18PG6JDT1FPG,7 Chapter 59 PRD_0G5Z23X6JP80 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_0KFCM1YQ89RG,CON_18PG6JDT1FPG,0 Chapter 8 PRD_0KFCM1YQ89RG Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_0KRPTEK0MTJG,CON_18PG6JDT1FPG,7 Chapter 44 PRD_0KRPTEK0MTJG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_0P9151DAGSHG,CON_18PG6JDT1FPG,7 Chapter 42 PRD_0P9151DAGSHG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_0QXZ7MRSM8ZG,CON_18PG6JDT1FPG,0 Chapter 7 PRD_0QXZ7MRSM8ZG Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_0TJFH7T3GQYG,CON_18PG6JDT1FPG,0 Chapter 3 PRD_0TJFH7T3GQYG Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_0TZHGMFCWRGG,CON_18PG6JDT1FPG,7 Chapter 46 PRD_0TZHGMFCWRGG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_14B510MK0AVG,CON_18PG6JDT1FPG,7 Chapter 53 PRD_14B510MK0AVG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_192ZQH6SAVW0,CON_18PG6JDT1FPG,7 Chapter 48 PRD_192ZQH6SAVW0 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_1D643QFJA990,CON_18PG6JDT1FPG,0 Chapter 4 PRD_1D643QFJA990 Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_1DKE1403PT30,CON_18PG6JDT1FPG,7 Chapter 50 PRD_1DKE1403PT30 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_1EHNG4J8EAA0,CON_18PG6JDT1FPG,0 Chapter 1 PRD_1EHNG4J8EAA0 Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_2099PPCT0RV0,CON_18PG6JDT1FPG,7 Chapter 62 PRD_2099PPCT0RV0 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_24ZR09EWD7T0,CON_18PG6JDT1FPG,7 Chapter 67 PRD_24ZR09EWD7T0 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2BC8KW8696S0,CON_18PG6JDT1FPG,7 Chapter 66 PRD_2BC8KW8696S0 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2E2VXFA8N5R0,CON_18PG6JDT1FPG,7 Chapter 61 PRD_2E2VXFA8N5R0 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2G1SCQ25JS20,CON_18PG6JDT1FPG,7 Chapter 45 PRD_2G1SCQ25JS20 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2HMQDA9MP880,CON_18PG6JDT1FPG,0 Chapter 9 PRD_2HMQDA9MP880 Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_2KWQ9SJ1MQRG,CON_18PG6JDT1FPG,7 Chapter 54 PRD_2KWQ9SJ1MQRG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2M57RXBYJQF0,CON_18PG6JDT1FPG,0 Chapter 2 PRD_2M57RXBYJQF0 Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_2MP9YBWFYR10,CON_18PG6JDT1FPG,7 Chapter 49 PRD_2MP9YBWFYR10 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2N3P6ZEDWNYG,CON_18PG6JDT1FPG,7 Chapter 57 PRD_2N3P6ZEDWNYG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2PD7VCCBGPZG,CON_18PG6JDT1FPG,7 Chapter 51 PRD_2PD7VCCBGPZG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2SG6HJBQRMXG,CON_18PG6JDT1FPG,7 Chapter 52 PRD_2SG6HJBQRMXG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_2W6H355T4KWG,CON_18PG6JDT1FPG,7 Chapter 55 PRD_2W6H355T4KWG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_363X8PAE2A40,CON_18PG6JDT1FPG,7 Chapter 56 PRD_363X8PAE2A40 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_388DZT3B0BTG,CON_18PG6JDT1FPG,0 Chapter 6 PRD_388DZT3B0BTG Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_38NQX8QMCVCG,CON_18PG6JDT1FPG,7 Chapter 43 PRD_38NQX8QMCVCG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_3CYW9EXDCASG,CON_18PG6JDT1FPG,0 Chapter 5 PRD_3CYW9EXDCASG Christopher Burgener CON_18PG6JDT1FPG 0  
PRD_3DQCQF3WPQ90,CON_18PG6JDT1FPG,7 Chapter 58 PRD_3DQCQF3WPQ90 Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_3FA68VHY8VKG,CON_18PG6JDT1FPG,7 Chapter 47 PRD_3FA68VHY8VKG Christopher Burgener CON_18PG6JDT1FPG 7  
PRD_3JKA827JH4Z0,CON_18PG6JDT1FPG,7 Chapter 63 PRD_3JKA827JH4Z0 Christopher Burgener CON_18PG6JDT1FPG 7  

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.059ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS