View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,926–7,950 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8330 | 2019-06-08 | 2019-06-08 10:58:47 | 1 | Train |
| 8331 | 2019-06-08 | 2019-06-08 10:59:24 | 1 | Train |
| 8332 | 2019-06-08 | 2019-06-08 14:39:33 | 1 | Taxi |
| 8333 | 2019-06-09 | 2019-06-09 12:38:55 | 3 | Walk |
| 8334 | 2019-06-09 | 2019-06-09 12:38:49 | 3 | Walk |
| 8335 | 2019-06-09 | 2019-06-09 12:39:08 | 3 | Walk |
| 8336 | 2019-06-13 | 2019-06-13 13:04:43 | 1 | Taxi |
| 8337 | 2019-06-10 | 2019-06-10 15:25:10 | 1 | Walk |
| 8338 | 2019-06-11 | 2019-06-11 09:39:14 | 1 | Walk |
| 8339 | 2019-06-11 | 2019-06-11 09:39:30 | 1 | Walk |
| 8340 | 2019-06-11 | 2019-06-11 10:54:10 | 2 | Other |
| 8341 | 2019-06-11 | 2019-06-11 10:53:57 | 2 | Other |
| 8342 | 2019-06-18 | 2019-06-18 12:21:55 | 1 | Taxi |
| 8343 | 2019-06-18 | 2019-06-18 12:21:29 | 1 | Taxi |
| 8344 | 2019-06-18 | 2019-06-18 12:21:42 | 1 | Taxi |
| 8345 | 2019-06-18 | 2019-06-18 12:21:16 | 1 | Taxi |
| 8346 | 2019-06-18 | 2019-06-18 12:21:56 | 1 | Taxi |
| 8347 | 2019-06-13 | 2019-06-13 12:49:36 | 4 | Walk |
| 8348 | 2019-06-13 | 2019-06-13 12:49:11 | 4 | Walk |
| 8349 | 2019-06-13 | 2019-06-13 12:49:16 | 4 | Walk |
| 8350 | 2019-06-13 | 2019-06-13 12:49:16 | 4 | Walk |
| 8351 | 2019-06-17 | 2019-06-17 09:20:31 | 2 | Metro |
| 8352 | 2019-06-17 | 2019-06-17 09:20:59 | 2 | Metro |
| 8353 | 2019-06-22 | 2019-06-22 12:22:57 | 1 | Other |
| 8354 | 2019-06-22 | 2019-06-22 12:22:55 | 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;