View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 676–700 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 730 | 2015-07-01 | 2015-07-01 11:05:12 | 1 | Walk |
| 731 | 2015-07-01 | 2015-07-01 11:04:58 | 1 | Walk |
| 732 | 2015-07-07 | 2015-07-07 15:48:04 | 1 | Train |
| 733 | 2015-07-02 | 2015-07-02 10:52:45 | 1 | Metro |
| 734 | 2015-07-02 | 2015-07-02 11:28:09 | 3 | Metro |
| 735 | 2015-07-02 | 2015-07-02 11:27:51 | 3 | Metro |
| 736 | 2015-07-05 | 2015-07-05 16:27:30 | 2 | Private Vehicle |
| 737 | 2015-07-03 | 2015-07-03 10:49:18 | 1 | Bus |
| 738 | 2015-07-03 | 2015-07-03 14:36:22 | 4 | Walk |
| 739 | 2015-07-03 | 2015-07-03 14:36:21 | 4 | Walk |
| 740 | 2015-07-03 | 2015-07-03 14:36:13 | 4 | Walk |
| 741 | 2015-07-06 | 2015-07-06 10:35:07 | 2 | Metro |
| 742 | 2015-07-06 | 2015-07-06 10:34:41 | 2 | Metro |
| 743 | 2015-07-06 | 2015-07-06 16:43:25 | 1 | Walk |
| 744 | 2015-07-06 | 2015-07-06 16:43:39 | 1 | Walk |
| 745 | 2015-07-04 | 2015-07-04 09:30:51 | 1 | Walk |
| 746 | 2015-07-05 | 2015-07-05 09:47:22 | 1 | Walk |
| 747 | 2015-07-05 | 2015-07-05 10:18:01 | 3 | Metro |
| 748 | 2015-07-05 | 2015-07-05 10:18:38 | 3 | Metro |
| 749 | 2015-07-05 | 2015-07-05 11:50:39 | 2 | Private Vehicle |
| 750 | 2015-07-05 | 2015-07-05 11:49:55 | 2 | Private Vehicle |
| 751 | 2015-07-05 | 2015-07-05 11:50:03 | 2 | Private Vehicle |
| 752 | 2015-07-05 | 2015-07-05 11:50:00 | 2 | Private Vehicle |
| 753 | 2015-07-18 | 2015-07-18 10:31:07 | 1 | Bus |
| 754 | 2015-07-18 | 2015-07-18 10:30:52 | 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;