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) or a virtual platform that proposes digital offers (streaming, audios).

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.
venue_is_virtual	BOOLEAN	Indicates if the venue is virtual. Each offerer has a virtual venue, it is only used to publish digital offers.
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.
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) .