File name: releases_simplified.csv.zstd .
The releases simplified export contains a denormalized view of all releases with joined lookup values for easier querying.
<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" />
We recommend that this report is used to answer most questions about releases. However, some information can not be denormalized into this snapshot; such as non-standard shops, genres, Thema codes, and some other information. In those cases you should instead reference the relevant related tables to look up this information.
</aside>
| Field | Data type | Description |
|---|---|---|
release_id |
integer | The release's ID. |
isbn |
string | The ISBN of the release. Can be empty. |
gtin13 |
string | The GTIN-13 identifier of the release. |
title |
string | The title of the release. |
display_artist |
string | The display name of the artist(s)/author(s). |
series_id |
integer | The ID of the series this release belongs to. Can be empty. |
series_name |
string | The name of the series (denormalized). Can be empty. |
licensor_id |
integer | The ID of the licensor. |
licensor |
string | The name of the licensor (denormalized). |
label_id |
integer | The ID of the label/imprint. |
label |
string | The name of the label (denormalized). |
added |
string (ISO 8601 datetime) | The date the release was added to the database. |
last_mod |
string (ISO 8601 datetime) | The date the release was last modified. |
media_available_from |
string (ISO 8601 datetime) | The date from which the media is available. Can be empty. |
release_date |
string (ISO 8601 date) | The release date. |
release_type |
string, one of audio-book, ebook, podcast |
The type of release. |
lang |
string (ISO 639-2 language code) | The language of the release. |
original_lang |
string (ISO 639-2 language code) | The original language of the release. Can be empty. |
original_title |
string | The original title of the release (if translated). Can be empty. |
copyright |
string | Copyright information. |
shop_subscription |
boolean | True if available in subscription shop. |
shop_purchased |
boolean | True if available for purchase. |
shop_free |
boolean | True if available for free. |
shop_discoverable |
boolean | True if discoverable in shop listings. |
track_count |
integer | The number of tracks in the release. |
duration |
string (time interval) | Total duration of the release (HH:MM:SS format). |
taken_down |
boolean | True if the release has been taken down. |