View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,776–2,800 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2926 | 2016-10-22 | 2016-10-22 10:12:48 | 1 | Metro |
| 2927 | 2016-10-22 | 2016-10-22 16:23:02 | 4 | Walk |
| 2928 | 2016-10-22 | 2016-10-22 16:22:33 | 4 | Walk |
| 2929 | 2016-11-11 | 2016-11-11 13:13:59 | 3 | Metro |
| 2930 | 2016-11-11 | 2016-11-11 13:13:44 | 3 | Metro |
| 2931 | 2016-11-11 | 2016-11-11 13:13:34 | 3 | Metro |
| 2932 | 2016-11-11 | 2016-11-11 13:14:07 | 3 | Metro |
| 2933 | 2016-10-25 | 2016-10-25 11:47:34 | 2 | Metro |
| 2934 | 2016-10-25 | 2016-10-25 11:47:11 | 2 | Metro |
| 2937 | 2016-11-04 | 2016-11-04 16:49:39 | 2 | Metro |
| 2938 | 2016-11-04 | 2016-11-04 16:50:09 | 2 | Metro |
| 2939 | 2016-11-04 | 2016-11-04 16:49:29 | 2 | Metro |
| 2940 | 2016-11-06 | 2016-11-06 11:06:34 | 1 | Metro |
| 2941 | 2016-10-28 | 2016-10-28 15:11:06 | 2 | Taxi |
| 2942 | 2016-10-30 | 2016-10-30 15:24:45 | 1 | Walk |
| 2943 | 2016-10-30 | 2016-10-30 15:24:36 | 1 | Walk |
| 2944 | 2016-11-06 | 2016-11-06 14:31:12 | 5 | Walk |
| 2945 | 2016-11-06 | 2016-11-06 14:30:55 | 5 | Walk |
| 2946 | 2016-11-26 | 2016-11-26 10:56:14 | 1 | Bus |
| 2947 | 2016-11-26 | 2016-11-26 10:56:33 | 1 | Bus |
| 2948 | 2016-11-26 | 2016-11-26 10:56:12 | 1 | Bus |
| 2949 | 2016-11-26 | 2016-11-26 10:56:13 | 1 | Bus |
| 2950 | 2016-11-02 | 2016-11-02 09:14:21 | 3 | Walk |
| 2951 | 2016-11-02 | 2016-11-02 09:14:49 | 3 | Walk |
| 2953 | 2016-12-26 | 2016-12-26 09:37:59 | 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;