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 401–425 of 9,383

museum_visit, page 17 of 376
ticket_idINTEGERvisit_dateanyfirst_entry_atTEXTentrance_idINTEGERtransport_modeTEXT
4302015-05-032015-05-03 14:01:332Private Vehicle
4312015-05-032015-05-03 14:01:262Private Vehicle
4322015-05-302015-05-30 10:00:064Metro
4332015-05-302015-05-30 10:00:114Metro
4342015-05-302015-05-30 10:00:114Metro
4352015-05-052015-05-05 10:29:012Metro
4362015-05-052015-05-05 10:29:242Metro
4372015-05-052015-05-05 10:29:282Metro
4382015-05-052015-05-05 10:29:302Metro
4392015-05-052015-05-05 10:29:042Metro
4402015-05-062015-05-06 11:57:022Metro
4412015-05-062015-05-06 11:57:182Metro
4422015-05-092015-05-09 09:39:462Metro
4432015-05-062015-05-06 15:24:021Metro
4442015-05-222015-05-22 14:04:101Metro
4452015-05-222015-05-22 14:04:291Metro
4462015-05-222015-05-22 14:04:151Metro
4472015-05-252015-05-25 10:55:312Taxi
4482015-05-252015-05-25 10:54:572Taxi
4492015-05-252015-05-25 10:55:442Taxi
4502015-05-252015-05-25 10:55:042Taxi
4512015-05-252015-05-25 10:55:282Taxi
4522015-09-022015-09-02 12:07:191Bus
4532015-09-022015-09-02 12:07:331Bus
4542015-09-022015-09-02 12:07:451Bus
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;