View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,751–2,775 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2899 | 2016-10-13 | 2016-10-13 13:59:29 | 4 | Walk |
| 2901 | 2016-10-13 | 2016-10-13 13:59:55 | 4 | Walk |
| 2902 | 2016-10-11 | 2016-10-11 10:39:32 | 1 | Metro |
| 2903 | 2016-10-11 | 2016-10-11 10:39:21 | 1 | Metro |
| 2904 | 2016-10-11 | 2016-10-11 10:39:26 | 1 | Metro |
| 2905 | 2016-10-11 | 2016-10-11 10:39:01 | 1 | Metro |
| 2906 | 2016-10-12 | 2016-10-12 16:02:15 | 1 | Metro |
| 2907 | 2016-10-12 | 2016-10-12 16:02:23 | 1 | Metro |
| 2908 | 2016-10-12 | 2016-10-12 16:02:25 | 1 | Metro |
| 2909 | 2016-10-15 | 2016-10-15 16:17:26 | 4 | Walk |
| 2910 | 2016-10-15 | 2016-10-15 16:17:25 | 4 | Walk |
| 2911 | 2016-10-15 | 2016-10-15 12:21:42 | 1 | Walk |
| 2912 | 2016-10-15 | 2016-10-15 12:21:27 | 1 | Walk |
| 2913 | 2016-10-16 | 2016-10-16 09:19:47 | 2 | Metro |
| 2914 | 2016-10-16 | 2016-10-16 09:19:53 | 2 | Metro |
| 2915 | 2016-10-30 | 2016-10-30 12:09:48 | 3 | Metro |
| 2916 | 2016-10-30 | 2016-10-30 12:09:26 | 3 | Metro |
| 2918 | 2016-10-26 | 2016-10-26 17:00:19 | 1 | Train |
| 2919 | 2016-10-19 | 2016-10-19 12:48:09 | 1 | Walk |
| 2920 | 2016-10-29 | 2016-10-29 09:35:11 | 5 | Walk |
| 2921 | 2016-10-29 | 2016-10-29 09:34:49 | 5 | Walk |
| 2922 | 2016-10-22 | 2016-10-22 10:12:37 | 1 | Metro |
| 2923 | 2016-10-22 | 2016-10-22 10:12:35 | 1 | Metro |
| 2924 | 2016-10-22 | 2016-10-22 10:12:16 | 1 | Metro |
| 2925 | 2016-10-22 | 2016-10-22 10:12:46 | 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;