View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,076–9,100 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9524 | 2019-12-30 | 2019-12-30 09:43:53 | 1 | Walk |
| 9525 | 2019-12-30 | 2019-12-30 09:44:09 | 1 | Walk |
| 9526 | 2019-12-08 | 2019-12-08 13:01:53 | 4 | Taxi |
| 9527 | 2019-12-08 | 2019-12-08 15:49:14 | 2 | Taxi |
| 9528 | 2019-12-12 | 2019-12-12 12:43:31 | 2 | Metro |
| 9529 | 2019-12-12 | 2019-12-12 12:43:41 | 2 | Metro |
| 9530 | 2019-12-10 | 2019-12-10 10:45:10 | 4 | Walk |
| 9531 | 2019-12-10 | 2019-12-10 10:45:32 | 4 | Walk |
| 9532 | 2019-12-10 | 2019-12-10 12:24:48 | 1 | Metro |
| 9533 | 2019-12-10 | 2019-12-10 14:24:18 | 4 | Walk |
| 9534 | 2019-12-10 | 2019-12-10 14:24:02 | 4 | Walk |
| 9535 | 2020-01-13 | 2020-01-13 16:30:54 | 1 | Private Vehicle |
| 9536 | 2019-12-18 | 2019-12-18 11:25:28 | 2 | Private Vehicle |
| 9537 | 2019-12-14 | 2019-12-14 16:20:16 | 2 | Metro |
| 9538 | 2019-12-14 | 2019-12-14 16:19:51 | 2 | Metro |
| 9539 | 2019-12-19 | 2019-12-19 10:59:13 | 4 | Metro |
| 9541 | 2019-12-15 | 2019-12-15 10:45:17 | 1 | Metro |
| 9542 | 2019-12-14 | 2019-12-14 14:38:51 | 4 | Other |
| 9543 | 2019-12-14 | 2019-12-14 14:42:20 | 2 | Walk |
| 9544 | 2019-12-14 | 2019-12-14 14:42:16 | 2 | Walk |
| 9545 | 2019-12-14 | 2019-12-14 15:49:29 | 4 | Walk |
| 9546 | 2019-12-14 | 2019-12-14 15:49:20 | 4 | Walk |
| 9547 | 2019-12-17 | 2019-12-17 10:27:25 | 1 | Walk |
| 9548 | 2019-12-17 | 2019-12-17 10:27:21 | 1 | Walk |
| 9552 | 2019-12-20 | 2019-12-20 09:22:35 | 4 | 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;