View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 9,001–9,025 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 9447 | 2019-11-21 | 2019-11-21 14:57:20 | 1 | Walk |
| 9448 | 2019-12-15 | 2019-12-15 15:10:46 | 1 | Metro |
| 9449 | 2019-11-26 | 2019-11-26 10:36:28 | 1 | Metro |
| 9450 | 2019-11-26 | 2019-11-26 10:36:12 | 1 | Metro |
| 9451 | 2019-11-26 | 2019-11-26 10:35:56 | 1 | Metro |
| 9452 | 2019-11-26 | 2019-11-26 10:36:25 | 1 | Metro |
| 9453 | 2019-11-26 | 2019-11-26 10:36:14 | 1 | Metro |
| 9454 | 2019-11-23 | 2019-11-23 11:05:45 | 2 | Walk |
| 9455 | 2019-11-23 | 2019-11-23 11:06:10 | 2 | Walk |
| 9456 | 2019-11-23 | 2019-11-23 11:06:03 | 2 | Walk |
| 9457 | 2019-11-23 | 2019-11-23 11:05:36 | 2 | Walk |
| 9458 | 2019-11-23 | 2019-11-23 11:05:42 | 2 | Walk |
| 9459 | 2019-11-22 | 2019-11-22 12:20:31 | 1 | Other |
| 9460 | 2019-11-22 | 2019-11-22 12:20:38 | 1 | Other |
| 9461 | 2019-11-22 | 2019-11-22 12:20:25 | 1 | Other |
| 9462 | 2019-11-22 | 2019-11-22 12:20:20 | 1 | Other |
| 9463 | 2019-11-23 | 2019-11-23 12:15:03 | 2 | Metro |
| 9464 | 2019-11-23 | 2019-11-23 12:14:56 | 2 | Metro |
| 9465 | 2019-11-23 | 2019-11-23 09:47:26 | 1 | Other |
| 9466 | 2019-11-23 | 2019-11-23 09:47:24 | 1 | Other |
| 9467 | 2019-11-23 | 2019-11-23 09:47:44 | 1 | Other |
| 9470 | 2019-11-28 | 2019-11-28 15:36:01 | 2 | Train |
| 9471 | 2019-11-28 | 2019-11-28 15:35:52 | 2 | Train |
| 9472 | 2019-11-28 | 2019-11-28 15:36:15 | 2 | Train |
| 9473 | 2019-11-28 | 2019-11-28 15:35:47 | 2 | Train |
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;