View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,076–8,100 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8488 | 2019-07-25 | 2019-07-25 12:19:48 | 1 | Metro |
| 8489 | 2019-07-25 | 2019-07-25 12:23:46 | 1 | Metro |
| 8490 | 2019-07-25 | 2019-07-25 12:24:26 | 1 | Metro |
| 8491 | 2019-07-25 | 2019-07-25 12:23:44 | 1 | Metro |
| 8492 | 2019-07-25 | 2019-07-25 12:21:02 | 1 | Metro |
| 8493 | 2019-07-25 | 2019-07-25 12:20:38 | 1 | Metro |
| 8494 | 2019-07-15 | 2019-07-15 09:32:53 | 2 | Private Vehicle |
| 8495 | 2019-07-15 | 2019-07-15 09:32:31 | 2 | Private Vehicle |
| 8496 | 2019-07-08 | 2019-07-08 15:00:16 | 2 | Metro |
| 8497 | 2019-07-06 | 2019-07-06 13:52:38 | 2 | Metro |
| 8498 | 2019-07-06 | 2019-07-06 13:52:33 | 2 | Metro |
| 8499 | 2019-07-06 | 2019-07-06 13:52:48 | 2 | Metro |
| 8500 | 2019-07-06 | 2019-07-06 13:50:31 | 1 | Walk |
| 8501 | 2019-07-06 | 2019-07-06 13:50:21 | 1 | Walk |
| 8502 | 2019-07-10 | 2019-07-10 13:48:24 | 1 | Bus |
| 8503 | 2019-07-07 | 2019-07-07 10:15:55 | 3 | Metro |
| 8504 | 2019-07-07 | 2019-07-07 10:04:17 | 4 | Metro |
| 8505 | 2019-07-07 | 2019-07-07 13:00:27 | 3 | Metro |
| 8506 | 2019-07-08 | 2019-07-08 09:03:21 | 1 | Metro |
| 8508 | 2019-08-15 | 2019-08-15 09:51:53 | 1 | Other |
| 8509 | 2019-07-08 | 2019-07-08 11:18:15 | 1 | Walk |
| 8510 | 2019-07-13 | 2019-07-13 12:02:46 | 3 | Metro |
| 8511 | 2019-07-13 | 2019-07-13 12:02:35 | 3 | Metro |
| 8512 | 2019-07-09 | 2019-07-09 11:52:24 | 4 | Walk |
| 8513 | 2019-07-14 | 2019-07-14 09:02:21 | 2 | 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;