View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,776–6,800 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7120 | 2019-02-27 | 2019-02-27 12:52:55 | 4 | Metro |
| 7121 | 2019-02-27 | 2019-02-27 12:53:05 | 4 | Metro |
| 7122 | 2019-02-27 | 2019-02-27 12:50:47 | 4 | Metro |
| 7123 | 2019-02-27 | 2019-02-27 12:54:41 | 4 | Metro |
| 7124 | 2019-02-27 | 2019-02-27 12:56:11 | 4 | Metro |
| 7125 | 2019-02-27 | 2019-02-27 12:57:05 | 4 | Metro |
| 7126 | 2019-02-27 | 2019-02-27 12:57:20 | 4 | Metro |
| 7127 | 2019-02-27 | 2019-02-27 12:57:35 | 4 | Metro |
| 7128 | 2019-02-27 | 2019-02-27 12:52:49 | 4 | Metro |
| 7129 | 2019-02-27 | 2019-02-27 12:56:37 | 4 | Metro |
| 7130 | 2019-02-27 | 2019-02-27 12:56:05 | 4 | Metro |
| 7131 | 2019-02-27 | 2019-02-27 12:54:45 | 4 | Metro |
| 7132 | 2019-02-27 | 2019-02-27 12:51:00 | 4 | Metro |
| 7133 | 2019-02-27 | 2019-02-27 12:51:53 | 4 | Metro |
| 7134 | 2019-02-27 | 2019-02-27 12:53:37 | 4 | Metro |
| 7135 | 2019-02-27 | 2019-02-27 12:53:45 | 4 | Metro |
| 7136 | 2019-02-27 | 2019-02-27 12:52:11 | 4 | Metro |
| 7137 | 2019-02-27 | 2019-02-27 12:55:45 | 4 | Metro |
| 7138 | 2019-02-27 | 2019-02-27 12:58:34 | 4 | Metro |
| 7139 | 2019-02-27 | 2019-02-27 12:53:23 | 4 | Metro |
| 7140 | 2019-02-27 | 2019-02-27 12:53:30 | 4 | Metro |
| 7141 | 2019-02-27 | 2019-02-27 12:52:41 | 4 | Metro |
| 7142 | 2019-02-27 | 2019-02-27 12:58:29 | 4 | Metro |
| 7143 | 2019-02-27 | 2019-02-27 12:52:53 | 4 | Metro |
| 7144 | 2019-02-27 | 2019-02-27 13:00:51 | 4 | 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;