View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,951–4,975 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5227 | 2018-01-26 | 2018-01-26 12:29:05 | 2 | Metro |
| 5228 | 2018-01-26 | 2018-01-26 12:29:30 | 2 | Metro |
| 5229 | 2018-01-24 | 2018-01-24 13:31:02 | 3 | Bus |
| 5230 | 2018-01-26 | 2018-01-26 10:53:37 | 1 | Walk |
| 5231 | 2018-01-26 | 2018-01-26 10:53:53 | 1 | Walk |
| 5233 | 2018-01-26 | 2018-01-26 13:02:25 | 1 | Walk |
| 5234 | 2018-01-26 | 2018-01-26 13:02:59 | 1 | Walk |
| 5235 | 2018-01-29 | 2018-01-29 14:07:24 | 2 | Taxi |
| 5236 | 2018-01-29 | 2018-01-29 14:08:01 | 2 | Taxi |
| 5237 | 2018-02-25 | 2018-02-25 09:59:36 | 4 | Metro |
| 5238 | 2018-01-29 | 2018-01-29 10:03:17 | 2 | Bus |
| 5239 | 2018-01-29 | 2018-01-29 10:03:45 | 2 | Bus |
| 5240 | 2018-01-29 | 2018-01-29 10:03:24 | 2 | Bus |
| 5241 | 2018-02-05 | 2018-02-05 10:34:11 | 5 | Taxi |
| 5242 | 2018-02-15 | 2018-02-15 09:32:26 | 4 | Metro |
| 5243 | 2018-02-15 | 2018-02-15 09:32:18 | 4 | Metro |
| 5244 | 2018-02-04 | 2018-02-04 10:33:07 | 1 | Walk |
| 5245 | 2018-02-04 | 2018-02-04 10:57:56 | 4 | Bus |
| 5246 | 2018-02-04 | 2018-02-04 10:58:03 | 4 | Bus |
| 5247 | 2018-02-07 | 2018-02-07 11:07:51 | 5 | Walk |
| 5248 | 2018-02-06 | 2018-02-06 09:51:15 | 3 | Bus |
| 5249 | 2018-02-06 | 2018-02-06 09:51:14 | 3 | Bus |
| 5250 | 2018-02-15 | 2018-02-15 10:16:10 | 1 | Other |
| 5251 | 2018-02-15 | 2018-02-15 10:16:38 | 1 | Other |
| 5252 | 2018-02-09 | 2018-02-09 13:16:31 | 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;