View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,901–4,925 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5174 | 2018-03-23 | 2018-03-23 12:03:53 | 1 | Metro |
| 5175 | 2018-03-23 | 2018-03-23 12:03:42 | 1 | Metro |
| 5176 | 2018-03-23 | 2018-03-23 12:03:08 | 1 | Metro |
| 5177 | 2018-03-23 | 2018-03-23 12:06:32 | 1 | Metro |
| 5178 | 2018-03-23 | 2018-03-23 12:02:57 | 1 | Metro |
| 5179 | 2018-03-23 | 2018-03-23 12:02:38 | 1 | Metro |
| 5180 | 2018-03-23 | 2018-03-23 12:04:22 | 1 | Metro |
| 5182 | 2018-03-23 | 2018-03-23 12:04:30 | 1 | Metro |
| 5183 | 2018-03-23 | 2018-03-23 12:04:38 | 1 | Metro |
| 5184 | 2018-03-23 | 2018-03-23 12:05:14 | 1 | Metro |
| 5185 | 2018-03-23 | 2018-03-23 12:07:19 | 1 | Metro |
| 5186 | 2018-03-23 | 2018-03-23 12:03:02 | 1 | Metro |
| 5188 | 2018-03-23 | 2018-03-23 12:04:39 | 1 | Metro |
| 5189 | 2018-03-23 | 2018-03-23 12:05:18 | 1 | Metro |
| 5190 | 2018-03-23 | 2018-03-23 12:04:53 | 1 | Metro |
| 5191 | 2018-03-23 | 2018-03-23 12:03:18 | 1 | Metro |
| 5192 | 2018-03-23 | 2018-03-23 12:05:07 | 1 | Metro |
| 5193 | 2018-03-23 | 2018-03-23 12:08:14 | 1 | Metro |
| 5194 | 2018-03-23 | 2018-03-23 12:03:30 | 1 | Metro |
| 5196 | 2018-03-23 | 2018-03-23 12:04:50 | 1 | Metro |
| 5197 | 2018-03-23 | 2018-03-23 12:03:38 | 1 | Metro |
| 5198 | 2018-03-23 | 2018-03-23 12:08:22 | 1 | Metro |
| 5199 | 2018-03-23 | 2018-03-23 12:11:17 | 1 | Metro |
| 5200 | 2018-01-17 | 2018-01-17 12:45:50 | 4 | Other |
| 5201 | 2018-01-18 | 2018-01-18 10:19:57 | 1 | Train |
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;