View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,201–3,225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3387 | 2017-01-07 | 2017-01-07 11:55:52 | 2 | Metro |
| 3388 | 2017-01-07 | 2017-01-07 15:06:06 | 4 | Walk |
| 3389 | 2017-01-08 | 2017-01-08 12:05:23 | 1 | Walk |
| 3390 | 2017-01-08 | 2017-01-08 12:05:14 | 1 | Walk |
| 3391 | 2017-01-10 | 2017-01-10 16:29:14 | 1 | Walk |
| 3392 | 2017-01-10 | 2017-01-10 16:29:23 | 1 | Walk |
| 3393 | 2017-01-17 | 2017-01-17 13:58:18 | 1 | Walk |
| 3394 | 2017-01-19 | 2017-01-19 10:59:43 | 1 | Train |
| 3395 | 2017-01-12 | 2017-01-12 14:52:20 | 3 | Other |
| 3396 | 2017-01-12 | 2017-01-12 14:52:42 | 3 | Other |
| 3397 | 2017-01-12 | 2017-01-12 14:52:49 | 3 | Other |
| 3398 | 2017-01-28 | 2017-01-28 10:36:00 | 3 | Walk |
| 3399 | 2017-01-28 | 2017-01-28 10:36:03 | 3 | Walk |
| 3400 | 2017-01-28 | 2017-01-28 10:35:46 | 3 | Walk |
| 3401 | 2017-01-14 | 2017-01-14 12:18:07 | 1 | Train |
| 3402 | 2017-01-14 | 2017-01-14 12:17:51 | 1 | Train |
| 3403 | 2017-01-14 | 2017-01-14 15:52:12 | 1 | Walk |
| 3404 | 2017-01-21 | 2017-01-21 10:06:26 | 3 | Walk |
| 3405 | 2017-01-21 | 2017-01-21 10:05:58 | 3 | Walk |
| 3406 | 2017-01-16 | 2017-01-16 11:06:19 | 4 | Walk |
| 3407 | 2017-01-16 | 2017-01-16 11:05:51 | 4 | Walk |
| 3408 | 2017-01-18 | 2017-01-18 12:43:56 | 1 | Metro |
| 3409 | 2017-01-18 | 2017-01-18 12:44:44 | 1 | Metro |
| 3410 | 2017-01-17 | 2017-01-17 14:21:55 | 2 | Metro |
| 3411 | 2017-01-17 | 2017-01-17 14:22:31 | 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;