View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 601–625 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 655 | 2015-06-12 | 2015-06-12 10:43:03 | 2 | Metro |
| 656 | 2015-06-16 | 2015-06-16 11:15:43 | 1 | Walk |
| 657 | 2015-06-11 | 2015-06-11 09:23:23 | 1 | Metro |
| 658 | 2015-06-11 | 2015-06-11 09:23:28 | 1 | Metro |
| 659 | 2015-06-11 | 2015-06-11 13:10:20 | 1 | Bus |
| 660 | 2015-06-11 | 2015-06-11 13:10:43 | 1 | Bus |
| 661 | 2015-06-11 | 2015-06-11 13:10:35 | 1 | Bus |
| 662 | 2015-06-11 | 2015-06-11 13:10:43 | 1 | Bus |
| 663 | 2015-06-12 | 2015-06-12 13:00:51 | 4 | Metro |
| 664 | 2015-06-12 | 2015-06-12 13:01:17 | 4 | Metro |
| 665 | 2015-06-12 | 2015-06-12 13:01:06 | 4 | Metro |
| 666 | 2015-06-12 | 2015-06-12 13:01:16 | 4 | Metro |
| 667 | 2015-06-14 | 2015-06-14 14:54:18 | 1 | Metro |
| 668 | 2015-06-14 | 2015-06-14 14:54:17 | 1 | Metro |
| 669 | 2015-06-14 | 2015-06-14 14:54:15 | 1 | Metro |
| 670 | 2015-06-14 | 2015-06-14 14:53:44 | 1 | Metro |
| 671 | 2015-06-14 | 2015-06-14 14:53:51 | 1 | Metro |
| 672 | 2015-06-13 | 2015-06-13 14:36:17 | 4 | Walk |
| 673 | 2015-06-13 | 2015-06-13 14:35:55 | 4 | Walk |
| 674 | 2015-06-13 | 2015-06-13 14:36:24 | 4 | Walk |
| 675 | 2015-06-13 | 2015-06-13 14:35:50 | 4 | Walk |
| 676 | 2015-07-16 | 2015-07-16 11:54:02 | 3 | Walk |
| 677 | 2015-07-16 | 2015-07-16 11:54:13 | 3 | Walk |
| 678 | 2015-07-16 | 2015-07-16 11:53:54 | 3 | Walk |
| 679 | 2015-06-15 | 2015-06-15 10:20:27 | 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;