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 5,126–5,150 of 9,738

entry_scan, page 206 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
5126532622018-02-26 10:23:511Metro
5127532822018-02-26 10:24:091Metro
5128532722018-02-26 10:24:151Metro
5129530352018-02-26 14:55:451Metro
5130530552018-02-26 14:55:541Metro
5131530452018-02-26 14:55:551Metro
5132533312018-02-27 09:11:011Walk
5133529522018-02-27 16:18:321Metro
5134529622018-02-27 16:19:011Metro
5135533512018-03-01 10:21:381Taxi
5136533612018-03-01 10:21:391Taxi
5137526612018-03-01 10:48:461Walk
5138527952018-03-02 10:09:361Metro
5139527652018-03-02 10:09:561Metro
5140527752018-03-02 10:10:051Metro
5141527852018-03-02 10:10:101Metro
5142527322018-03-02 10:55:141Metro
5143527422018-03-02 10:55:221Metro
5144533942018-03-03 15:37:471Walk
5145532912018-03-04 09:13:461Bus
5146533212018-03-04 09:13:551Bus
5147533112018-03-04 09:14:061Bus
5148533012018-03-04 09:14:121Bus
5149530122018-03-05 14:15:201Metro
5150531512018-03-06 11:13:321Walk
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;