View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,001–1,025 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1070 | 2015-10-04 | 2015-10-04 10:38:22 | 1 | Walk |
| 1071 | 2015-10-04 | 2015-10-04 10:38:13 | 1 | Walk |
| 1072 | 2015-09-07 | 2015-09-07 14:36:15 | 4 | Metro |
| 1073 | 2015-09-07 | 2015-09-07 14:35:52 | 4 | Metro |
| 1074 | 2015-09-09 | 2015-09-09 16:57:18 | 3 | Metro |
| 1075 | 2015-09-09 | 2015-09-09 16:57:27 | 3 | Metro |
| 1076 | 2015-09-14 | 2015-09-14 15:08:18 | 1 | Taxi |
| 1077 | 2015-09-14 | 2015-09-14 15:08:22 | 1 | Taxi |
| 1078 | 2015-09-14 | 2015-09-14 15:08:50 | 1 | Taxi |
| 1079 | 2015-09-14 | 2015-09-14 15:08:19 | 1 | Taxi |
| 1080 | 2015-09-11 | 2015-09-11 09:19:31 | 3 | Train |
| 1081 | 2015-09-17 | 2015-09-17 11:16:34 | 1 | Walk |
| 1082 | 2015-09-17 | 2015-09-17 11:17:01 | 1 | Walk |
| 1083 | 2015-09-11 | 2015-09-11 12:20:14 | 5 | Walk |
| 1084 | 2015-09-11 | 2015-09-11 12:20:09 | 5 | Walk |
| 1085 | 2015-09-11 | 2015-09-11 12:20:25 | 5 | Walk |
| 1086 | 2015-09-12 | 2015-09-12 15:42:43 | 3 | Metro |
| 1087 | 2015-09-13 | 2015-09-13 10:31:19 | 1 | Metro |
| 1088 | 2015-09-13 | 2015-09-13 10:31:39 | 1 | Metro |
| 1089 | 2015-09-13 | 2015-09-13 11:24:28 | 1 | Walk |
| 1090 | 2015-09-13 | 2015-09-13 11:24:11 | 1 | Walk |
| 1091 | 2015-10-13 | 2015-10-13 13:18:11 | 4 | Bus |
| 1092 | 2015-10-13 | 2015-10-13 13:18:25 | 4 | Bus |
| 1093 | 2015-10-13 | 2015-10-13 13:18:41 | 4 | Bus |
| 1094 | 2015-10-13 | 2015-10-13 13:18:23 | 4 | 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;