View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 426–450 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 455 | 2015-09-02 | 2015-09-02 12:07:37 | 1 | Bus |
| 456 | 2015-09-02 | 2015-09-02 12:07:39 | 1 | Bus |
| 458 | 2015-09-02 | 2015-09-02 12:08:24 | 1 | Bus |
| 459 | 2015-09-02 | 2015-09-02 12:07:55 | 1 | Bus |
| 460 | 2015-09-02 | 2015-09-02 12:08:57 | 1 | Bus |
| 461 | 2015-09-02 | 2015-09-02 12:08:31 | 1 | Bus |
| 463 | 2015-09-02 | 2015-09-02 12:08:49 | 1 | Bus |
| 464 | 2015-09-02 | 2015-09-02 12:08:09 | 1 | Bus |
| 465 | 2015-09-02 | 2015-09-02 12:08:47 | 1 | Bus |
| 466 | 2015-09-02 | 2015-09-02 12:09:55 | 1 | Bus |
| 467 | 2015-09-02 | 2015-09-02 12:10:34 | 1 | Bus |
| 468 | 2015-09-02 | 2015-09-02 12:09:39 | 1 | Bus |
| 469 | 2015-09-02 | 2015-09-02 12:09:34 | 1 | Bus |
| 470 | 2015-09-02 | 2015-09-02 12:08:23 | 1 | Bus |
| 471 | 2015-09-02 | 2015-09-02 12:08:27 | 1 | Bus |
| 472 | 2015-09-02 | 2015-09-02 12:09:43 | 1 | Bus |
| 473 | 2015-09-02 | 2015-09-02 12:09:51 | 1 | Bus |
| 475 | 2015-09-02 | 2015-09-02 12:10:39 | 1 | Bus |
| 476 | 2015-09-02 | 2015-09-02 12:12:34 | 1 | Bus |
| 477 | 2015-09-02 | 2015-09-02 12:11:43 | 1 | Bus |
| 478 | 2015-09-02 | 2015-09-02 12:12:18 | 1 | Bus |
| 479 | 2015-09-02 | 2015-09-02 12:13:19 | 1 | Bus |
| 483 | 2015-09-02 | 2015-09-02 12:08:59 | 1 | Bus |
| 484 | 2015-09-02 | 2015-09-02 12:09:55 | 1 | Bus |
| 485 | 2015-09-02 | 2015-09-02 12:11:49 | 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;