View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,626–2,650 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2768 | 2016-08-31 | 2016-08-31 13:48:23 | 1 | Metro |
| 2769 | 2016-09-01 | 2016-09-01 09:38:42 | 2 | Taxi |
| 2770 | 2016-09-08 | 2016-09-08 12:23:57 | 1 | Metro |
| 2771 | 2016-09-08 | 2016-09-08 12:24:28 | 1 | Metro |
| 2772 | 2016-09-08 | 2016-09-08 12:24:00 | 1 | Metro |
| 2773 | 2016-09-08 | 2016-09-08 12:24:34 | 1 | Metro |
| 2774 | 2016-09-01 | 2016-09-01 11:00:38 | 2 | Metro |
| 2775 | 2016-09-01 | 2016-09-01 11:00:50 | 2 | Metro |
| 2776 | 2016-09-01 | 2016-09-01 11:00:48 | 2 | Metro |
| 2779 | 2016-09-08 | 2016-09-08 12:37:24 | 1 | Taxi |
| 2780 | 2016-09-02 | 2016-09-02 11:16:11 | 4 | Other |
| 2781 | 2016-09-02 | 2016-09-02 11:16:37 | 4 | Other |
| 2782 | 2016-09-04 | 2016-09-04 12:22:48 | 5 | Walk |
| 2783 | 2016-09-16 | 2016-09-16 09:10:37 | 1 | Metro |
| 2784 | 2016-09-16 | 2016-09-16 09:10:24 | 1 | Metro |
| 2785 | 2016-09-16 | 2016-09-16 11:52:21 | 4 | Metro |
| 2786 | 2016-09-05 | 2016-09-05 10:07:01 | 4 | Metro |
| 2787 | 2016-09-21 | 2016-09-21 16:27:24 | 1 | Metro |
| 2788 | 2016-09-21 | 2016-09-21 16:27:58 | 1 | Metro |
| 2789 | 2016-09-24 | 2016-09-24 12:21:25 | 1 | Metro |
| 2790 | 2016-09-07 | 2016-09-07 11:12:11 | 1 | Bus |
| 2791 | 2016-09-07 | 2016-09-07 11:12:50 | 1 | Bus |
| 2792 | 2016-09-07 | 2016-09-07 11:12:57 | 1 | Bus |
| 2793 | 2016-09-07 | 2016-09-07 12:37:50 | 2 | Bus |
| 2794 | 2016-09-07 | 2016-09-07 12:38:11 | 2 | Bus |
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;