View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,201–5,225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5480 | 2018-03-29 | 2018-03-29 10:05:01 | 1 | Taxi |
| 5481 | 2018-03-29 | 2018-03-29 10:05:26 | 1 | Taxi |
| 5482 | 2018-03-30 | 2018-03-30 11:35:12 | 4 | Metro |
| 5483 | 2018-03-30 | 2018-03-30 11:35:32 | 4 | Metro |
| 5484 | 2018-04-07 | 2018-04-07 15:05:05 | 2 | Walk |
| 5485 | 2018-04-07 | 2018-04-07 15:04:42 | 2 | Walk |
| 5486 | 2018-03-31 | 2018-03-31 12:13:07 | 2 | Metro |
| 5487 | 2018-03-31 | 2018-03-31 12:12:44 | 2 | Metro |
| 5488 | 2018-03-31 | 2018-03-31 12:12:59 | 2 | Metro |
| 5489 | 2018-03-31 | 2018-03-31 12:13:06 | 2 | Metro |
| 5490 | 2018-03-31 | 2018-03-31 12:13:12 | 2 | Metro |
| 5491 | 2018-03-31 | 2018-03-31 09:10:47 | 2 | Metro |
| 5492 | 2018-03-31 | 2018-03-31 09:10:21 | 2 | Metro |
| 5493 | 2018-03-31 | 2018-03-31 09:10:42 | 2 | Metro |
| 5494 | 2018-03-31 | 2018-03-31 13:22:00 | 5 | Walk |
| 5495 | 2018-03-31 | 2018-03-31 13:22:08 | 5 | Walk |
| 5496 | 2018-03-31 | 2018-03-31 13:22:26 | 5 | Walk |
| 5497 | 2018-03-31 | 2018-03-31 13:22:28 | 5 | Walk |
| 5498 | 2018-03-31 | 2018-03-31 13:22:08 | 5 | Walk |
| 5499 | 2018-04-26 | 2018-04-26 14:05:45 | 1 | Walk |
| 5500 | 2018-04-01 | 2018-04-01 09:43:50 | 1 | Other |
| 5501 | 2018-04-16 | 2018-04-16 09:27:43 | 1 | Walk |
| 5502 | 2018-04-11 | 2018-04-11 09:51:00 | 3 | Metro |
| 5503 | 2018-04-11 | 2018-04-11 09:51:05 | 3 | Metro |
| 5504 | 2018-04-02 | 2018-04-02 09:13:13 | 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;