BookWalker

home / database

product_contributors

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

17 rows where contributor_id = "CON_2EYME29Y7YP0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0HWJZEG6HYNG,CON_2EYME29Y7YP0,1 Volume 1 PRD_0HWJZEG6HYNG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_0MW0P052A1V0,CON_2EYME29Y7YP0,1 Volume 1 PRD_0MW0P052A1V0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_0PC96BKH66R0,CON_2EYME29Y7YP0,1 Volume 2 PRD_0PC96BKH66R0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_0RYCQ63X1CCG,CON_2EYME29Y7YP0,1 Perdita PRD_0RYCQ63X1CCG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_15PKX0Q2KTYG,CON_2EYME29Y7YP0,1 Volume 1 PRD_15PKX0Q2KTYG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_184GNQ04FMJG,CON_2EYME29Y7YP0,1 Volume 1 PRD_184GNQ04FMJG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_1FJ8Y8XA86BG,CON_2EYME29Y7YP0,1 A Very Unusual Governess PRD_1FJ8Y8XA86BG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_1NPM5WPFMGEG,CON_2EYME29Y7YP0,1 Volume 1 PRD_1NPM5WPFMGEG SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_1X3A96QJA10G,CON_2EYME29Y7YP0,1 Volume 2 PRD_1X3A96QJA10G SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_22QT2HZ8XEA0,CON_2EYME29Y7YP0,1 Volume 1 PRD_22QT2HZ8XEA0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_36GA8VHE81W0,CON_2EYME29Y7YP0,1 A Very Unusual Governess PRD_36GA8VHE81W0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_379B4P4XNTF0,CON_2EYME29Y7YP0,1 Volume 2 PRD_379B4P4XNTF0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_38SMK655R740,CON_2EYME29Y7YP0,1 Volume 2 PRD_38SMK655R740 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_3AT6WMJ9T5Q0,CON_2EYME29Y7YP0,1 Volume 2 PRD_3AT6WMJ9T5Q0 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_3BZ83EH71M30,CON_2EYME29Y7YP0,1 Volume 2 PRD_3BZ83EH71M30 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_3MF1A38SE390,CON_2EYME29Y7YP0,1 Reawakening Miss Calverley PRD_3MF1A38SE390 SYLVIA ANDREW CON_2EYME29Y7YP0 1  
PRD_3RXHNPA3A280,CON_2EYME29Y7YP0,1 Reawakening Miss Calverley PRD_3RXHNPA3A280 SYLVIA ANDREW CON_2EYME29Y7YP0 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.637ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS