View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 876–900 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 944 | 2015-08-11 | 2015-08-11 13:54:53 | 3 | Train |
| 945 | 2015-08-23 | 2015-08-23 15:49:15 | 3 | Walk |
| 946 | 2015-08-23 | 2015-08-23 15:49:33 | 3 | Walk |
| 947 | 2015-08-12 | 2015-08-12 14:49:36 | 4 | Bus |
| 948 | 2015-08-12 | 2015-08-12 14:49:46 | 4 | Bus |
| 949 | 2015-08-12 | 2015-08-12 10:20:03 | 3 | Taxi |
| 950 | 2015-08-12 | 2015-08-12 10:19:21 | 3 | Taxi |
| 951 | 2015-08-21 | 2015-08-21 10:35:29 | 4 | Metro |
| 952 | 2015-08-21 | 2015-08-21 10:35:38 | 4 | Metro |
| 953 | 2015-08-12 | 2015-08-12 15:50:16 | 3 | Metro |
| 954 | 2015-08-12 | 2015-08-12 15:50:17 | 3 | Metro |
| 955 | 2015-08-13 | 2015-08-13 13:32:00 | 1 | Metro |
| 956 | 2015-08-13 | 2015-08-13 13:31:46 | 1 | Metro |
| 957 | 2015-08-13 | 2015-08-13 13:31:26 | 1 | Metro |
| 958 | 2015-09-16 | 2015-09-16 16:01:53 | 1 | Walk |
| 959 | 2015-09-16 | 2015-09-16 16:02:09 | 1 | Walk |
| 960 | 2015-09-16 | 2015-09-16 16:02:11 | 1 | Walk |
| 961 | 2015-09-16 | 2015-09-16 16:01:44 | 1 | Walk |
| 962 | 2015-08-13 | 2015-08-13 14:47:20 | 4 | Metro |
| 963 | 2015-08-16 | 2015-08-16 11:18:27 | 4 | Bus |
| 964 | 2015-08-16 | 2015-08-16 11:53:55 | 1 | Walk |
| 965 | 2015-08-14 | 2015-08-14 15:24:27 | 1 | Metro |
| 966 | 2015-08-14 | 2015-08-14 15:24:36 | 1 | Metro |
| 967 | 2015-08-14 | 2015-08-14 15:24:11 | 1 | Metro |
| 968 | 2015-08-15 | 2015-08-15 10:58:36 | 1 | Train |
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;