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 4,701–4,725 of 9,738

entry_scan, page 189 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
4701474712017-11-11 10:55:361Train
4702474612017-11-11 10:56:021Train
4703484722017-11-12 10:12:551Metro
4704484812017-11-12 10:19:181Walk
4705484142017-11-12 10:40:291Taxi
4706485022017-11-13 10:11:581Metro
4707484922017-11-13 10:12:131Metro
4708484442017-11-13 10:51:051Metro
4709484542017-11-13 10:51:171Metro
4710485212017-11-15 12:23:151Walk
4711485112017-11-15 12:23:291Walk
4712478022017-11-15 12:31:391Metro
4713485322017-11-17 11:52:511Walk
4714485422017-11-17 11:53:221Walk
4715485622017-11-17 11:53:231Walk
4716485522017-11-17 11:53:391Walk
4717485422017-11-17 14:07:420NULL
4718485322017-11-17 14:22:590NULL
4719485622017-11-17 15:01:220NULL
4720485522017-11-17 15:30:420NULL
4721480812017-11-18 10:02:011Train
4722480712017-11-18 10:02:171Train
4723486022017-11-21 09:43:231Metro
4724486922017-11-21 11:26:261Metro
4725487022017-11-21 11:26:461Metro
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;