View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 1,526–1,550 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 1614 | 2015-12-21 | 2015-12-21 15:01:08 | 4 | Walk |
| 1615 | 2015-12-21 | 2015-12-21 15:00:36 | 4 | Walk |
| 1616 | 2015-12-21 | 2015-12-21 15:01:02 | 4 | Walk |
| 1617 | 2015-12-21 | 2015-12-21 15:01:04 | 4 | Walk |
| 1618 | 2015-12-22 | 2015-12-22 09:41:20 | 3 | Walk |
| 1619 | 2015-12-22 | 2015-12-22 10:18:05 | 5 | Walk |
| 1620 | 2015-12-22 | 2015-12-22 10:17:48 | 5 | Walk |
| 1621 | 2016-01-21 | 2016-01-21 10:15:12 | 1 | Metro |
| 1622 | 2016-01-21 | 2016-01-21 10:15:24 | 1 | Metro |
| 1623 | 2015-12-29 | 2015-12-29 15:04:45 | 2 | Metro |
| 1624 | 2015-12-29 | 2015-12-29 15:04:21 | 2 | Metro |
| 1625 | 2015-12-22 | 2015-12-22 15:29:50 | 4 | Metro |
| 1626 | 2015-12-23 | 2015-12-23 09:05:05 | 4 | Walk |
| 1627 | 2015-12-23 | 2015-12-23 09:05:04 | 4 | Walk |
| 1628 | 2015-12-23 | 2015-12-23 09:04:35 | 4 | Walk |
| 1629 | 2015-12-23 | 2015-12-23 09:04:27 | 4 | Walk |
| 1630 | 2015-12-23 | 2015-12-23 09:04:23 | 4 | Walk |
| 1631 | 2015-12-26 | 2015-12-26 10:30:04 | 5 | Metro |
| 1632 | 2015-12-26 | 2015-12-26 10:29:45 | 5 | Metro |
| 1633 | 2016-01-01 | 2016-01-01 13:48:05 | 1 | Walk |
| 1634 | 2016-01-07 | 2016-01-07 11:45:29 | 2 | Bus |
| 1635 | 2015-12-26 | 2015-12-26 09:04:56 | 4 | Walk |
| 1636 | 2015-12-26 | 2015-12-26 13:39:41 | 4 | Walk |
| 1637 | 2015-12-26 | 2015-12-26 12:30:57 | 2 | Metro |
| 1638 | 2015-12-26 | 2015-12-26 12:31:17 | 2 | 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;