View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,526–2,550 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2665 | 2016-08-29 | 2016-08-29 15:08:08 | 1 | Metro |
| 2666 | 2016-08-29 | 2016-08-29 15:07:55 | 1 | Metro |
| 2667 | 2016-08-20 | 2016-08-20 11:12:15 | 2 | Metro |
| 2668 | 2016-08-20 | 2016-08-20 11:12:21 | 2 | Metro |
| 2669 | 2016-08-21 | 2016-08-21 13:44:53 | 4 | Other |
| 2670 | 2016-08-21 | 2016-08-21 13:45:07 | 4 | Other |
| 2671 | 2016-08-21 | 2016-08-21 10:35:26 | 1 | Walk |
| 2672 | 2016-08-21 | 2016-08-21 10:35:48 | 1 | Walk |
| 2673 | 2016-08-21 | 2016-08-21 10:35:46 | 1 | Walk |
| 2674 | 2016-08-21 | 2016-08-21 10:35:36 | 1 | Walk |
| 2675 | 2016-08-21 | 2016-08-21 10:35:20 | 1 | Walk |
| 2676 | 2016-08-21 | 2016-08-21 14:28:35 | 1 | Metro |
| 2677 | 2016-08-21 | 2016-08-21 14:29:07 | 1 | Metro |
| 2678 | 2016-08-21 | 2016-08-21 14:29:00 | 1 | Metro |
| 2679 | 2016-08-21 | 2016-08-21 14:28:34 | 1 | Metro |
| 2680 | 2016-08-21 | 2016-08-21 14:28:38 | 1 | Metro |
| 2681 | 2016-08-30 | 2016-08-30 09:03:49 | 2 | Metro |
| 2682 | 2016-08-24 | 2016-08-24 14:01:05 | 1 | Metro |
| 2683 | 2016-08-24 | 2016-08-24 14:00:45 | 1 | Metro |
| 2684 | 2016-08-24 | 2016-08-24 14:01:02 | 1 | Metro |
| 2685 | 2016-08-25 | 2016-08-25 10:22:14 | 4 | Walk |
| 2686 | 2016-08-25 | 2016-08-25 10:21:59 | 4 | Walk |
| 2687 | 2016-08-25 | 2016-08-25 10:21:55 | 4 | Walk |
| 2688 | 2016-08-25 | 2016-08-25 10:21:52 | 4 | Walk |
| 2689 | 2016-08-25 | 2016-08-25 10:22:07 | 4 | 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;