View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,301–8,325 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8720 | 2019-08-14 | 2019-08-14 13:58:37 | 1 | Metro |
| 8721 | 2019-08-14 | 2019-08-14 13:58:48 | 1 | Metro |
| 8722 | 2019-08-07 | 2019-08-07 10:04:10 | 2 | Taxi |
| 8723 | 2019-08-07 | 2019-08-07 12:13:56 | 2 | Other |
| 8724 | 2019-08-07 | 2019-08-07 12:13:42 | 2 | Other |
| 8725 | 2019-08-07 | 2019-08-07 12:14:13 | 2 | Other |
| 8726 | 2019-08-07 | 2019-08-07 12:13:32 | 2 | Other |
| 8727 | 2019-08-26 | 2019-08-26 15:51:13 | 1 | Private Vehicle |
| 8728 | 2019-08-26 | 2019-08-26 15:50:41 | 1 | Private Vehicle |
| 8729 | 2019-09-11 | 2019-09-11 12:10:42 | 2 | Metro |
| 8730 | 2019-09-11 | 2019-09-11 12:10:12 | 2 | Metro |
| 8731 | 2019-08-17 | 2019-08-17 09:41:51 | 1 | Walk |
| 8732 | 2019-08-17 | 2019-08-17 09:42:28 | 1 | Walk |
| 8733 | 2019-08-09 | 2019-08-09 09:06:18 | 1 | Walk |
| 8734 | 2019-08-09 | 2019-08-09 09:05:50 | 1 | Walk |
| 8735 | 2019-08-09 | 2019-08-09 09:06:24 | 1 | Walk |
| 8736 | 2019-08-09 | 2019-08-09 09:56:01 | 3 | Walk |
| 8737 | 2019-08-09 | 2019-08-09 10:50:34 | 1 | Bus |
| 8738 | 2019-08-09 | 2019-08-09 10:50:43 | 1 | Bus |
| 8739 | 2019-08-12 | 2019-08-12 11:33:30 | 1 | Metro |
| 8740 | 2019-08-12 | 2019-08-12 11:33:44 | 1 | Metro |
| 8741 | 2019-08-10 | 2019-08-10 11:31:39 | 1 | Walk |
| 8742 | 2019-08-10 | 2019-08-10 11:31:59 | 1 | Walk |
| 8743 | 2019-08-10 | 2019-08-10 11:31:27 | 1 | Walk |
| 8744 | 2019-08-10 | 2019-08-10 11:31:31 | 1 | Walk |
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;