View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 376–400 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 404 | 2015-08-02 | 2015-08-02 12:02:18 | 4 | Bus |
| 405 | 2015-08-02 | 2015-08-02 11:55:52 | 4 | Bus |
| 406 | 2015-08-02 | 2015-08-02 12:00:02 | 4 | Bus |
| 407 | 2015-08-02 | 2015-08-02 12:00:54 | 4 | Bus |
| 408 | 2015-08-02 | 2015-08-02 11:59:39 | 4 | Bus |
| 410 | 2015-08-02 | 2015-08-02 12:01:16 | 4 | Bus |
| 411 | 2015-08-02 | 2015-08-02 11:56:57 | 4 | Bus |
| 412 | 2015-08-02 | 2015-08-02 12:01:38 | 4 | Bus |
| 413 | 2015-08-02 | 2015-08-02 11:57:07 | 4 | Bus |
| 414 | 2015-08-02 | 2015-08-02 12:00:24 | 4 | Bus |
| 415 | 2015-08-02 | 2015-08-02 11:59:44 | 4 | Bus |
| 416 | 2015-08-02 | 2015-08-02 11:59:52 | 4 | Bus |
| 417 | 2015-08-02 | 2015-08-02 12:04:15 | 4 | Bus |
| 418 | 2015-08-02 | 2015-08-02 12:03:36 | 4 | Bus |
| 419 | 2015-08-02 | 2015-08-02 12:00:16 | 4 | Bus |
| 420 | 2015-05-01 | 2015-05-01 11:29:53 | 1 | Other |
| 421 | 2015-05-01 | 2015-05-01 11:30:33 | 1 | Other |
| 422 | 2015-05-01 | 2015-05-01 15:42:18 | 3 | Metro |
| 423 | 2015-05-02 | 2015-05-02 14:25:42 | 5 | Other |
| 424 | 2015-05-02 | 2015-05-02 14:25:23 | 5 | Other |
| 425 | 2015-05-03 | 2015-05-03 10:06:41 | 1 | Metro |
| 426 | 2015-05-03 | 2015-05-03 10:00:50 | 1 | Walk |
| 427 | 2015-05-03 | 2015-05-03 10:00:24 | 1 | Walk |
| 428 | 2015-05-03 | 2015-05-03 14:01:27 | 2 | Private Vehicle |
| 429 | 2015-05-03 | 2015-05-03 14:01:28 | 2 | Private Vehicle |
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;