View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,176–9,200 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9628 | 2020-01-01 | 2020-01-01 11:21:53 | 3 | Walk |
| 9629 | 2020-01-01 | 2020-01-01 11:21:47 | 3 | Walk |
| 9630 | 2020-01-02 | 2020-01-02 14:21:38 | 1 | Metro |
| 9631 | 2020-01-02 | 2020-01-02 14:21:20 | 1 | Metro |
| 9632 | 2020-01-06 | 2020-01-06 14:52:56 | 1 | Walk |
| 9633 | 2020-01-06 | 2020-01-06 14:53:05 | 1 | Walk |
| 9634 | 2020-01-08 | 2020-01-08 10:28:23 | 3 | Bus |
| 9635 | 2020-01-08 | 2020-01-08 10:28:32 | 3 | Bus |
| 9636 | 2020-01-08 | 2020-01-08 10:28:50 | 3 | Bus |
| 9637 | 2020-01-08 | 2020-01-08 10:28:08 | 3 | Bus |
| 9638 | 2020-01-06 | 2020-01-06 11:55:43 | 3 | Metro |
| 9639 | 2020-01-06 | 2020-01-06 11:55:50 | 3 | Metro |
| 9640 | 2020-01-05 | 2020-01-05 14:51:05 | 1 | Train |
| 9641 | 2020-01-05 | 2020-01-05 13:26:52 | 2 | Metro |
| 9642 | 2020-01-05 | 2020-01-05 13:26:10 | 2 | Metro |
| 9643 | 2020-01-06 | 2020-01-06 09:38:15 | 1 | Walk |
| 9644 | 2020-01-22 | 2020-01-22 12:27:55 | 1 | Walk |
| 9645 | 2020-01-22 | 2020-01-22 12:27:32 | 1 | Walk |
| 9646 | 2020-01-07 | 2020-01-07 10:26:28 | 2 | Metro |
| 9647 | 2020-01-07 | 2020-01-07 11:36:28 | 1 | Metro |
| 9648 | 2020-01-09 | 2020-01-09 15:33:58 | 2 | Other |
| 9649 | 2020-01-09 | 2020-01-09 15:33:51 | 2 | Other |
| 9650 | 2020-01-12 | 2020-01-12 15:30:58 | 3 | Walk |
| 9651 | 2020-01-12 | 2020-01-12 15:30:32 | 3 | Walk |
| 9652 | 2020-01-08 | 2020-01-08 11:07:58 | 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;