View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,151–4,175 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4385 | 2017-08-14 | 2017-08-14 13:13:30 | 3 | Metro |
| 4386 | 2017-08-14 | 2017-08-14 14:33:43 | 2 | Metro |
| 4387 | 2017-08-14 | 2017-08-14 14:34:13 | 2 | Metro |
| 4388 | 2017-08-14 | 2017-08-14 14:34:04 | 2 | Metro |
| 4389 | 2017-08-14 | 2017-08-14 14:34:12 | 2 | Metro |
| 4390 | 2017-08-22 | 2017-08-22 09:20:20 | 1 | Walk |
| 4391 | 2017-08-19 | 2017-08-19 09:55:52 | 2 | Bus |
| 4392 | 2017-08-19 | 2017-08-19 09:55:56 | 2 | Bus |
| 4393 | 2017-09-08 | 2017-09-08 12:24:15 | 5 | Walk |
| 4394 | 2017-08-15 | 2017-08-15 09:53:25 | 2 | Bus |
| 4395 | 2017-08-15 | 2017-08-15 09:53:08 | 2 | Bus |
| 4396 | 2017-09-01 | 2017-09-01 10:21:36 | 4 | Metro |
| 4397 | 2017-09-01 | 2017-09-01 10:21:20 | 4 | Metro |
| 4398 | 2017-09-01 | 2017-09-01 10:21:50 | 4 | Metro |
| 4399 | 2017-09-01 | 2017-09-01 10:21:48 | 4 | Metro |
| 4400 | 2017-08-16 | 2017-08-16 09:25:56 | 1 | Metro |
| 4401 | 2017-08-26 | 2017-08-26 11:37:13 | 4 | Walk |
| 4402 | 2017-08-26 | 2017-08-26 11:37:14 | 4 | Walk |
| 4403 | 2017-08-17 | 2017-08-17 11:37:43 | 1 | Walk |
| 4404 | 2017-08-17 | 2017-08-17 11:37:13 | 1 | Walk |
| 4405 | 2017-08-17 | 2017-08-17 11:37:30 | 1 | Walk |
| 4406 | 2017-08-17 | 2017-08-17 11:37:28 | 1 | Walk |
| 4407 | 2017-08-17 | 2017-08-17 14:06:34 | 2 | Metro |
| 4408 | 2017-08-22 | 2017-08-22 13:38:34 | 2 | Metro |
| 4409 | 2017-08-18 | 2017-08-18 12:18:31 | 2 | 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;