View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,901–6,925 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7247 | 2018-12-18 | 2018-12-18 11:12:00 | 2 | Metro |
| 7248 | 2018-12-09 | 2018-12-09 10:31:19 | 1 | Walk |
| 7249 | 2018-12-09 | 2018-12-09 10:31:02 | 1 | Walk |
| 7250 | 2018-12-26 | 2018-12-26 14:34:19 | 1 | Metro |
| 7251 | 2018-12-26 | 2018-12-26 14:34:44 | 1 | Metro |
| 7252 | 2018-12-11 | 2018-12-11 09:42:17 | 2 | Metro |
| 7253 | 2018-12-16 | 2018-12-16 16:09:01 | 1 | Metro |
| 7254 | 2019-01-12 | 2019-01-12 10:59:18 | 1 | Bus |
| 7255 | 2019-01-12 | 2019-01-12 10:59:48 | 1 | Bus |
| 7256 | 2018-12-12 | 2018-12-12 10:28:54 | 4 | Metro |
| 7257 | 2018-12-12 | 2018-12-12 10:28:23 | 4 | Metro |
| 7258 | 2018-12-12 | 2018-12-12 12:01:25 | 1 | Metro |
| 7259 | 2018-12-12 | 2018-12-12 12:01:07 | 1 | Metro |
| 7260 | 2018-12-14 | 2018-12-14 11:00:42 | 4 | Metro |
| 7261 | 2018-12-14 | 2018-12-14 11:00:40 | 4 | Metro |
| 7262 | 2019-01-05 | 2019-01-05 16:27:32 | 1 | Walk |
| 7263 | 2019-01-05 | 2019-01-05 16:28:01 | 1 | Walk |
| 7264 | 2019-01-05 | 2019-01-05 16:28:07 | 1 | Walk |
| 7265 | 2019-01-05 | 2019-01-05 16:27:34 | 1 | Walk |
| 7266 | 2018-12-24 | 2018-12-24 10:29:22 | 3 | Walk |
| 7267 | 2018-12-24 | 2018-12-24 10:29:21 | 3 | Walk |
| 7268 | 2018-12-14 | 2018-12-14 10:52:15 | 1 | Bus |
| 7269 | 2018-12-14 | 2018-12-14 10:52:20 | 1 | Bus |
| 7270 | 2018-12-14 | 2018-12-14 11:49:43 | 2 | Metro |
| 7271 | 2018-12-14 | 2018-12-14 11:50:02 | 2 | 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;