View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,226–5,250 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5505 | 2018-04-02 | 2018-04-02 09:13:05 | 1 | Metro |
| 5506 | 2018-04-09 | 2018-04-09 09:04:31 | 4 | Other |
| 5507 | 2018-04-09 | 2018-04-09 09:04:00 | 4 | Other |
| 5508 | 2018-04-09 | 2018-04-09 09:04:18 | 4 | Other |
| 5509 | 2018-04-06 | 2018-04-06 10:48:18 | 2 | Walk |
| 5510 | 2018-04-06 | 2018-04-06 10:48:29 | 2 | Walk |
| 5511 | 2018-04-02 | 2018-04-02 14:32:16 | 2 | Train |
| 5513 | 2018-04-05 | 2018-04-05 11:46:02 | 1 | Walk |
| 5514 | 2018-04-05 | 2018-04-05 11:45:42 | 1 | Walk |
| 5515 | 2018-04-10 | 2018-04-10 15:31:20 | 1 | Metro |
| 5516 | 2018-04-10 | 2018-04-10 15:31:27 | 1 | Metro |
| 5517 | 2018-04-04 | 2018-04-04 09:09:17 | 5 | Metro |
| 5518 | 2018-04-04 | 2018-04-04 09:09:09 | 5 | Metro |
| 5519 | 2018-04-10 | 2018-04-10 12:54:14 | 2 | Metro |
| 5520 | 2018-04-05 | 2018-04-05 11:30:32 | 5 | Train |
| 5521 | 2018-05-28 | 2018-05-28 11:41:27 | 2 | Private Vehicle |
| 5522 | 2018-04-16 | 2018-04-16 14:37:35 | 3 | Bus |
| 5523 | 2018-04-15 | 2018-04-15 15:44:12 | 5 | Walk |
| 5524 | 2018-04-07 | 2018-04-07 11:43:43 | 2 | Metro |
| 5525 | 2018-04-08 | 2018-04-08 10:14:39 | 1 | Metro |
| 5526 | 2018-04-08 | 2018-04-08 10:14:32 | 1 | Metro |
| 5527 | 2018-05-02 | 2018-05-02 11:38:55 | 2 | Metro |
| 5528 | 2018-05-02 | 2018-05-02 11:38:32 | 2 | Metro |
| 5529 | 2018-05-02 | 2018-05-02 11:39:16 | 2 | Metro |
| 5530 | 2018-05-02 | 2018-05-02 11:38:48 | 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;