View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 201–225 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 221 | 2015-04-01 | 2015-04-01 09:51:26 | 5 | Walk |
| 222 | 2015-04-04 | 2015-04-04 10:10:13 | 5 | Walk |
| 223 | 2015-04-01 | 2015-04-01 14:18:25 | 4 | Metro |
| 224 | 2015-04-01 | 2015-04-01 14:18:57 | 4 | Metro |
| 225 | 2015-04-01 | 2015-04-01 14:18:55 | 4 | Metro |
| 226 | 2015-04-01 | 2015-04-01 14:18:33 | 4 | Metro |
| 227 | 2015-04-27 | 2015-04-27 11:00:47 | 2 | Metro |
| 228 | 2015-04-27 | 2015-04-27 11:00:14 | 2 | Metro |
| 230 | 2015-04-02 | 2015-04-02 15:27:09 | 1 | Walk |
| 231 | 2015-04-04 | 2015-04-04 09:52:53 | 3 | Walk |
| 232 | 2015-04-04 | 2015-04-04 09:52:47 | 3 | Walk |
| 233 | 2015-04-11 | 2015-04-11 09:54:37 | 1 | Train |
| 235 | 2015-04-04 | 2015-04-04 09:41:44 | 1 | Walk |
| 236 | 2015-04-04 | 2015-04-04 09:41:14 | 1 | Walk |
| 237 | 2015-04-04 | 2015-04-04 14:28:32 | 3 | Walk |
| 238 | 2015-04-04 | 2015-04-04 14:28:23 | 3 | Walk |
| 239 | 2015-04-04 | 2015-04-04 14:28:02 | 3 | Walk |
| 240 | 2015-04-12 | 2015-04-12 14:21:44 | 2 | Metro |
| 241 | 2015-04-05 | 2015-04-05 09:32:23 | 3 | Metro |
| 242 | 2015-04-05 | 2015-04-05 09:32:44 | 3 | Metro |
| 243 | 2015-04-05 | 2015-04-05 09:51:42 | 2 | Taxi |
| 244 | 2015-04-05 | 2015-04-05 09:51:57 | 2 | Taxi |
| 245 | 2015-04-05 | 2015-04-05 09:51:52 | 2 | Taxi |
| 246 | 2015-04-05 | 2015-04-05 09:52:14 | 2 | Taxi |
| 247 | 2015-04-05 | 2015-04-05 11:16:04 | 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;