View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,851–3,875 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4073 | 2017-07-03 | 2017-07-03 11:59:25 | 5 | Walk |
| 4074 | 2017-07-03 | 2017-07-03 11:59:44 | 5 | Walk |
| 4075 | 2017-06-22 | 2017-06-22 14:37:02 | 1 | Walk |
| 4076 | 2017-06-22 | 2017-06-22 14:37:06 | 1 | Walk |
| 4077 | 2017-06-22 | 2017-06-22 14:36:45 | 1 | Walk |
| 4078 | 2017-06-22 | 2017-06-22 14:36:57 | 1 | Walk |
| 4079 | 2017-06-23 | 2017-06-23 15:05:49 | 1 | Metro |
| 4081 | 2017-06-25 | 2017-06-25 14:26:56 | 1 | Bus |
| 4082 | 2017-06-25 | 2017-06-25 14:26:54 | 1 | Bus |
| 4083 | 2017-06-26 | 2017-06-26 10:44:21 | 2 | Metro |
| 4084 | 2017-06-26 | 2017-06-26 10:44:00 | 2 | Metro |
| 4085 | 2017-06-24 | 2017-06-24 11:41:46 | 1 | Metro |
| 4086 | 2017-06-24 | 2017-06-24 11:41:24 | 1 | Metro |
| 4087 | 2017-07-07 | 2017-07-07 13:28:59 | 3 | Metro |
| 4088 | 2017-07-07 | 2017-07-07 13:29:14 | 3 | Metro |
| 4089 | 2017-06-25 | 2017-06-25 11:39:48 | 1 | Walk |
| 4090 | 2017-06-25 | 2017-06-25 11:40:11 | 1 | Walk |
| 4091 | 2017-06-25 | 2017-06-25 13:34:49 | 1 | Bus |
| 4092 | 2017-06-25 | 2017-06-25 13:34:54 | 1 | Bus |
| 4093 | 2017-06-25 | 2017-06-25 14:44:39 | 1 | Train |
| 4094 | 2017-06-25 | 2017-06-25 14:43:59 | 1 | Train |
| 4095 | 2017-06-25 | 2017-06-25 14:44:10 | 1 | Train |
| 4096 | 2017-06-28 | 2017-06-28 14:33:10 | 1 | Bus |
| 4097 | 2017-06-28 | 2017-06-28 14:33:11 | 1 | Bus |
| 4098 | 2017-06-26 | 2017-06-26 11:13:37 | 3 | 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;