View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,876–8,900 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9317 | 2019-10-29 | 2019-10-29 13:11:40 | 2 | Bus |
| 9318 | 2019-10-28 | 2019-10-28 13:44:47 | 4 | Walk |
| 9319 | 2019-10-28 | 2019-10-28 13:44:29 | 4 | Walk |
| 9320 | 2019-10-29 | 2019-10-29 09:50:43 | 1 | Metro |
| 9321 | 2019-10-29 | 2019-10-29 09:50:05 | 1 | Metro |
| 9322 | 2019-10-28 | 2019-10-28 11:39:06 | 2 | Private Vehicle |
| 9323 | 2019-11-09 | 2019-11-09 11:33:42 | 1 | Walk |
| 9324 | 2019-11-09 | 2019-11-09 11:33:49 | 1 | Walk |
| 9325 | 2019-10-28 | 2019-10-28 14:16:00 | 1 | Train |
| 9326 | 2019-10-29 | 2019-10-29 11:44:23 | 4 | Walk |
| 9327 | 2019-10-29 | 2019-10-29 11:43:47 | 4 | Walk |
| 9329 | 2019-10-29 | 2019-10-29 11:33:42 | 5 | Walk |
| 9330 | 2019-10-29 | 2019-10-29 11:33:50 | 5 | Walk |
| 9331 | 2019-10-29 | 2019-10-29 15:00:00 | 2 | Walk |
| 9332 | 2019-10-29 | 2019-10-29 15:00:14 | 2 | Walk |
| 9333 | 2019-10-29 | 2019-10-29 15:00:20 | 2 | Walk |
| 9334 | 2019-10-29 | 2019-10-29 15:00:12 | 2 | Walk |
| 9335 | 2019-10-29 | 2019-10-29 16:52:25 | 2 | Metro |
| 9336 | 2019-10-29 | 2019-10-29 16:52:36 | 2 | Metro |
| 9337 | 2019-11-06 | 2019-11-06 09:32:06 | 1 | Walk |
| 9338 | 2019-11-06 | 2019-11-06 09:32:02 | 1 | Walk |
| 9339 | 2019-11-02 | 2019-11-02 09:41:03 | 4 | Walk |
| 9340 | 2019-11-10 | 2019-11-10 10:54:09 | 3 | Bus |
| 9341 | 2019-11-10 | 2019-11-10 10:53:31 | 3 | Bus |
| 9342 | 2019-11-02 | 2019-11-02 11:16:01 | 1 | 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;