View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,201–1,225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1288 | 2015-10-02 | 2015-10-02 14:45:00 | 1 | Walk |
| 1289 | 2015-10-02 | 2015-10-02 14:44:44 | 1 | Walk |
| 1290 | 2015-10-08 | 2015-10-08 10:32:44 | 1 | Taxi |
| 1291 | 2015-10-04 | 2015-10-04 12:48:11 | 5 | Walk |
| 1292 | 2015-10-04 | 2015-10-04 12:47:38 | 5 | Walk |
| 1293 | 2015-10-04 | 2015-10-04 12:48:12 | 5 | Walk |
| 1294 | 2015-10-04 | 2015-10-04 12:48:08 | 5 | Walk |
| 1295 | 2015-10-17 | 2015-10-17 11:38:52 | 1 | Train |
| 1296 | 2015-10-17 | 2015-10-17 11:39:23 | 1 | Train |
| 1297 | 2015-10-13 | 2015-10-13 09:23:54 | 1 | Metro |
| 1298 | 2015-10-13 | 2015-10-13 09:23:22 | 1 | Metro |
| 1299 | 2015-10-10 | 2015-10-10 10:27:51 | 2 | Metro |
| 1300 | 2015-10-11 | 2015-10-11 09:53:42 | 5 | Walk |
| 1301 | 2015-10-11 | 2015-10-11 09:53:43 | 5 | Walk |
| 1302 | 2015-10-11 | 2015-10-11 09:52:55 | 5 | Walk |
| 1303 | 2015-10-11 | 2015-10-11 09:53:33 | 5 | Walk |
| 1304 | 2015-10-11 | 2015-10-11 12:02:48 | 1 | Metro |
| 1305 | 2015-10-11 | 2015-10-11 12:02:56 | 1 | Metro |
| 1306 | 2015-10-11 | 2015-10-11 12:02:56 | 1 | Metro |
| 1307 | 2015-10-21 | 2015-10-21 14:30:59 | 1 | Walk |
| 1308 | 2015-10-21 | 2015-10-21 14:31:10 | 1 | Walk |
| 1309 | 2015-10-12 | 2015-10-12 14:50:27 | 1 | Walk |
| 1310 | 2015-10-12 | 2015-10-12 14:50:44 | 1 | Walk |
| 1311 | 2015-10-12 | 2015-10-12 14:51:10 | 1 | Walk |
| 1312 | 2015-10-12 | 2015-10-12 14:50:34 | 1 | 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;