View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,326–5,350 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5611 | 2018-08-10 | 2018-08-10 11:05:11 | 1 | Walk |
| 5612 | 2018-08-10 | 2018-08-10 11:03:44 | 1 | Walk |
| 5613 | 2018-08-10 | 2018-08-10 11:02:59 | 1 | Walk |
| 5614 | 2018-08-10 | 2018-08-10 11:04:21 | 1 | Walk |
| 5617 | 2018-08-10 | 2018-08-10 11:06:11 | 1 | Walk |
| 5620 | 2018-08-10 | 2018-08-10 11:05:44 | 1 | Walk |
| 5622 | 2018-08-10 | 2018-08-10 11:05:57 | 1 | Walk |
| 5623 | 2018-08-10 | 2018-08-10 11:04:15 | 1 | Walk |
| 5626 | 2018-08-10 | 2018-08-10 11:05:35 | 1 | Walk |
| 5627 | 2018-08-10 | 2018-08-10 11:06:11 | 1 | Walk |
| 5628 | 2018-08-10 | 2018-08-10 11:06:49 | 1 | Walk |
| 5629 | 2018-08-10 | 2018-08-10 11:04:20 | 1 | Walk |
| 5631 | 2018-08-10 | 2018-08-10 11:03:31 | 1 | Walk |
| 5632 | 2018-04-21 | 2018-04-21 15:04:38 | 1 | Train |
| 5633 | 2018-04-21 | 2018-04-21 15:04:15 | 1 | Train |
| 5634 | 2018-04-22 | 2018-04-22 10:03:02 | 1 | Metro |
| 5635 | 2018-04-22 | 2018-04-22 10:02:47 | 1 | Metro |
| 5636 | 2018-04-25 | 2018-04-25 11:10:53 | 5 | Walk |
| 5637 | 2018-04-25 | 2018-04-25 11:10:16 | 5 | Walk |
| 5638 | 2018-04-22 | 2018-04-22 11:35:18 | 2 | Train |
| 5639 | 2018-04-22 | 2018-04-22 11:35:22 | 2 | Train |
| 5640 | 2018-04-26 | 2018-04-26 15:00:29 | 4 | Bus |
| 5641 | 2018-04-26 | 2018-04-26 15:00:10 | 4 | Bus |
| 5642 | 2018-04-30 | 2018-04-30 12:25:00 | 1 | Walk |
| 5643 | 2018-04-30 | 2018-04-30 12:24:29 | 1 | 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;