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,226–1,250 of 9,383

museum_visit, page 50 of 376
ticket_idINTEGERvisit_dateanyfirst_entry_atTEXTentrance_idINTEGERtransport_modeTEXT
13132015-10-122015-10-12 15:47:391Walk
13142015-10-122015-10-12 15:47:461Walk
13152015-10-132015-10-13 13:27:381Metro
13162015-10-132015-10-13 13:27:271Metro
13172015-10-142015-10-14 11:43:324Bus
13182015-10-142015-10-14 11:44:004Bus
13192015-10-142015-10-14 11:43:324Bus
13202015-10-162015-10-16 12:43:213Metro
13212015-10-162015-10-16 12:43:203Metro
13222015-10-262015-10-26 12:24:374Taxi
13232015-10-262015-10-26 12:24:464Taxi
13242015-10-152015-10-15 09:40:121Walk
13252015-10-152015-10-15 12:07:002Metro
13262015-10-162015-10-16 11:07:582Metro
13272015-10-162015-10-16 11:07:292Metro
13282015-11-082015-11-08 16:22:252Metro
13292015-11-082015-11-08 16:21:382Metro
13302015-11-082015-11-08 16:21:432Metro
13312015-10-182015-10-18 11:02:002Taxi
13322015-10-182015-10-18 13:44:352Metro
13332015-10-182015-10-18 13:44:342Metro
13342015-10-182015-10-18 13:45:142Metro
13352015-10-182015-10-18 13:45:142Metro
13362015-10-192015-10-19 16:44:291Train
13372015-10-192015-10-19 16:44:091Train
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;