View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,376–7,400 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7772 | 2019-03-12 | 2019-03-12 14:57:08 | 4 | Train |
| 7773 | 2019-03-06 | 2019-03-06 09:48:42 | 4 | Bus |
| 7774 | 2019-03-07 | 2019-03-07 10:42:54 | 2 | Private Vehicle |
| 7775 | 2019-03-15 | 2019-03-15 16:56:26 | 3 | Walk |
| 7776 | 2019-03-15 | 2019-03-15 16:56:03 | 3 | Walk |
| 7777 | 2019-03-15 | 2019-03-15 16:56:34 | 3 | Walk |
| 7778 | 2019-03-15 | 2019-03-15 16:56:24 | 3 | Walk |
| 7779 | 2019-03-15 | 2019-03-15 16:56:38 | 3 | Walk |
| 7780 | 2019-03-08 | 2019-03-08 10:04:40 | 5 | Walk |
| 7781 | 2019-03-08 | 2019-03-08 10:04:39 | 5 | Walk |
| 7782 | 2019-03-08 | 2019-03-08 09:29:56 | 2 | Metro |
| 7783 | 2019-03-08 | 2019-03-08 09:29:41 | 2 | Metro |
| 7784 | 2019-03-09 | 2019-03-09 11:50:37 | 5 | Walk |
| 7785 | 2019-03-09 | 2019-03-09 11:50:28 | 5 | Walk |
| 7786 | 2019-03-09 | 2019-03-09 11:50:20 | 5 | Walk |
| 7787 | 2019-03-09 | 2019-03-09 11:51:09 | 5 | Walk |
| 7788 | 2019-03-11 | 2019-03-11 09:20:37 | 3 | Metro |
| 7789 | 2019-03-11 | 2019-03-11 09:21:03 | 3 | Metro |
| 7790 | 2019-03-11 | 2019-03-11 09:20:57 | 3 | Metro |
| 7791 | 2019-03-11 | 2019-03-11 09:20:48 | 3 | Metro |
| 7792 | 2019-03-11 | 2019-03-11 10:05:26 | 1 | Walk |
| 7793 | 2019-03-11 | 2019-03-11 10:04:56 | 1 | Walk |
| 7794 | 2019-03-11 | 2019-03-11 10:04:49 | 1 | Walk |
| 7795 | 2019-03-20 | 2019-03-20 11:32:43 | 4 | Walk |
| 7796 | 2019-03-20 | 2019-03-20 11:32:37 | 4 | 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;