View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,001–4,025 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4235 | 2017-09-20 | 2017-09-20 12:39:58 | 1 | Other |
| 4236 | 2017-09-20 | 2017-09-20 12:42:09 | 1 | Other |
| 4237 | 2017-09-20 | 2017-09-20 12:39:39 | 1 | Other |
| 4238 | 2017-09-20 | 2017-09-20 12:41:13 | 1 | Other |
| 4239 | 2017-07-14 | 2017-07-14 10:53:09 | 3 | Metro |
| 4240 | 2017-07-14 | 2017-07-14 10:53:27 | 3 | Metro |
| 4241 | 2017-07-14 | 2017-07-14 11:00:39 | 1 | Metro |
| 4242 | 2017-07-14 | 2017-07-14 11:00:54 | 1 | Metro |
| 4243 | 2017-07-11 | 2017-07-11 11:54:11 | 1 | Walk |
| 4244 | 2017-07-11 | 2017-07-11 11:54:45 | 1 | Walk |
| 4245 | 2017-07-19 | 2017-07-19 11:24:12 | 1 | Walk |
| 4246 | 2017-07-19 | 2017-07-19 11:24:36 | 1 | Walk |
| 4247 | 2017-07-19 | 2017-07-19 11:24:19 | 1 | Walk |
| 4248 | 2017-07-13 | 2017-07-13 12:00:21 | 1 | Walk |
| 4249 | 2017-07-16 | 2017-07-16 11:08:18 | 1 | Walk |
| 4250 | 2017-07-14 | 2017-07-14 12:06:34 | 4 | Walk |
| 4251 | 2017-07-14 | 2017-07-14 12:06:14 | 4 | Walk |
| 4252 | 2017-07-15 | 2017-07-15 10:01:58 | 1 | Walk |
| 4253 | 2017-07-15 | 2017-07-15 10:01:54 | 1 | Walk |
| 4254 | 2017-07-15 | 2017-07-15 13:30:47 | 1 | Metro |
| 4255 | 2017-07-16 | 2017-07-16 10:50:37 | 4 | Walk |
| 4256 | 2017-07-16 | 2017-07-16 10:50:23 | 4 | Walk |
| 4257 | 2017-07-16 | 2017-07-16 10:50:22 | 4 | Walk |
| 4258 | 2017-07-16 | 2017-07-16 10:50:15 | 4 | Walk |
| 4259 | 2017-07-16 | 2017-07-16 12:00:23 | 4 | 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;