Table: Venue Removed

This model exports venues removed data for ministry use. It contains only removed venues not longer available for booking in pass Culture apps. Non-permanent venues have been switched to permanent ones in August 2025. At the time they were deleted, these venues did not have any active or bookable offer.

Table description

name	data_type	description
venue_id	STRING	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_open_to_public		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.
offerer_id		Unique identifier of the offerer.
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.
venue_department_code		Department code of the venue.
venue_city		City where the venue is located.
venue_postal_code		Postal code of the venue.
venue_latitude		Latitude coordinate of the venue.
venue_longitude		Longitude coordinate of the venue.