View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 2,551–2,575 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 2690 | 2016-09-17 | 2016-09-17 16:24:45 | 1 | Train |
| 2691 | 2016-09-17 | 2016-09-17 16:24:30 | 1 | Train |
| 2692 | 2016-08-24 | 2016-08-24 09:14:09 | 1 | Walk |
| 2693 | 2016-08-24 | 2016-08-24 09:13:53 | 1 | Walk |
| 2694 | 2016-10-28 | 2016-10-28 11:11:29 | 4 | Bus |
| 2695 | 2016-10-28 | 2016-10-28 11:11:39 | 4 | Bus |
| 2696 | 2016-10-28 | 2016-10-28 11:11:53 | 4 | Bus |
| 2697 | 2016-10-28 | 2016-10-28 11:11:56 | 4 | Bus |
| 2698 | 2016-10-28 | 2016-10-28 11:12:01 | 4 | Bus |
| 2699 | 2016-10-28 | 2016-10-28 11:12:39 | 4 | Bus |
| 2700 | 2016-10-28 | 2016-10-28 11:12:59 | 4 | Bus |
| 2702 | 2016-10-28 | 2016-10-28 11:12:11 | 4 | Bus |
| 2703 | 2016-10-28 | 2016-10-28 11:13:13 | 4 | Bus |
| 2704 | 2016-10-28 | 2016-10-28 11:12:32 | 4 | Bus |
| 2705 | 2016-10-28 | 2016-10-28 11:12:59 | 4 | Bus |
| 2706 | 2016-10-28 | 2016-10-28 11:13:41 | 4 | Bus |
| 2707 | 2016-10-28 | 2016-10-28 11:12:53 | 4 | Bus |
| 2708 | 2016-10-28 | 2016-10-28 11:13:13 | 4 | Bus |
| 2709 | 2016-10-28 | 2016-10-28 11:14:17 | 4 | Bus |
| 2710 | 2016-10-28 | 2016-10-28 11:13:29 | 4 | Bus |
| 2711 | 2016-10-28 | 2016-10-28 11:13:21 | 4 | Bus |
| 2712 | 2016-10-28 | 2016-10-28 11:13:28 | 4 | Bus |
| 2713 | 2016-10-28 | 2016-10-28 11:13:35 | 4 | Bus |
| 2714 | 2016-10-28 | 2016-10-28 11:14:01 | 4 | Bus |
| 2715 | 2016-10-28 | 2016-10-28 11:14:49 | 4 | 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;