View
museum_visit
One row per admitted ticket: the first entry of its day, with the transport answer.
Rows 5,176–5,200 of 9,383
| ticket_idINTEGER | visit_dateany | first_entry_atTEXT | entrance_idINTEGER | transport_modeTEXT |
|---|---|---|---|---|
| 5455 | 2018-03-25 | 2018-03-25 11:33:31 | 4 | Bus |
| 5456 | 2018-03-25 | 2018-03-25 11:33:37 | 4 | Bus |
| 5457 | 2018-04-19 | 2018-04-19 10:00:02 | 3 | Metro |
| 5458 | 2018-04-19 | 2018-04-19 10:00:10 | 3 | Metro |
| 5459 | 2018-04-19 | 2018-04-19 10:00:08 | 3 | Metro |
| 5460 | 2018-04-19 | 2018-04-19 09:59:37 | 3 | Metro |
| 5461 | 2018-04-01 | 2018-04-01 13:08:05 | 5 | Bus |
| 5462 | 2018-03-24 | 2018-03-24 10:59:16 | 1 | Walk |
| 5463 | 2018-03-24 | 2018-03-24 10:59:40 | 1 | Walk |
| 5464 | 2018-04-06 | 2018-04-06 10:43:51 | 2 | Metro |
| 5465 | 2018-04-06 | 2018-04-06 10:43:22 | 2 | Metro |
| 5466 | 2018-03-26 | 2018-03-26 10:54:58 | 1 | Metro |
| 5467 | 2018-03-26 | 2018-03-26 10:54:48 | 1 | Metro |
| 5468 | 2018-03-26 | 2018-03-26 12:24:35 | 3 | Train |
| 5469 | 2018-03-26 | 2018-03-26 12:24:06 | 3 | Train |
| 5470 | 2018-03-28 | 2018-03-28 10:17:52 | 1 | Walk |
| 5471 | 2018-03-29 | 2018-03-29 11:32:42 | 2 | Walk |
| 5472 | 2018-04-07 | 2018-04-07 09:13:59 | 1 | Walk |
| 5473 | 2018-04-07 | 2018-04-07 09:14:08 | 1 | Walk |
| 5474 | 2018-04-01 | 2018-04-01 15:58:44 | 3 | Train |
| 5475 | 2018-04-01 | 2018-04-01 15:58:40 | 3 | Train |
| 5476 | 2018-04-01 | 2018-04-01 14:44:08 | 1 | Walk |
| 5477 | 2018-03-29 | 2018-03-29 09:50:10 | 1 | Metro |
| 5478 | 2018-03-29 | 2018-03-29 09:49:44 | 1 | Metro |
| 5479 | 2018-03-29 | 2018-03-29 10:05:09 | 1 | Taxi |
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;