View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,751–5,775 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6064 | 2018-07-11 | 2018-07-11 09:44:22 | 3 | Walk |
| 6065 | 2018-07-11 | 2018-07-11 09:44:49 | 3 | Walk |
| 6066 | 2018-06-21 | 2018-06-21 09:20:57 | 1 | Walk |
| 6067 | 2018-06-21 | 2018-06-21 09:20:51 | 1 | Walk |
| 6068 | 2018-07-05 | 2018-07-05 12:25:33 | 1 | Other |
| 6069 | 2018-07-05 | 2018-07-05 12:25:11 | 1 | Other |
| 6070 | 2018-06-23 | 2018-06-23 09:12:33 | 1 | Bus |
| 6071 | 2018-06-21 | 2018-06-21 11:47:12 | 2 | Bus |
| 6072 | 2018-06-22 | 2018-06-22 14:16:00 | 5 | Walk |
| 6073 | 2018-07-01 | 2018-07-01 12:15:22 | 3 | Walk |
| 6074 | 2018-07-01 | 2018-07-01 12:15:22 | 3 | Walk |
| 6078 | 2018-06-24 | 2018-06-24 10:23:05 | 2 | Metro |
| 6079 | 2018-06-24 | 2018-06-24 10:23:29 | 2 | Metro |
| 6080 | 2018-06-24 | 2018-06-24 10:23:03 | 2 | Metro |
| 6081 | 2018-06-28 | 2018-06-28 12:45:23 | 2 | Bus |
| 6082 | 2018-07-01 | 2018-07-01 10:19:29 | 4 | Train |
| 6083 | 2018-06-30 | 2018-06-30 16:51:18 | 4 | Other |
| 6084 | 2018-06-30 | 2018-06-30 16:51:00 | 4 | Other |
| 6085 | 2018-06-30 | 2018-06-30 16:50:59 | 4 | Other |
| 6086 | 2018-06-30 | 2018-06-30 16:51:10 | 4 | Other |
| 6087 | 2018-06-30 | 2018-06-30 16:51:10 | 4 | Other |
| 6088 | 2018-07-19 | 2018-07-19 10:47:23 | 1 | Walk |
| 6089 | 2018-07-19 | 2018-07-19 10:47:40 | 1 | Walk |
| 6090 | 2018-07-09 | 2018-07-09 15:54:18 | 3 | Metro |
| 6091 | 2018-07-09 | 2018-07-09 15:54:15 | 3 | Metro |
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;