View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,276–3,300 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3474 | 2017-02-01 | 2017-02-01 10:47:49 | 1 | Metro |
| 3475 | 2017-02-01 | 2017-02-01 10:47:45 | 1 | Metro |
| 3476 | 2017-02-01 | 2017-02-01 10:47:13 | 1 | Metro |
| 3477 | 2017-02-01 | 2017-02-01 10:47:59 | 1 | Metro |
| 3478 | 2017-01-27 | 2017-01-27 13:22:43 | 3 | Walk |
| 3479 | 2017-01-27 | 2017-01-27 13:22:43 | 3 | Walk |
| 3480 | 2017-02-06 | 2017-02-06 11:33:03 | 1 | Metro |
| 3481 | 2017-02-06 | 2017-02-06 11:33:01 | 1 | Metro |
| 3482 | 2017-02-08 | 2017-02-08 10:31:28 | 1 | Metro |
| 3483 | 2017-01-26 | 2017-01-26 13:35:51 | 5 | Bus |
| 3484 | 2017-01-27 | 2017-01-27 09:14:08 | 5 | Bus |
| 3485 | 2017-01-27 | 2017-01-27 10:08:35 | 3 | Other |
| 3486 | 2017-01-27 | 2017-01-27 11:01:07 | 5 | Metro |
| 3487 | 2017-01-27 | 2017-01-27 11:01:23 | 5 | Metro |
| 3488 | 2017-01-27 | 2017-01-27 15:25:19 | 4 | Walk |
| 3489 | 2017-01-27 | 2017-01-27 15:25:28 | 4 | Walk |
| 3490 | 2017-01-27 | 2017-01-27 15:25:50 | 4 | Walk |
| 3491 | 2017-01-27 | 2017-01-27 15:25:44 | 4 | Walk |
| 3492 | 2017-02-14 | 2017-02-14 12:42:23 | 5 | Bus |
| 3493 | 2017-01-31 | 2017-01-31 11:12:54 | 2 | Metro |
| 3494 | 2017-02-18 | 2017-02-18 11:33:50 | 3 | Metro |
| 3495 | 2017-02-07 | 2017-02-07 10:29:07 | 4 | Walk |
| 3496 | 2017-02-07 | 2017-02-07 10:29:19 | 4 | Walk |
| 3497 | 2017-02-03 | 2017-02-03 14:58:36 | 5 | Train |
| 3498 | 2017-02-03 | 2017-02-03 14:59:16 | 5 | Train |
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;