View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,001–8,025 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8407 | 2019-07-01 | 2019-07-01 13:43:16 | 1 | Train |
| 8408 | 2019-07-01 | 2019-07-01 13:43:47 | 1 | Train |
| 8409 | 2019-06-29 | 2019-06-29 10:28:32 | 1 | Taxi |
| 8410 | 2019-06-29 | 2019-06-29 10:28:42 | 1 | Taxi |
| 8411 | 2019-07-02 | 2019-07-02 14:49:35 | 1 | Taxi |
| 8412 | 2019-06-25 | 2019-06-25 10:12:19 | 2 | Train |
| 8413 | 2019-06-25 | 2019-06-25 10:12:55 | 2 | Train |
| 8414 | 2019-06-25 | 2019-06-25 10:12:19 | 2 | Train |
| 8415 | 2019-06-25 | 2019-06-25 10:12:20 | 2 | Train |
| 8416 | 2019-06-22 | 2019-06-22 09:55:11 | 2 | Metro |
| 8417 | 2019-06-22 | 2019-06-22 09:55:25 | 2 | Metro |
| 8418 | 2019-06-22 | 2019-06-22 09:55:07 | 2 | Metro |
| 8419 | 2019-06-22 | 2019-06-22 09:55:31 | 2 | Metro |
| 8420 | 2019-06-30 | 2019-06-30 09:57:53 | 2 | Train |
| 8421 | 2019-06-28 | 2019-06-28 10:31:38 | 5 | Private Vehicle |
| 8422 | 2019-06-28 | 2019-06-28 10:31:43 | 5 | Private Vehicle |
| 8423 | 2019-06-27 | 2019-06-27 11:47:05 | 1 | Walk |
| 8424 | 2019-06-27 | 2019-06-27 11:47:05 | 1 | Walk |
| 8425 | 2019-06-27 | 2019-06-27 11:46:34 | 1 | Walk |
| 8426 | 2019-06-27 | 2019-06-27 11:47:11 | 1 | Walk |
| 8427 | 2019-06-28 | 2019-06-28 14:11:23 | 1 | Metro |
| 8428 | 2019-06-28 | 2019-06-28 14:11:54 | 1 | Metro |
| 8429 | 2019-07-13 | 2019-07-13 13:12:39 | 2 | Walk |
| 8430 | 2019-06-25 | 2019-06-25 11:00:08 | 2 | Metro |
| 8431 | 2019-06-25 | 2019-06-25 10:59:36 | 2 | 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;