View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,851–1,875 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1955 | 2016-03-19 | 2016-03-19 11:16:48 | 1 | Metro |
| 1957 | 2016-03-28 | 2016-03-28 11:41:45 | 1 | Walk |
| 1958 | 2016-03-28 | 2016-03-28 11:42:16 | 1 | Walk |
| 1959 | 2016-03-16 | 2016-03-16 13:41:50 | 1 | Taxi |
| 1960 | 2016-03-19 | 2016-03-19 15:20:59 | 1 | Metro |
| 1961 | 2016-03-19 | 2016-03-19 15:21:15 | 1 | Metro |
| 1962 | 2016-03-19 | 2016-03-19 15:21:09 | 1 | Metro |
| 1963 | 2016-03-19 | 2016-03-19 15:20:36 | 1 | Metro |
| 1964 | 2016-03-18 | 2016-03-18 11:09:11 | 5 | Bus |
| 1965 | 2016-04-03 | 2016-04-03 12:51:01 | 1 | Walk |
| 1966 | 2016-04-03 | 2016-04-03 12:50:19 | 1 | Walk |
| 1967 | 2016-03-20 | 2016-03-20 09:18:44 | 1 | Walk |
| 1968 | 2016-03-20 | 2016-03-20 09:19:05 | 1 | Walk |
| 1973 | 2016-03-20 | 2016-03-20 09:37:40 | 1 | Metro |
| 1974 | 2016-03-20 | 2016-03-20 09:37:00 | 1 | Metro |
| 1975 | 2016-03-20 | 2016-03-20 09:37:47 | 1 | Metro |
| 1976 | 2016-03-26 | 2016-03-26 15:27:29 | 1 | Walk |
| 1977 | 2016-03-26 | 2016-03-26 15:27:37 | 1 | Walk |
| 1978 | 2016-04-10 | 2016-04-10 12:56:34 | 1 | Private Vehicle |
| 1979 | 2016-03-21 | 2016-03-21 15:21:29 | 1 | Walk |
| 1980 | 2016-03-21 | 2016-03-21 15:21:25 | 1 | Walk |
| 1981 | 2016-03-22 | 2016-03-22 10:27:39 | 1 | Metro |
| 1982 | 2016-03-28 | 2016-03-28 10:45:01 | 5 | Other |
| 1983 | 2016-04-08 | 2016-04-08 10:51:34 | 1 | Metro |
| 1984 | 2016-03-28 | 2016-03-28 11:05:45 | 1 | Other |
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;