View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,101–4,125 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4335 | 2017-08-11 | 2017-08-11 12:20:47 | 1 | Metro |
| 4336 | 2017-08-11 | 2017-08-11 12:21:04 | 1 | Metro |
| 4337 | 2017-08-11 | 2017-08-11 12:20:51 | 1 | Metro |
| 4338 | 2017-08-13 | 2017-08-13 10:32:35 | 1 | Metro |
| 4339 | 2017-08-13 | 2017-08-13 10:32:31 | 1 | Metro |
| 4340 | 2017-08-13 | 2017-08-13 10:32:48 | 1 | Metro |
| 4341 | 2017-08-13 | 2017-08-13 13:41:31 | 1 | Metro |
| 4342 | 2017-08-13 | 2017-08-13 13:40:58 | 1 | Metro |
| 4343 | 2017-08-07 | 2017-08-07 12:10:45 | 4 | Train |
| 4344 | 2017-08-16 | 2017-08-16 09:23:29 | 3 | Walk |
| 4345 | 2017-08-16 | 2017-08-16 09:23:04 | 3 | Walk |
| 4346 | 2017-08-09 | 2017-08-09 11:38:10 | 1 | Bus |
| 4347 | 2017-08-09 | 2017-08-09 11:37:49 | 1 | Bus |
| 4348 | 2017-08-05 | 2017-08-05 14:55:03 | 1 | Metro |
| 4349 | 2017-08-05 | 2017-08-05 14:54:50 | 1 | Metro |
| 4350 | 2017-08-06 | 2017-08-06 10:25:06 | 2 | Metro |
| 4351 | 2017-08-06 | 2017-08-06 11:08:47 | 2 | Walk |
| 4352 | 2017-08-06 | 2017-08-06 11:08:42 | 2 | Walk |
| 4353 | 2017-08-09 | 2017-08-09 15:13:52 | 1 | Metro |
| 4354 | 2017-08-09 | 2017-08-09 15:13:59 | 1 | Metro |
| 4355 | 2017-08-10 | 2017-08-10 12:38:37 | 4 | Walk |
| 4356 | 2017-08-07 | 2017-08-07 10:37:31 | 5 | Walk |
| 4357 | 2017-08-07 | 2017-08-07 10:37:21 | 5 | Walk |
| 4358 | 2017-08-07 | 2017-08-07 13:17:37 | 2 | Metro |
| 4359 | 2017-08-07 | 2017-08-07 13:17:19 | 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;