View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,976–5,000 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5253 | 2018-02-09 | 2018-02-09 11:58:15 | 2 | Bus |
| 5254 | 2018-02-09 | 2018-02-09 11:58:17 | 2 | Bus |
| 5255 | 2018-02-08 | 2018-02-08 09:22:03 | 1 | Walk |
| 5256 | 2018-02-08 | 2018-02-08 09:21:36 | 1 | Walk |
| 5257 | 2018-02-08 | 2018-02-08 13:38:52 | 2 | Metro |
| 5258 | 2018-02-08 | 2018-02-08 13:38:32 | 2 | Metro |
| 5259 | 2018-02-21 | 2018-02-21 16:33:14 | 1 | Metro |
| 5260 | 2018-02-21 | 2018-02-21 16:32:48 | 1 | Metro |
| 5261 | 2018-02-17 | 2018-02-17 10:43:26 | 5 | Walk |
| 5262 | 2018-02-13 | 2018-02-13 12:51:27 | 4 | Walk |
| 5263 | 2018-02-13 | 2018-02-13 12:51:03 | 4 | Walk |
| 5264 | 2018-02-13 | 2018-02-13 12:51:13 | 4 | Walk |
| 5265 | 2018-02-13 | 2018-02-13 12:50:44 | 4 | Walk |
| 5266 | 2018-03-01 | 2018-03-01 10:48:46 | 1 | Walk |
| 5267 | 2018-02-11 | 2018-02-11 12:56:30 | 3 | Bus |
| 5268 | 2018-02-22 | 2018-02-22 10:07:20 | 1 | Walk |
| 5269 | 2018-02-22 | 2018-02-22 10:07:35 | 1 | Walk |
| 5270 | 2018-02-21 | 2018-02-21 13:05:23 | 2 | Private Vehicle |
| 5271 | 2018-02-21 | 2018-02-21 13:05:16 | 2 | Private Vehicle |
| 5272 | 2018-02-21 | 2018-02-21 13:04:45 | 2 | Private Vehicle |
| 5273 | 2018-03-02 | 2018-03-02 10:55:14 | 2 | Metro |
| 5274 | 2018-03-02 | 2018-03-02 10:55:22 | 2 | Metro |
| 5275 | 2018-02-16 | 2018-02-16 09:33:44 | 5 | Walk |
| 5276 | 2018-03-02 | 2018-03-02 10:09:56 | 5 | Metro |
| 5277 | 2018-03-02 | 2018-03-02 10:10:05 | 5 | 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;