View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,701–7,725 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8102 | 2019-04-25 | 2019-04-25 12:30:49 | 2 | Taxi |
| 8103 | 2019-04-25 | 2019-04-25 12:30:20 | 2 | Taxi |
| 8104 | 2019-04-21 | 2019-04-21 16:11:12 | 3 | Walk |
| 8105 | 2019-05-04 | 2019-05-04 09:40:19 | 2 | Taxi |
| 8106 | 2019-05-04 | 2019-05-04 09:39:35 | 2 | Taxi |
| 8107 | 2019-04-22 | 2019-04-22 09:53:08 | 5 | Walk |
| 8108 | 2019-04-22 | 2019-04-22 09:52:32 | 5 | Walk |
| 8109 | 2019-06-09 | 2019-06-09 09:19:00 | 1 | Walk |
| 8110 | 2019-06-09 | 2019-06-09 09:19:13 | 1 | Walk |
| 8111 | 2019-05-03 | 2019-05-03 16:52:20 | 1 | Walk |
| 8112 | 2019-05-03 | 2019-05-03 16:51:58 | 1 | Walk |
| 8113 | 2019-05-03 | 2019-05-03 16:51:38 | 1 | Walk |
| 8114 | 2019-05-03 | 2019-05-03 16:51:57 | 1 | Walk |
| 8115 | 2019-05-03 | 2019-05-03 15:07:34 | 1 | Walk |
| 8116 | 2019-05-03 | 2019-05-03 15:06:48 | 1 | Walk |
| 8117 | 2019-04-23 | 2019-04-23 11:33:44 | 1 | Walk |
| 8118 | 2019-04-23 | 2019-04-23 11:34:15 | 1 | Walk |
| 8119 | 2019-04-23 | 2019-04-23 09:11:02 | 1 | Walk |
| 8120 | 2019-04-23 | 2019-04-23 09:10:37 | 1 | Walk |
| 8121 | 2019-04-23 | 2019-04-23 09:10:47 | 1 | Walk |
| 8122 | 2019-05-10 | 2019-05-10 10:58:34 | 4 | Walk |
| 8123 | 2019-05-10 | 2019-05-10 10:58:34 | 4 | Walk |
| 8124 | 2019-04-26 | 2019-04-26 10:20:36 | 3 | Walk |
| 8125 | 2019-04-26 | 2019-04-26 10:20:46 | 3 | Walk |
| 8126 | 2019-04-26 | 2019-04-26 10:20:49 | 3 | 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;