View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 226–250 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 248 | 2015-04-05 | 2015-04-05 11:16:16 | 1 | Metro |
| 249 | 2015-04-05 | 2015-04-05 11:15:38 | 1 | Metro |
| 250 | 2015-04-05 | 2015-04-05 11:16:01 | 1 | Metro |
| 251 | 2015-04-05 | 2015-04-05 11:16:07 | 1 | Metro |
| 252 | 2015-04-17 | 2015-04-17 17:00:38 | 2 | Private Vehicle |
| 253 | 2015-04-17 | 2015-04-17 17:00:12 | 2 | Private Vehicle |
| 254 | 2015-04-05 | 2015-04-05 12:46:12 | 3 | Metro |
| 255 | 2015-04-13 | 2015-04-13 10:21:18 | 1 | Train |
| 256 | 2015-04-06 | 2015-04-06 11:00:20 | 3 | Metro |
| 257 | 2015-04-06 | 2015-04-06 11:00:33 | 3 | Metro |
| 258 | 2015-04-06 | 2015-04-06 11:21:58 | 1 | Walk |
| 259 | 2015-04-06 | 2015-04-06 11:21:58 | 1 | Walk |
| 260 | 2015-04-26 | 2015-04-26 09:12:18 | 1 | Metro |
| 261 | 2015-04-26 | 2015-04-26 09:12:15 | 1 | Metro |
| 262 | 2015-04-09 | 2015-04-09 10:28:21 | 3 | Taxi |
| 263 | 2015-04-09 | 2015-04-09 10:28:22 | 3 | Taxi |
| 264 | 2015-04-09 | 2015-04-09 10:28:33 | 3 | Taxi |
| 265 | 2015-04-09 | 2015-04-09 10:28:01 | 3 | Taxi |
| 266 | 2015-04-15 | 2015-04-15 12:49:19 | 1 | Walk |
| 267 | 2015-04-10 | 2015-04-10 09:53:37 | 1 | Metro |
| 268 | 2015-04-10 | 2015-04-10 10:28:34 | 2 | Private Vehicle |
| 269 | 2015-04-10 | 2015-04-10 10:28:48 | 2 | Private Vehicle |
| 270 | 2015-04-10 | 2015-04-10 14:01:28 | 1 | Walk |
| 271 | 2015-04-11 | 2015-04-11 16:15:07 | 1 | Bus |
| 272 | 2015-04-11 | 2015-04-11 16:14:54 | 1 | Bus |
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;