View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,901–8,925 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9343 | 2019-11-19 | 2019-11-19 13:31:02 | 2 | Metro |
| 9344 | 2019-11-19 | 2019-11-19 13:31:05 | 2 | Metro |
| 9346 | 2019-11-07 | 2019-11-07 12:53:18 | 3 | Bus |
| 9347 | 2019-11-07 | 2019-11-07 12:52:44 | 3 | Bus |
| 9348 | 2019-11-08 | 2019-11-08 15:33:28 | 1 | Walk |
| 9349 | 2019-11-08 | 2019-11-08 15:34:15 | 1 | Walk |
| 9350 | 2019-12-18 | 2019-12-18 11:30:27 | 3 | Metro |
| 9351 | 2019-12-18 | 2019-12-18 11:31:02 | 3 | Metro |
| 9352 | 2019-12-18 | 2019-12-18 11:31:09 | 3 | Metro |
| 9353 | 2019-11-04 | 2019-11-04 11:36:43 | 1 | Metro |
| 9354 | 2019-11-04 | 2019-11-04 11:37:30 | 1 | Metro |
| 9355 | 2019-11-04 | 2019-11-04 11:37:10 | 1 | Metro |
| 9356 | 2019-11-04 | 2019-11-04 11:36:56 | 1 | Metro |
| 9357 | 2019-11-07 | 2019-11-07 09:49:34 | 3 | Metro |
| 9358 | 2019-11-07 | 2019-11-07 09:49:42 | 3 | Metro |
| 9359 | 2019-11-09 | 2019-11-09 14:45:48 | 2 | Taxi |
| 9360 | 2019-11-09 | 2019-11-09 14:45:57 | 2 | Taxi |
| 9361 | 2019-11-09 | 2019-11-09 14:45:35 | 2 | Taxi |
| 9362 | 2019-11-14 | 2019-11-14 10:39:22 | 1 | Walk |
| 9363 | 2019-11-16 | 2019-11-16 12:59:48 | 1 | Taxi |
| 9365 | 2019-11-16 | 2019-11-16 12:59:26 | 1 | Taxi |
| 9366 | 2019-11-06 | 2019-11-06 09:09:58 | 2 | Metro |
| 9367 | 2019-11-06 | 2019-11-06 09:10:01 | 2 | Metro |
| 9368 | 2019-11-07 | 2019-11-07 09:15:14 | 3 | Metro |
| 9369 | 2019-11-07 | 2019-11-07 09:15:36 | 3 | 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;