View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,301–4,325 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4541 | 2017-09-06 | 2017-09-06 14:35:47 | 2 | Bus |
| 4542 | 2017-09-04 | 2017-09-04 16:24:19 | 2 | Other |
| 4543 | 2017-09-04 | 2017-09-04 16:24:39 | 2 | Other |
| 4544 | 2017-09-04 | 2017-09-04 16:24:12 | 2 | Other |
| 4545 | 2017-09-06 | 2017-09-06 15:15:34 | 1 | Walk |
| 4546 | 2017-09-06 | 2017-09-06 15:15:58 | 1 | Walk |
| 4547 | 2017-09-06 | 2017-09-06 15:15:41 | 1 | Walk |
| 4548 | 2017-09-06 | 2017-09-06 15:15:25 | 1 | Walk |
| 4549 | 2017-09-06 | 2017-09-06 11:38:58 | 3 | Walk |
| 4550 | 2017-09-06 | 2017-09-06 13:40:23 | 3 | Metro |
| 4551 | 2017-09-06 | 2017-09-06 13:40:12 | 3 | Metro |
| 4552 | 2017-09-06 | 2017-09-06 13:40:32 | 3 | Metro |
| 4553 | 2017-09-09 | 2017-09-09 10:18:17 | 1 | Bus |
| 4554 | 2017-09-15 | 2017-09-15 14:18:33 | 1 | Walk |
| 4555 | 2017-09-15 | 2017-09-15 14:18:45 | 1 | Walk |
| 4556 | 2017-09-15 | 2017-09-15 14:18:19 | 1 | Walk |
| 4557 | 2017-09-15 | 2017-09-15 14:18:45 | 1 | Walk |
| 4558 | 2017-09-15 | 2017-09-15 14:18:37 | 1 | Walk |
| 4559 | 2017-09-07 | 2017-09-07 16:20:32 | 5 | Metro |
| 4560 | 2017-09-07 | 2017-09-07 16:20:50 | 5 | Metro |
| 4561 | 2017-09-07 | 2017-09-07 16:20:55 | 5 | Metro |
| 4562 | 2017-09-08 | 2017-09-08 11:24:32 | 4 | Walk |
| 4563 | 2017-09-10 | 2017-09-10 11:22:58 | 1 | Metro |
| 4564 | 2017-09-10 | 2017-09-10 11:23:28 | 1 | Metro |
| 4565 | 2017-09-18 | 2017-09-18 15:08:20 | 2 | Metro |
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;