View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,726–6,750 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7070 | 2018-11-16 | 2018-11-16 10:57:48 | 1 | Train |
| 7071 | 2018-11-19 | 2018-11-19 13:54:12 | 1 | Bus |
| 7072 | 2018-11-17 | 2018-11-17 11:06:47 | 1 | Metro |
| 7073 | 2018-11-19 | 2018-11-19 10:13:02 | 1 | Metro |
| 7074 | 2018-11-19 | 2018-11-19 10:13:11 | 1 | Metro |
| 7075 | 2018-11-19 | 2018-11-19 10:13:21 | 1 | Metro |
| 7076 | 2018-11-19 | 2018-11-19 14:52:33 | 2 | Walk |
| 7077 | 2018-11-19 | 2018-11-19 14:52:21 | 2 | Walk |
| 7078 | 2018-11-19 | 2018-11-19 14:51:59 | 2 | Walk |
| 7079 | 2018-11-19 | 2018-11-19 14:52:12 | 2 | Walk |
| 7080 | 2018-12-08 | 2018-12-08 16:26:37 | 2 | Metro |
| 7081 | 2018-11-21 | 2018-11-21 13:08:06 | 1 | Metro |
| 7082 | 2018-11-21 | 2018-11-21 13:08:36 | 1 | Metro |
| 7083 | 2018-11-23 | 2018-11-23 11:09:35 | 1 | Walk |
| 7084 | 2018-11-21 | 2018-11-21 14:48:13 | 5 | Bus |
| 7085 | 2019-02-27 | 2019-02-27 12:47:05 | 4 | Metro |
| 7086 | 2019-02-27 | 2019-02-27 12:47:19 | 4 | Metro |
| 7087 | 2019-02-27 | 2019-02-27 12:47:23 | 4 | Metro |
| 7088 | 2019-02-27 | 2019-02-27 12:47:17 | 4 | Metro |
| 7089 | 2019-02-27 | 2019-02-27 12:47:53 | 4 | Metro |
| 7090 | 2019-02-27 | 2019-02-27 12:47:35 | 4 | Metro |
| 7091 | 2019-02-27 | 2019-02-27 12:47:35 | 4 | Metro |
| 7092 | 2019-02-27 | 2019-02-27 12:48:22 | 4 | Metro |
| 7093 | 2019-02-27 | 2019-02-27 12:49:05 | 4 | Metro |
| 7094 | 2019-02-27 | 2019-02-27 12:47:41 | 4 | 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;