View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,876–7,900 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8279 | 2019-05-31 | 2019-05-31 12:52:30 | 1 | Walk |
| 8280 | 2019-05-30 | 2019-05-30 09:01:56 | 1 | Metro |
| 8281 | 2019-05-30 | 2019-05-30 09:02:20 | 1 | Metro |
| 8282 | 2019-05-31 | 2019-05-31 09:13:45 | 3 | Walk |
| 8283 | 2019-06-25 | 2019-06-25 10:56:16 | 4 | Bus |
| 8284 | 2019-06-03 | 2019-06-03 11:29:04 | 4 | Walk |
| 8285 | 2019-06-03 | 2019-06-03 11:29:17 | 4 | Walk |
| 8286 | 2019-05-28 | 2019-05-28 10:32:46 | 2 | Metro |
| 8287 | 2019-05-28 | 2019-05-28 10:33:18 | 2 | Metro |
| 8288 | 2019-05-28 | 2019-05-28 10:33:19 | 2 | Metro |
| 8289 | 2019-06-23 | 2019-06-23 16:50:37 | 4 | Walk |
| 8290 | 2019-06-23 | 2019-06-23 16:50:53 | 4 | Walk |
| 8291 | 2019-06-23 | 2019-06-23 16:50:51 | 4 | Walk |
| 8292 | 2019-05-28 | 2019-05-28 13:34:01 | 1 | Metro |
| 8293 | 2019-05-28 | 2019-05-28 13:33:42 | 1 | Metro |
| 8294 | 2019-05-28 | 2019-05-28 13:34:06 | 1 | Metro |
| 8295 | 2019-06-03 | 2019-06-03 10:59:00 | 1 | Walk |
| 8296 | 2019-06-03 | 2019-06-03 10:59:01 | 1 | Walk |
| 8297 | 2019-05-30 | 2019-05-30 09:49:32 | 4 | Walk |
| 8298 | 2019-06-14 | 2019-06-14 09:47:34 | 1 | Metro |
| 8299 | 2019-05-31 | 2019-05-31 13:39:31 | 2 | Metro |
| 8300 | 2019-06-02 | 2019-06-02 14:14:30 | 2 | Metro |
| 8301 | 2019-05-31 | 2019-05-31 10:45:54 | 1 | Metro |
| 8302 | 2019-06-02 | 2019-06-02 15:07:55 | 3 | Walk |
| 8303 | 2019-06-02 | 2019-06-02 15:08:11 | 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;