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_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. | |
| 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. |