View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,726–3,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3947 | 2017-06-05 | 2017-06-05 10:26:16 | 2 | Private Vehicle |
| 3948 | 2017-05-18 | 2017-05-18 09:32:50 | 1 | Walk |
| 3949 | 2017-05-18 | 2017-05-18 09:33:02 | 1 | Walk |
| 3950 | 2017-05-28 | 2017-05-28 09:24:05 | 2 | Walk |
| 3951 | 2017-05-28 | 2017-05-28 09:23:55 | 2 | Walk |
| 3952 | 2017-05-19 | 2017-05-19 11:07:35 | 1 | Other |
| 3953 | 2017-05-20 | 2017-05-20 09:48:02 | 2 | Metro |
| 3954 | 2017-05-20 | 2017-05-20 09:47:56 | 2 | Metro |
| 3955 | 2017-05-21 | 2017-05-21 10:51:21 | 1 | Walk |
| 3956 | 2017-05-21 | 2017-05-21 10:51:38 | 1 | Walk |
| 3957 | 2017-05-27 | 2017-05-27 14:56:43 | 1 | Walk |
| 3958 | 2017-05-27 | 2017-05-27 14:56:53 | 1 | Walk |
| 3959 | 2017-05-27 | 2017-05-27 14:56:32 | 1 | Walk |
| 3960 | 2017-06-14 | 2017-06-14 11:28:29 | 1 | Walk |
| 3961 | 2017-06-14 | 2017-06-14 11:28:44 | 1 | Walk |
| 3962 | 2017-05-28 | 2017-05-28 09:59:37 | 4 | Walk |
| 3963 | 2017-05-28 | 2017-05-28 09:59:29 | 4 | Walk |
| 3964 | 2017-05-28 | 2017-05-28 09:59:41 | 4 | Walk |
| 3965 | 2017-05-25 | 2017-05-25 14:21:40 | 1 | Metro |
| 3966 | 2017-05-25 | 2017-05-25 14:21:58 | 1 | Metro |
| 3967 | 2017-05-25 | 2017-05-25 14:22:13 | 1 | Metro |
| 3968 | 2017-05-25 | 2017-05-25 14:21:47 | 1 | Metro |
| 3969 | 2017-06-12 | 2017-06-12 15:30:22 | 1 | Metro |
| 3970 | 2017-06-12 | 2017-06-12 15:30:27 | 1 | Metro |
| 3971 | 2017-06-12 | 2017-06-12 15:30:06 | 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;