View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,826–3,850 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4048 | 2017-06-19 | 2017-06-19 10:05:32 | 2 | Walk |
| 4049 | 2017-06-16 | 2017-06-16 11:28:30 | 2 | Metro |
| 4050 | 2017-06-16 | 2017-06-16 11:28:28 | 2 | Metro |
| 4051 | 2017-06-16 | 2017-06-16 11:49:39 | 4 | Walk |
| 4052 | 2017-06-16 | 2017-06-16 11:50:42 | 1 | Walk |
| 4053 | 2017-06-16 | 2017-06-16 11:50:48 | 1 | Walk |
| 4054 | 2017-06-18 | 2017-06-18 16:02:42 | 2 | Private Vehicle |
| 4055 | 2017-06-18 | 2017-06-18 16:03:10 | 2 | Private Vehicle |
| 4056 | 2017-06-18 | 2017-06-18 10:57:40 | 1 | Metro |
| 4057 | 2017-06-21 | 2017-06-21 10:00:05 | 1 | Metro |
| 4058 | 2017-07-05 | 2017-07-05 09:47:05 | 4 | Metro |
| 4059 | 2017-06-29 | 2017-06-29 14:45:54 | 1 | Walk |
| 4060 | 2017-06-29 | 2017-06-29 14:46:05 | 1 | Walk |
| 4061 | 2017-06-24 | 2017-06-24 11:09:47 | 1 | Bus |
| 4062 | 2017-06-30 | 2017-06-30 14:44:52 | 1 | Walk |
| 4063 | 2017-06-19 | 2017-06-19 10:33:18 | 1 | Metro |
| 4064 | 2017-06-19 | 2017-06-19 12:39:07 | 2 | Metro |
| 4065 | 2017-06-19 | 2017-06-19 12:39:42 | 2 | Metro |
| 4066 | 2017-06-21 | 2017-06-21 10:09:55 | 5 | Other |
| 4067 | 2017-06-21 | 2017-06-21 10:10:20 | 5 | Other |
| 4068 | 2017-06-21 | 2017-06-21 10:10:28 | 5 | Other |
| 4069 | 2017-06-21 | 2017-06-21 11:01:13 | 5 | Walk |
| 4070 | 2017-06-21 | 2017-06-21 12:01:56 | 5 | Metro |
| 4071 | 2017-06-21 | 2017-06-21 12:01:51 | 5 | Metro |
| 4072 | 2017-06-21 | 2017-06-21 12:02:10 | 5 | 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;