View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,076–3,100 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3254 | 2017-03-15 | 2017-03-15 11:20:59 | 4 | Walk |
| 3255 | 2017-03-15 | 2017-03-15 11:21:06 | 4 | Walk |
| 3256 | 2017-03-15 | 2017-03-15 11:21:11 | 4 | Walk |
| 3257 | 2017-03-15 | 2017-03-15 11:21:30 | 4 | Walk |
| 3258 | 2017-03-15 | 2017-03-15 11:21:50 | 4 | Walk |
| 3259 | 2017-03-15 | 2017-03-15 11:21:38 | 4 | Walk |
| 3260 | 2017-03-15 | 2017-03-15 11:22:28 | 4 | Walk |
| 3261 | 2017-03-15 | 2017-03-15 11:22:02 | 4 | Walk |
| 3262 | 2017-03-15 | 2017-03-15 11:21:26 | 4 | Walk |
| 3263 | 2017-03-15 | 2017-03-15 11:23:10 | 4 | Walk |
| 3264 | 2017-03-15 | 2017-03-15 11:23:13 | 4 | Walk |
| 3265 | 2017-03-15 | 2017-03-15 11:22:02 | 4 | Walk |
| 3266 | 2017-03-15 | 2017-03-15 11:23:13 | 4 | Walk |
| 3267 | 2017-03-15 | 2017-03-15 11:24:20 | 4 | Walk |
| 3268 | 2017-03-15 | 2017-03-15 11:22:20 | 4 | Walk |
| 3269 | 2017-03-15 | 2017-03-15 11:22:58 | 4 | Walk |
| 3270 | 2017-03-15 | 2017-03-15 11:23:06 | 4 | Walk |
| 3271 | 2017-03-15 | 2017-03-15 11:25:02 | 4 | Walk |
| 3272 | 2017-03-15 | 2017-03-15 11:22:25 | 4 | Walk |
| 3273 | 2017-03-15 | 2017-03-15 11:24:10 | 4 | Walk |
| 3274 | 2017-03-15 | 2017-03-15 11:22:56 | 4 | Walk |
| 3275 | 2017-03-15 | 2017-03-15 11:26:20 | 4 | Walk |
| 3276 | 2017-03-15 | 2017-03-15 11:23:08 | 4 | Walk |
| 3277 | 2017-03-15 | 2017-03-15 11:25:38 | 4 | Walk |
| 3278 | 2017-03-15 | 2017-03-15 11:26:40 | 4 | Walk |
View definition
CREATE VIEW museum_visit AS
SELECT
e.ticket_id,
date(e.scanned_at) AS visit_date,
e.scanned_at AS first_entry_at,
e.entrance_id,
e.transport_mode
FROM entry_scan e
WHERE e.is_first_entry = 1;