Skip to content
Louvre Ops DB

Table

entry_scan

Every entrance scan; only the first of the day records how the visitor travelled.

Replaces in 2020: Entrance, Ticket.Transportation

Download CSV Query in playground

Rows 2,476–2,500 of 9,738

entry_scan, page 100 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
2476256422016-07-28 09:53:481Walk
2477256722016-07-28 11:29:311Walk
2478256522016-07-28 11:29:361Walk
2479256622016-07-28 11:30:111Walk
2480253412016-07-29 14:11:201Metro
2481257032016-07-30 16:23:351Taxi
2482257132016-07-30 16:24:171Taxi
2483256012016-07-31 09:43:551Other
2484244542016-07-31 10:28:281Bus
2485257622016-07-31 11:02:461Walk
2486257522016-07-31 11:02:491Walk
2487257822016-07-31 11:03:121Walk
2488257722016-07-31 11:03:181Walk
2489258012016-07-31 11:25:131Other
2490257912016-07-31 11:25:461Other
2491245342016-07-31 11:31:401Bus
2492255422016-07-31 13:09:481Metro
2493255022016-07-31 13:09:591Metro
2494255322016-07-31 13:10:081Metro
2495255222016-07-31 13:10:201Metro
2496255122016-07-31 13:10:321Metro
2497255722016-07-31 16:47:081Metro
2498255822016-07-31 16:47:091Metro
2499254432016-08-01 11:02:491Walk
2500254332016-08-01 11:03:211Walk
Table definition
CREATE TABLE entry_scan (
  scan_id        INTEGER PRIMARY KEY,
  ticket_id      INTEGER NOT NULL REFERENCES ticket (ticket_id),
  entrance_id    INTEGER NOT NULL REFERENCES entrance (entrance_id),
  scanned_at     TEXT NOT NULL,
  is_first_entry INTEGER NOT NULL CHECK (is_first_entry IN (0, 1)),
  transport_mode TEXT CHECK (transport_mode IN ('Walk', 'Metro', 'Train', 'Bus', 'Taxi', 'Private Vehicle', 'Other')),
  CHECK ((is_first_entry = 1) = (transport_mode IS NOT NULL))
) STRICT;