View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 7,126–7,150 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 7491 | 2019-03-15 | 2019-03-15 13:01:37 | 1 | Metro |
| 7492 | 2019-03-15 | 2019-03-15 13:04:11 | 1 | Metro |
| 7493 | 2019-03-15 | 2019-03-15 13:03:21 | 1 | Metro |
| 7494 | 2019-03-15 | 2019-03-15 13:03:31 | 1 | Metro |
| 7495 | 2019-03-15 | 2019-03-15 13:04:53 | 1 | Metro |
| 7496 | 2019-03-15 | 2019-03-15 13:05:07 | 1 | Metro |
| 7497 | 2019-03-15 | 2019-03-15 13:04:01 | 1 | Metro |
| 7498 | 2019-03-15 | 2019-03-15 13:05:35 | 1 | Metro |
| 7499 | 2019-03-15 | 2019-03-15 13:05:05 | 1 | Metro |
| 7500 | 2019-03-15 | 2019-03-15 13:02:59 | 1 | Metro |
| 7501 | 2019-03-15 | 2019-03-15 13:03:29 | 1 | Metro |
| 7502 | 2019-03-15 | 2019-03-15 13:06:06 | 1 | Metro |
| 7503 | 2019-03-15 | 2019-03-15 13:02:51 | 1 | Metro |
| 7504 | 2019-03-15 | 2019-03-15 13:07:26 | 1 | Metro |
| 7505 | 2019-03-15 | 2019-03-15 13:06:17 | 1 | Metro |
| 7506 | 2019-03-15 | 2019-03-15 13:04:33 | 1 | Metro |
| 7507 | 2019-03-15 | 2019-03-15 13:03:11 | 1 | Metro |
| 7508 | 2019-03-15 | 2019-03-15 13:07:24 | 1 | Metro |
| 7509 | 2019-03-15 | 2019-03-15 13:07:05 | 1 | Metro |
| 7510 | 2019-03-15 | 2019-03-15 13:05:38 | 1 | Metro |
| 7511 | 2019-03-15 | 2019-03-15 13:08:37 | 1 | Metro |
| 7512 | 2019-03-15 | 2019-03-15 13:08:16 | 1 | Metro |
| 7513 | 2019-03-15 | 2019-03-15 13:03:05 | 1 | Metro |
| 7514 | 2019-03-15 | 2019-03-15 13:04:23 | 1 | Metro |
| 7515 | 2019-03-15 | 2019-03-15 13:08:55 | 1 | 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;