View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,476–5,500 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5781 | 2018-05-15 | 2018-05-15 10:16:16 | 4 | Metro |
| 5782 | 2018-05-15 | 2018-05-15 10:16:17 | 4 | Metro |
| 5783 | 2018-05-24 | 2018-05-24 10:42:38 | 4 | Walk |
| 5784 | 2018-05-24 | 2018-05-24 10:42:48 | 4 | Walk |
| 5785 | 2018-05-16 | 2018-05-16 11:32:35 | 2 | Private Vehicle |
| 5786 | 2018-05-16 | 2018-05-16 11:32:16 | 2 | Private Vehicle |
| 5787 | 2018-05-25 | 2018-05-25 10:10:01 | 2 | Metro |
| 5788 | 2018-05-17 | 2018-05-17 11:11:18 | 3 | Metro |
| 5789 | 2018-05-17 | 2018-05-17 11:10:50 | 3 | Metro |
| 5790 | 2018-05-17 | 2018-05-17 11:10:52 | 3 | Metro |
| 5791 | 2018-05-17 | 2018-05-17 11:11:19 | 3 | Metro |
| 5792 | 2018-05-17 | 2018-05-17 13:49:03 | 2 | Metro |
| 5793 | 2018-05-21 | 2018-05-21 12:57:17 | 4 | Train |
| 5794 | 2018-05-21 | 2018-05-21 12:57:41 | 4 | Train |
| 5795 | 2018-06-02 | 2018-06-02 12:34:52 | 1 | Walk |
| 5796 | 2018-06-02 | 2018-06-02 12:35:26 | 1 | Walk |
| 5797 | 2018-05-30 | 2018-05-30 11:07:36 | 1 | Metro |
| 5798 | 2018-05-30 | 2018-05-30 11:07:26 | 1 | Metro |
| 5799 | 2018-06-07 | 2018-06-07 11:54:27 | 3 | Train |
| 5800 | 2018-06-07 | 2018-06-07 11:53:59 | 3 | Train |
| 5801 | 2018-05-19 | 2018-05-19 10:41:04 | 4 | Bus |
| 5802 | 2018-05-19 | 2018-05-19 15:04:40 | 1 | Walk |
| 5803 | 2018-05-25 | 2018-05-25 13:15:24 | 2 | Metro |
| 5804 | 2018-05-25 | 2018-05-25 13:14:55 | 2 | Metro |
| 5805 | 2018-05-25 | 2018-05-25 13:15:32 | 2 | 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;