View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,226–9,250 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9678 | 2020-01-18 | 2020-01-18 09:08:00 | 4 | Taxi |
| 9679 | 2020-01-18 | 2020-01-18 09:08:17 | 4 | Taxi |
| 9680 | 2020-01-18 | 2020-01-18 09:08:35 | 4 | Taxi |
| 9681 | 2020-01-18 | 2020-01-18 09:08:20 | 4 | Taxi |
| 9682 | 2020-01-20 | 2020-01-20 14:46:47 | 2 | Walk |
| 9683 | 2020-01-20 | 2020-01-20 14:46:56 | 2 | Walk |
| 9684 | 2020-01-15 | 2020-01-15 14:38:08 | 2 | Walk |
| 9685 | 2020-01-15 | 2020-01-15 14:38:23 | 2 | Walk |
| 9686 | 2020-01-19 | 2020-01-19 12:42:19 | 5 | Metro |
| 9687 | 2020-01-19 | 2020-01-19 12:42:38 | 5 | Metro |
| 9688 | 2020-01-19 | 2020-01-19 12:42:14 | 5 | Metro |
| 9689 | 2020-01-19 | 2020-01-19 12:42:12 | 5 | Metro |
| 9690 | 2020-02-17 | 2020-02-17 11:37:56 | 2 | Private Vehicle |
| 9691 | 2020-02-17 | 2020-02-17 11:37:14 | 2 | Private Vehicle |
| 9692 | 2020-02-17 | 2020-02-17 11:37:30 | 2 | Private Vehicle |
| 9693 | 2020-01-18 | 2020-01-18 14:55:52 | 1 | Walk |
| 9694 | 2020-01-18 | 2020-01-18 14:56:04 | 1 | Walk |
| 9695 | 2020-01-18 | 2020-01-18 12:07:03 | 1 | Metro |
| 9696 | 2020-01-18 | 2020-01-18 12:06:58 | 1 | Metro |
| 9697 | 2020-01-18 | 2020-01-18 12:24:16 | 1 | Bus |
| 9698 | 2020-01-22 | 2020-01-22 10:35:27 | 1 | Private Vehicle |
| 9699 | 2020-01-19 | 2020-01-19 09:40:43 | 1 | Metro |
| 9700 | 2020-01-19 | 2020-01-19 09:40:31 | 1 | Metro |
| 9702 | 2020-01-20 | 2020-01-20 12:25:13 | 4 | Walk |
| 9703 | 2020-01-21 | 2020-01-21 12:56:08 | 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;