BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_2RJ87X33BQ40"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_00E9GR4DZ1XG,CON_2RJ87X33BQ40,1 Chapter 11 PRD_00E9GR4DZ1XG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_04WR2B1QV0WG,CON_2RJ87X33BQ40,1 Chapter 1 PRD_04WR2B1QV0WG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0KQWKSJK36TG,CON_2RJ87X33BQ40,1 Chapter 20 PRD_0KQWKSJK36TG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0M85DKWV8D10,CON_2RJ87X33BQ40,0 Chapter 1 PRD_0M85DKWV8D10 Emi Fukasaku CON_2RJ87X33BQ40 0  
PRD_0P4FXCCNF5SG,CON_2RJ87X33BQ40,1 Chapter 19 PRD_0P4FXCCNF5SG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0SBEVJ81Q3ZG,CON_2RJ87X33BQ40,1 Chapter 15 PRD_0SBEVJ81Q3ZG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0TTY8ZEZB4RG,CON_2RJ87X33BQ40,1 Chapter 17 PRD_0TTY8ZEZB4RG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0XSS55ABK2YG,CON_2RJ87X33BQ40,1 Chapter 13 PRD_0XSS55ABK2YG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_0ZF4ASR7GB70,CON_2RJ87X33BQ40,0 Chapter 1 PRD_0ZF4ASR7GB70 Emi Fukasaku CON_2RJ87X33BQ40 0  
PRD_11RYZS5JFK7G,CON_2RJ87X33BQ40,1 Chapter 1 PRD_11RYZS5JFK7G Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1328PS73JF7G,CON_2RJ87X33BQ40,1 Chapter 1 PRD_1328PS73JF7G Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_134A738NMT70,CON_2RJ87X33BQ40,1 Chapter 7 PRD_134A738NMT70 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_17TTJPAZGS60,CON_2RJ87X33BQ40,1 Chapter 5 PRD_17TTJPAZGS60 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1ABNW941WR50,CON_2RJ87X33BQ40,1 Chapter 3 PRD_1ABNW941WR50 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1DEMSF0E56B0,CON_2RJ87X33BQ40,1 Chapter 21 PRD_1DEMSF0E56B0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1ER4FW6BS740,CON_2RJ87X33BQ40,1 Chapter 23 PRD_1ER4FW6BS740 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1WQVNGEK8V00,CON_2RJ87X33BQ40,1 Chapter 9 PRD_1WQVNGEK8V00 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_1Z8PBC6W2HMG,CON_2RJ87X33BQ40,1 Volume 1 PRD_1Z8PBC6W2HMG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2211YFN8H1E0,CON_2RJ87X33BQ40,1 Chapter 12 PRD_2211YFN8H1E0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_24VFR86H69MG,CON_2RJ87X33BQ40,0 Chapter 1 PRD_24VFR86H69MG Emi Fukasaku CON_2RJ87X33BQ40 0  
PRD_26QG92PJX0D0,CON_2RJ87X33BQ40,1 Chapter 10 PRD_26QG92PJX0D0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_277BSQ8W1B80,CON_2RJ87X33BQ40,1 Chapter 1 PRD_277BSQ8W1B80 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2B9YBV0V28VG,CON_2RJ87X33BQ40,0 Chapter 1 PRD_2B9YBV0V28VG Emi Fukasaku CON_2RJ87X33BQ40 0  
PRD_2E2QH7AEPFT0,CON_2RJ87X33BQ40,1 Chapter 1 PRD_2E2QH7AEPFT0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2HZ743XG15A0,CON_2RJ87X33BQ40,1 Chapter 2 PRD_2HZ743XG15A0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2MA87MC3KR60,CON_2RJ87X33BQ40,1 Chapter 1 PRD_2MA87MC3KR60 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2MDQQPZTD490,CON_2RJ87X33BQ40,1 Chapter 18 PRD_2MDQQPZTD490 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2V2619SW9380,CON_2RJ87X33BQ40,1 Chapter 16 PRD_2V2619SW9380 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_2ZGHCWV6N2F0,CON_2RJ87X33BQ40,1 Chapter 14 PRD_2ZGHCWV6N2F0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_31DJRDVTJTPG,CON_2RJ87X33BQ40,1 Chapter 6 PRD_31DJRDVTJTPG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_32Z2ETSGPVQG,CON_2RJ87X33BQ40,1 Chapter 8 PRD_32Z2ETSGPVQG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_342DB0NWYSNG,CON_2RJ87X33BQ40,1 Chapter 4 PRD_342DB0NWYSNG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_38GXPKQ6TRMG,CON_2RJ87X33BQ40,1 Chapter 24 PRD_38GXPKQ6TRMG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_3APH3PPS9JP0,CON_2RJ87X33BQ40,1 Chapter 1 PRD_3APH3PPS9JP0 Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_3F1C06H977VG,CON_2RJ87X33BQ40,1 Chapter 22 PRD_3F1C06H977VG Emi Fukasaku CON_2RJ87X33BQ40 1  
PRD_3YPTJ0N9Y9Z0,CON_2RJ87X33BQ40,1 Volume 1 PRD_3YPTJ0N9Y9Z0 Emi Fukasaku CON_2RJ87X33BQ40 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.159ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS