View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,651–6,675 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6992 | 2018-12-04 | 2018-12-04 14:00:44 | 1 | Bus |
| 6993 | 2018-12-04 | 2018-12-04 14:06:10 | 1 | Bus |
| 6995 | 2018-12-04 | 2018-12-04 14:05:43 | 1 | Bus |
| 6996 | 2018-12-04 | 2018-12-04 13:59:38 | 1 | Bus |
| 6997 | 2018-12-04 | 2018-12-04 13:59:42 | 1 | Bus |
| 6998 | 2018-12-04 | 2018-12-04 14:04:54 | 1 | Bus |
| 6999 | 2018-12-04 | 2018-12-04 14:05:05 | 1 | Bus |
| 7000 | 2018-12-04 | 2018-12-04 14:01:26 | 1 | Bus |
| 7001 | 2018-10-31 | 2018-10-31 15:28:57 | 4 | Walk |
| 7002 | 2018-10-31 | 2018-10-31 15:28:09 | 4 | Walk |
| 7003 | 2018-11-03 | 2018-11-03 09:01:47 | 5 | Walk |
| 7004 | 2018-11-21 | 2018-11-21 15:52:05 | 2 | Bus |
| 7005 | 2018-11-12 | 2018-11-12 10:58:26 | 1 | Other |
| 7006 | 2018-11-12 | 2018-11-12 10:57:57 | 1 | Other |
| 7007 | 2018-11-11 | 2018-11-11 11:00:16 | 1 | Walk |
| 7008 | 2018-11-11 | 2018-11-11 11:00:24 | 1 | Walk |
| 7009 | 2018-11-11 | 2018-11-11 11:00:43 | 1 | Walk |
| 7010 | 2018-11-11 | 2018-11-11 11:00:12 | 1 | Walk |
| 7011 | 2018-11-21 | 2018-11-21 14:07:57 | 1 | Walk |
| 7012 | 2018-11-21 | 2018-11-21 14:08:05 | 1 | Walk |
| 7013 | 2018-11-21 | 2018-11-21 14:08:28 | 1 | Walk |
| 7014 | 2018-12-01 | 2018-12-01 10:15:52 | 1 | Other |
| 7015 | 2018-12-01 | 2018-12-01 10:15:29 | 1 | Other |
| 7016 | 2018-12-01 | 2018-12-01 10:15:36 | 1 | Other |
| 7017 | 2018-11-04 | 2018-11-04 10:25:47 | 4 | 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;