View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,176–3,200 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3358 | 2017-03-14 | 2017-03-14 11:04:59 | 4 | Walk |
| 3359 | 2017-03-14 | 2017-03-14 11:06:59 | 4 | Walk |
| 3360 | 2017-03-14 | 2017-03-14 11:07:14 | 4 | Walk |
| 3361 | 2017-03-14 | 2017-03-14 11:05:23 | 4 | Walk |
| 3362 | 2017-03-14 | 2017-03-14 11:04:34 | 4 | Walk |
| 3365 | 2017-03-14 | 2017-03-14 11:07:59 | 4 | Walk |
| 3366 | 2017-03-14 | 2017-03-14 11:04:44 | 4 | Walk |
| 3367 | 2017-03-14 | 2017-03-14 11:06:39 | 4 | Walk |
| 3368 | 2017-03-14 | 2017-03-14 11:08:44 | 4 | Walk |
| 3369 | 2017-03-14 | 2017-03-14 11:06:11 | 4 | Walk |
| 3370 | 2017-03-14 | 2017-03-14 11:05:29 | 4 | Walk |
| 3372 | 2017-03-14 | 2017-03-14 11:07:45 | 4 | Walk |
| 3373 | 2017-03-14 | 2017-03-14 11:08:23 | 4 | Walk |
| 3374 | 2017-03-14 | 2017-03-14 11:09:59 | 4 | Walk |
| 3375 | 2017-03-14 | 2017-03-14 11:07:20 | 4 | Walk |
| 3376 | 2017-03-14 | 2017-03-14 11:09:29 | 4 | Walk |
| 3377 | 2017-03-14 | 2017-03-14 11:10:44 | 4 | Walk |
| 3378 | 2017-03-14 | 2017-03-14 11:09:55 | 4 | Walk |
| 3379 | 2017-03-14 | 2017-03-14 11:09:02 | 4 | Walk |
| 3380 | 2017-03-14 | 2017-03-14 11:09:13 | 4 | Walk |
| 3381 | 2017-03-14 | 2017-03-14 11:10:34 | 4 | Walk |
| 3383 | 2017-01-06 | 2017-01-06 10:25:40 | 2 | Metro |
| 3384 | 2017-01-06 | 2017-01-06 10:25:38 | 2 | Metro |
| 3385 | 2017-01-07 | 2017-01-07 11:55:46 | 2 | Metro |
| 3386 | 2017-01-07 | 2017-01-07 11:55:56 | 2 | Metro |
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;