View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,026–5,050 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5305 | 2018-02-26 | 2018-02-26 14:55:54 | 5 | Metro |
| 5306 | 2018-02-22 | 2018-02-22 11:13:01 | 1 | Walk |
| 5307 | 2018-03-21 | 2018-03-21 09:42:49 | 2 | Metro |
| 5308 | 2018-03-21 | 2018-03-21 09:43:08 | 2 | Metro |
| 5309 | 2018-03-21 | 2018-03-21 09:43:03 | 2 | Metro |
| 5310 | 2018-03-06 | 2018-03-06 12:50:52 | 1 | Other |
| 5311 | 2018-03-06 | 2018-03-06 12:50:43 | 1 | Other |
| 5312 | 2018-03-06 | 2018-03-06 12:50:23 | 1 | Other |
| 5313 | 2018-02-23 | 2018-02-23 12:09:04 | 4 | Taxi |
| 5314 | 2018-02-23 | 2018-02-23 12:09:20 | 4 | Taxi |
| 5315 | 2018-03-06 | 2018-03-06 11:13:32 | 1 | Walk |
| 5316 | 2018-02-24 | 2018-02-24 10:53:00 | 4 | Bus |
| 5317 | 2018-02-24 | 2018-02-24 10:53:01 | 4 | Bus |
| 5318 | 2018-02-24 | 2018-02-24 10:54:52 | 2 | Walk |
| 5319 | 2018-02-24 | 2018-02-24 11:33:11 | 1 | Walk |
| 5320 | 2018-02-24 | 2018-02-24 11:33:13 | 1 | Walk |
| 5321 | 2018-02-25 | 2018-02-25 09:13:31 | 1 | Private Vehicle |
| 5322 | 2018-02-25 | 2018-02-25 11:48:36 | 4 | Metro |
| 5323 | 2018-02-25 | 2018-02-25 11:48:25 | 4 | Metro |
| 5324 | 2018-02-25 | 2018-02-25 11:48:40 | 4 | Metro |
| 5325 | 2018-02-25 | 2018-02-25 11:48:31 | 4 | Metro |
| 5326 | 2018-02-26 | 2018-02-26 10:23:51 | 2 | Metro |
| 5327 | 2018-02-26 | 2018-02-26 10:24:15 | 2 | Metro |
| 5328 | 2018-02-26 | 2018-02-26 10:24:09 | 2 | Metro |
| 5329 | 2018-03-04 | 2018-03-04 09:13:46 | 1 | Bus |
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;