View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,026–8,050 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8432 | 2019-06-25 | 2019-06-25 10:59:58 | 2 | Metro |
| 8434 | 2019-07-13 | 2019-07-13 10:01:32 | 1 | Walk |
| 8435 | 2019-06-26 | 2019-06-26 14:36:11 | 1 | Walk |
| 8436 | 2019-07-07 | 2019-07-07 10:07:38 | 2 | Metro |
| 8438 | 2019-06-27 | 2019-06-27 14:19:36 | 4 | Metro |
| 8439 | 2019-06-27 | 2019-06-27 14:19:22 | 4 | Metro |
| 8440 | 2019-06-27 | 2019-06-27 14:19:06 | 4 | Metro |
| 8441 | 2019-06-27 | 2019-06-27 14:19:25 | 4 | Metro |
| 8442 | 2019-06-28 | 2019-06-28 13:01:42 | 1 | Walk |
| 8443 | 2019-06-28 | 2019-06-28 13:02:03 | 1 | Walk |
| 8448 | 2019-06-29 | 2019-06-29 09:56:36 | 1 | Taxi |
| 8449 | 2019-06-29 | 2019-06-29 09:56:45 | 1 | Taxi |
| 8450 | 2019-06-29 | 2019-06-29 09:56:14 | 1 | Taxi |
| 8451 | 2019-07-06 | 2019-07-06 11:23:05 | 1 | Walk |
| 8452 | 2019-07-06 | 2019-07-06 11:22:52 | 1 | Walk |
| 8453 | 2019-07-02 | 2019-07-02 09:48:14 | 1 | Walk |
| 8454 | 2019-07-13 | 2019-07-13 13:28:10 | 1 | Metro |
| 8455 | 2019-07-13 | 2019-07-13 13:28:52 | 1 | Metro |
| 8456 | 2019-07-08 | 2019-07-08 09:35:04 | 1 | Metro |
| 8457 | 2019-07-08 | 2019-07-08 09:35:11 | 1 | Metro |
| 8458 | 2019-07-08 | 2019-07-08 09:35:00 | 1 | Metro |
| 8459 | 2019-07-08 | 2019-07-08 09:35:43 | 1 | Metro |
| 8460 | 2019-07-04 | 2019-07-04 12:33:15 | 1 | Metro |
| 8461 | 2019-07-04 | 2019-07-04 12:33:07 | 1 | Metro |
| 8462 | 2019-07-05 | 2019-07-05 11:27:09 | 1 | Taxi |
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;