View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,126–1,150 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1197 | 2015-09-23 | 2015-09-23 11:37:13 | 2 | Metro |
| 1198 | 2015-09-23 | 2015-09-23 11:37:27 | 2 | Metro |
| 1199 | 2015-09-23 | 2015-09-23 11:37:20 | 2 | Metro |
| 1200 | 2015-09-23 | 2015-09-23 12:46:52 | 2 | Bus |
| 1201 | 2015-10-01 | 2015-10-01 10:01:40 | 1 | Walk |
| 1204 | 2015-12-08 | 2015-12-08 12:18:15 | 4 | Metro |
| 1205 | 2015-12-08 | 2015-12-08 12:18:19 | 4 | Metro |
| 1206 | 2015-12-08 | 2015-12-08 12:18:45 | 4 | Metro |
| 1207 | 2015-12-08 | 2015-12-08 12:18:54 | 4 | Metro |
| 1208 | 2015-12-08 | 2015-12-08 12:18:35 | 4 | Metro |
| 1209 | 2015-12-08 | 2015-12-08 12:19:05 | 4 | Metro |
| 1210 | 2015-12-08 | 2015-12-08 12:19:27 | 4 | Metro |
| 1211 | 2015-12-08 | 2015-12-08 12:19:18 | 4 | Metro |
| 1212 | 2015-12-08 | 2015-12-08 12:19:19 | 4 | Metro |
| 1213 | 2015-12-08 | 2015-12-08 12:19:54 | 4 | Metro |
| 1217 | 2015-12-08 | 2015-12-08 12:20:15 | 4 | Metro |
| 1218 | 2015-12-08 | 2015-12-08 12:20:05 | 4 | Metro |
| 1220 | 2015-12-08 | 2015-12-08 12:20:27 | 4 | Metro |
| 1221 | 2015-12-08 | 2015-12-08 12:20:12 | 4 | Metro |
| 1222 | 2015-12-08 | 2015-12-08 12:19:53 | 4 | Metro |
| 1224 | 2015-12-08 | 2015-12-08 12:19:45 | 4 | Metro |
| 1227 | 2015-12-08 | 2015-12-08 12:21:59 | 4 | Metro |
| 1228 | 2015-12-08 | 2015-12-08 12:19:23 | 4 | Metro |
| 1229 | 2015-12-08 | 2015-12-08 12:21:15 | 4 | Metro |
| 1230 | 2015-12-08 | 2015-12-08 12:21:44 | 4 | 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;