View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,726–2,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2874 | 2016-10-06 | 2016-10-06 12:31:05 | 1 | Taxi |
| 2875 | 2016-10-06 | 2016-10-06 12:30:47 | 1 | Taxi |
| 2876 | 2016-10-06 | 2016-10-06 12:30:31 | 1 | Taxi |
| 2877 | 2016-10-07 | 2016-10-07 14:59:23 | 3 | Private Vehicle |
| 2878 | 2016-10-07 | 2016-10-07 14:59:48 | 3 | Private Vehicle |
| 2879 | 2016-10-10 | 2016-10-10 12:27:04 | 4 | Other |
| 2880 | 2016-10-10 | 2016-10-10 12:27:18 | 4 | Other |
| 2881 | 2016-10-10 | 2016-10-10 12:27:10 | 4 | Other |
| 2882 | 2016-10-08 | 2016-10-08 09:05:31 | 2 | Metro |
| 2883 | 2016-10-08 | 2016-10-08 09:05:24 | 2 | Metro |
| 2884 | 2016-10-08 | 2016-10-08 14:01:34 | 1 | Taxi |
| 2885 | 2016-10-08 | 2016-10-08 14:01:49 | 1 | Taxi |
| 2886 | 2016-10-08 | 2016-10-08 14:01:32 | 1 | Taxi |
| 2887 | 2016-10-15 | 2016-10-15 11:20:02 | 1 | Metro |
| 2888 | 2016-10-15 | 2016-10-15 11:20:13 | 1 | Metro |
| 2889 | 2016-10-09 | 2016-10-09 09:09:39 | 1 | Walk |
| 2890 | 2016-10-09 | 2016-10-09 09:09:53 | 1 | Walk |
| 2891 | 2016-10-09 | 2016-10-09 09:10:16 | 1 | Walk |
| 2892 | 2016-10-09 | 2016-10-09 09:10:15 | 1 | Walk |
| 2893 | 2016-10-18 | 2016-10-18 13:35:21 | 2 | Metro |
| 2894 | 2016-10-18 | 2016-10-18 13:34:49 | 2 | Metro |
| 2895 | 2016-10-18 | 2016-10-18 13:35:05 | 2 | Metro |
| 2896 | 2016-10-18 | 2016-10-18 13:35:19 | 2 | Metro |
| 2897 | 2016-10-13 | 2016-10-13 14:00:09 | 4 | Walk |
| 2898 | 2016-10-13 | 2016-10-13 13:59:44 | 4 | Walk |
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;