View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,276–8,300 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8695 | 2019-08-10 | 2019-08-10 14:20:44 | 3 | Metro |
| 8696 | 2019-08-05 | 2019-08-05 13:34:08 | 2 | Metro |
| 8697 | 2019-08-05 | 2019-08-05 13:34:06 | 2 | Metro |
| 8698 | 2019-08-16 | 2019-08-16 11:26:14 | 1 | Metro |
| 8699 | 2019-08-16 | 2019-08-16 11:25:49 | 1 | Metro |
| 8700 | 2019-08-16 | 2019-08-16 11:26:05 | 1 | Metro |
| 8701 | 2019-08-16 | 2019-08-16 11:25:29 | 1 | Metro |
| 8702 | 2019-08-27 | 2019-08-27 16:09:57 | 2 | Train |
| 8703 | 2019-08-27 | 2019-08-27 16:10:00 | 2 | Train |
| 8704 | 2019-08-04 | 2019-08-04 11:10:52 | 1 | Train |
| 8705 | 2019-08-06 | 2019-08-06 14:21:05 | 1 | Bus |
| 8706 | 2019-08-06 | 2019-08-06 14:21:12 | 1 | Bus |
| 8707 | 2019-08-06 | 2019-08-06 14:21:21 | 1 | Bus |
| 8708 | 2019-08-06 | 2019-08-06 14:21:11 | 1 | Bus |
| 8709 | 2019-08-05 | 2019-08-05 10:39:42 | 2 | Bus |
| 8710 | 2019-08-09 | 2019-08-09 11:12:54 | 1 | Walk |
| 8711 | 2019-08-27 | 2019-08-27 10:36:00 | 4 | Metro |
| 8712 | 2019-08-06 | 2019-08-06 09:36:42 | 1 | Metro |
| 8713 | 2019-08-06 | 2019-08-06 09:37:00 | 1 | Metro |
| 8714 | 2019-08-06 | 2019-08-06 13:03:34 | 2 | Walk |
| 8715 | 2019-08-06 | 2019-08-06 13:03:54 | 2 | Walk |
| 8716 | 2019-08-06 | 2019-08-06 13:03:15 | 2 | Walk |
| 8717 | 2019-08-07 | 2019-08-07 10:21:46 | 2 | Metro |
| 8718 | 2019-08-07 | 2019-08-07 10:21:59 | 2 | Metro |
| 8719 | 2019-08-14 | 2019-08-14 13:59: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;