View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 4,526–4,550 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 4774 | 2017-10-21 | 2017-10-21 09:26:01 | 1 | Metro |
| 4775 | 2017-10-17 | 2017-10-17 16:24:16 | 5 | Metro |
| 4776 | 2017-10-17 | 2017-10-17 16:23:56 | 5 | Metro |
| 4777 | 2017-10-17 | 2017-10-17 16:24:16 | 5 | Metro |
| 4778 | 2017-10-17 | 2017-10-17 16:24:15 | 5 | Metro |
| 4779 | 2017-10-17 | 2017-10-17 16:24:20 | 5 | Metro |
| 4780 | 2017-11-15 | 2017-11-15 12:31:39 | 2 | Metro |
| 4781 | 2017-10-30 | 2017-10-30 11:39:28 | 1 | Walk |
| 4782 | 2017-10-18 | 2017-10-18 14:49:59 | 2 | Metro |
| 4783 | 2017-10-18 | 2017-10-18 14:49:40 | 2 | Metro |
| 4784 | 2017-10-18 | 2017-10-18 14:50:03 | 2 | Metro |
| 4785 | 2017-11-04 | 2017-11-04 12:20:12 | 1 | Bus |
| 4786 | 2017-11-04 | 2017-11-04 12:20:21 | 1 | Bus |
| 4787 | 2017-10-28 | 2017-10-28 10:38:16 | 1 | Metro |
| 4788 | 2017-10-28 | 2017-10-28 10:38:22 | 1 | Metro |
| 4789 | 2017-10-28 | 2017-10-28 10:37:44 | 1 | Metro |
| 4790 | 2017-10-28 | 2017-10-28 10:41:33 | 2 | Metro |
| 4791 | 2017-10-28 | 2017-10-28 10:40:52 | 2 | Metro |
| 4792 | 2017-10-28 | 2017-10-28 10:41:22 | 2 | Metro |
| 4793 | 2017-10-28 | 2017-10-28 10:40:57 | 2 | Metro |
| 4794 | 2017-10-22 | 2017-10-22 11:30:15 | 1 | Bus |
| 4795 | 2017-10-20 | 2017-10-20 09:12:49 | 1 | Walk |
| 4796 | 2017-10-20 | 2017-10-20 09:12:42 | 1 | Walk |
| 4799 | 2017-10-21 | 2017-10-21 09:15:45 | 4 | Private Vehicle |
| 4801 | 2017-10-23 | 2017-10-23 11:31:39 | 4 | Walk |
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;