Skip to content
Louvre Ops DB

View

museum_visit

One row per admitted ticket: the first entry of its day, with the transport answer.

Download CSV Query in playground

Rows 1,151–1,175 of 9,383

museum_visit, page 47 of 376
ticket_idINTEGERvisit_dateanyfirst_entry_atTEXTentrance_idINTEGERtransport_modeTEXT
12322015-12-082015-12-08 12:19:554Metro
12342015-12-082015-12-08 12:22:064Metro
12352015-12-082015-12-08 12:19:434Metro
12362015-12-082015-12-08 12:20:104Metro
12372015-12-082015-12-08 12:22:394Metro
12382015-12-082015-12-08 12:20:454Metro
12412015-12-082015-12-08 12:22:094Metro
12422015-12-082015-12-08 12:22:454Metro
12432015-12-082015-12-08 12:21:594Metro
12442015-12-082015-12-08 12:22:074Metro
12452015-12-082015-12-08 12:24:454Metro
12462015-12-082015-12-08 12:21:524Metro
12472015-12-082015-12-08 12:20:234Metro
12492015-12-082015-12-08 12:24:514Metro
12522015-12-082015-12-08 12:22:474Metro
12532015-09-252015-09-25 10:32:581Walk
12542015-09-252015-09-25 10:51:322Metro
12552015-09-272015-09-27 10:47:274Walk
12562015-09-272015-09-27 10:46:544Walk
12572015-09-272015-09-27 10:46:594Walk
12582015-09-272015-09-27 10:47:064Walk
12592015-09-272015-09-27 10:47:144Walk
12602015-09-272015-09-27 11:03:432Metro
12612015-09-272015-09-27 12:58:292Metro
12622015-09-272015-09-27 12:58:272Metro
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;