View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,226–6,250 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6552 | 2018-10-05 | 2018-10-05 11:44:53 | 4 | Bus |
| 6553 | 2018-10-05 | 2018-10-05 11:47:38 | 4 | Bus |
| 6554 | 2018-08-23 | 2018-08-23 12:27:34 | 5 | Walk |
| 6555 | 2018-08-23 | 2018-08-23 12:26:59 | 5 | Walk |
| 6556 | 2018-09-03 | 2018-09-03 13:59:26 | 1 | Walk |
| 6557 | 2018-09-03 | 2018-09-03 13:59:07 | 1 | Walk |
| 6558 | 2018-09-03 | 2018-09-03 13:59:10 | 1 | Walk |
| 6559 | 2018-08-27 | 2018-08-27 10:28:34 | 1 | Walk |
| 6560 | 2018-08-25 | 2018-08-25 10:17:18 | 1 | Bus |
| 6561 | 2018-08-25 | 2018-08-25 15:48:25 | 4 | Walk |
| 6562 | 2018-08-25 | 2018-08-25 13:20:46 | 5 | Walk |
| 6563 | 2018-08-25 | 2018-08-25 13:20:45 | 5 | Walk |
| 6564 | 2018-08-31 | 2018-08-31 14:12:43 | 1 | Walk |
| 6565 | 2018-08-31 | 2018-08-31 14:12:54 | 1 | Walk |
| 6566 | 2018-08-27 | 2018-08-27 10:25:41 | 1 | Walk |
| 6567 | 2018-08-27 | 2018-08-27 15:46:50 | 2 | Private Vehicle |
| 6568 | 2018-09-04 | 2018-09-04 10:55:46 | 4 | Walk |
| 6569 | 2018-09-04 | 2018-09-04 10:56:09 | 4 | Walk |
| 6570 | 2018-09-04 | 2018-09-04 10:56:16 | 4 | Walk |
| 6571 | 2018-08-30 | 2018-08-30 09:14:07 | 1 | Metro |
| 6572 | 2018-08-30 | 2018-08-30 09:14:27 | 1 | Metro |
| 6573 | 2018-08-29 | 2018-08-29 11:37:19 | 1 | Walk |
| 6574 | 2018-09-14 | 2018-09-14 10:09:26 | 5 | Walk |
| 6575 | 2018-09-14 | 2018-09-14 10:09:37 | 5 | Walk |
| 6576 | 2018-08-31 | 2018-08-31 12:09:09 | 2 | Bus |
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;