View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,651–8,675 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9089 | 2019-09-24 | 2019-09-24 11:22:52 | 5 | Metro |
| 9090 | 2019-09-23 | 2019-09-23 10:46:23 | 1 | Walk |
| 9091 | 2019-09-23 | 2019-09-23 10:45:52 | 1 | Walk |
| 9092 | 2019-09-23 | 2019-09-23 10:45:48 | 1 | Walk |
| 9093 | 2019-09-23 | 2019-09-23 10:45:49 | 1 | Walk |
| 9094 | 2019-10-04 | 2019-10-04 10:58:00 | 2 | Metro |
| 9095 | 2019-10-04 | 2019-10-04 10:58:04 | 2 | Metro |
| 9096 | 2019-09-22 | 2019-09-22 13:19:51 | 1 | Bus |
| 9097 | 2019-09-22 | 2019-09-22 12:35:00 | 4 | Walk |
| 9098 | 2019-09-22 | 2019-09-22 12:35:20 | 4 | Walk |
| 9099 | 2019-09-22 | 2019-09-22 12:35:22 | 4 | Walk |
| 9100 | 2019-09-22 | 2019-09-22 11:44:49 | 2 | Metro |
| 9101 | 2019-09-22 | 2019-09-22 11:44:21 | 2 | Metro |
| 9102 | 2019-09-22 | 2019-09-22 11:44:53 | 2 | Metro |
| 9103 | 2019-09-22 | 2019-09-22 11:44:40 | 2 | Metro |
| 9104 | 2019-10-03 | 2019-10-03 09:24:31 | 1 | Walk |
| 9105 | 2019-10-03 | 2019-10-03 09:24:38 | 1 | Walk |
| 9106 | 2019-10-03 | 2019-10-03 09:24:49 | 1 | Walk |
| 9107 | 2019-09-23 | 2019-09-23 10:34:34 | 1 | Walk |
| 9108 | 2019-09-23 | 2019-09-23 10:34:05 | 1 | Walk |
| 9109 | 2019-11-03 | 2019-11-03 11:30:43 | 1 | Walk |
| 9110 | 2019-11-03 | 2019-11-03 11:30:54 | 1 | Walk |
| 9111 | 2019-11-03 | 2019-11-03 11:30:33 | 1 | Walk |
| 9112 | 2019-11-03 | 2019-11-03 11:31:08 | 1 | Walk |
| 9113 | 2019-10-14 | 2019-10-14 10:36:25 | 3 | 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;