View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,376–3,400 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3575 | 2017-03-01 | 2017-03-01 10:40:03 | 1 | Walk |
| 3576 | 2017-03-15 | 2017-03-15 14:42:39 | 3 | Bus |
| 3577 | 2017-03-15 | 2017-03-15 14:42:43 | 3 | Bus |
| 3578 | 2017-03-15 | 2017-03-15 14:42:40 | 3 | Bus |
| 3579 | 2017-03-15 | 2017-03-15 14:42:38 | 3 | Bus |
| 3580 | 2017-03-15 | 2017-03-15 14:42:38 | 3 | Bus |
| 3581 | 2017-03-08 | 2017-03-08 09:57:33 | 1 | Walk |
| 3582 | 2017-03-08 | 2017-03-08 09:56:52 | 1 | Walk |
| 3583 | 2017-03-03 | 2017-03-03 10:32:12 | 1 | Metro |
| 3584 | 2017-03-03 | 2017-03-03 10:31:49 | 1 | Metro |
| 3585 | 2017-03-03 | 2017-03-03 10:32:17 | 1 | Metro |
| 3586 | 2017-03-03 | 2017-03-03 10:32:03 | 1 | Metro |
| 3587 | 2017-03-05 | 2017-03-05 10:52:35 | 1 | Metro |
| 3588 | 2017-03-05 | 2017-03-05 10:52:03 | 1 | Metro |
| 3589 | 2017-03-05 | 2017-03-05 10:52:26 | 1 | Metro |
| 3590 | 2017-03-06 | 2017-03-06 09:40:29 | 1 | Other |
| 3591 | 2017-03-04 | 2017-03-04 10:15:19 | 1 | Walk |
| 3592 | 2017-03-05 | 2017-03-05 10:50:16 | 1 | Taxi |
| 3593 | 2017-03-05 | 2017-03-05 10:50:48 | 1 | Taxi |
| 3594 | 2017-03-20 | 2017-03-20 15:59:48 | 1 | Walk |
| 3595 | 2017-03-06 | 2017-03-06 11:08:59 | 1 | Metro |
| 3596 | 2017-03-06 | 2017-03-06 11:08:49 | 1 | Metro |
| 3597 | 2017-03-06 | 2017-03-06 11:08:28 | 1 | Metro |
| 3598 | 2017-03-06 | 2017-03-06 11:08:29 | 1 | Metro |
| 3599 | 2017-03-13 | 2017-03-13 09:43:24 | 3 | 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;