View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,401–3,425 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3600 | 2017-03-13 | 2017-03-13 09:43:45 | 3 | Walk |
| 3601 | 2017-03-07 | 2017-03-07 10:15:22 | 3 | Metro |
| 3602 | 2017-03-07 | 2017-03-07 10:16:08 | 3 | Metro |
| 3603 | 2017-03-07 | 2017-03-07 12:53:53 | 1 | Walk |
| 3604 | 2017-03-07 | 2017-03-07 12:53:56 | 1 | Walk |
| 3605 | 2017-03-08 | 2017-03-08 09:15:59 | 1 | Walk |
| 3606 | 2017-03-08 | 2017-03-08 09:16:28 | 1 | Walk |
| 3607 | 2017-03-08 | 2017-03-08 13:48:37 | 2 | Metro |
| 3608 | 2017-03-08 | 2017-03-08 13:49:15 | 2 | Metro |
| 3609 | 2017-03-12 | 2017-03-12 10:55:32 | 1 | Metro |
| 3610 | 2017-03-10 | 2017-03-10 12:30:36 | 4 | Taxi |
| 3611 | 2017-03-10 | 2017-03-10 12:30:33 | 4 | Taxi |
| 3612 | 2017-03-25 | 2017-03-25 14:54:13 | 2 | Metro |
| 3613 | 2017-03-25 | 2017-03-25 14:53:43 | 2 | Metro |
| 3614 | 2017-03-25 | 2017-03-25 14:53:53 | 2 | Metro |
| 3615 | 2017-03-16 | 2017-03-16 14:29:48 | 5 | Walk |
| 3616 | 2017-03-16 | 2017-03-16 14:29:27 | 5 | Walk |
| 3617 | 2017-03-16 | 2017-03-16 14:30:01 | 5 | Walk |
| 3618 | 2017-03-14 | 2017-03-14 09:55:35 | 3 | Walk |
| 3619 | 2017-03-15 | 2017-03-15 11:02:30 | 1 | Walk |
| 3620 | 2017-03-15 | 2017-03-15 11:02:38 | 1 | Walk |
| 3621 | 2017-03-15 | 2017-03-15 11:02:08 | 1 | Walk |
| 3622 | 2017-03-15 | 2017-03-15 11:02:44 | 1 | Walk |
| 3623 | 2017-03-15 | 2017-03-15 11:02:31 | 1 | Walk |
| 3624 | 2017-03-25 | 2017-03-25 11:07:13 | 1 | Bus |
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;