View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 76–100 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 76 | 2015-03-08 | 2015-03-08 14:32:44 | 5 | Metro |
| 77 | 2015-03-08 | 2015-03-08 14:32:11 | 5 | Metro |
| 78 | 2015-03-04 | 2015-03-04 14:37:40 | 1 | Metro |
| 79 | 2015-03-04 | 2015-03-04 14:37:12 | 1 | Metro |
| 80 | 2015-03-09 | 2015-03-09 16:51:54 | 3 | Walk |
| 81 | 2015-03-05 | 2015-03-05 11:56:06 | 5 | Walk |
| 83 | 2015-03-12 | 2015-03-12 12:20:09 | 1 | Walk |
| 84 | 2015-03-12 | 2015-03-12 12:20:14 | 1 | Walk |
| 85 | 2015-03-12 | 2015-03-12 12:19:55 | 1 | Walk |
| 86 | 2015-03-06 | 2015-03-06 10:36:12 | 1 | Walk |
| 87 | 2015-03-06 | 2015-03-06 11:10:53 | 5 | Walk |
| 88 | 2015-03-06 | 2015-03-06 13:14:08 | 1 | Metro |
| 89 | 2015-03-06 | 2015-03-06 13:14:24 | 1 | Metro |
| 90 | 2015-03-07 | 2015-03-07 11:03:26 | 2 | Bus |
| 91 | 2015-03-08 | 2015-03-08 09:53:09 | 3 | Metro |
| 92 | 2015-03-08 | 2015-03-08 09:53:00 | 3 | Metro |
| 93 | 2015-03-13 | 2015-03-13 11:47:51 | 1 | Walk |
| 94 | 2015-03-13 | 2015-03-13 11:47:19 | 1 | Walk |
| 96 | 2015-03-13 | 2015-03-13 11:47:55 | 1 | Walk |
| 97 | 2015-03-15 | 2015-03-15 09:08:31 | 1 | Walk |
| 100 | 2015-03-12 | 2015-03-12 12:13:41 | 1 | Metro |
| 101 | 2015-03-12 | 2015-03-12 12:13:27 | 1 | Metro |
| 102 | 2015-03-13 | 2015-03-13 10:44:57 | 1 | Walk |
| 103 | 2015-03-14 | 2015-03-14 11:36:52 | 2 | Metro |
| 104 | 2015-03-14 | 2015-03-14 13:34:56 | 2 | Private Vehicle |
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;