View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 801–825 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 860 | 2015-08-02 | 2015-08-02 14:45:31 | 1 | Bus |
| 861 | 2015-07-26 | 2015-07-26 09:24:43 | 3 | Metro |
| 862 | 2015-07-26 | 2015-07-26 09:25:03 | 3 | Metro |
| 863 | 2015-07-26 | 2015-07-26 09:24:42 | 3 | Metro |
| 864 | 2015-07-26 | 2015-07-26 09:24:38 | 3 | Metro |
| 865 | 2015-07-29 | 2015-07-29 11:23:46 | 5 | Other |
| 866 | 2015-07-29 | 2015-07-29 11:23:38 | 5 | Other |
| 871 | 2015-07-29 | 2015-07-29 09:36:34 | 2 | Walk |
| 872 | 2015-07-29 | 2015-07-29 09:36:34 | 2 | Walk |
| 873 | 2015-08-15 | 2015-08-15 12:20:12 | 1 | Other |
| 874 | 2015-08-15 | 2015-08-15 12:20:16 | 1 | Other |
| 875 | 2015-08-15 | 2015-08-15 12:20:44 | 1 | Other |
| 876 | 2015-08-15 | 2015-08-15 12:20:09 | 1 | Other |
| 877 | 2015-07-29 | 2015-07-29 09:24:03 | 3 | Metro |
| 878 | 2015-07-29 | 2015-07-29 09:23:38 | 3 | Metro |
| 879 | 2015-07-29 | 2015-07-29 09:23:52 | 3 | Metro |
| 880 | 2015-08-23 | 2015-08-23 11:17:01 | 1 | Metro |
| 881 | 2015-08-23 | 2015-08-23 11:17:04 | 1 | Metro |
| 882 | 2015-08-23 | 2015-08-23 11:17:01 | 1 | Metro |
| 883 | 2015-08-23 | 2015-08-23 11:17:15 | 1 | Metro |
| 887 | 2015-07-29 | 2015-07-29 13:00:22 | 1 | Metro |
| 888 | 2015-07-29 | 2015-07-29 13:00:13 | 1 | Metro |
| 889 | 2015-08-10 | 2015-08-10 15:34:31 | 1 | Walk |
| 890 | 2015-08-10 | 2015-08-10 15:34:40 | 1 | Walk |
| 891 | 2015-07-30 | 2015-07-30 10:59:37 | 3 | 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;