View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,426–8,450 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8847 | 2019-08-29 | 2019-08-29 09:39:52 | 2 | Walk |
| 8848 | 2019-10-07 | 2019-10-07 10:18:56 | 1 | Other |
| 8849 | 2019-10-07 | 2019-10-07 10:18:59 | 1 | Other |
| 8850 | 2019-10-07 | 2019-10-07 10:19:03 | 1 | Other |
| 8851 | 2019-10-07 | 2019-10-07 10:18:30 | 1 | Other |
| 8852 | 2019-08-31 | 2019-08-31 12:31:51 | 1 | Metro |
| 8853 | 2019-08-31 | 2019-08-31 12:31:51 | 1 | Metro |
| 8854 | 2019-08-30 | 2019-08-30 09:35:08 | 1 | Metro |
| 8855 | 2019-08-30 | 2019-08-30 09:35:00 | 1 | Metro |
| 8856 | 2019-08-30 | 2019-08-30 10:28:44 | 1 | Walk |
| 8857 | 2019-08-30 | 2019-08-30 10:28:09 | 1 | Walk |
| 8858 | 2019-08-30 | 2019-08-30 10:28:34 | 1 | Walk |
| 8859 | 2019-09-11 | 2019-09-11 11:59:20 | 1 | Walk |
| 8860 | 2019-09-11 | 2019-09-11 11:58:51 | 1 | Walk |
| 8861 | 2019-09-11 | 2019-09-11 11:59:04 | 1 | Walk |
| 8862 | 2019-09-11 | 2019-09-11 11:58:50 | 1 | Walk |
| 8863 | 2019-09-11 | 2019-09-11 11:59:20 | 1 | Walk |
| 8864 | 2019-08-31 | 2019-08-31 10:13:40 | 2 | Metro |
| 8865 | 2019-08-31 | 2019-08-31 10:13:21 | 2 | Metro |
| 8866 | 2019-08-31 | 2019-08-31 10:32:09 | 1 | Other |
| 8867 | 2019-08-31 | 2019-08-31 10:31:51 | 1 | Other |
| 8868 | 2019-09-02 | 2019-09-02 11:40:46 | 1 | Walk |
| 8869 | 2019-09-30 | 2019-09-30 09:30:18 | 2 | Metro |
| 8870 | 2019-09-24 | 2019-09-24 11:33:28 | 1 | Metro |
| 8871 | 2019-09-01 | 2019-09-01 11:57:44 | 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;