offer_id: Unique identifier for the offer.

offer_product_id: Identifier for the product associated with the offer.

offer_product_humanized_id: Human-readable identifier for the product associated with the offer.

offer_id_at_providers: Identifier for the offer at external providers.

offer_is_synchronised: Indicates whether the offer is synchronized with API systems and has a product_id.

offer_description: Offer description (synopsis, further details on the show) as provided by thecultural partner and displayed in app.

offer_name: Name of the offer as it appears in the application.

offer_category_id: Identifier for the category of the offer.

offer_category: Identifier for the category of the offer.

offer_creation_date: Date when the offer was created.

offer_created_at: Timestamp when the offer was created.

offer_updated_at: Timestamp when the offer was last updated.

offer_is_duo: Indicates if the offer can be booked as a duo.

offer_is_underage_selectable: Indicates if the offer is selectable for underage users.

Metadata related

offer_type: Deprecated.

offer_is_bookable: Indicates if the offer is bookable.

offer_is_digital_goods: Indicates if the offer includes digital goods.

offer_is_physical_goods: Indicates if the offer includes physical goods.

offer_is_event: Indicates if the offer is an event.

offer_humanized_id: Human-readable identifier for the offer used in various platforms.

passculture_pro_url: URL to the offer on PassCulture Pro.

webapp_url: URL to the offer on the web application.

offer_subcategory_id: Identifier for the subcategory of the offer.

offer_url: URL to the offer.

offer_is_national: Indicates if the offer is available nationally.

offer_is_numerical: Indicates if the offer is digital (based on an url).

offer_is_geolocated: Indicates if the offer is geolocated.

offer_is_active: Indicates if the offer is active.

offer_validation: Validation status of the offer.

author: The offer's author (a book's author, a music's singer, a movie's director).

performer: Performers involved in this offer.

stage_director: Stage director, if applicable.

theater_movie_id: Allociné identifier for the movie, if applicable.

theater_room_id: Allociné identifier for the theater room, if applicable.

speaker: Speaker or professor, if applicable.

movie_type: Type of movie, if applicable (e.g., feature film, short film).

movie_visa: Film visa number, if applicable.

movie_release_date: Release date, if applicable.

movie_genres: Genres of the film, if applicable.

companies: Companies involved in the production or distribution of the film, if applicable.

movie_countries: Countries where the film was produced, if applicable.

casting: Actors in the film, if applicable.

isbn: ISBN of the book, if applicable.

offer_ean: EAN of the offer, if applicable.

rayon: Literary genre, if applicable.

offer_macro_rayon: Semantic clustering of column__rayon.

book_editor: Editor of the book, if applicable.

type: Type of the offer.

sub_type: Sub-type of the offer.

mediation_humanized_id: Human-readable identifier for mediation.

offer_publication_date: Publication date of the offer.

is_future_scheduled: Indicates if the offer is scheduled for the future.

item_id: Identifier for the item associated with the offer used internally by the data science team.

search_group_name: Legacy: Category displayed in the application

image_url: Image displayed in the passculture.app if present.

titelive_gtl_id: Unique identifier of the Genre Tite Live (GTL) associated to this offer.

gtl_type: Type of GTL associated to this offer. Can either be "BOOK" or "MUSIC"

gtl_label_level_1: Name of the level 1 GTL associated to this offer (for example, "Littératurefor a book or "Pop" for music.)

gtl_label_level_2: Name of the level 2 GTL associated to this offer (for example, "Poésie" for a book or "Brit Pop" for music.)

gtl_label_level_3: Name of the level 3 GTL associated to this offer (for example, "Haiku" for a book). Only available for books.

gtl_label_level_4: Name of the level 4 GTL associated to this offer. Only available for books.

offer_type_domain: Deprecated: The offer's category type,as many metadata info are specific to certain offer types. Can be either "BOOK", "MUSIC", "SHOW" or "MOVIE".

offer_type_id: Deprecated: Unique identifier of the offer's type. Currently available to describe either music genres (pop, rock) or show type (opera, circus).

offer_sub_type_id: Deprecated: Legacy identifier. Prefer using GTL.

offer_type_label: Deprecated: Defines the offer genre for music, books and movies. Defines the offer show type for shows.

offer_sub_type_label: Deprecated: Defines the offer sub genre for music, books and movies. Defines the offer show sub type for shows.

offer_type_labels: Deprecated: Legacy identifier. Prefer using GTL.

is_headlined: Indicates if the offer is currently headlined on the app venue page.

total_headlines: Number of different times the offer was headlined on the app venue page. (an offer headline can be desactivated and reactivated)

offer_last_provider_id: Id of the offer's last provider.

is_local_authority: Indicates if the offerer is a local authority or not.

Date related

first_individual_offer_creation_date: Date of the first individual offer creation.

last_individual_offer_creation_date: Date of the last individual offer creation.

first_bookable_offer_date: Date of the first bookable offer.

last_bookable_offer_date: Date of the last bookable offer.

first_individual_bookable_offer_date: Date of the first individual bookable offer.

last_individual_bookable_offer_date: Date of the last individual bookable offer.

first_offer_creation_date: Date of the first offer creation.

last_offer_creation_date: Date of the last offer creation.

first_headline_date: First date of headline on the app venue page.

last_headline_date: Last date of headline on the app venue page.