venues
Restaurants, bars, snack stands and shops. One row is one venue.
- One row is
- one venue
- Columns
- 8
- Rows in Sample
- 72
- Rows in Standard
- 72
- Rows in Full
- 72
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| venue_idkey | integer | Unique id for the row. | |
| venue_name | text | Name. | |
| venue_type | text | Kind of venue. | bar; cafe; quick service restaurant; shop; snack stand; table service restaurant |
| location_type | text | In a park, in a hotel, or at Paseo Velaluz. | Paseo Velaluz; resort hotel; theme or water park |
| park_code | text | The park, for venues inside one. Can be empty. | CE; PT; PY |
| land_id | integer | The land, for venues inside a park. Can be empty. | |
| hotel_id | integer | The hotel, for venues inside one. Can be empty. | |
| opened_date | date | Date it first opened. Empty in venues means it was open before 2018. Can be empty. | 2021-05-21 to 2021-05-21 |
How it connects
This table points to
- land_id matches lands.land_id
- hotel_id matches hotels.hotel_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| venue_id | venue_name | venue_type | location_type | park_code | land_id | hotel_id | opened_date |
|---|---|---|---|---|---|---|---|
| 101 | Lighthouse Mercantile | shop | theme or water park | CE | 1 | ||
| 102 | Faro Bakery & Coffee | cafe | theme or water park | CE | 1 | ||
| 103 | Lantern Cart | snack stand | theme or water park | CE | 1 | ||
| 104 | Abuela's Cocina | table service restaurant | theme or water park | CE | 2 | ||
| 105 | Cuentos Toy Workshop | shop | theme or water park | CE | 2 |