View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,026–4,050 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4260 | 2017-07-16 | 2017-07-16 11:59:55 | 4 | Walk |
| 4261 | 2017-07-16 | 2017-07-16 12:00:11 | 4 | Walk |
| 4262 | 2017-07-16 | 2017-07-16 12:00:22 | 4 | Walk |
| 4263 | 2017-07-16 | 2017-07-16 12:00:20 | 4 | Walk |
| 4264 | 2017-07-22 | 2017-07-22 12:26:53 | 1 | Walk |
| 4265 | 2017-07-22 | 2017-07-22 12:27:03 | 1 | Walk |
| 4266 | 2017-07-22 | 2017-07-22 12:27:13 | 1 | Walk |
| 4267 | 2017-07-22 | 2017-07-22 12:26:52 | 1 | Walk |
| 4268 | 2017-07-25 | 2017-07-25 11:53:28 | 1 | Private Vehicle |
| 4269 | 2017-07-25 | 2017-07-25 11:52:55 | 1 | Private Vehicle |
| 4270 | 2017-07-25 | 2017-07-25 11:40:37 | 1 | Metro |
| 4271 | 2017-07-25 | 2017-07-25 11:40:30 | 1 | Metro |
| 4272 | 2017-07-18 | 2017-07-18 09:47:57 | 1 | Metro |
| 4273 | 2017-07-18 | 2017-07-18 09:47:52 | 1 | Metro |
| 4274 | 2017-07-18 | 2017-07-18 09:48:18 | 1 | Metro |
| 4275 | 2017-07-18 | 2017-07-18 09:48:08 | 1 | Metro |
| 4276 | 2017-07-18 | 2017-07-18 09:48:26 | 1 | Metro |
| 4277 | 2017-07-18 | 2017-07-18 11:39:21 | 4 | Other |
| 4278 | 2017-07-27 | 2017-07-27 11:29:26 | 3 | Walk |
| 4279 | 2017-07-27 | 2017-07-27 11:29:02 | 3 | Walk |
| 4280 | 2017-07-18 | 2017-07-18 16:36:14 | 2 | Walk |
| 4281 | 2017-07-18 | 2017-07-18 16:36:31 | 2 | Walk |
| 4282 | 2017-07-18 | 2017-07-18 16:36:00 | 2 | Walk |
| 4283 | 2017-08-07 | 2017-08-07 12:50:21 | 3 | Walk |
| 4284 | 2017-08-07 | 2017-08-07 12:51:00 | 3 | 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;