View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,976–8,000 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8382 | 2019-06-30 | 2019-06-30 12:09:06 | 1 | Walk |
| 8383 | 2019-06-30 | 2019-06-30 12:09:09 | 1 | Walk |
| 8384 | 2019-06-16 | 2019-06-16 10:18:32 | 1 | Metro |
| 8385 | 2019-06-18 | 2019-06-18 13:26:18 | 3 | Walk |
| 8386 | 2019-06-18 | 2019-06-18 13:26:00 | 3 | Walk |
| 8387 | 2019-07-15 | 2019-07-15 12:28:08 | 2 | Walk |
| 8388 | 2019-06-24 | 2019-06-24 12:47:30 | 3 | Walk |
| 8389 | 2019-06-24 | 2019-06-24 12:47:36 | 3 | Walk |
| 8390 | 2019-06-24 | 2019-06-24 12:47:01 | 3 | Walk |
| 8391 | 2019-07-03 | 2019-07-03 10:46:10 | 3 | Metro |
| 8392 | 2019-07-03 | 2019-07-03 10:46:26 | 3 | Metro |
| 8393 | 2019-07-03 | 2019-07-03 10:46:26 | 3 | Metro |
| 8394 | 2019-07-03 | 2019-07-03 10:46:10 | 3 | Metro |
| 8395 | 2019-07-03 | 2019-07-03 10:46:14 | 3 | Metro |
| 8396 | 2019-06-22 | 2019-06-22 10:13:45 | 1 | Metro |
| 8397 | 2019-06-18 | 2019-06-18 11:40:44 | 1 | Walk |
| 8398 | 2019-07-10 | 2019-07-10 11:59:03 | 1 | Metro |
| 8399 | 2019-07-16 | 2019-07-16 11:22:10 | 1 | Metro |
| 8400 | 2019-06-22 | 2019-06-22 11:46:08 | 1 | Metro |
| 8401 | 2019-06-22 | 2019-06-22 11:46:00 | 1 | Metro |
| 8402 | 2019-06-22 | 2019-06-22 11:46:08 | 1 | Metro |
| 8403 | 2019-06-22 | 2019-06-22 11:46:09 | 1 | Metro |
| 8404 | 2019-06-22 | 2019-06-22 09:53:58 | 4 | Walk |
| 8405 | 2019-06-22 | 2019-06-22 09:53:56 | 4 | Walk |
| 8406 | 2019-06-22 | 2019-06-22 09:54:20 | 4 | Walk |
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;