View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 8,576–8,600 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9007 | 2019-12-15 | 2019-12-15 11:11:26 | 4 | Bus |
| 9008 | 2019-12-15 | 2019-12-15 11:16:28 | 4 | Bus |
| 9009 | 2019-09-12 | 2019-09-12 09:19:57 | 1 | Metro |
| 9010 | 2019-09-12 | 2019-09-12 09:20:01 | 1 | Metro |
| 9011 | 2019-09-15 | 2019-09-15 09:28:48 | 1 | Bus |
| 9012 | 2019-09-14 | 2019-09-14 11:52:35 | 2 | Metro |
| 9013 | 2019-09-14 | 2019-09-14 11:53:21 | 2 | Metro |
| 9014 | 2019-09-15 | 2019-09-15 12:14:12 | 5 | Train |
| 9015 | 2019-09-15 | 2019-09-15 12:14:12 | 5 | Train |
| 9016 | 2019-09-15 | 2019-09-15 12:14:15 | 5 | Train |
| 9017 | 2019-09-15 | 2019-09-15 12:14:15 | 5 | Train |
| 9018 | 2019-09-15 | 2019-09-15 12:14:55 | 5 | Train |
| 9019 | 2019-10-03 | 2019-10-03 09:47:34 | 1 | Walk |
| 9020 | 2019-10-03 | 2019-10-03 09:47:23 | 1 | Walk |
| 9021 | 2019-10-03 | 2019-10-03 09:47:34 | 1 | Walk |
| 9022 | 2019-10-03 | 2019-10-03 09:47:32 | 1 | Walk |
| 9023 | 2019-09-15 | 2019-09-15 10:20:54 | 2 | Walk |
| 9024 | 2019-09-15 | 2019-09-15 10:20:07 | 2 | Walk |
| 9025 | 2019-09-15 | 2019-09-15 10:20:28 | 2 | Walk |
| 9027 | 2019-10-26 | 2019-10-26 09:19:46 | 4 | Metro |
| 9029 | 2019-10-26 | 2019-10-26 09:20:00 | 4 | Metro |
| 9030 | 2019-10-26 | 2019-10-26 09:20:14 | 4 | Metro |
| 9031 | 2019-10-26 | 2019-10-26 09:20:04 | 4 | Metro |
| 9032 | 2019-10-26 | 2019-10-26 09:20:42 | 4 | Metro |
| 9033 | 2019-10-26 | 2019-10-26 09:20:06 | 4 | 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;