View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 6,401–6,425 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 6730 | 2018-09-18 | 2018-09-18 15:49:47 | 1 | Walk |
| 6731 | 2018-09-18 | 2018-09-18 15:49:22 | 1 | Walk |
| 6732 | 2018-09-18 | 2018-09-18 15:49:52 | 1 | Walk |
| 6733 | 2018-09-18 | 2018-09-18 15:49:12 | 1 | Walk |
| 6734 | 2018-09-19 | 2018-09-19 11:44:49 | 4 | Bus |
| 6735 | 2018-09-19 | 2018-09-19 11:45:16 | 4 | Bus |
| 6736 | 2018-09-19 | 2018-09-19 11:45:17 | 4 | Bus |
| 6737 | 2018-09-20 | 2018-09-20 11:30:25 | 2 | Bus |
| 6738 | 2018-09-20 | 2018-09-20 11:30:31 | 2 | Bus |
| 6739 | 2018-09-26 | 2018-09-26 12:25:38 | 2 | Private Vehicle |
| 6740 | 2018-09-21 | 2018-09-21 09:01:47 | 1 | Walk |
| 6741 | 2018-09-21 | 2018-09-21 09:01:34 | 1 | Walk |
| 6742 | 2018-09-25 | 2018-09-25 10:54:52 | 4 | Walk |
| 6743 | 2018-09-25 | 2018-09-25 10:54:51 | 4 | Walk |
| 6744 | 2018-10-20 | 2018-10-20 12:19:00 | 4 | Walk |
| 6745 | 2018-10-20 | 2018-10-20 12:18:39 | 4 | Walk |
| 6746 | 2018-09-23 | 2018-09-23 14:00:20 | 1 | Train |
| 6747 | 2018-09-23 | 2018-09-23 14:00:25 | 1 | Train |
| 6748 | 2018-09-23 | 2018-09-23 14:00:18 | 1 | Train |
| 6749 | 2018-09-26 | 2018-09-26 10:41:50 | 2 | Walk |
| 6750 | 2018-09-26 | 2018-09-26 10:41:26 | 2 | Walk |
| 6751 | 2018-09-26 | 2018-09-26 10:41:24 | 2 | Walk |
| 6752 | 2018-09-24 | 2018-09-24 13:47:25 | 1 | Metro |
| 6753 | 2018-10-04 | 2018-10-04 09:52:27 | 1 | Metro |
| 6754 | 2018-10-04 | 2018-10-04 09:52:23 | 1 | 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;