View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,051–6,075 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6373 | 2018-08-31 | 2018-08-31 09:48:25 | 4 | Walk |
| 6374 | 2018-08-31 | 2018-08-31 09:49:11 | 4 | Walk |
| 6375 | 2018-08-31 | 2018-08-31 09:47:01 | 4 | Walk |
| 6376 | 2018-08-31 | 2018-08-31 09:49:20 | 4 | Walk |
| 6377 | 2018-08-31 | 2018-08-31 09:50:13 | 4 | Walk |
| 6378 | 2018-08-31 | 2018-08-31 09:46:37 | 4 | Walk |
| 6379 | 2018-08-31 | 2018-08-31 09:49:15 | 4 | Walk |
| 6380 | 2018-08-31 | 2018-08-31 09:50:12 | 4 | Walk |
| 6381 | 2018-08-31 | 2018-08-31 09:50:01 | 4 | Walk |
| 6382 | 2018-08-31 | 2018-08-31 09:51:03 | 4 | Walk |
| 6383 | 2018-08-31 | 2018-08-31 09:50:25 | 4 | Walk |
| 6384 | 2018-08-31 | 2018-08-31 09:47:01 | 4 | Walk |
| 6385 | 2018-08-31 | 2018-08-31 09:50:21 | 4 | Walk |
| 6386 | 2018-08-31 | 2018-08-31 09:49:34 | 4 | Walk |
| 6387 | 2018-08-31 | 2018-08-31 09:48:43 | 4 | Walk |
| 6388 | 2018-08-31 | 2018-08-31 09:47:17 | 4 | Walk |
| 6389 | 2018-08-31 | 2018-08-31 09:52:41 | 4 | Walk |
| 6390 | 2018-08-04 | 2018-08-04 13:11:20 | 1 | Taxi |
| 6391 | 2018-08-04 | 2018-08-04 13:11:10 | 1 | Taxi |
| 6392 | 2018-08-04 | 2018-08-04 13:11:21 | 1 | Taxi |
| 6393 | 2018-08-04 | 2018-08-04 13:11:26 | 1 | Taxi |
| 6394 | 2018-08-04 | 2018-08-04 16:49:04 | 5 | Walk |
| 6395 | 2018-08-04 | 2018-08-04 16:49:50 | 5 | Walk |
| 6396 | 2018-08-05 | 2018-08-05 11:05:10 | 1 | Train |
| 6397 | 2018-08-05 | 2018-08-05 13:01:05 | 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;