database

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

Custom SQL query

Tables

contributors

id, name, name_alt

9,633 rows

distributors

id, display_name, legal_name, code_name, currency_code

35 rows

export_metadata

key, value

3 rows

geoblock_territories

geoblock_id, territory, type

1,888 rows

geoblocks

id

61 rows

images

id, name, mime, width, height

84,094 rows

labels

id, publisher_id, geoblock_id, name, aliases

165 rows

prices

id, product_id, amount, start_at

86,478 rows

product_contributors

product_id, contributor_id, role, name_override

141,443 rows

product_distributors

product_id, distributor_id

86,479 rows

product_external_ids

id, product_id, source, type, external_id, external_id_original

Many rows

product_tags

product_id, tag_id

82,507 rows

products

id, content_id, series_id, parent_content_id, level, content_type, product_type, title, alt_titles, subtitle, display_title, display_title_short, description, description_short, image_id, display_order, listed_at, label_id, geoblock_id, display_name, copyright, on_presale_at, on_sale_at, off_sale_at, add_on, add_on_campaign_only

86,479 rows

publishers

id, display_name, aliases, country

140 rows

series

id, type, title, alt_titles, subtitle, display_title, display_title_short, description, description_short, image_id, listed_at

13,614 rows

series_external_ids

id, series_id, type, external_id, external_id_original

25,834 rows

series_tags

series_id, tag_id

158,111 rows

tags

id, name, slug, description, namespace, priority

736 rows