View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,501–2,525 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2640 | 2016-08-14 | 2016-08-14 11:05:50 | 4 | Walk |
| 2641 | 2016-08-14 | 2016-08-14 11:05:39 | 4 | Walk |
| 2642 | 2016-08-14 | 2016-08-14 11:05:36 | 4 | Walk |
| 2643 | 2016-08-15 | 2016-08-15 13:52:12 | 2 | Metro |
| 2644 | 2016-08-15 | 2016-08-15 13:52:12 | 2 | Metro |
| 2645 | 2016-08-15 | 2016-08-15 13:51:56 | 2 | Metro |
| 2646 | 2016-08-15 | 2016-08-15 13:52:07 | 2 | Metro |
| 2647 | 2016-08-15 | 2016-08-15 13:52:10 | 2 | Metro |
| 2648 | 2016-08-16 | 2016-08-16 11:57:15 | 1 | Train |
| 2649 | 2016-08-16 | 2016-08-16 11:57:15 | 1 | Train |
| 2650 | 2016-08-16 | 2016-08-16 11:57:24 | 1 | Train |
| 2651 | 2016-08-16 | 2016-08-16 11:57:04 | 1 | Train |
| 2652 | 2016-08-16 | 2016-08-16 11:56:58 | 1 | Train |
| 2653 | 2016-08-21 | 2016-08-21 14:31:47 | 5 | Taxi |
| 2654 | 2016-09-03 | 2016-09-03 09:40:00 | 1 | Metro |
| 2655 | 2016-09-03 | 2016-09-03 09:40:27 | 1 | Metro |
| 2656 | 2016-08-26 | 2016-08-26 14:32:16 | 1 | Metro |
| 2657 | 2016-08-26 | 2016-08-26 14:32:26 | 1 | Metro |
| 2658 | 2016-08-23 | 2016-08-23 12:32:51 | 2 | Metro |
| 2659 | 2016-08-23 | 2016-08-23 12:32:42 | 2 | Metro |
| 2660 | 2016-08-23 | 2016-08-23 12:32:50 | 2 | Metro |
| 2661 | 2016-08-23 | 2016-08-23 12:32:51 | 2 | Metro |
| 2662 | 2016-08-24 | 2016-08-24 10:04:40 | 2 | Walk |
| 2663 | 2016-08-24 | 2016-08-24 10:04:37 | 2 | Walk |
| 2664 | 2016-08-18 | 2016-08-18 11:00:05 | 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;