View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,101–9,125 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9553 | 2019-12-20 | 2019-12-20 09:22:25 | 4 | Walk |
| 9554 | 2020-01-16 | 2020-01-16 15:14:12 | 1 | Taxi |
| 9555 | 2020-01-16 | 2020-01-16 15:14:45 | 1 | Taxi |
| 9556 | 2019-12-21 | 2019-12-21 10:23:28 | 1 | Metro |
| 9557 | 2019-12-21 | 2019-12-21 10:23:18 | 1 | Metro |
| 9558 | 2019-12-28 | 2019-12-28 11:48:54 | 1 | Bus |
| 9559 | 2019-12-21 | 2019-12-21 15:41:05 | 1 | Walk |
| 9560 | 2019-12-24 | 2019-12-24 15:40:40 | 2 | Metro |
| 9561 | 2019-12-24 | 2019-12-24 15:40:17 | 2 | Metro |
| 9562 | 2019-12-24 | 2019-12-24 15:40:11 | 2 | Metro |
| 9563 | 2019-12-24 | 2019-12-24 15:40:32 | 2 | Metro |
| 9564 | 2019-12-28 | 2019-12-28 11:10:10 | 1 | Bus |
| 9565 | 2019-12-18 | 2019-12-18 11:16:21 | 1 | Walk |
| 9566 | 2019-12-18 | 2019-12-18 11:16:31 | 1 | Walk |
| 9567 | 2019-12-28 | 2019-12-28 16:30:05 | 2 | Walk |
| 9568 | 2019-12-19 | 2019-12-19 14:14:40 | 5 | Metro |
| 9569 | 2019-12-20 | 2019-12-20 15:07:04 | 1 | Walk |
| 9570 | 2019-12-20 | 2019-12-20 15:06:43 | 1 | Walk |
| 9571 | 2019-12-28 | 2019-12-28 16:26:31 | 1 | Metro |
| 9572 | 2019-12-28 | 2019-12-28 12:32:39 | 1 | Metro |
| 9573 | 2019-12-28 | 2019-12-28 12:33:10 | 1 | Metro |
| 9574 | 2020-01-09 | 2020-01-09 13:24:22 | 2 | Metro |
| 9575 | 2020-01-09 | 2020-01-09 13:24:20 | 2 | Metro |
| 9576 | 2019-12-24 | 2019-12-24 15:18:32 | 1 | Metro |
| 9577 | 2019-12-24 | 2019-12-24 15:18:22 | 1 | 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;