View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,676–6,700 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7018 | 2018-11-11 | 2018-11-11 12:58:12 | 2 | Walk |
| 7019 | 2018-11-05 | 2018-11-05 12:53:29 | 1 | Metro |
| 7020 | 2018-11-05 | 2018-11-05 12:53:53 | 1 | Metro |
| 7021 | 2018-11-05 | 2018-11-05 12:54:03 | 1 | Metro |
| 7022 | 2018-11-05 | 2018-11-05 14:26:08 | 1 | Train |
| 7023 | 2018-11-05 | 2018-11-05 14:26:04 | 1 | Train |
| 7024 | 2018-11-06 | 2018-11-06 13:11:29 | 1 | Other |
| 7025 | 2018-11-06 | 2018-11-06 13:11:27 | 1 | Other |
| 7026 | 2018-11-06 | 2018-11-06 13:11:34 | 1 | Other |
| 7027 | 2018-11-09 | 2018-11-09 10:25:33 | 3 | Other |
| 7028 | 2018-11-09 | 2018-11-09 10:25:29 | 3 | Other |
| 7029 | 2018-11-09 | 2018-11-09 10:24:48 | 3 | Other |
| 7030 | 2018-11-11 | 2018-11-11 12:55:39 | 2 | Metro |
| 7031 | 2018-11-11 | 2018-11-11 12:55:56 | 2 | Metro |
| 7032 | 2018-11-11 | 2018-11-11 12:55:45 | 2 | Metro |
| 7033 | 2018-11-11 | 2018-11-11 12:55:41 | 2 | Metro |
| 7034 | 2018-11-10 | 2018-11-10 15:53:12 | 1 | Taxi |
| 7035 | 2018-11-10 | 2018-11-10 15:53:18 | 1 | Taxi |
| 7036 | 2018-11-10 | 2018-11-10 11:35:13 | 1 | Metro |
| 7037 | 2018-11-10 | 2018-11-10 10:27:16 | 3 | Metro |
| 7038 | 2018-11-11 | 2018-11-11 09:18:16 | 1 | Walk |
| 7039 | 2018-11-11 | 2018-11-11 09:18:19 | 1 | Walk |
| 7042 | 2018-11-11 | 2018-11-11 12:18:28 | 1 | Taxi |
| 7043 | 2018-11-16 | 2018-11-16 15:39:03 | 2 | Metro |
| 7044 | 2018-11-16 | 2018-11-16 15:38:20 | 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;