View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,451–2,475 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2589 | 2016-08-14 | 2016-08-14 14:27:22 | 1 | Metro |
| 2590 | 2016-08-14 | 2016-08-14 14:26:45 | 1 | Metro |
| 2591 | 2016-08-14 | 2016-08-14 14:26:49 | 1 | Metro |
| 2592 | 2016-08-13 | 2016-08-13 14:27:57 | 5 | Walk |
| 2593 | 2016-08-13 | 2016-08-13 14:27:42 | 5 | Walk |
| 2594 | 2016-08-05 | 2016-08-05 12:16:15 | 1 | Bus |
| 2595 | 2016-08-05 | 2016-08-05 12:16:09 | 1 | Bus |
| 2596 | 2016-08-09 | 2016-08-09 15:11:48 | 1 | Walk |
| 2597 | 2016-08-09 | 2016-08-09 15:11:46 | 1 | Walk |
| 2598 | 2016-08-06 | 2016-08-06 09:55:16 | 1 | Walk |
| 2599 | 2016-08-06 | 2016-08-06 09:55:07 | 1 | Walk |
| 2600 | 2016-08-06 | 2016-08-06 09:55:23 | 1 | Walk |
| 2601 | 2016-08-06 | 2016-08-06 09:54:44 | 1 | Walk |
| 2602 | 2016-08-06 | 2016-08-06 14:40:23 | 1 | Metro |
| 2603 | 2016-08-09 | 2016-08-09 12:27:35 | 4 | Walk |
| 2604 | 2016-08-09 | 2016-08-09 12:27:29 | 4 | Walk |
| 2605 | 2016-08-09 | 2016-08-09 12:26:55 | 4 | Walk |
| 2606 | 2016-08-07 | 2016-08-07 12:17:23 | 1 | Bus |
| 2607 | 2016-08-07 | 2016-08-07 12:17:20 | 1 | Bus |
| 2608 | 2016-08-07 | 2016-08-07 12:16:52 | 1 | Bus |
| 2609 | 2016-08-07 | 2016-08-07 12:17:11 | 1 | Bus |
| 2611 | 2016-08-09 | 2016-08-09 14:26:47 | 4 | Taxi |
| 2612 | 2016-08-09 | 2016-08-09 14:27:02 | 4 | Taxi |
| 2613 | 2016-08-11 | 2016-08-11 10:59:40 | 1 | Walk |
| 2614 | 2016-08-11 | 2016-08-11 10:59:59 | 1 | 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;