View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,651–1,675 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1749 | 2016-01-25 | 2016-01-25 15:19:23 | 2 | Walk |
| 1750 | 2016-01-22 | 2016-01-22 10:33:05 | 1 | Walk |
| 1751 | 2016-01-22 | 2016-01-22 10:33:24 | 1 | Walk |
| 1752 | 2016-01-23 | 2016-01-23 09:18:31 | 2 | Metro |
| 1753 | 2016-01-23 | 2016-01-23 09:18:06 | 2 | Metro |
| 1754 | 2016-01-23 | 2016-01-23 09:17:48 | 2 | Metro |
| 1755 | 2016-01-23 | 2016-01-23 09:32:11 | 5 | Metro |
| 1756 | 2016-01-23 | 2016-01-23 09:32:36 | 5 | Metro |
| 1757 | 2016-01-23 | 2016-01-23 11:18:23 | 1 | Walk |
| 1758 | 2016-01-23 | 2016-01-23 11:18:49 | 1 | Walk |
| 1759 | 2016-01-23 | 2016-01-23 11:59:39 | 1 | Taxi |
| 1760 | 2016-01-23 | 2016-01-23 11:59:53 | 1 | Taxi |
| 1761 | 2016-01-23 | 2016-01-23 12:00:11 | 1 | Taxi |
| 1762 | 2016-01-24 | 2016-01-24 10:40:12 | 1 | Metro |
| 1763 | 2016-01-26 | 2016-01-26 10:46:33 | 2 | Private Vehicle |
| 1764 | 2016-01-26 | 2016-01-26 10:46:27 | 2 | Private Vehicle |
| 1767 | 2016-01-30 | 2016-01-30 12:47:23 | 1 | Walk |
| 1768 | 2016-01-30 | 2016-01-30 12:47:53 | 1 | Walk |
| 1769 | 2016-01-30 | 2016-01-30 12:47:43 | 1 | Walk |
| 1770 | 2016-01-30 | 2016-01-30 16:47:42 | 1 | Other |
| 1771 | 2016-02-04 | 2016-02-04 12:24:48 | 1 | Walk |
| 1772 | 2016-02-04 | 2016-02-04 12:24:12 | 1 | Walk |
| 1773 | 2016-02-26 | 2016-02-26 10:53:32 | 1 | Bus |
| 1775 | 2016-02-02 | 2016-02-02 09:44:55 | 2 | Metro |
| 1776 | 2016-02-03 | 2016-02-03 11:02:14 | 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;