View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,201–7,225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7580 | 2019-02-02 | 2019-02-02 15:51:58 | 2 | Metro |
| 7582 | 2019-02-06 | 2019-02-06 10:41:31 | 2 | Walk |
| 7583 | 2019-02-06 | 2019-02-06 10:42:03 | 2 | Walk |
| 7584 | 2019-02-06 | 2019-02-06 10:42:08 | 2 | Walk |
| 7585 | 2019-02-06 | 2019-02-06 10:41:43 | 2 | Walk |
| 7586 | 2019-02-14 | 2019-02-14 10:09:43 | 1 | Train |
| 7587 | 2019-02-04 | 2019-02-04 10:55:59 | 3 | Train |
| 7588 | 2019-02-07 | 2019-02-07 09:31:10 | 5 | Walk |
| 7589 | 2019-02-05 | 2019-02-05 11:57:19 | 4 | Metro |
| 7590 | 2019-02-05 | 2019-02-05 11:57:11 | 4 | Metro |
| 7591 | 2019-02-05 | 2019-02-05 11:57:19 | 4 | Metro |
| 7592 | 2019-02-15 | 2019-02-15 15:16:24 | 1 | Metro |
| 7593 | 2019-02-15 | 2019-02-15 15:15:51 | 1 | Metro |
| 7594 | 2019-02-07 | 2019-02-07 14:30:14 | 2 | Metro |
| 7595 | 2019-02-07 | 2019-02-07 14:30:48 | 2 | Metro |
| 7598 | 2019-02-12 | 2019-02-12 14:32:08 | 5 | Walk |
| 7599 | 2019-02-12 | 2019-02-12 14:32:26 | 5 | Walk |
| 7600 | 2019-02-07 | 2019-02-07 14:39:09 | 2 | Bus |
| 7601 | 2019-02-19 | 2019-02-19 13:02:57 | 1 | Metro |
| 7602 | 2019-02-17 | 2019-02-17 09:50:18 | 3 | Metro |
| 7603 | 2019-02-17 | 2019-02-17 09:50:32 | 3 | Metro |
| 7604 | 2019-02-17 | 2019-02-17 09:49:59 | 3 | Metro |
| 7605 | 2019-02-10 | 2019-02-10 10:15:28 | 1 | Metro |
| 7606 | 2019-02-28 | 2019-02-28 14:38:44 | 1 | Walk |
| 7607 | 2019-02-28 | 2019-02-28 14:38:09 | 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;