View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 951–975 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1020 | 2015-09-08 | 2015-09-08 14:37:14 | 1 | Metro |
| 1021 | 2015-09-08 | 2015-09-08 14:36:57 | 1 | Metro |
| 1022 | 2015-08-24 | 2015-08-24 10:35:50 | 1 | Metro |
| 1023 | 2015-09-05 | 2015-09-05 14:01:26 | 4 | Metro |
| 1024 | 2015-09-05 | 2015-09-05 14:01:30 | 4 | Metro |
| 1025 | 2015-09-05 | 2015-09-05 14:01:17 | 4 | Metro |
| 1026 | 2015-09-05 | 2015-09-05 14:01:31 | 4 | Metro |
| 1027 | 2015-08-25 | 2015-08-25 10:30:25 | 1 | Walk |
| 1028 | 2015-08-25 | 2015-08-25 10:30:39 | 1 | Walk |
| 1029 | 2015-08-30 | 2015-08-30 14:39:16 | 2 | Private Vehicle |
| 1030 | 2015-08-27 | 2015-08-27 15:06:04 | 1 | Metro |
| 1031 | 2015-08-27 | 2015-08-27 15:06:12 | 1 | Metro |
| 1032 | 2015-08-30 | 2015-08-30 10:58:15 | 4 | Walk |
| 1033 | 2015-08-30 | 2015-08-30 10:58:27 | 4 | Walk |
| 1034 | 2015-09-09 | 2015-09-09 10:25:25 | 1 | Walk |
| 1035 | 2015-09-09 | 2015-09-09 10:25:48 | 1 | Walk |
| 1036 | 2015-08-28 | 2015-08-28 12:35:32 | 4 | Walk |
| 1037 | 2015-08-28 | 2015-08-28 12:35:35 | 4 | Walk |
| 1038 | 2015-08-28 | 2015-08-28 12:36:08 | 4 | Walk |
| 1039 | 2015-08-28 | 2015-08-28 12:36:04 | 4 | Walk |
| 1040 | 2015-08-28 | 2015-08-28 12:59:23 | 1 | Walk |
| 1041 | 2015-08-28 | 2015-08-28 12:59:30 | 1 | Walk |
| 1042 | 2015-08-30 | 2015-08-30 13:16:54 | 5 | Taxi |
| 1043 | 2015-08-30 | 2015-08-30 13:16:58 | 5 | Taxi |
| 1044 | 2015-09-01 | 2015-09-01 14:18:46 | 2 | 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;