View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,451–5,475 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5755 | 2018-05-18 | 2018-05-18 12:33:54 | 1 | Taxi |
| 5756 | 2018-05-12 | 2018-05-12 15:51:04 | 1 | Metro |
| 5757 | 2018-05-12 | 2018-05-12 15:50:35 | 1 | Metro |
| 5758 | 2018-05-13 | 2018-05-13 10:05:20 | 5 | Taxi |
| 5759 | 2018-05-13 | 2018-05-13 10:04:48 | 5 | Taxi |
| 5760 | 2018-05-13 | 2018-05-13 10:49:50 | 1 | Walk |
| 5761 | 2018-05-13 | 2018-05-13 10:49:53 | 1 | Walk |
| 5762 | 2018-05-13 | 2018-05-13 13:02:02 | 5 | Metro |
| 5763 | 2018-05-13 | 2018-05-13 13:15:19 | 2 | Private Vehicle |
| 5764 | 2018-05-18 | 2018-05-18 10:23:13 | 1 | Other |
| 5765 | 2018-05-18 | 2018-05-18 10:23:35 | 1 | Other |
| 5766 | 2018-05-18 | 2018-05-18 10:23:19 | 1 | Other |
| 5767 | 2018-05-18 | 2018-05-18 10:23:37 | 1 | Other |
| 5769 | 2018-05-23 | 2018-05-23 10:55:17 | 3 | Metro |
| 5770 | 2018-05-23 | 2018-05-23 10:55:24 | 3 | Metro |
| 5771 | 2018-05-23 | 2018-05-23 10:55:11 | 3 | Metro |
| 5772 | 2018-05-23 | 2018-05-23 10:55:03 | 3 | Metro |
| 5773 | 2018-05-25 | 2018-05-25 11:54:57 | 1 | Taxi |
| 5774 | 2018-05-25 | 2018-05-25 11:54:52 | 1 | Taxi |
| 5775 | 2018-05-15 | 2018-05-15 10:04:27 | 4 | Walk |
| 5776 | 2018-05-15 | 2018-05-15 10:04:06 | 4 | Walk |
| 5777 | 2018-05-15 | 2018-05-15 10:04:02 | 4 | Walk |
| 5778 | 2018-05-15 | 2018-05-15 10:03:47 | 4 | Walk |
| 5779 | 2018-05-15 | 2018-05-15 10:16:43 | 4 | Metro |
| 5780 | 2018-05-15 | 2018-05-15 10:16:22 | 4 | 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;