View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,101–3,125 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3279 | 2017-03-15 | 2017-03-15 11:23:26 | 4 | Walk |
| 3280 | 2017-03-15 | 2017-03-15 11:24:53 | 4 | Walk |
| 3281 | 2017-03-15 | 2017-03-15 11:24:06 | 4 | Walk |
| 3282 | 2017-03-15 | 2017-03-15 11:24:42 | 4 | Walk |
| 3283 | 2017-03-15 | 2017-03-15 11:26:50 | 4 | Walk |
| 3284 | 2017-03-15 | 2017-03-15 11:22:54 | 4 | Walk |
| 3285 | 2017-03-15 | 2017-03-15 11:24:02 | 4 | Walk |
| 3286 | 2017-03-15 | 2017-03-15 11:26:53 | 4 | Walk |
| 3287 | 2017-03-15 | 2017-03-15 11:26:30 | 4 | Walk |
| 3288 | 2017-03-15 | 2017-03-15 11:26:05 | 4 | Walk |
| 3289 | 2017-03-15 | 2017-03-15 11:29:14 | 4 | Walk |
| 3290 | 2017-03-15 | 2017-03-15 11:25:09 | 4 | Walk |
| 3291 | 2017-03-15 | 2017-03-15 11:25:54 | 4 | Walk |
| 3292 | 2017-03-15 | 2017-03-15 11:26:41 | 4 | Walk |
| 3293 | 2017-03-15 | 2017-03-15 11:27:30 | 4 | Walk |
| 3294 | 2017-03-15 | 2017-03-15 11:31:05 | 4 | Walk |
| 3295 | 2017-03-15 | 2017-03-15 11:23:38 | 4 | Walk |
| 3296 | 2017-03-15 | 2017-03-15 11:24:25 | 4 | Walk |
| 3297 | 2017-03-15 | 2017-03-15 11:29:38 | 4 | Walk |
| 3298 | 2017-03-15 | 2017-03-15 11:26:50 | 4 | Walk |
| 3299 | 2017-03-15 | 2017-03-15 11:26:12 | 4 | Walk |
| 3300 | 2017-03-15 | 2017-03-15 11:25:32 | 4 | Walk |
| 3301 | 2017-03-15 | 2017-03-15 11:32:50 | 4 | Walk |
| 3302 | 2016-12-28 | 2016-12-28 11:03:23 | 3 | Walk |
| 3303 | 2016-12-25 | 2016-12-25 12:27:50 | 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;