View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,676–7,700 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 8076 | 2019-04-14 | 2019-04-14 13:43:04 | 1 | Walk |
| 8077 | 2019-04-15 | 2019-04-15 10:10:08 | 1 | Metro |
| 8078 | 2019-04-24 | 2019-04-24 13:21:11 | 1 | Walk |
| 8079 | 2019-04-24 | 2019-04-24 13:21:20 | 1 | Walk |
| 8080 | 2019-04-24 | 2019-04-24 13:21:06 | 1 | Walk |
| 8081 | 2019-05-03 | 2019-05-03 09:57:57 | 1 | Walk |
| 8083 | 2019-04-16 | 2019-04-16 09:26:37 | 4 | Metro |
| 8084 | 2019-04-16 | 2019-04-16 09:26:40 | 4 | Metro |
| 8085 | 2019-04-19 | 2019-04-19 09:57:42 | 1 | Walk |
| 8086 | 2019-04-17 | 2019-04-17 11:00:07 | 1 | Other |
| 8087 | 2019-04-17 | 2019-04-17 15:18:35 | 4 | Walk |
| 8088 | 2019-05-04 | 2019-05-04 15:26:44 | 1 | Metro |
| 8089 | 2019-05-04 | 2019-05-04 15:26:43 | 1 | Metro |
| 8090 | 2019-05-10 | 2019-05-10 16:18:30 | 3 | Train |
| 8091 | 2019-05-10 | 2019-05-10 16:18:27 | 3 | Train |
| 8092 | 2019-05-10 | 2019-05-10 16:18:02 | 3 | Train |
| 8093 | 2019-04-25 | 2019-04-25 09:51:55 | 4 | Walk |
| 8094 | 2019-04-25 | 2019-04-25 09:51:18 | 4 | Walk |
| 8095 | 2019-04-19 | 2019-04-19 11:46:17 | 2 | Bus |
| 8096 | 2019-04-19 | 2019-04-19 11:45:43 | 2 | Bus |
| 8097 | 2019-04-25 | 2019-04-25 09:37:48 | 2 | Bus |
| 8098 | 2019-04-25 | 2019-04-25 09:37:41 | 2 | Bus |
| 8099 | 2019-04-20 | 2019-04-20 11:46:51 | 1 | Bus |
| 8100 | 2019-04-20 | 2019-04-20 11:46:24 | 1 | Bus |
| 8101 | 2019-04-27 | 2019-04-27 11:45:50 | 5 | 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;