View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,326–9,350 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9782 | 2020-02-08 | 2020-02-08 10:08:43 | 4 | Bus |
| 9783 | 2020-02-08 | 2020-02-08 10:08:07 | 4 | Bus |
| 9784 | 2020-02-11 | 2020-02-11 10:10:42 | 1 | Train |
| 9785 | 2020-02-11 | 2020-02-11 10:10:33 | 1 | Train |
| 9786 | 2020-02-11 | 2020-02-11 10:57:12 | 2 | Private Vehicle |
| 9787 | 2020-02-09 | 2020-02-09 16:33:08 | 1 | Walk |
| 9788 | 2020-02-09 | 2020-02-09 14:19:51 | 1 | Walk |
| 9789 | 2020-02-09 | 2020-02-09 14:19:44 | 1 | Walk |
| 9790 | 2020-02-11 | 2020-02-11 13:37:55 | 1 | Metro |
| 9791 | 2020-02-11 | 2020-02-11 13:37:55 | 1 | Metro |
| 9792 | 2020-02-15 | 2020-02-15 11:02:44 | 3 | Walk |
| 9793 | 2020-02-15 | 2020-02-15 11:02:44 | 3 | Walk |
| 9794 | 2020-02-15 | 2020-02-15 11:02:25 | 3 | Walk |
| 9795 | 2020-02-13 | 2020-02-13 13:44:58 | 1 | Walk |
| 9796 | 2020-02-13 | 2020-02-13 13:44:48 | 1 | Walk |
| 9797 | 2020-02-20 | 2020-02-20 14:52:09 | 1 | Train |
| 9798 | 2020-02-20 | 2020-02-20 14:52:22 | 1 | Train |
| 9799 | 2020-02-20 | 2020-02-20 14:52:26 | 1 | Train |
| 9800 | 2020-02-20 | 2020-02-20 14:51:59 | 1 | Train |
| 9801 | 2020-02-20 | 2020-02-20 14:52:27 | 1 | Train |
| 9802 | 2020-02-17 | 2020-02-17 10:54:29 | 1 | Walk |
| 9803 | 2020-02-17 | 2020-02-17 10:54:37 | 1 | Walk |
| 9804 | 2020-02-15 | 2020-02-15 09:40:19 | 2 | Walk |
| 9805 | 2020-02-18 | 2020-02-18 10:28:36 | 5 | Metro |
| 9806 | 2020-02-18 | 2020-02-18 10:28:35 | 5 | Metro |
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;