View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,501–3,525 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3707 | 2017-03-31 | 2017-03-31 13:16:14 | 1 | Metro |
| 3708 | 2017-04-04 | 2017-04-04 13:44:18 | 3 | Bus |
| 3709 | 2017-04-04 | 2017-04-04 13:44:05 | 3 | Bus |
| 3710 | 2017-04-04 | 2017-04-04 13:44:47 | 3 | Bus |
| 3711 | 2017-03-31 | 2017-03-31 16:09:34 | 2 | Metro |
| 3712 | 2017-04-01 | 2017-04-01 13:06:57 | 2 | Walk |
| 3713 | 2017-04-01 | 2017-04-01 13:06:55 | 2 | Walk |
| 3714 | 2017-04-23 | 2017-04-23 13:42:17 | 1 | Walk |
| 3715 | 2017-04-23 | 2017-04-23 13:42:11 | 1 | Walk |
| 3716 | 2017-04-23 | 2017-04-23 13:42:36 | 1 | Walk |
| 3717 | 2017-04-23 | 2017-04-23 13:42:08 | 1 | Walk |
| 3720 | 2017-04-16 | 2017-04-16 11:58:30 | 1 | Bus |
| 3721 | 2017-04-29 | 2017-04-29 12:24:33 | 2 | Other |
| 3722 | 2017-04-29 | 2017-04-29 12:24:15 | 2 | Other |
| 3723 | 2017-04-13 | 2017-04-13 12:58:42 | 1 | Walk |
| 3724 | 2017-04-13 | 2017-04-13 12:58:44 | 1 | Walk |
| 3725 | 2017-04-06 | 2017-04-06 13:06:39 | 1 | Metro |
| 3726 | 2017-04-06 | 2017-04-06 13:07:04 | 1 | Metro |
| 3727 | 2017-04-26 | 2017-04-26 09:33:44 | 4 | Bus |
| 3728 | 2017-04-07 | 2017-04-07 14:54:38 | 2 | Metro |
| 3729 | 2017-04-07 | 2017-04-07 14:54:42 | 2 | Metro |
| 3730 | 2017-04-09 | 2017-04-09 11:32:57 | 4 | Bus |
| 3731 | 2017-04-08 | 2017-04-08 10:23:38 | 2 | Metro |
| 3732 | 2017-04-08 | 2017-04-08 10:23:45 | 2 | Metro |
| 3733 | 2017-04-12 | 2017-04-12 11:25:48 | 3 | Private Vehicle |
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;