Table: Venue

This model exports venue data for ministry use. Venues are defined by a SIRET number. Model contains information about cultural venues including: - Basic information (ID, name, description, public name) - Business information (SIRET number, virtual status) - Temporal information (creation date) - Venue type - Managing offerer association

Table description

name	data_type	description
venue_id		Unique identifier for the venue.
venue_name		Name of the venue.
venue_description		Description of the venue written by the partner.
venue_public_name		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_siret		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		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		Unique identifier of the offerer.
offerer_validation_status		Validation status of the offerer.
offerer_is_active		Indicates if the offerer is active. Returns 'true' if offerer is active. Returns 'false' if the offerer has been deactivated.
venue_creation_date		Date when the venue was created on the application.
venue_type_label		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.