View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,351–7,375 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7745 | 2019-03-02 | 2019-03-02 10:38:46 | 5 | Bus |
| 7746 | 2019-03-17 | 2019-03-17 16:21:14 | 4 | Metro |
| 7747 | 2019-03-17 | 2019-03-17 16:21:35 | 4 | Metro |
| 7748 | 2019-03-17 | 2019-03-17 16:21:02 | 4 | Metro |
| 7749 | 2019-03-17 | 2019-03-17 16:21:04 | 4 | Metro |
| 7750 | 2019-03-17 | 2019-03-17 16:21:18 | 4 | Metro |
| 7751 | 2019-03-05 | 2019-03-05 11:24:56 | 5 | Walk |
| 7752 | 2019-03-05 | 2019-03-05 11:25:45 | 5 | Walk |
| 7753 | 2019-03-05 | 2019-03-05 11:25:20 | 5 | Walk |
| 7754 | 2019-03-04 | 2019-03-04 10:29:51 | 2 | Bus |
| 7755 | 2019-03-04 | 2019-03-04 10:29:50 | 2 | Bus |
| 7756 | 2019-03-04 | 2019-03-04 10:29:35 | 2 | Bus |
| 7757 | 2019-03-07 | 2019-03-07 09:14:38 | 2 | Metro |
| 7758 | 2019-03-07 | 2019-03-07 09:15:00 | 2 | Metro |
| 7759 | 2019-03-07 | 2019-03-07 09:14:22 | 2 | Metro |
| 7760 | 2019-03-07 | 2019-03-07 09:15:06 | 2 | Metro |
| 7761 | 2019-03-07 | 2019-03-07 09:14:46 | 2 | Metro |
| 7762 | 2019-03-05 | 2019-03-05 09:36:23 | 1 | Walk |
| 7764 | 2019-03-05 | 2019-03-05 09:36:58 | 1 | Walk |
| 7765 | 2019-03-05 | 2019-03-05 09:36:28 | 1 | Walk |
| 7767 | 2019-03-08 | 2019-03-08 11:44:48 | 2 | Walk |
| 7768 | 2019-03-05 | 2019-03-05 11:30:28 | 4 | Metro |
| 7769 | 2019-03-05 | 2019-03-05 11:30:18 | 4 | Metro |
| 7770 | 2019-03-05 | 2019-03-05 11:29:56 | 4 | Metro |
| 7771 | 2019-03-12 | 2019-03-12 14:57:02 | 4 | Train |
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;