View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,601–4,625 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4854 | 2017-11-17 | 2017-11-17 11:53:22 | 2 | Walk |
| 4855 | 2017-11-17 | 2017-11-17 11:53:39 | 2 | Walk |
| 4856 | 2017-11-17 | 2017-11-17 11:53:23 | 2 | Walk |
| 4860 | 2017-11-21 | 2017-11-21 09:43:23 | 2 | Metro |
| 4861 | 2018-01-18 | 2018-01-18 11:53:04 | 2 | Walk |
| 4862 | 2018-01-18 | 2018-01-18 11:52:28 | 2 | Walk |
| 4863 | 2017-12-09 | 2017-12-09 11:58:42 | 4 | Walk |
| 4864 | 2017-12-09 | 2017-12-09 11:58:44 | 4 | Walk |
| 4865 | 2017-12-09 | 2017-12-09 11:58:47 | 4 | Walk |
| 4866 | 2017-11-23 | 2017-11-23 14:12:09 | 4 | Walk |
| 4867 | 2018-01-19 | 2018-01-19 09:06:53 | 5 | Metro |
| 4868 | 2018-01-19 | 2018-01-19 09:07:12 | 5 | Metro |
| 4869 | 2017-11-21 | 2017-11-21 11:26:26 | 2 | Metro |
| 4870 | 2017-11-21 | 2017-11-21 11:26:46 | 2 | Metro |
| 4871 | 2017-11-22 | 2017-11-22 09:55:28 | 4 | Walk |
| 4872 | 2017-11-22 | 2017-11-22 09:55:28 | 4 | Walk |
| 4873 | 2017-11-22 | 2017-11-22 09:55:41 | 4 | Walk |
| 4874 | 2017-11-22 | 2017-11-22 09:55:51 | 4 | Walk |
| 4875 | 2017-11-22 | 2017-11-22 09:52:44 | 1 | Walk |
| 4876 | 2017-11-22 | 2017-11-22 09:52:15 | 1 | Walk |
| 4877 | 2017-11-22 | 2017-11-22 10:22:34 | 1 | Bus |
| 4878 | 2017-11-22 | 2017-11-22 10:22:48 | 1 | Bus |
| 4879 | 2017-11-25 | 2017-11-25 16:39:02 | 2 | Metro |
| 4880 | 2017-11-25 | 2017-11-25 16:39:17 | 2 | Metro |
| 4881 | 2017-11-23 | 2017-11-23 12:21:53 | 2 | 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;