View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,676–4,700 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4932 | 2017-12-10 | 2017-12-10 16:23:47 | 2 | Metro |
| 4933 | 2017-12-16 | 2017-12-16 09:11:49 | 1 | Walk |
| 4934 | 2017-12-16 | 2017-12-16 09:11:39 | 1 | Walk |
| 4935 | 2017-12-19 | 2017-12-19 10:53:59 | 1 | Metro |
| 4936 | 2017-12-12 | 2017-12-12 15:15:32 | 4 | Walk |
| 4937 | 2017-12-12 | 2017-12-12 15:15:33 | 4 | Walk |
| 4938 | 2017-12-12 | 2017-12-12 15:15:03 | 4 | Walk |
| 4939 | 2017-12-12 | 2017-12-12 15:14:58 | 4 | Walk |
| 4940 | 2017-12-17 | 2017-12-17 11:28:44 | 1 | Walk |
| 4941 | 2017-12-17 | 2017-12-17 11:28:43 | 1 | Walk |
| 4942 | 2017-12-20 | 2017-12-20 16:50:51 | 1 | Metro |
| 4943 | 2017-12-20 | 2017-12-20 16:50:57 | 1 | Metro |
| 4944 | 2017-12-15 | 2017-12-15 11:53:18 | 3 | Walk |
| 4945 | 2017-12-15 | 2017-12-15 11:53:05 | 3 | Walk |
| 4946 | 2017-12-15 | 2017-12-15 11:52:52 | 3 | Walk |
| 4947 | 2017-12-22 | 2017-12-22 11:51:45 | 4 | Walk |
| 4948 | 2017-12-17 | 2017-12-17 09:11:37 | 1 | Bus |
| 4949 | 2017-12-24 | 2017-12-24 09:41:35 | 4 | Bus |
| 4950 | 2017-12-24 | 2017-12-24 09:41:57 | 4 | Bus |
| 4951 | 2017-12-24 | 2017-12-24 09:41:22 | 4 | Bus |
| 4952 | 2017-12-20 | 2017-12-20 10:27:08 | 3 | Bus |
| 4953 | 2017-12-20 | 2017-12-20 10:27:25 | 3 | Bus |
| 4954 | 2017-12-20 | 2017-12-20 10:27:13 | 3 | Bus |
| 4955 | 2017-12-20 | 2017-12-20 10:27:49 | 3 | Bus |
| 4956 | 2018-02-11 | 2018-02-11 14:24:24 | 1 | 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;