View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,051–8,075 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8463 | 2019-07-25 | 2019-07-25 12:18:08 | 1 | Metro |
| 8464 | 2019-07-25 | 2019-07-25 12:18:17 | 1 | Metro |
| 8465 | 2019-07-25 | 2019-07-25 12:18:26 | 1 | Metro |
| 8466 | 2019-07-25 | 2019-07-25 12:18:35 | 1 | Metro |
| 8467 | 2019-07-25 | 2019-07-25 12:18:48 | 1 | Metro |
| 8468 | 2019-07-25 | 2019-07-25 12:19:03 | 1 | Metro |
| 8469 | 2019-07-25 | 2019-07-25 12:19:02 | 1 | Metro |
| 8470 | 2019-07-25 | 2019-07-25 12:19:53 | 1 | Metro |
| 8471 | 2019-07-25 | 2019-07-25 12:18:48 | 1 | Metro |
| 8472 | 2019-07-25 | 2019-07-25 12:18:53 | 1 | Metro |
| 8473 | 2019-07-25 | 2019-07-25 12:18:58 | 1 | Metro |
| 8474 | 2019-07-25 | 2019-07-25 12:19:03 | 1 | Metro |
| 8475 | 2019-07-25 | 2019-07-25 12:19:20 | 1 | Metro |
| 8476 | 2019-07-25 | 2019-07-25 12:20:31 | 1 | Metro |
| 8477 | 2019-07-25 | 2019-07-25 12:21:10 | 1 | Metro |
| 8478 | 2019-07-25 | 2019-07-25 12:20:23 | 1 | Metro |
| 8479 | 2019-07-25 | 2019-07-25 12:20:48 | 1 | Metro |
| 8480 | 2019-07-25 | 2019-07-25 12:19:16 | 1 | Metro |
| 8481 | 2019-07-25 | 2019-07-25 12:20:32 | 1 | Metro |
| 8482 | 2019-07-25 | 2019-07-25 12:19:24 | 1 | Metro |
| 8483 | 2019-07-25 | 2019-07-25 12:21:48 | 1 | Metro |
| 8484 | 2019-07-25 | 2019-07-25 12:19:53 | 1 | Metro |
| 8485 | 2019-07-25 | 2019-07-25 12:23:38 | 1 | Metro |
| 8486 | 2019-07-25 | 2019-07-25 12:22:44 | 1 | Metro |
| 8487 | 2019-07-25 | 2019-07-25 12:21:44 | 1 | 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;