View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 3,751–3,775 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 3972 | 2017-05-28 | 2017-05-28 11:09:58 | 5 | Walk |
| 3973 | 2017-05-28 | 2017-05-28 11:09:50 | 5 | Walk |
| 3974 | 2017-05-28 | 2017-05-28 11:25:22 | 2 | Walk |
| 3975 | 2017-05-28 | 2017-05-28 12:09:18 | 1 | Walk |
| 3976 | 2017-05-29 | 2017-05-29 10:56:21 | 1 | Bus |
| 3977 | 2017-05-29 | 2017-05-29 15:12:26 | 1 | Metro |
| 3978 | 2017-06-14 | 2017-06-14 10:38:06 | 1 | Train |
| 3979 | 2017-06-14 | 2017-06-14 10:37:45 | 1 | Train |
| 3980 | 2017-06-04 | 2017-06-04 10:10:50 | 1 | Taxi |
| 3981 | 2017-06-01 | 2017-06-01 10:50:01 | 2 | Walk |
| 3982 | 2017-06-01 | 2017-06-01 10:50:43 | 2 | Walk |
| 3983 | 2017-06-06 | 2017-06-06 12:48:52 | 1 | Metro |
| 3984 | 2017-06-06 | 2017-06-06 12:48:38 | 1 | Metro |
| 3985 | 2017-06-06 | 2017-06-06 12:58:43 | 3 | Walk |
| 3986 | 2017-06-18 | 2017-06-18 16:11:41 | 1 | Walk |
| 3987 | 2017-06-18 | 2017-06-18 16:11:00 | 1 | Walk |
| 3988 | 2017-06-04 | 2017-06-04 11:25:52 | 1 | Walk |
| 3989 | 2017-06-04 | 2017-06-04 11:25:44 | 1 | Walk |
| 3990 | 2017-06-04 | 2017-06-04 11:25:39 | 1 | Walk |
| 3992 | 2017-06-05 | 2017-06-05 10:50:08 | 1 | Metro |
| 3993 | 2017-06-05 | 2017-06-05 10:50:12 | 1 | Metro |
| 3994 | 2017-06-15 | 2017-06-15 12:28:07 | 2 | Bus |
| 3995 | 2017-06-15 | 2017-06-15 12:27:19 | 2 | Bus |
| 3996 | 2017-06-15 | 2017-06-15 12:27:32 | 2 | Bus |
| 3997 | 2017-06-15 | 2017-06-15 12:27:34 | 2 | Bus |
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;