View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,251–8,275 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8670 | 2019-08-12 | 2019-08-12 10:53:59 | 2 | Metro |
| 8671 | 2019-08-12 | 2019-08-12 10:53:58 | 2 | Metro |
| 8672 | 2019-08-12 | 2019-08-12 10:53:38 | 2 | Metro |
| 8673 | 2019-08-04 | 2019-08-04 09:50:00 | 2 | Metro |
| 8674 | 2019-08-02 | 2019-08-02 09:17:34 | 5 | Walk |
| 8675 | 2019-08-02 | 2019-08-02 09:17:52 | 5 | Walk |
| 8676 | 2019-08-02 | 2019-08-02 09:17:40 | 5 | Walk |
| 8677 | 2019-08-02 | 2019-08-02 09:17:37 | 5 | Walk |
| 8678 | 2019-08-02 | 2019-08-02 09:22:04 | 1 | Taxi |
| 8679 | 2019-08-02 | 2019-08-02 09:21:57 | 1 | Taxi |
| 8680 | 2019-08-02 | 2019-08-02 09:22:21 | 1 | Taxi |
| 8681 | 2019-08-02 | 2019-08-02 09:21:48 | 1 | Taxi |
| 8682 | 2019-08-02 | 2019-08-02 09:21:46 | 1 | Taxi |
| 8683 | 2019-08-02 | 2019-08-02 13:52:55 | 1 | Walk |
| 8684 | 2019-08-02 | 2019-08-02 13:52:56 | 1 | Walk |
| 8685 | 2019-08-02 | 2019-08-02 16:56:15 | 1 | Walk |
| 8686 | 2019-08-02 | 2019-08-02 16:55:56 | 1 | Walk |
| 8687 | 2019-08-16 | 2019-08-16 14:18:32 | 3 | Bus |
| 8688 | 2019-08-16 | 2019-08-16 14:18:34 | 3 | Bus |
| 8689 | 2019-08-16 | 2019-08-16 14:18:34 | 3 | Bus |
| 8690 | 2019-08-16 | 2019-08-16 14:18:22 | 3 | Bus |
| 8691 | 2019-08-25 | 2019-08-25 13:07:49 | 1 | Metro |
| 8692 | 2019-08-25 | 2019-08-25 13:08:06 | 1 | Metro |
| 8693 | 2019-08-10 | 2019-08-10 14:20:40 | 3 | Metro |
| 8694 | 2019-08-10 | 2019-08-10 14:20:27 | 3 | 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;