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,176–1,200 of 9,383

museum_visit, page 48 of 376
ticket_idINTEGERvisit_dateanyfirst_entry_atTEXTentrance_idINTEGERtransport_modeTEXT
12632015-10-262015-10-26 13:08:521Walk
12642015-10-262015-10-26 13:08:411Walk
12652015-10-052015-10-05 10:30:381Other
12662015-10-052015-10-05 10:30:271Other
12672015-10-022015-10-02 15:06:302Metro
12682015-10-022015-10-02 15:06:052Metro
12692015-10-022015-10-02 15:06:182Metro
12702015-10-022015-10-02 15:06:202Metro
12712015-10-022015-10-02 15:06:192Metro
12722015-09-302015-09-30 12:27:444Walk
12732015-09-302015-09-30 12:27:144Walk
12742015-10-012015-10-01 11:30:282Metro
12752015-10-012015-10-01 11:31:052Metro
12762015-10-132015-10-13 11:02:524Train
12772015-10-132015-10-13 11:02:534Train
12782015-10-132015-10-13 11:02:204Train
12792015-10-022015-10-02 09:25:401Other
12802015-10-022015-10-02 09:17:201Walk
12812015-10-022015-10-02 09:16:521Walk
12822015-10-022015-10-02 09:16:431Walk
12832015-10-022015-10-02 09:16:421Walk
12842015-10-022015-10-02 09:17:201Walk
12852015-10-022015-10-02 12:59:291Walk
12862015-10-022015-10-02 13:26:062Metro
12872015-10-022015-10-02 14:45:181Walk
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;