View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,901–2,925 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3059 | 2016-11-25 | 2016-11-25 14:44:58 | 1 | Bus |
| 3060 | 2016-11-25 | 2016-11-25 14:44:51 | 1 | Bus |
| 3061 | 2016-11-27 | 2016-11-27 11:42:17 | 1 | Metro |
| 3062 | 2016-11-27 | 2016-11-27 11:42:07 | 1 | Metro |
| 3063 | 2016-11-27 | 2016-11-27 09:31:30 | 1 | Taxi |
| 3064 | 2016-11-27 | 2016-11-27 09:31:07 | 1 | Taxi |
| 3065 | 2016-11-27 | 2016-11-27 09:31:07 | 1 | Taxi |
| 3066 | 2016-11-27 | 2016-11-27 09:31:15 | 1 | Taxi |
| 3067 | 2016-12-02 | 2016-12-02 13:32:38 | 2 | Private Vehicle |
| 3068 | 2016-11-29 | 2016-11-29 10:21:28 | 1 | Bus |
| 3069 | 2016-12-08 | 2016-12-08 11:06:15 | 3 | Walk |
| 3070 | 2016-12-08 | 2016-12-08 11:06:27 | 3 | Walk |
| 3071 | 2016-12-08 | 2016-12-08 11:05:48 | 3 | Walk |
| 3072 | 2016-12-08 | 2016-12-08 11:06:24 | 3 | Walk |
| 3073 | 2016-11-30 | 2016-11-30 16:31:44 | 1 | Walk |
| 3074 | 2016-11-30 | 2016-11-30 16:31:40 | 1 | Walk |
| 3075 | 2016-12-07 | 2016-12-07 10:45:34 | 2 | Metro |
| 3076 | 2016-12-07 | 2016-12-07 10:45:35 | 2 | Metro |
| 3077 | 2016-12-07 | 2016-12-07 10:45:54 | 2 | Metro |
| 3078 | 2016-12-27 | 2016-12-27 10:42:51 | 2 | Metro |
| 3079 | 2016-12-27 | 2016-12-27 10:43:37 | 2 | Metro |
| 3080 | 2016-12-27 | 2016-12-27 10:42:53 | 2 | Metro |
| 3081 | 2017-02-24 | 2017-02-24 10:59:13 | 4 | Bus |
| 3082 | 2017-02-24 | 2017-02-24 10:59:22 | 4 | Bus |
| 3083 | 2017-02-24 | 2017-02-24 10:59:41 | 4 | 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;