View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 776–800 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 831 | 2015-07-22 | 2015-07-22 12:56:53 | 5 | Metro |
| 832 | 2015-07-23 | 2015-07-23 11:22:14 | 2 | Metro |
| 833 | 2015-07-23 | 2015-07-23 11:17:39 | 1 | Other |
| 834 | 2015-07-23 | 2015-07-23 13:00:35 | 2 | Bus |
| 835 | 2015-07-23 | 2015-07-23 14:18:30 | 3 | Walk |
| 840 | 2015-07-24 | 2015-07-24 11:23:03 | 1 | Walk |
| 841 | 2015-07-24 | 2015-07-24 11:23:13 | 1 | Walk |
| 842 | 2015-07-24 | 2015-07-24 11:22:42 | 1 | Walk |
| 843 | 2015-07-24 | 2015-07-24 11:23:07 | 1 | Walk |
| 844 | 2015-07-24 | 2015-07-24 11:22:54 | 1 | Walk |
| 845 | 2015-07-24 | 2015-07-24 09:01:21 | 3 | Metro |
| 846 | 2015-07-24 | 2015-07-24 09:01:17 | 3 | Metro |
| 847 | 2015-07-24 | 2015-07-24 09:32:10 | 1 | Walk |
| 848 | 2015-07-24 | 2015-07-24 10:33:24 | 1 | Metro |
| 849 | 2015-07-24 | 2015-07-24 10:33:23 | 1 | Metro |
| 850 | 2015-08-04 | 2015-08-04 10:28:50 | 1 | Metro |
| 851 | 2015-08-04 | 2015-08-04 10:29:02 | 1 | Metro |
| 852 | 2015-07-25 | 2015-07-25 10:22:57 | 1 | Walk |
| 853 | 2015-07-25 | 2015-07-25 10:23:06 | 1 | Walk |
| 854 | 2015-07-25 | 2015-07-25 10:22:56 | 1 | Walk |
| 855 | 2015-07-25 | 2015-07-25 10:22:53 | 1 | Walk |
| 856 | 2015-07-25 | 2015-07-25 10:23:00 | 1 | Walk |
| 857 | 2015-07-25 | 2015-07-25 14:54:54 | 1 | Other |
| 858 | 2015-07-25 | 2015-07-25 15:14:18 | 2 | Metro |
| 859 | 2015-08-02 | 2015-08-02 14:46:20 | 1 | Bus |
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;