View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,751–4,775 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5007 | 2018-01-19 | 2018-01-19 13:07:39 | 1 | Metro |
| 5008 | 2018-01-19 | 2018-01-19 13:05:24 | 1 | Metro |
| 5009 | 2018-01-19 | 2018-01-19 13:06:17 | 1 | Metro |
| 5010 | 2018-01-19 | 2018-01-19 13:07:50 | 1 | Metro |
| 5011 | 2018-01-19 | 2018-01-19 13:07:45 | 1 | Metro |
| 5012 | 2018-01-19 | 2018-01-19 13:05:44 | 1 | Metro |
| 5013 | 2018-01-19 | 2018-01-19 13:07:49 | 1 | Metro |
| 5014 | 2018-01-19 | 2018-01-19 13:05:54 | 1 | Metro |
| 5015 | 2018-01-19 | 2018-01-19 13:07:27 | 1 | Metro |
| 5016 | 2018-01-19 | 2018-01-19 13:05:41 | 1 | Metro |
| 5017 | 2018-01-19 | 2018-01-19 13:07:21 | 1 | Metro |
| 5018 | 2018-01-19 | 2018-01-19 13:10:24 | 1 | Metro |
| 5019 | 2018-01-19 | 2018-01-19 13:08:55 | 1 | Metro |
| 5020 | 2018-01-19 | 2018-01-19 13:10:00 | 1 | Metro |
| 5021 | 2018-01-19 | 2018-01-19 13:11:09 | 1 | Metro |
| 5022 | 2018-01-19 | 2018-01-19 13:09:28 | 1 | Metro |
| 5023 | 2018-01-19 | 2018-01-19 13:07:39 | 1 | Metro |
| 5024 | 2018-01-19 | 2018-01-19 13:11:54 | 1 | Metro |
| 5025 | 2018-01-19 | 2018-01-19 13:11:05 | 1 | Metro |
| 5026 | 2018-01-19 | 2018-01-19 13:11:51 | 1 | Metro |
| 5027 | 2018-01-19 | 2018-01-19 13:08:07 | 1 | Metro |
| 5028 | 2018-01-19 | 2018-01-19 13:07:39 | 1 | Metro |
| 5029 | 2018-01-19 | 2018-01-19 13:11:57 | 1 | Metro |
| 5030 | 2018-01-19 | 2018-01-19 13:08:28 | 1 | Metro |
| 5031 | 2018-01-19 | 2018-01-19 13:12:23 | 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;