View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,926–3,950 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4160 | 2017-07-01 | 2017-07-01 15:31:46 | 1 | Metro |
| 4161 | 2017-07-01 | 2017-07-01 15:31:21 | 1 | Metro |
| 4162 | 2017-07-01 | 2017-07-01 15:32:01 | 1 | Metro |
| 4163 | 2017-07-01 | 2017-07-01 15:31:49 | 1 | Metro |
| 4164 | 2017-07-18 | 2017-07-18 11:01:46 | 3 | Metro |
| 4165 | 2017-07-03 | 2017-07-03 11:07:02 | 1 | Bus |
| 4166 | 2017-07-03 | 2017-07-03 11:06:58 | 1 | Bus |
| 4167 | 2017-07-04 | 2017-07-04 11:44:06 | 4 | Metro |
| 4168 | 2017-07-04 | 2017-07-04 14:27:41 | 1 | Walk |
| 4169 | 2017-07-05 | 2017-07-05 11:57:54 | 2 | Metro |
| 4170 | 2017-07-05 | 2017-07-05 11:58:37 | 2 | Metro |
| 4171 | 2017-07-13 | 2017-07-13 09:55:07 | 2 | Metro |
| 4172 | 2017-07-12 | 2017-07-12 11:50:47 | 2 | Metro |
| 4173 | 2017-07-12 | 2017-07-12 11:51:25 | 2 | Metro |
| 4174 | 2017-07-05 | 2017-07-05 11:10:19 | 2 | Private Vehicle |
| 4175 | 2017-07-05 | 2017-07-05 13:58:43 | 3 | Metro |
| 4176 | 2017-07-13 | 2017-07-13 14:11:25 | 1 | Walk |
| 4177 | 2017-07-13 | 2017-07-13 14:10:49 | 1 | Walk |
| 4178 | 2017-07-08 | 2017-07-08 12:59:12 | 4 | Bus |
| 4179 | 2017-07-08 | 2017-07-08 12:58:43 | 4 | Bus |
| 4180 | 2017-07-09 | 2017-07-09 09:12:01 | 3 | Metro |
| 4181 | 2017-07-19 | 2017-07-19 10:47:23 | 3 | Taxi |
| 4182 | 2017-07-08 | 2017-07-08 13:36:18 | 1 | Walk |
| 4183 | 2017-07-08 | 2017-07-08 13:35:50 | 1 | Walk |
| 4184 | 2017-07-07 | 2017-07-07 10:28:18 | 3 | 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;