View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,201–2,225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2336 | 2016-06-14 | 2016-06-14 09:25:00 | 2 | Metro |
| 2337 | 2016-06-14 | 2016-06-14 09:24:53 | 2 | Metro |
| 2338 | 2016-06-14 | 2016-06-14 12:19:36 | 1 | Metro |
| 2339 | 2016-06-10 | 2016-06-10 15:02:40 | 1 | Metro |
| 2340 | 2016-06-06 | 2016-06-06 11:13:26 | 4 | Walk |
| 2341 | 2016-06-06 | 2016-06-06 11:13:08 | 4 | Walk |
| 2342 | 2016-06-06 | 2016-06-06 12:55:07 | 2 | Private Vehicle |
| 2343 | 2016-06-06 | 2016-06-06 12:55:14 | 2 | Private Vehicle |
| 2344 | 2016-06-08 | 2016-06-08 12:16:46 | 4 | Taxi |
| 2345 | 2016-06-08 | 2016-06-08 12:16:48 | 4 | Taxi |
| 2346 | 2016-06-24 | 2016-06-24 11:31:33 | 2 | Metro |
| 2347 | 2016-06-24 | 2016-06-24 11:31:30 | 2 | Metro |
| 2348 | 2016-06-24 | 2016-06-24 11:31:41 | 2 | Metro |
| 2349 | 2016-06-24 | 2016-06-24 11:31:19 | 2 | Metro |
| 2350 | 2016-06-24 | 2016-06-24 11:31:39 | 2 | Metro |
| 2351 | 2016-06-09 | 2016-06-09 10:07:23 | 3 | Bus |
| 2352 | 2016-06-09 | 2016-06-09 10:07:37 | 3 | Bus |
| 2353 | 2016-06-09 | 2016-06-09 11:18:21 | 4 | Bus |
| 2354 | 2016-06-09 | 2016-06-09 11:47:36 | 2 | Metro |
| 2355 | 2016-06-09 | 2016-06-09 11:48:07 | 2 | Metro |
| 2356 | 2016-06-09 | 2016-06-09 11:48:07 | 2 | Metro |
| 2357 | 2016-06-10 | 2016-06-10 11:06:15 | 2 | Metro |
| 2358 | 2016-06-10 | 2016-06-10 11:06:21 | 2 | Metro |
| 2359 | 2016-06-10 | 2016-06-10 12:43:04 | 4 | Walk |
| 2360 | 2016-06-10 | 2016-06-10 16:37:05 | 1 | Other |
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;