View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,976–4,000 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4210 | 2017-09-20 | 2017-09-20 12:35:37 | 1 | Other |
| 4211 | 2017-09-20 | 2017-09-20 12:35:34 | 1 | Other |
| 4212 | 2017-09-20 | 2017-09-20 12:34:09 | 1 | Other |
| 4213 | 2017-09-20 | 2017-09-20 12:36:13 | 1 | Other |
| 4214 | 2017-09-20 | 2017-09-20 12:35:13 | 1 | Other |
| 4215 | 2017-09-20 | 2017-09-20 12:35:02 | 1 | Other |
| 4216 | 2017-09-20 | 2017-09-20 12:35:09 | 1 | Other |
| 4217 | 2017-09-20 | 2017-09-20 12:37:43 | 1 | Other |
| 4218 | 2017-09-20 | 2017-09-20 12:37:13 | 1 | Other |
| 4219 | 2017-09-20 | 2017-09-20 12:35:07 | 1 | Other |
| 4220 | 2017-09-20 | 2017-09-20 12:36:25 | 1 | Other |
| 4221 | 2017-09-20 | 2017-09-20 12:36:34 | 1 | Other |
| 4222 | 2017-09-20 | 2017-09-20 12:37:09 | 1 | Other |
| 4223 | 2017-09-20 | 2017-09-20 12:34:37 | 1 | Other |
| 4224 | 2017-09-20 | 2017-09-20 12:39:21 | 1 | Other |
| 4225 | 2017-09-20 | 2017-09-20 12:37:10 | 1 | Other |
| 4226 | 2017-09-20 | 2017-09-20 12:38:19 | 1 | Other |
| 4227 | 2017-09-20 | 2017-09-20 12:39:01 | 1 | Other |
| 4228 | 2017-09-20 | 2017-09-20 12:34:57 | 1 | Other |
| 4229 | 2017-09-20 | 2017-09-20 12:35:34 | 1 | Other |
| 4230 | 2017-09-20 | 2017-09-20 12:40:11 | 1 | Other |
| 4231 | 2017-09-20 | 2017-09-20 12:40:59 | 1 | Other |
| 4232 | 2017-09-20 | 2017-09-20 12:40:37 | 1 | Other |
| 4233 | 2017-09-20 | 2017-09-20 12:42:04 | 1 | Other |
| 4234 | 2017-09-20 | 2017-09-20 12:41:41 | 1 | Other |
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;