View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,176–2,200 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2311 | 2016-06-01 | 2016-06-01 10:11:30 | 1 | Walk |
| 2312 | 2016-06-01 | 2016-06-01 10:11:18 | 1 | Walk |
| 2313 | 2016-06-01 | 2016-06-01 14:17:06 | 3 | Metro |
| 2314 | 2016-06-01 | 2016-06-01 14:16:45 | 3 | Metro |
| 2315 | 2016-06-01 | 2016-06-01 14:16:59 | 3 | Metro |
| 2316 | 2016-06-01 | 2016-06-01 14:17:12 | 3 | Metro |
| 2317 | 2016-06-01 | 2016-06-01 14:17:08 | 3 | Metro |
| 2318 | 2016-06-02 | 2016-06-02 09:24:13 | 2 | Walk |
| 2319 | 2016-06-02 | 2016-06-02 11:04:33 | 2 | Train |
| 2320 | 2016-06-07 | 2016-06-07 14:03:09 | 1 | Walk |
| 2321 | 2016-06-07 | 2016-06-07 14:03:37 | 1 | Walk |
| 2322 | 2016-06-07 | 2016-06-07 14:03:53 | 1 | Walk |
| 2323 | 2016-06-07 | 2016-06-07 14:03:52 | 1 | Walk |
| 2324 | 2016-06-11 | 2016-06-11 13:12:23 | 1 | Walk |
| 2325 | 2016-06-11 | 2016-06-11 13:12:13 | 1 | Walk |
| 2326 | 2016-06-11 | 2016-06-11 13:12:48 | 1 | Walk |
| 2327 | 2016-06-03 | 2016-06-03 10:57:10 | 1 | Walk |
| 2328 | 2016-06-06 | 2016-06-06 11:37:15 | 3 | Walk |
| 2329 | 2016-06-06 | 2016-06-06 11:37:17 | 3 | Walk |
| 2330 | 2016-06-23 | 2016-06-23 09:28:27 | 2 | Metro |
| 2331 | 2016-06-23 | 2016-06-23 09:28:09 | 2 | Metro |
| 2332 | 2016-06-23 | 2016-06-23 09:28:41 | 2 | Metro |
| 2333 | 2016-06-23 | 2016-06-23 09:28:57 | 2 | Metro |
| 2334 | 2016-06-04 | 2016-06-04 12:38:40 | 1 | Metro |
| 2335 | 2016-06-04 | 2016-06-04 12:39:16 | 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;