View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,701–6,725 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7045 | 2018-11-16 | 2018-11-16 15:38:29 | 2 | Metro |
| 7046 | 2018-11-16 | 2018-11-16 15:38:52 | 2 | Metro |
| 7047 | 2018-11-15 | 2018-11-15 16:09:49 | 1 | Taxi |
| 7048 | 2018-11-18 | 2018-11-18 11:06:52 | 2 | Walk |
| 7049 | 2018-11-18 | 2018-11-18 11:06:30 | 2 | Walk |
| 7050 | 2018-11-18 | 2018-11-18 11:06:04 | 2 | Walk |
| 7051 | 2018-11-18 | 2018-11-18 11:06:42 | 2 | Walk |
| 7052 | 2018-11-13 | 2018-11-13 11:25:36 | 1 | Private Vehicle |
| 7053 | 2018-11-13 | 2018-11-13 14:16:23 | 2 | Metro |
| 7054 | 2018-11-13 | 2018-11-13 14:16:31 | 2 | Metro |
| 7055 | 2018-11-13 | 2018-11-13 14:16:03 | 2 | Metro |
| 7056 | 2018-11-13 | 2018-11-13 14:16:36 | 2 | Metro |
| 7057 | 2018-11-13 | 2018-11-13 14:16:10 | 2 | Metro |
| 7058 | 2018-11-15 | 2018-11-15 10:51:04 | 2 | Walk |
| 7059 | 2018-11-15 | 2018-11-15 10:50:47 | 2 | Walk |
| 7060 | 2018-11-15 | 2018-11-15 10:51:08 | 2 | Walk |
| 7061 | 2018-11-15 | 2018-11-15 10:50:32 | 2 | Walk |
| 7062 | 2018-12-02 | 2018-12-02 11:04:51 | 1 | Walk |
| 7063 | 2018-11-14 | 2018-11-14 15:22:05 | 1 | Walk |
| 7064 | 2018-11-15 | 2018-11-15 11:41:46 | 1 | Walk |
| 7065 | 2018-11-15 | 2018-11-15 11:41:34 | 1 | Walk |
| 7066 | 2018-11-15 | 2018-11-15 11:31:47 | 2 | Train |
| 7067 | 2018-11-18 | 2018-11-18 09:21:11 | 1 | Private Vehicle |
| 7068 | 2018-11-16 | 2018-11-16 10:57:59 | 1 | Train |
| 7069 | 2018-11-16 | 2018-11-16 10:58:11 | 1 | Train |
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;