View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,451–4,475 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4693 | 2017-11-22 | 2017-11-22 12:08:51 | 1 | Walk |
| 4695 | 2017-11-22 | 2017-11-22 12:08:27 | 1 | Walk |
| 4696 | 2017-11-22 | 2017-11-22 12:08:40 | 1 | Walk |
| 4697 | 2017-11-22 | 2017-11-22 12:09:05 | 1 | Walk |
| 4698 | 2017-11-22 | 2017-11-22 12:09:23 | 1 | Walk |
| 4700 | 2017-11-22 | 2017-11-22 12:09:07 | 1 | Walk |
| 4701 | 2017-11-22 | 2017-11-22 12:10:44 | 1 | Walk |
| 4702 | 2017-11-22 | 2017-11-22 12:10:15 | 1 | Walk |
| 4703 | 2017-11-22 | 2017-11-22 12:11:40 | 1 | Walk |
| 4704 | 2017-11-22 | 2017-11-22 12:11:07 | 1 | Walk |
| 4705 | 2017-11-22 | 2017-11-22 12:10:28 | 1 | Walk |
| 4706 | 2017-11-22 | 2017-11-22 12:10:55 | 1 | Walk |
| 4707 | 2017-11-22 | 2017-11-22 12:10:08 | 1 | Walk |
| 4708 | 2017-11-22 | 2017-11-22 12:09:15 | 1 | Walk |
| 4709 | 2017-11-22 | 2017-11-22 12:12:07 | 1 | Walk |
| 4710 | 2017-11-22 | 2017-11-22 12:13:25 | 1 | Walk |
| 4711 | 2017-11-22 | 2017-11-22 12:12:54 | 1 | Walk |
| 4712 | 2017-11-22 | 2017-11-22 12:11:07 | 1 | Walk |
| 4713 | 2017-11-22 | 2017-11-22 12:12:55 | 1 | Walk |
| 4714 | 2017-11-22 | 2017-11-22 12:14:25 | 1 | Walk |
| 4715 | 2017-11-22 | 2017-11-22 12:10:10 | 1 | Walk |
| 4716 | 2017-11-22 | 2017-11-22 12:10:43 | 1 | Walk |
| 4717 | 2017-11-22 | 2017-11-22 12:13:14 | 1 | Walk |
| 4718 | 2017-11-22 | 2017-11-22 12:13:25 | 1 | Walk |
| 4720 | 2017-11-22 | 2017-11-22 12:12:34 | 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;