View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 551–575 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 603 | 2015-05-22 | 2015-05-22 11:28:18 | 1 | Bus |
| 604 | 2015-05-22 | 2015-05-22 11:28:06 | 1 | Bus |
| 605 | 2015-05-22 | 2015-05-22 15:33:50 | 1 | Walk |
| 606 | 2015-05-23 | 2015-05-23 10:40:52 | 4 | Walk |
| 607 | 2015-06-07 | 2015-06-07 14:04:15 | 1 | Bus |
| 608 | 2015-05-24 | 2015-05-24 09:36:22 | 2 | Metro |
| 609 | 2015-05-24 | 2015-05-24 09:36:20 | 2 | Metro |
| 610 | 2015-05-28 | 2015-05-28 10:33:13 | 1 | Metro |
| 611 | 2015-05-25 | 2015-05-25 15:36:18 | 5 | Walk |
| 612 | 2015-05-25 | 2015-05-25 15:45:45 | 1 | Walk |
| 613 | 2015-05-25 | 2015-05-25 15:45:52 | 1 | Walk |
| 614 | 2015-05-25 | 2015-05-25 15:46:10 | 1 | Walk |
| 615 | 2015-05-29 | 2015-05-29 09:50:54 | 3 | Walk |
| 616 | 2015-05-29 | 2015-05-29 10:53:33 | 5 | Metro |
| 617 | 2015-05-29 | 2015-05-29 10:52:55 | 5 | Metro |
| 618 | 2015-05-29 | 2015-05-29 10:53:13 | 5 | Metro |
| 619 | 2015-05-29 | 2015-05-29 10:53:05 | 5 | Metro |
| 622 | 2015-06-01 | 2015-06-01 13:18:06 | 1 | Walk |
| 623 | 2015-06-01 | 2015-06-01 13:18:26 | 1 | Walk |
| 624 | 2015-06-10 | 2015-06-10 15:01:46 | 4 | Bus |
| 625 | 2015-06-10 | 2015-06-10 15:01:40 | 4 | Bus |
| 626 | 2015-06-13 | 2015-06-13 13:03:33 | 3 | Bus |
| 627 | 2015-06-13 | 2015-06-13 13:03:24 | 3 | Bus |
| 628 | 2015-06-13 | 2015-06-13 13:03:21 | 3 | Bus |
| 629 | 2015-06-13 | 2015-06-13 13:03:48 | 3 | 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;