View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,076–4,100 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4310 | 2017-07-28 | 2017-07-28 13:14:27 | 1 | Walk |
| 4311 | 2017-07-28 | 2017-07-28 11:44:47 | 5 | Walk |
| 4312 | 2017-07-28 | 2017-07-28 11:44:54 | 5 | Walk |
| 4313 | 2017-07-28 | 2017-07-28 13:52:04 | 4 | Metro |
| 4314 | 2017-08-17 | 2017-08-17 12:50:44 | 1 | Metro |
| 4315 | 2017-08-17 | 2017-08-17 12:51:10 | 1 | Metro |
| 4316 | 2017-07-30 | 2017-07-30 12:06:17 | 1 | Bus |
| 4317 | 2017-07-31 | 2017-07-31 13:59:57 | 1 | Walk |
| 4318 | 2017-07-31 | 2017-07-31 14:00:27 | 1 | Walk |
| 4319 | 2017-07-31 | 2017-07-31 09:16:57 | 5 | Walk |
| 4320 | 2017-07-31 | 2017-07-31 09:17:08 | 5 | Walk |
| 4321 | 2017-08-01 | 2017-08-01 16:13:11 | 1 | Train |
| 4322 | 2017-08-01 | 2017-08-01 16:13:30 | 1 | Train |
| 4323 | 2017-07-31 | 2017-07-31 11:20:16 | 4 | Walk |
| 4324 | 2017-08-05 | 2017-08-05 10:17:08 | 1 | Walk |
| 4325 | 2017-08-06 | 2017-08-06 12:25:17 | 1 | Walk |
| 4326 | 2017-08-06 | 2017-08-06 12:25:30 | 1 | Walk |
| 4327 | 2017-08-06 | 2017-08-06 12:25:07 | 1 | Walk |
| 4328 | 2017-08-02 | 2017-08-02 15:52:27 | 1 | Metro |
| 4329 | 2017-08-02 | 2017-08-02 15:52:49 | 1 | Metro |
| 4330 | 2017-08-02 | 2017-08-02 15:52:44 | 1 | Metro |
| 4331 | 2017-08-02 | 2017-08-02 15:52:44 | 1 | Metro |
| 4332 | 2017-08-02 | 2017-08-02 15:52:24 | 1 | Metro |
| 4333 | 2017-08-04 | 2017-08-04 11:48:59 | 1 | Bus |
| 4334 | 2017-08-11 | 2017-08-11 12:21:08 | 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;