Table: Venue Model

The mrt_global__venue table provides detailed information about venues, including their location, capacity, and associated offers. A venue is managed by an offerer. It can be a physical place (library, cinema, theater) - owned by the offerer or a performance venue - or a virtual platform that hosts digital offers (streaming, audios). It can be represented by a SIRET.

NB : the amount of venues will soon decrease because tech teams are currently regularizing venues : only physical venues belonging to the offerer (which can be performance venues or “administrative” venues) will remain. Activity (offers, reservations, stick) of performance venues that do not belong to the offerer / of digital venues will be transferred to other venues belonging to the offerer.

Table description

name	data_type	description
venue_id	STRING	Unique identifier for the venue.
venue_name	STRING	Name of the venue.
venue_public_name	STRING	Name of the venue displayed on the application. Can be different of the venue_name if the partner want display a more descriptive name for example.
venue_booking_email	STRING	Email displayed on the application, can be used to book the offer or reach to the partner.
venue_street	STRING	Street address of the venue.
venue_latitude	NUMERIC	Latitude coordinate of the venue.
venue_longitude	NUMERIC	Longitude coordinate of the venue.
venue_department_code	STRING	Department code of the venue.
venue_postal_code	STRING	Postal code of the venue.
venue_city	STRING	City where the venue is located.
venue_siret	STRING	SIRET number of the venue. A venue may not have a SIRET (especially when it hosts public but does not belong to the offerer. Exemple : a theater company performs a play in a concert hall they don't own.)
venue_is_virtual	BOOLEAN	Indicates if the venue is virtual. Each offerer has a virtual venue, it is only used to publish digital offers. NB : digital venues will soon be deleted, their offers/bookings/stocks will be transferred to other venues of the offerer.
offerer_id	STRING	Unique identifier of the offerer.
venue_creation_date	DATETIME	Date when the venue was created on the application.
venue_is_permanent	BOOLEAN	Indicates if the venue is permanent. A permanent venue is a venue that can receive public permanently, that can propose offers, and that is managed by the partner. Permanent venues exemple : a library, a cinema. Non permanent venues example : a public garden that hosted a festival once, or a theater that hosted a concert once - it can be permanent for the partner who owns the theater, but not for the partner who is hosted once in this place.
venue_is_open_to_public	BOOLEAN	This field will replace the venue_is_permanent field (mid-2025), as part of the offer-adresse project. It is a venue that can receive public permanently, that can propose offers, and that is managed by the partner.
venue_is_acessibility_synched	BOOLEAN	Indicates if the venue's accessibility is synchronized.
venue_type_label	STRING	Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list during subscription. If you need to study bookings and offers per cultural sector, use the offer categories instead. "Autre" category contains many administrative venues of live performance actors and local authorities. NB : this venue_type_label segmentation is limited and currently being revised.
venue_label	STRING	Label of the venue. The label is appended by the Ministry as token of quality and standing in its category.
venue_humanized_id	STRING	Unique identifier of the venue.
venue_backoffice_link	STRING	Backoffice link for the venue.
venue_region_name	STRING	Region name where the venue is located.
venue_epci	STRING	EPCI code of the venue.
venue_density_label	STRING	Detailed density label of the venue's location.
venue_macro_density_label	STRING	Macro density label of the venue's location (urbain, rural)
venue_academy_name	STRING	Academy of the venue.
venue_targeted_audience	STRING	Targeted audience for the venue : individual, educational, both.
venue_description	STRING	Description of the venue written by the partner.
venue_withdrawal_details	STRING	Facultative description of the withdrawal in the venue.
venue_contact_phone_number	STRING	Contact phone number of the venue displayed on the application (venue page).
venue_contact_email	STRING	Contact email for the venue displayed on the application (venue page).
venue_contact_website	STRING	Contact website for the venue displayed on the application.
venue_pc_pro_link	STRING	PC Pro link for the venue.
venue_iris_internal_id	STRING	Internal IRIS identifier for the venue.
total_individual_bookings	INT64	Total number of individual bookings.
total_collective_bookings	INT64	Total number of collective bookings.
total_bookings	INT64	Total number of bookings, both individual and collective.
total_non_cancelled_individual_bookings	INT64	Total number of non-cancelled individual bookings made by the user.
total_non_cancelled_collective_bookings	INT64	Total number of collective bookings that were not cancelled.
first_individual_booking_date	DATE	Date of the first individual booking.
last_individual_booking_date	DATE	Date of the last individual booking.
first_collective_booking_date	DATE	Date of the first collective booking.
last_collective_booking_date	DATE	Date of the last collective booking.
total_non_cancelled_bookings	INT64	Total number of bookings that were not cancelled, both individual and collective.
total_used_bookings	INT64	Total number of bookings that were used.
total_used_individual_bookings	INT64	Total number of used individual bookings.
total_used_collective_bookings	INT64	Total number of collective bookings that were used.
total_individual_theoretic_revenue	NUMERIC	Total theoretical revenue from individual bookings.
total_individual_real_revenue	NUMERIC	Total actual revenue from individual bookings.
total_collective_theoretic_revenue	NUMERIC	Total theoretical revenue from collective bookings.
total_collective_real_revenue	NUMERIC	Total actual revenue from collective bookings.
total_theoretic_revenue	NUMERIC	Total theoretical revenue from all bookings.
total_real_revenue	NUMERIC	Total actual revenue from all bookings.
first_individual_offer_creation_date	DATE	Date of the first individual offer creation.
last_individual_offer_creation_date	DATE	Date of the last individual offer creation.
total_created_individual_offers	INT64	Total number of individual offers created.
first_collective_offer_creation_date	DATE	Date of the first collective offer creation.
last_collective_offer_creation_date	DATE	Date of the last collective offer creation.
total_created_collective_offers	INT64	Total number of collective offers created.
total_created_offers	INT64	Total number of offers created, both individual and collective.
first_bookable_offer_date	DATE	Date of the first bookable offer.
last_bookable_offer_date	DATE	Date of the last bookable offer.
first_individual_bookable_offer_date	DATE	Date of the first individual bookable offer.
last_individual_bookable_offer_date	DATE	Date of the last individual bookable offer.
first_collective_bookable_offer_date	DATE	Date of the first collective bookable offer.
last_collective_bookable_offer_date	DATE	Date of the last collective bookable offer.
first_booking_date	DATE	Date of the first booking.
last_booking_date	DATE	Date of the last booking.
first_offer_creation_date	DATE	Date of the first offer creation.
last_offer_creation_date	DATE	Date of the last offer creation.
total_bookable_individual_offers	INT64	Total number of individual offers that are bookable.
total_bookable_collective_offers	INT64	Total number of collective offers that are bookable.
total_bookable_offers	INT64	Total number of offers that are bookable, both individual and collective.
total_non_cancelled_tickets	INT64	Total number of tickets that were not cancelled.
total_current_year_non_cancelled_tickets	INT64	Total number of tickets that were not cancelled in the current year.
is_active_last_30days	BOOLEAN	Analytical field: Indicates if it was active in the last 30 days.
is_active_current_year	BOOLEAN	Analytical field: Indicates if it is active in the current year.
is_individual_active_last_30days	BOOLEAN	Analytical field: Indicates if it had individual activity in the last 30 days.
is_individual_active_current_year	BOOLEAN	Analytical field: Indicates if it has individual activity in the current year.
is_collective_active_last_30days	BOOLEAN	Analytical field: Indicates if it had collective activity in the last 30 days.
is_collective_active_current_year	BOOLEAN	Analytical field: Indicates if it has collective activity in the current year.
offerer_name	STRING	Name of the offerer.
offerer_validation_status	STRING	Validation status of the offerer.
offerer_is_active	BOOLEAN	Indicates if the offerer is active. Returns 'true' if offerer is active. Returns 'false' if the offerer has been deactivated.
dms_accepted_at	TIMESTAMP	Date when the offerer was accepted in DMS.
first_dms_adage_status	STRING	First DMS adage status of the offerer.
is_reference_adage	BOOLEAN	Indicates if the offerer is a reference in adage.
is_synchro_adage	BOOLEAN	Indicates if the offerer is synchronized with adage.
partner_id	STRING	Unique identifier of the partner.
offerer_address_id	STRING	The unique identifier for the mapping between an offerer and an address where he created offers.
offerer_rank_desc	INT64	Offerer rank in descending order.
offerer_rank_asc	INT64	Offerer rank in ascending order.
venue_density_level	STRING	ID of the density level of the venue (cf venue_density_label).
venue_in_qpv	BOOLEAN	Indicates whether the venue is in a City Policy Priority Neighborhood.
venue_in_zrr	BOOLEAN	Indicates whether the venue is in a ZRR.
venue_rural_city_type	STRING	Type of rural city of the venue.
venue_department_name	STRING	Department name where of the venue.
banner_url	STRING	Venue image url.
venue_image_source	STRING	Origin of venue image : google, offerer, default_category.
total_distinct_headline_offers	INT64	Number of distinct offers which were headlined on the app venue page.
has_headline_offer	BOOLEAN	Indicates if an offer is currently headlined on the app venue page.
first_headline_offer_date	DATETIME	First date of headline offer on the app venue page.
last_headline_offer_date	DATETIME	Last date of headline offer on the app venue page.
venue_adage_inscription_date	DATE	Date when the venue was synchonized on Adage (able to publish collective offers) .
offerer_is_epn	BOOLEAN	Boolean true when the offerer is flagged as a national public structure.