View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,326–3,350 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3524 | 2017-02-11 | 2017-02-11 13:53:01 | 1 | Walk |
| 3525 | 2017-03-05 | 2017-03-05 09:08:46 | 1 | Metro |
| 3526 | 2017-03-05 | 2017-03-05 09:08:12 | 1 | Metro |
| 3527 | 2017-03-05 | 2017-03-05 09:08:19 | 1 | Metro |
| 3528 | 2017-03-05 | 2017-03-05 09:08:48 | 1 | Metro |
| 3529 | 2017-02-19 | 2017-02-19 09:01:55 | 1 | Train |
| 3530 | 2017-02-19 | 2017-02-19 09:01:44 | 1 | Train |
| 3531 | 2017-02-12 | 2017-02-12 11:58:54 | 1 | Metro |
| 3532 | 2017-02-15 | 2017-02-15 16:54:06 | 2 | Walk |
| 3533 | 2017-02-19 | 2017-02-19 14:21:55 | 2 | Bus |
| 3534 | 2017-02-19 | 2017-02-19 14:21:54 | 2 | Bus |
| 3536 | 2017-02-20 | 2017-02-20 11:36:34 | 5 | Walk |
| 3537 | 2017-03-10 | 2017-03-10 15:46:17 | 1 | Private Vehicle |
| 3538 | 2017-03-10 | 2017-03-10 15:46:35 | 1 | Private Vehicle |
| 3539 | 2017-02-19 | 2017-02-19 12:22:50 | 1 | Walk |
| 3540 | 2017-02-19 | 2017-02-19 12:22:28 | 1 | Walk |
| 3541 | 2017-02-19 | 2017-02-19 12:22:56 | 1 | Walk |
| 3542 | 2017-02-19 | 2017-02-19 12:22:40 | 1 | Walk |
| 3543 | 2017-02-20 | 2017-02-20 13:39:32 | 1 | Metro |
| 3544 | 2017-02-20 | 2017-02-20 13:39:25 | 1 | Metro |
| 3545 | 2017-02-20 | 2017-02-20 10:01:20 | 3 | Bus |
| 3546 | 2017-02-20 | 2017-02-20 10:01:29 | 3 | Bus |
| 3547 | 2017-02-22 | 2017-02-22 14:43:08 | 5 | Walk |
| 3548 | 2017-02-22 | 2017-02-22 14:43:01 | 5 | Walk |
| 3549 | 2017-02-22 | 2017-02-22 14:43:16 | 5 | 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;