View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,376–5,400 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5669 | 2018-05-07 | 2018-05-07 15:13:51 | 4 | Walk |
| 5670 | 2018-04-28 | 2018-04-28 12:33:38 | 1 | Bus |
| 5671 | 2018-04-29 | 2018-04-29 11:29:35 | 2 | Metro |
| 5672 | 2018-04-29 | 2018-04-29 11:28:54 | 2 | Metro |
| 5673 | 2018-05-01 | 2018-05-01 11:11:03 | 3 | Taxi |
| 5674 | 2018-05-11 | 2018-05-11 13:39:28 | 2 | Other |
| 5675 | 2018-05-11 | 2018-05-11 13:39:48 | 2 | Other |
| 5676 | 2018-05-02 | 2018-05-02 10:21:14 | 2 | Metro |
| 5677 | 2018-05-02 | 2018-05-02 14:35:55 | 1 | Walk |
| 5678 | 2018-05-19 | 2018-05-19 15:50:57 | 2 | Metro |
| 5679 | 2018-05-19 | 2018-05-19 15:51:15 | 2 | Metro |
| 5680 | 2018-05-19 | 2018-05-19 15:51:31 | 2 | Metro |
| 5681 | 2018-05-19 | 2018-05-19 15:51:04 | 2 | Metro |
| 5682 | 2018-05-19 | 2018-05-19 15:51:09 | 2 | Metro |
| 5683 | 2018-05-11 | 2018-05-11 10:04:15 | 2 | Metro |
| 5684 | 2018-05-11 | 2018-05-11 10:03:52 | 2 | Metro |
| 5685 | 2018-05-04 | 2018-05-04 09:31:09 | 1 | Other |
| 5686 | 2018-05-26 | 2018-05-26 11:10:50 | 4 | Taxi |
| 5687 | 2018-05-04 | 2018-05-04 15:07:51 | 2 | Metro |
| 5688 | 2018-05-04 | 2018-05-04 15:07:53 | 2 | Metro |
| 5689 | 2018-05-16 | 2018-05-16 09:49:58 | 1 | Other |
| 5690 | 2018-05-05 | 2018-05-05 13:04:44 | 2 | Metro |
| 5691 | 2018-05-05 | 2018-05-05 09:37:49 | 1 | Walk |
| 5692 | 2018-05-05 | 2018-05-05 09:38:25 | 1 | Walk |
| 5693 | 2018-05-05 | 2018-05-05 10:17:04 | 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;