View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,976–9,000 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9422 | 2019-11-19 | 2019-11-19 10:08:11 | 3 | Walk |
| 9423 | 2019-11-24 | 2019-11-24 10:32:14 | 2 | Metro |
| 9424 | 2019-11-19 | 2019-11-19 09:59:09 | 1 | Train |
| 9425 | 2019-11-19 | 2019-11-19 09:58:32 | 1 | Train |
| 9426 | 2019-11-22 | 2019-11-22 14:51:15 | 3 | Metro |
| 9427 | 2019-11-22 | 2019-11-22 14:50:54 | 3 | Metro |
| 9428 | 2019-11-28 | 2019-11-28 13:11:35 | 2 | Walk |
| 9429 | 2019-11-28 | 2019-11-28 13:11:23 | 2 | Walk |
| 9430 | 2019-11-20 | 2019-11-20 11:45:57 | 1 | Walk |
| 9431 | 2019-11-20 | 2019-11-20 11:46:22 | 1 | Walk |
| 9432 | 2019-11-20 | 2019-11-20 11:46:40 | 1 | Walk |
| 9433 | 2019-11-20 | 2019-11-20 11:46:46 | 1 | Walk |
| 9434 | 2019-11-23 | 2019-11-23 15:21:33 | 2 | Metro |
| 9435 | 2019-11-25 | 2019-11-25 10:02:01 | 2 | Metro |
| 9436 | 2019-11-25 | 2019-11-25 10:01:52 | 2 | Metro |
| 9437 | 2019-11-29 | 2019-11-29 12:37:17 | 1 | Taxi |
| 9438 | 2019-11-29 | 2019-11-29 12:36:41 | 1 | Taxi |
| 9439 | 2019-12-25 | 2019-12-25 11:42:51 | 4 | Walk |
| 9440 | 2019-12-25 | 2019-12-25 11:43:06 | 4 | Walk |
| 9441 | 2019-12-25 | 2019-12-25 11:43:00 | 4 | Walk |
| 9442 | 2019-12-25 | 2019-12-25 11:42:28 | 4 | Walk |
| 9443 | 2019-11-21 | 2019-11-21 14:56:33 | 1 | Walk |
| 9444 | 2019-11-21 | 2019-11-21 14:56:46 | 1 | Walk |
| 9445 | 2019-11-21 | 2019-11-21 14:56:49 | 1 | Walk |
| 9446 | 2019-11-21 | 2019-11-21 14:56:50 | 1 | 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;