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 1,476–1,500 of 9,738

entry_scan, page 60 of 390
scan_idINTEGERticket_id→ ticket.ticket_identrance_id→ entrance.entrance_idscanned_atTEXTis_first_entryINTEGERtransport_modeTEXT
1476157222015-12-09 09:27:161Metro
1477156922015-12-09 09:27:251Metro
1478157022015-12-09 09:27:391Metro
1479156822015-12-09 09:27:411Metro
1480157322015-12-09 09:58:401Metro
1481157322015-12-09 12:55:580NULL
1482157542015-12-09 13:38:171Bus
1483157742015-12-09 13:38:441Bus
1484157642015-12-09 13:38:591Bus
1485157812015-12-11 12:30:551Walk
1486157912015-12-11 14:56:071Metro
1487158032015-12-12 09:43:351Walk
1488158142015-12-12 15:14:141Walk
1489158212015-12-13 16:22:451Metro
1490158722015-12-15 10:39:551Private Vehicle
1491158622015-12-15 10:40:061Private Vehicle
1492158822015-12-15 10:40:081Private Vehicle
1493158922015-12-15 10:40:181Private Vehicle
1494158622015-12-15 12:31:050NULL
1495157422015-12-15 12:31:501Metro
1496158722015-12-15 13:09:160NULL
1497158952015-12-15 14:11:210NULL
1498158822015-12-15 14:17:320NULL
1499154012015-12-16 15:59:441Walk
1500159142015-12-17 09:04:361Bus
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;