View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,676–1,700 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1777 | 2016-02-03 | 2016-02-03 11:01:58 | 4 | Walk |
| 1778 | 2016-02-18 | 2016-02-18 13:26:56 | 1 | Metro |
| 1779 | 2016-02-07 | 2016-02-07 11:14:48 | 4 | Taxi |
| 1780 | 2016-02-07 | 2016-02-07 11:14:54 | 4 | Taxi |
| 1781 | 2016-02-07 | 2016-02-07 13:19:40 | 3 | Walk |
| 1782 | 2016-02-09 | 2016-02-09 12:25:54 | 2 | Taxi |
| 1783 | 2016-02-09 | 2016-02-09 12:26:09 | 2 | Taxi |
| 1784 | 2016-02-09 | 2016-02-09 12:25:28 | 2 | Taxi |
| 1785 | 2016-02-09 | 2016-02-09 13:41:56 | 2 | Metro |
| 1786 | 2016-02-09 | 2016-02-09 13:41:54 | 2 | Metro |
| 1787 | 2016-02-11 | 2016-02-11 12:23:03 | 4 | Walk |
| 1788 | 2016-02-13 | 2016-02-13 11:09:18 | 2 | Metro |
| 1789 | 2016-02-13 | 2016-02-13 11:09:08 | 2 | Metro |
| 1790 | 2016-02-13 | 2016-02-13 11:08:51 | 2 | Metro |
| 1791 | 2016-02-17 | 2016-02-17 11:40:34 | 1 | Metro |
| 1792 | 2016-02-17 | 2016-02-17 11:40:51 | 1 | Metro |
| 1793 | 2016-02-17 | 2016-02-17 11:41:01 | 1 | Metro |
| 1794 | 2016-02-14 | 2016-02-14 16:14:31 | 1 | Bus |
| 1795 | 2016-02-14 | 2016-02-14 16:13:52 | 1 | Bus |
| 1796 | 2016-02-14 | 2016-02-14 16:13:42 | 1 | Bus |
| 1797 | 2016-02-14 | 2016-02-14 16:14:15 | 1 | Bus |
| 1798 | 2016-03-04 | 2016-03-04 09:01:18 | 1 | Walk |
| 1799 | 2016-02-16 | 2016-02-16 09:36:31 | 1 | Walk |
| 1800 | 2016-02-16 | 2016-02-16 09:36:16 | 1 | Walk |
| 1801 | 2016-02-16 | 2016-02-16 09:36:14 | 1 | 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;