survey_day_ratings
Ratings for each park day covered by a survey. One row is one park day on one survey.
- One row is
- one park day on one survey
- Columns
- 10
- Rows in Sample
- 6,943
- Rows in Standard
- 68,928
- Rows in Full
- 694,133
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| survey_idkey | integer | Links to survey_responses. | |
| visit_datekey | date | The day rated. | |
| park_code | text | CE Costa Encandela, PT Punta Tormenta, PY Playa Zambulla. Links to parks. | CE; PT; PY |
| day_rating | integer | Rating of the day, 0 to 10. | 0 to 10 |
| wait_times_rating | integer | 1 to 5. | 1 to 5 |
| rides_rating | integer | 1 to 5. | 1 to 5 |
| food_rating | integer | 1 to 5. Can be empty. | 1 to 5 |
| staff_rating | integer | 1 to 5. | 1 to 5 |
| cleanliness_rating | integer | 1 to 5. | 1 to 5 |
| value_rating | integer | 1 to 5. | 1 to 5 |
How it connects
This table points to
- survey_id matches survey_responses.survey_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| survey_id | visit_date | park_code | day_rating | wait_times_rating | rides_rating | food_rating | staff_rating | cleanliness_rating | value_rating |
|---|---|---|---|---|---|---|---|---|---|
| 40000217 | 2018-01-02 | CE | 9 | 4 | 4 | 4 | 4 | 4 | 5 |
| 40000217 | 2018-01-04 | CE | 7 | 4 | 4 | 3 | 4 | 3 | |
| 40000217 | 2018-01-06 | PT | 6 | 4 | 3 | 4 | 4 | 5 | 3 |
| 40000537 | 2018-01-05 | PT | 7 | 5 | 4 | 4 | 5 | 5 | 4 |
| 40000549 | 2018-01-05 | PT | 10 | 3 | 5 | 4 | 5 | 5 | 4 |