View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,526–6,550 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6863 | 2018-10-09 | 2018-10-09 09:50:38 | 5 | Walk |
| 6864 | 2018-10-09 | 2018-10-09 09:51:06 | 5 | Walk |
| 6865 | 2018-10-09 | 2018-10-09 09:55:20 | 3 | Walk |
| 6866 | 2018-10-09 | 2018-10-09 12:44:48 | 1 | Metro |
| 6867 | 2018-10-09 | 2018-10-09 12:44:10 | 1 | Metro |
| 6868 | 2018-10-09 | 2018-10-09 12:44:08 | 1 | Metro |
| 6869 | 2018-10-11 | 2018-10-11 10:56:35 | 1 | Metro |
| 6870 | 2018-10-11 | 2018-10-11 11:43:45 | 1 | Metro |
| 6871 | 2018-10-11 | 2018-10-11 11:43:32 | 1 | Metro |
| 6872 | 2018-10-12 | 2018-10-12 09:31:38 | 3 | Walk |
| 6873 | 2018-10-13 | 2018-10-13 12:25:17 | 2 | Metro |
| 6874 | 2018-10-13 | 2018-10-13 12:24:50 | 2 | Metro |
| 6875 | 2018-10-13 | 2018-10-13 12:25:00 | 2 | Metro |
| 6876 | 2018-10-13 | 2018-10-13 12:24:50 | 2 | Metro |
| 6877 | 2018-10-13 | 2018-10-13 12:25:12 | 2 | Metro |
| 6878 | 2018-10-28 | 2018-10-28 10:24:01 | 1 | Train |
| 6879 | 2018-10-28 | 2018-10-28 10:23:56 | 1 | Train |
| 6880 | 2018-10-13 | 2018-10-13 13:59:40 | 4 | Walk |
| 6881 | 2018-10-13 | 2018-10-13 13:59:43 | 4 | Walk |
| 6882 | 2018-10-14 | 2018-10-14 10:04:34 | 4 | Walk |
| 6883 | 2018-10-14 | 2018-10-14 10:04:36 | 4 | Walk |
| 6884 | 2018-10-19 | 2018-10-19 15:18:19 | 4 | Walk |
| 6885 | 2018-10-19 | 2018-10-19 15:17:55 | 4 | Walk |
| 6886 | 2018-10-15 | 2018-10-15 15:22:19 | 4 | Walk |
| 6887 | 2018-10-15 | 2018-10-15 13:43:57 | 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;