View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 576–600 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 630 | 2015-06-03 | 2015-06-03 11:23:34 | 1 | Metro |
| 631 | 2015-06-03 | 2015-06-03 11:24:06 | 1 | Metro |
| 632 | 2015-06-11 | 2015-06-11 09:09:46 | 4 | Other |
| 633 | 2015-06-06 | 2015-06-06 10:21:23 | 4 | Walk |
| 634 | 2015-06-06 | 2015-06-06 10:21:32 | 4 | Walk |
| 635 | 2015-06-09 | 2015-06-09 09:22:00 | 2 | Metro |
| 636 | 2015-06-09 | 2015-06-09 09:21:54 | 2 | Metro |
| 637 | 2015-06-06 | 2015-06-06 11:11:42 | 3 | Metro |
| 638 | 2015-06-06 | 2015-06-06 13:29:31 | 2 | Metro |
| 639 | 2015-06-06 | 2015-06-06 15:47:00 | 1 | Walk |
| 640 | 2015-06-08 | 2015-06-08 10:49:44 | 2 | Metro |
| 641 | 2015-06-08 | 2015-06-08 10:49:30 | 2 | Metro |
| 642 | 2015-06-08 | 2015-06-08 10:49:35 | 2 | Metro |
| 643 | 2015-06-08 | 2015-06-08 10:47:46 | 2 | Metro |
| 644 | 2015-06-08 | 2015-06-08 10:48:03 | 2 | Metro |
| 645 | 2015-06-08 | 2015-06-08 10:47:46 | 2 | Metro |
| 646 | 2015-06-08 | 2015-06-08 10:47:48 | 2 | Metro |
| 647 | 2015-06-08 | 2015-06-08 11:22:40 | 1 | Metro |
| 648 | 2015-06-08 | 2015-06-08 11:22:32 | 1 | Metro |
| 649 | 2015-06-08 | 2015-06-08 14:57:46 | 2 | Private Vehicle |
| 650 | 2015-06-14 | 2015-06-14 09:21:27 | 1 | Walk |
| 651 | 2015-06-14 | 2015-06-14 09:21:14 | 1 | Walk |
| 652 | 2015-06-14 | 2015-06-14 09:21:23 | 1 | Walk |
| 653 | 2015-06-14 | 2015-06-14 09:21:46 | 1 | Walk |
| 654 | 2015-06-11 | 2015-06-11 16:47:08 | 2 | 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;