View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,701–3,725 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3922 | 2017-05-11 | 2017-05-11 14:12:01 | 3 | Metro |
| 3923 | 2017-05-11 | 2017-05-11 14:12:02 | 3 | Metro |
| 3924 | 2017-05-11 | 2017-05-11 15:57:25 | 2 | Metro |
| 3925 | 2017-05-11 | 2017-05-11 15:57:33 | 2 | Metro |
| 3926 | 2017-06-16 | 2017-06-16 09:13:47 | 1 | Train |
| 3927 | 2017-06-16 | 2017-06-16 09:12:58 | 1 | Train |
| 3928 | 2017-06-16 | 2017-06-16 09:13:16 | 1 | Train |
| 3929 | 2017-05-12 | 2017-05-12 09:10:12 | 2 | Metro |
| 3930 | 2017-05-12 | 2017-05-12 09:10:20 | 2 | Metro |
| 3931 | 2017-05-13 | 2017-05-13 09:43:28 | 3 | Walk |
| 3932 | 2017-05-13 | 2017-05-13 09:43:12 | 3 | Walk |
| 3933 | 2017-05-13 | 2017-05-13 09:43:13 | 3 | Walk |
| 3934 | 2017-05-13 | 2017-05-13 09:43:25 | 3 | Walk |
| 3935 | 2017-05-12 | 2017-05-12 14:11:40 | 3 | Walk |
| 3936 | 2017-05-13 | 2017-05-13 12:27:02 | 5 | Walk |
| 3937 | 2017-05-13 | 2017-05-13 15:41:17 | 1 | Metro |
| 3938 | 2017-05-13 | 2017-05-13 15:41:02 | 1 | Metro |
| 3939 | 2017-05-13 | 2017-05-13 15:41:00 | 1 | Metro |
| 3940 | 2017-05-24 | 2017-05-24 10:46:51 | 5 | Walk |
| 3941 | 2017-05-20 | 2017-05-20 12:04:51 | 1 | Other |
| 3942 | 2017-05-18 | 2017-05-18 10:09:40 | 2 | Train |
| 3943 | 2017-06-05 | 2017-06-05 10:26:18 | 2 | Private Vehicle |
| 3944 | 2017-06-05 | 2017-06-05 10:26:50 | 2 | Private Vehicle |
| 3945 | 2017-06-05 | 2017-06-05 10:26:40 | 2 | Private Vehicle |
| 3946 | 2017-06-05 | 2017-06-05 10:26:43 | 2 | Private Vehicle |
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;