View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,776–3,800 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3998 | 2017-06-15 | 2017-06-15 12:27:23 | 2 | Bus |
| 3999 | 2017-06-06 | 2017-06-06 09:08:39 | 1 | Metro |
| 4000 | 2017-06-06 | 2017-06-06 10:15:38 | 1 | Metro |
| 4001 | 2017-06-06 | 2017-06-06 10:16:03 | 1 | Metro |
| 4002 | 2017-06-06 | 2017-06-06 10:58:14 | 1 | Walk |
| 4003 | 2017-06-06 | 2017-06-06 12:01:21 | 1 | Walk |
| 4004 | 2017-08-06 | 2017-08-06 09:25:37 | 2 | Metro |
| 4005 | 2017-06-07 | 2017-06-07 09:26:36 | 3 | Metro |
| 4006 | 2017-06-07 | 2017-06-07 09:26:46 | 3 | Metro |
| 4007 | 2017-06-11 | 2017-06-11 14:51:30 | 3 | Walk |
| 4008 | 2017-06-11 | 2017-06-11 14:51:31 | 3 | Walk |
| 4009 | 2017-06-08 | 2017-06-08 11:57:26 | 1 | Other |
| 4010 | 2017-06-08 | 2017-06-08 11:57:20 | 1 | Other |
| 4011 | 2017-06-08 | 2017-06-08 13:00:27 | 2 | Walk |
| 4012 | 2017-06-08 | 2017-06-08 12:59:51 | 2 | Walk |
| 4013 | 2017-06-08 | 2017-06-08 12:59:47 | 2 | Walk |
| 4014 | 2017-06-08 | 2017-06-08 13:00:07 | 2 | Walk |
| 4015 | 2017-06-08 | 2017-06-08 13:00:05 | 2 | Walk |
| 4016 | 2017-06-09 | 2017-06-09 12:45:34 | 2 | Bus |
| 4017 | 2017-06-11 | 2017-06-11 14:14:59 | 4 | Taxi |
| 4018 | 2017-06-10 | 2017-06-10 10:08:10 | 1 | Walk |
| 4019 | 2017-06-10 | 2017-06-10 10:07:50 | 1 | Walk |
| 4020 | 2017-06-10 | 2017-06-10 10:08:12 | 1 | Walk |
| 4021 | 2017-06-10 | 2017-06-10 10:08:10 | 1 | Walk |
| 4022 | 2017-06-10 | 2017-06-10 10:08:14 | 1 | 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;