View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,726–1,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1827 | 2016-02-23 | 2016-02-23 10:45:53 | 5 | Walk |
| 1828 | 2016-02-23 | 2016-02-23 10:46:00 | 5 | Walk |
| 1829 | 2016-02-23 | 2016-02-23 10:45:46 | 5 | Walk |
| 1830 | 2016-02-23 | 2016-02-23 10:45:42 | 5 | Walk |
| 1831 | 2016-02-25 | 2016-02-25 13:35:18 | 1 | Walk |
| 1832 | 2016-02-27 | 2016-02-27 13:25:03 | 1 | Metro |
| 1833 | 2016-02-27 | 2016-02-27 13:24:31 | 1 | Metro |
| 1834 | 2016-02-27 | 2016-02-27 13:24:33 | 1 | Metro |
| 1835 | 2016-02-27 | 2016-02-27 13:24:38 | 1 | Metro |
| 1836 | 2016-02-27 | 2016-02-27 13:24:44 | 1 | Metro |
| 1837 | 2016-03-10 | 2016-03-10 11:09:40 | 2 | Metro |
| 1838 | 2016-03-10 | 2016-03-10 11:09:29 | 2 | Metro |
| 1839 | 2016-03-10 | 2016-03-10 11:09:26 | 2 | Metro |
| 1840 | 2016-02-29 | 2016-02-29 13:58:29 | 4 | Walk |
| 1841 | 2016-02-29 | 2016-02-29 13:58:17 | 4 | Walk |
| 1842 | 2016-02-29 | 2016-02-29 13:57:57 | 4 | Walk |
| 1843 | 2016-02-29 | 2016-02-29 13:58:44 | 4 | Walk |
| 1844 | 2016-03-26 | 2016-03-26 15:12:10 | 1 | Walk |
| 1845 | 2016-03-26 | 2016-03-26 15:12:15 | 1 | Walk |
| 1846 | 2016-03-02 | 2016-03-02 09:49:44 | 1 | Walk |
| 1847 | 2016-03-02 | 2016-03-02 09:50:12 | 1 | Walk |
| 1848 | 2016-03-02 | 2016-03-02 09:49:51 | 1 | Walk |
| 1849 | 2016-03-02 | 2016-03-02 09:49:37 | 1 | Walk |
| 1850 | 2016-03-02 | 2016-03-02 16:48:29 | 1 | Metro |
| 1851 | 2016-03-02 | 2016-03-02 16:48:17 | 1 | 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;