View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,251–4,275 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4486 | 2017-08-29 | 2017-08-29 12:34:05 | 1 | Train |
| 4490 | 2017-08-24 | 2017-08-24 12:02:28 | 2 | Metro |
| 4491 | 2017-08-24 | 2017-08-24 11:57:39 | 3 | Metro |
| 4492 | 2017-08-24 | 2017-08-24 11:57:49 | 3 | Metro |
| 4493 | 2017-08-24 | 2017-08-24 11:57:54 | 3 | Metro |
| 4494 | 2017-08-24 | 2017-08-24 11:57:59 | 3 | Metro |
| 4496 | 2017-08-26 | 2017-08-26 11:58:40 | 1 | Metro |
| 4497 | 2017-08-26 | 2017-08-26 11:59:09 | 1 | Metro |
| 4498 | 2017-08-26 | 2017-08-26 11:58:54 | 1 | Metro |
| 4499 | 2017-08-27 | 2017-08-27 16:03:17 | 1 | Taxi |
| 4500 | 2017-08-27 | 2017-08-27 16:03:28 | 1 | Taxi |
| 4502 | 2017-09-05 | 2017-09-05 13:49:56 | 2 | Metro |
| 4503 | 2017-08-26 | 2017-08-26 13:55:23 | 1 | Walk |
| 4504 | 2017-08-26 | 2017-08-26 15:45:54 | 1 | Walk |
| 4505 | 2017-08-26 | 2017-08-26 15:46:01 | 1 | Walk |
| 4506 | 2017-08-26 | 2017-08-26 15:45:25 | 1 | Walk |
| 4507 | 2017-08-28 | 2017-08-28 11:33:17 | 1 | Walk |
| 4508 | 2017-08-28 | 2017-08-28 11:33:14 | 1 | Walk |
| 4509 | 2017-08-28 | 2017-08-28 11:33:03 | 1 | Walk |
| 4510 | 2017-08-28 | 2017-08-28 11:33:40 | 1 | Walk |
| 4511 | 2017-08-28 | 2017-08-28 11:33:26 | 1 | Walk |
| 4512 | 2017-09-04 | 2017-09-04 11:33:45 | 1 | Metro |
| 4513 | 2017-09-04 | 2017-09-04 11:33:47 | 1 | Metro |
| 4514 | 2017-09-04 | 2017-09-04 11:33:23 | 1 | Metro |
| 4515 | 2017-08-27 | 2017-08-27 12:06:35 | 4 | 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;