View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,251–9,275 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9704 | 2020-01-21 | 2020-01-21 13:45:06 | 1 | Train |
| 9705 | 2020-01-21 | 2020-01-21 13:44:30 | 1 | Train |
| 9706 | 2020-01-21 | 2020-01-21 13:44:36 | 1 | Train |
| 9707 | 2020-02-01 | 2020-02-01 11:22:00 | 1 | Metro |
| 9708 | 2020-02-01 | 2020-02-01 11:22:44 | 1 | Metro |
| 9711 | 2020-01-22 | 2020-01-22 09:49:29 | 4 | Bus |
| 9712 | 2020-01-22 | 2020-01-22 14:26:06 | 2 | Metro |
| 9713 | 2020-01-22 | 2020-01-22 14:25:48 | 2 | Metro |
| 9714 | 2020-01-22 | 2020-01-22 13:17:11 | 1 | Walk |
| 9715 | 2020-01-22 | 2020-01-22 13:17:13 | 1 | Walk |
| 9716 | 2020-01-29 | 2020-01-29 13:56:15 | 2 | Train |
| 9717 | 2020-01-23 | 2020-01-23 12:44:08 | 1 | Walk |
| 9719 | 2020-01-23 | 2020-01-23 12:44:43 | 1 | Walk |
| 9720 | 2020-01-23 | 2020-01-23 12:44:09 | 1 | Walk |
| 9721 | 2020-01-23 | 2020-01-23 14:25:40 | 1 | Bus |
| 9722 | 2020-01-23 | 2020-01-23 14:25:28 | 1 | Bus |
| 9723 | 2020-01-29 | 2020-01-29 11:11:09 | 1 | Walk |
| 9724 | 2020-01-29 | 2020-01-29 11:10:47 | 1 | Walk |
| 9725 | 2020-01-29 | 2020-01-29 11:10:25 | 1 | Walk |
| 9726 | 2020-01-25 | 2020-01-25 14:23:28 | 2 | Taxi |
| 9727 | 2020-01-25 | 2020-01-25 14:23:41 | 2 | Taxi |
| 9728 | 2020-01-25 | 2020-01-25 14:23:49 | 2 | Taxi |
| 9729 | 2020-01-25 | 2020-01-25 14:23:39 | 2 | Taxi |
| 9730 | 2020-01-25 | 2020-01-25 14:23:22 | 2 | Taxi |
| 9731 | 2020-02-10 | 2020-02-10 15:45:49 | 3 | Walk |
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;