View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,701–1,725 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1802 | 2016-02-16 | 2016-02-16 16:44:03 | 4 | Walk |
| 1803 | 2016-02-16 | 2016-02-16 16:43:33 | 4 | Walk |
| 1804 | 2016-02-16 | 2016-02-16 16:43:34 | 4 | Walk |
| 1805 | 2016-02-16 | 2016-02-16 16:43:48 | 4 | Walk |
| 1806 | 2016-02-16 | 2016-02-16 16:44:03 | 4 | Walk |
| 1807 | 2016-02-22 | 2016-02-22 12:12:22 | 4 | Other |
| 1808 | 2016-03-08 | 2016-03-08 10:01:55 | 2 | Metro |
| 1809 | 2016-02-17 | 2016-02-17 15:59:19 | 1 | Taxi |
| 1810 | 2016-02-17 | 2016-02-17 15:59:00 | 1 | Taxi |
| 1811 | 2016-02-17 | 2016-02-17 15:59:43 | 1 | Taxi |
| 1812 | 2016-02-18 | 2016-02-18 11:46:18 | 1 | Train |
| 1813 | 2016-02-18 | 2016-02-18 11:46:13 | 1 | Train |
| 1814 | 2016-02-18 | 2016-02-18 11:46:18 | 1 | Train |
| 1815 | 2016-02-18 | 2016-02-18 11:46:10 | 1 | Train |
| 1816 | 2016-02-18 | 2016-02-18 15:32:45 | 1 | Other |
| 1817 | 2016-02-18 | 2016-02-18 15:32:25 | 1 | Other |
| 1818 | 2016-02-18 | 2016-02-18 15:32:03 | 1 | Other |
| 1819 | 2016-02-18 | 2016-02-18 15:32:37 | 1 | Other |
| 1820 | 2016-02-19 | 2016-02-19 10:36:42 | 1 | Walk |
| 1821 | 2016-02-19 | 2016-02-19 10:36:47 | 1 | Walk |
| 1822 | 2016-02-19 | 2016-02-19 10:36:34 | 1 | Walk |
| 1823 | 2016-03-05 | 2016-03-05 13:04:40 | 2 | Metro |
| 1824 | 2016-03-05 | 2016-03-05 13:04:57 | 2 | Metro |
| 1825 | 2016-02-19 | 2016-02-19 16:47:42 | 1 | Metro |
| 1826 | 2016-02-20 | 2016-02-20 11:46:13 | 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;