View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,426–6,450 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6755 | 2018-09-25 | 2018-09-25 10:39:48 | 2 | Metro |
| 6756 | 2018-09-25 | 2018-09-25 10:39:41 | 2 | Metro |
| 6757 | 2018-09-25 | 2018-09-25 10:40:02 | 2 | Metro |
| 6758 | 2018-09-25 | 2018-09-25 10:39:53 | 2 | Metro |
| 6759 | 2018-09-25 | 2018-09-25 10:40:11 | 2 | Metro |
| 6760 | 2018-09-25 | 2018-09-25 12:53:53 | 2 | Walk |
| 6761 | 2018-09-25 | 2018-09-25 14:46:12 | 2 | Train |
| 6762 | 2018-09-25 | 2018-09-25 14:46:27 | 2 | Train |
| 6763 | 2018-10-06 | 2018-10-06 15:18:16 | 1 | Walk |
| 6764 | 2018-09-26 | 2018-09-26 09:34:35 | 4 | Walk |
| 6765 | 2018-09-26 | 2018-09-26 09:35:00 | 4 | Walk |
| 6766 | 2018-09-26 | 2018-09-26 09:00:23 | 4 | Walk |
| 6767 | 2018-09-26 | 2018-09-26 09:00:54 | 4 | Walk |
| 6768 | 2018-09-26 | 2018-09-26 09:00:39 | 4 | Walk |
| 6769 | 2018-09-26 | 2018-09-26 09:00:31 | 4 | Walk |
| 6770 | 2018-09-26 | 2018-09-26 11:25:26 | 2 | Metro |
| 6771 | 2018-10-08 | 2018-10-08 09:42:19 | 3 | Metro |
| 6772 | 2018-10-10 | 2018-10-10 13:17:03 | 2 | Private Vehicle |
| 6773 | 2018-10-10 | 2018-10-10 13:16:25 | 2 | Private Vehicle |
| 6774 | 2018-09-28 | 2018-09-28 14:23:37 | 5 | Metro |
| 6775 | 2018-09-28 | 2018-09-28 14:24:02 | 5 | Metro |
| 6776 | 2018-09-30 | 2018-09-30 13:23:37 | 4 | Private Vehicle |
| 6777 | 2018-09-29 | 2018-09-29 11:33:59 | 1 | Metro |
| 6778 | 2018-09-29 | 2018-09-29 11:34:19 | 1 | Metro |
| 6779 | 2018-10-18 | 2018-10-18 15:49:45 | 3 | 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;