View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,426–5,450 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5728 | 2018-08-27 | 2018-08-27 10:29:14 | 1 | Bus |
| 5729 | 2018-08-27 | 2018-08-27 10:30:39 | 1 | Bus |
| 5730 | 2018-08-27 | 2018-08-27 10:30:06 | 1 | Bus |
| 5732 | 2018-08-27 | 2018-08-27 10:30:52 | 1 | Bus |
| 5733 | 2018-08-27 | 2018-08-27 10:28:42 | 1 | Bus |
| 5735 | 2018-08-27 | 2018-08-27 10:30:04 | 1 | Bus |
| 5736 | 2018-08-27 | 2018-08-27 10:31:54 | 1 | Bus |
| 5737 | 2018-08-27 | 2018-08-27 10:28:39 | 1 | Bus |
| 5738 | 2018-05-31 | 2018-05-31 10:00:49 | 2 | Walk |
| 5739 | 2018-05-31 | 2018-05-31 10:00:41 | 2 | Walk |
| 5740 | 2018-05-13 | 2018-05-13 09:29:01 | 1 | Metro |
| 5741 | 2018-05-24 | 2018-05-24 13:43:28 | 1 | Walk |
| 5742 | 2018-05-24 | 2018-05-24 13:43:18 | 1 | Walk |
| 5743 | 2018-05-24 | 2018-05-24 13:43:31 | 1 | Walk |
| 5744 | 2018-05-24 | 2018-05-24 13:42:44 | 1 | Walk |
| 5745 | 2018-05-16 | 2018-05-16 11:10:06 | 1 | Metro |
| 5746 | 2018-05-16 | 2018-05-16 11:10:03 | 1 | Metro |
| 5747 | 2018-05-16 | 2018-05-16 11:10:22 | 1 | Metro |
| 5748 | 2018-05-12 | 2018-05-12 11:52:41 | 4 | Walk |
| 5749 | 2018-05-12 | 2018-05-12 11:52:44 | 4 | Walk |
| 5750 | 2018-05-13 | 2018-05-13 11:58:29 | 5 | Walk |
| 5751 | 2018-05-13 | 2018-05-13 11:58:02 | 5 | Walk |
| 5752 | 2018-05-13 | 2018-05-13 11:58:10 | 5 | Walk |
| 5753 | 2018-05-13 | 2018-05-13 11:58:19 | 5 | Walk |
| 5754 | 2018-05-18 | 2018-05-18 12:33:21 | 1 | Taxi |
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;