View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,726–5,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6036 | 2018-06-15 | 2018-06-15 13:23:23 | 2 | Private Vehicle |
| 6037 | 2018-06-13 | 2018-06-13 14:56:54 | 4 | Taxi |
| 6038 | 2018-06-13 | 2018-06-13 14:56:36 | 4 | Taxi |
| 6039 | 2018-06-13 | 2018-06-13 14:57:05 | 4 | Taxi |
| 6040 | 2018-06-13 | 2018-06-13 14:56:53 | 4 | Taxi |
| 6041 | 2018-06-13 | 2018-06-13 14:56:31 | 4 | Taxi |
| 6042 | 2018-06-13 | 2018-06-13 12:44:04 | 1 | Bus |
| 6043 | 2018-06-13 | 2018-06-13 15:36:18 | 1 | Walk |
| 6044 | 2018-06-13 | 2018-06-13 15:36:20 | 1 | Walk |
| 6045 | 2018-06-26 | 2018-06-26 10:39:17 | 1 | Private Vehicle |
| 6046 | 2018-06-15 | 2018-06-15 11:00:15 | 2 | Metro |
| 6047 | 2018-06-15 | 2018-06-15 11:22:55 | 1 | Walk |
| 6049 | 2018-06-15 | 2018-06-15 10:33:09 | 5 | Bus |
| 6050 | 2018-07-08 | 2018-07-08 10:44:14 | 3 | Walk |
| 6051 | 2018-07-08 | 2018-07-08 10:43:58 | 3 | Walk |
| 6054 | 2018-06-22 | 2018-06-22 14:39:31 | 1 | Walk |
| 6055 | 2018-06-22 | 2018-06-22 14:39:28 | 1 | Walk |
| 6056 | 2018-06-17 | 2018-06-17 12:27:02 | 2 | Metro |
| 6057 | 2018-06-17 | 2018-06-17 12:27:15 | 2 | Metro |
| 6058 | 2018-06-17 | 2018-06-17 12:26:44 | 2 | Metro |
| 6059 | 2018-06-17 | 2018-06-17 12:27:18 | 2 | Metro |
| 6060 | 2018-06-18 | 2018-06-18 15:58:31 | 1 | Bus |
| 6061 | 2018-06-18 | 2018-06-18 15:58:02 | 1 | Bus |
| 6062 | 2018-06-19 | 2018-06-19 10:33:52 | 1 | Metro |
| 6063 | 2018-06-19 | 2018-06-19 10:33:58 | 1 | 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;