View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,826–6,850 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7171 | 2018-11-23 | 2018-11-23 13:52:08 | 1 | Metro |
| 7172 | 2018-11-23 | 2018-11-23 14:52:43 | 1 | Bus |
| 7173 | 2018-11-23 | 2018-11-23 14:52:41 | 1 | Bus |
| 7174 | 2018-11-23 | 2018-11-23 14:52:08 | 1 | Bus |
| 7175 | 2018-11-23 | 2018-11-23 14:52:12 | 1 | Bus |
| 7176 | 2018-12-18 | 2018-12-18 14:10:57 | 2 | Walk |
| 7177 | 2018-12-18 | 2018-12-18 14:11:10 | 2 | Walk |
| 7178 | 2018-11-30 | 2018-11-30 13:10:28 | 2 | Walk |
| 7179 | 2018-11-30 | 2018-11-30 13:10:28 | 2 | Walk |
| 7180 | 2018-11-24 | 2018-11-24 10:17:53 | 1 | Train |
| 7181 | 2018-11-24 | 2018-11-24 10:17:58 | 1 | Train |
| 7182 | 2018-12-16 | 2018-12-16 10:14:05 | 5 | Metro |
| 7183 | 2018-12-16 | 2018-12-16 10:14:37 | 5 | Metro |
| 7184 | 2018-12-16 | 2018-12-16 10:14:23 | 5 | Metro |
| 7185 | 2018-12-02 | 2018-12-02 09:16:08 | 1 | Metro |
| 7186 | 2018-12-02 | 2018-12-02 09:16:02 | 1 | Metro |
| 7187 | 2018-12-02 | 2018-12-02 09:16:21 | 1 | Metro |
| 7188 | 2018-12-02 | 2018-12-02 09:15:48 | 1 | Metro |
| 7189 | 2018-12-02 | 2018-12-02 09:16:10 | 1 | Metro |
| 7190 | 2018-11-26 | 2018-11-26 10:39:55 | 3 | Walk |
| 7191 | 2018-11-26 | 2018-11-26 10:39:54 | 3 | Walk |
| 7192 | 2018-11-26 | 2018-11-26 12:13:05 | 1 | Metro |
| 7193 | 2018-11-26 | 2018-11-26 12:12:34 | 1 | Metro |
| 7194 | 2018-11-26 | 2018-11-26 12:13:10 | 1 | Metro |
| 7195 | 2018-11-26 | 2018-11-26 12:12:56 | 1 | 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;