View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 901–925 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 969 | 2015-08-15 | 2015-08-15 10:58:21 | 1 | Train |
| 970 | 2015-08-15 | 2015-08-15 10:58:42 | 1 | Train |
| 971 | 2015-08-15 | 2015-08-15 11:59:48 | 1 | Metro |
| 972 | 2015-08-15 | 2015-08-15 15:02:18 | 3 | Bus |
| 973 | 2015-08-15 | 2015-08-15 15:01:58 | 3 | Bus |
| 974 | 2015-08-15 | 2015-08-15 15:11:55 | 5 | Train |
| 975 | 2015-08-16 | 2015-08-16 15:44:15 | 2 | Walk |
| 976 | 2015-08-17 | 2015-08-17 10:02:13 | 2 | Train |
| 977 | 2015-08-17 | 2015-08-17 10:02:20 | 2 | Train |
| 978 | 2015-08-17 | 2015-08-17 10:02:53 | 2 | Train |
| 979 | 2015-08-27 | 2015-08-27 15:47:44 | 1 | Metro |
| 980 | 2015-08-27 | 2015-08-27 15:47:35 | 1 | Metro |
| 981 | 2015-08-27 | 2015-08-27 15:47:46 | 1 | Metro |
| 983 | 2015-08-18 | 2015-08-18 10:38:49 | 2 | Private Vehicle |
| 984 | 2015-08-18 | 2015-08-18 10:38:48 | 2 | Private Vehicle |
| 985 | 2015-08-18 | 2015-08-18 14:53:23 | 4 | Other |
| 986 | 2015-08-18 | 2015-08-18 14:54:13 | 4 | Other |
| 987 | 2015-08-22 | 2015-08-22 10:27:59 | 3 | Other |
| 988 | 2015-08-30 | 2015-08-30 12:56:05 | 2 | Metro |
| 989 | 2015-09-06 | 2015-09-06 16:29:47 | 1 | Walk |
| 990 | 2015-08-29 | 2015-08-29 14:39:29 | 1 | Walk |
| 991 | 2015-08-20 | 2015-08-20 11:10:34 | 1 | Walk |
| 992 | 2015-08-20 | 2015-08-20 13:15:39 | 4 | Walk |
| 993 | 2015-08-20 | 2015-08-20 13:15:43 | 4 | Walk |
| 994 | 2015-08-20 | 2015-08-20 13:16:20 | 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;