View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,726–7,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8127 | 2019-04-26 | 2019-04-26 10:20:42 | 3 | Walk |
| 8128 | 2019-04-24 | 2019-04-24 09:40:36 | 3 | Taxi |
| 8129 | 2019-04-24 | 2019-04-24 09:40:50 | 3 | Taxi |
| 8130 | 2019-04-24 | 2019-04-24 09:40:53 | 3 | Taxi |
| 8131 | 2019-04-28 | 2019-04-28 09:33:59 | 1 | Train |
| 8132 | 2019-04-28 | 2019-04-28 09:33:33 | 1 | Train |
| 8133 | 2019-04-26 | 2019-04-26 10:23:38 | 3 | Walk |
| 8134 | 2019-05-06 | 2019-05-06 12:48:53 | 4 | Walk |
| 8135 | 2019-05-06 | 2019-05-06 12:48:57 | 4 | Walk |
| 8136 | 2019-06-06 | 2019-06-06 11:07:38 | 2 | Metro |
| 8137 | 2019-06-06 | 2019-06-06 11:07:53 | 2 | Metro |
| 8138 | 2019-06-06 | 2019-06-06 11:08:15 | 2 | Metro |
| 8139 | 2019-06-06 | 2019-06-06 11:08:06 | 2 | Metro |
| 8140 | 2019-06-06 | 2019-06-06 11:07:39 | 2 | Metro |
| 8141 | 2019-04-29 | 2019-04-29 11:51:51 | 5 | Bus |
| 8142 | 2019-04-29 | 2019-04-29 11:52:33 | 5 | Bus |
| 8143 | 2019-05-05 | 2019-05-05 13:52:53 | 1 | Walk |
| 8144 | 2019-04-29 | 2019-04-29 14:43:54 | 1 | Walk |
| 8145 | 2019-04-29 | 2019-04-29 14:43:41 | 1 | Walk |
| 8146 | 2019-05-01 | 2019-05-01 09:08:01 | 3 | Taxi |
| 8147 | 2019-04-30 | 2019-04-30 10:24:17 | 1 | Walk |
| 8148 | 2019-04-30 | 2019-04-30 10:24:12 | 1 | Walk |
| 8149 | 2019-04-30 | 2019-04-30 13:12:21 | 2 | Walk |
| 8150 | 2019-05-03 | 2019-05-03 10:00:15 | 3 | Bus |
| 8151 | 2019-05-03 | 2019-05-03 10:00:58 | 3 | Bus |
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;