View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,326–8,350 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8745 | 2019-08-10 | 2019-08-10 14:24:26 | 1 | Train |
| 8746 | 2019-08-10 | 2019-08-10 14:24:29 | 1 | Train |
| 8747 | 2019-08-11 | 2019-08-11 12:08:15 | 1 | Walk |
| 8748 | 2019-08-11 | 2019-08-11 12:08:35 | 1 | Walk |
| 8749 | 2019-08-11 | 2019-08-11 12:08:30 | 1 | Walk |
| 8750 | 2019-08-11 | 2019-08-11 12:08:43 | 1 | Walk |
| 8751 | 2019-08-11 | 2019-08-11 12:08:14 | 1 | Walk |
| 8752 | 2019-09-06 | 2019-09-06 12:43:34 | 5 | Metro |
| 8753 | 2019-09-06 | 2019-09-06 12:43:02 | 5 | Metro |
| 8754 | 2019-08-15 | 2019-08-15 14:17:25 | 4 | Walk |
| 8755 | 2019-08-15 | 2019-08-15 14:17:22 | 4 | Walk |
| 8756 | 2019-08-15 | 2019-08-15 14:17:54 | 4 | Walk |
| 8757 | 2019-08-13 | 2019-08-13 09:41:21 | 2 | Metro |
| 8758 | 2019-08-15 | 2019-08-15 11:36:18 | 1 | Walk |
| 8759 | 2019-08-21 | 2019-08-21 10:54:56 | 1 | Train |
| 8760 | 2019-08-14 | 2019-08-14 13:24:54 | 1 | Bus |
| 8761 | 2019-08-21 | 2019-08-21 10:04:37 | 1 | Walk |
| 8762 | 2019-08-25 | 2019-08-25 10:38:32 | 4 | Metro |
| 8763 | 2019-08-25 | 2019-08-25 10:38:06 | 4 | Metro |
| 8764 | 2019-08-25 | 2019-08-25 10:38:13 | 4 | Metro |
| 8765 | 2019-08-25 | 2019-08-25 10:38:36 | 4 | Metro |
| 8766 | 2019-08-25 | 2019-08-25 10:38:18 | 4 | Metro |
| 8767 | 2019-08-28 | 2019-08-28 10:54:39 | 3 | Metro |
| 8768 | 2019-08-28 | 2019-08-28 10:54:37 | 3 | Metro |
| 8769 | 2019-08-15 | 2019-08-15 13:16:44 | 1 | Taxi |
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;