View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,401–7,425 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7797 | 2019-03-20 | 2019-03-20 11:32:36 | 4 | Walk |
| 7798 | 2019-03-12 | 2019-03-12 10:41:13 | 2 | Metro |
| 7799 | 2019-03-12 | 2019-03-12 10:41:22 | 2 | Metro |
| 7800 | 2019-03-12 | 2019-03-12 12:21:16 | 1 | Walk |
| 7801 | 2019-03-22 | 2019-03-22 15:07:02 | 2 | Train |
| 7802 | 2019-03-22 | 2019-03-22 15:07:07 | 2 | Train |
| 7803 | 2019-04-04 | 2019-04-04 09:43:35 | 2 | Metro |
| 7804 | 2019-03-20 | 2019-03-20 10:20:05 | 1 | Walk |
| 7805 | 2019-03-14 | 2019-03-14 11:53:20 | 2 | Bus |
| 7806 | 2019-03-14 | 2019-03-14 11:53:45 | 2 | Bus |
| 7807 | 2019-03-30 | 2019-03-30 09:23:19 | 3 | Bus |
| 7808 | 2019-03-30 | 2019-03-30 09:23:41 | 3 | Bus |
| 7809 | 2019-03-21 | 2019-03-21 11:37:21 | 1 | Walk |
| 7810 | 2019-03-21 | 2019-03-21 11:37:41 | 1 | Walk |
| 7811 | 2019-03-18 | 2019-03-18 10:40:24 | 1 | Metro |
| 7812 | 2019-03-19 | 2019-03-19 14:48:09 | 4 | Walk |
| 7813 | 2019-03-19 | 2019-03-19 14:48:31 | 4 | Walk |
| 7814 | 2019-03-25 | 2019-03-25 10:26:05 | 1 | Metro |
| 7815 | 2019-03-26 | 2019-03-26 12:03:20 | 4 | Metro |
| 7816 | 2019-03-26 | 2019-03-26 12:03:30 | 4 | Metro |
| 7817 | 2019-03-26 | 2019-03-26 12:03:33 | 4 | Metro |
| 7818 | 2019-03-26 | 2019-03-26 12:03:31 | 4 | Metro |
| 7819 | 2019-03-18 | 2019-03-18 12:23:57 | 3 | Walk |
| 7820 | 2019-03-18 | 2019-03-18 14:57:48 | 4 | Private Vehicle |
| 7821 | 2019-04-11 | 2019-04-11 13:18:25 | 1 | Train |
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;