LogoLogo
English
English
  • X-ASSIST
  • Getting Started
  • X-ASSIST App
    • X-ASSIST App
    • On-Trip Data Integration
  • Travel Monitor
    • Travel Monitor Settings
      • General Settings
      • Roles and Responsibilities
      • Pre-trip Information
      • Alerting
    • Operating the Travel Monitor
      • Travellers
      • Status and Icons
      • Site Management
      • Expat Management
      • Alerts and Special Alerts
    • FAQ
      • Assistance
      • Alerting
      • Permissions
      • Data
  • RISK MAP
    • Risk Map
  • Global Events
    • Global Events
    • Events and Incidents
    • Multiple Views
    • Email Information for Events
    • FAQ
  • Country Information
    • Country Risks
      • Executive Summary
      • Risk Overview
      • Medical Risks
      • Advisory
      • Charts
      • Country Favourites
      • Security Risk Icons
    • Visa Requirements
    • FAQ
  • ARTICLES
    • Articles
  • ADMIN AREA
    • Admin Area
    • User Profile
    • FAQ
  • INTERFACES
    • Login Options and User Integration
    • Travel Data Interface
    • Travel Data Integration
    • API Access
    • FAQ
  • Analytics
    • Introduction
    • Analytics Tutorial
    • The Panel Editor
    • Global Filters
    • Dashboard Sharing
    • Data Dictionary
      • Airlines
      • Airports
      • Alerts
      • Bookings
      • Countries
      • Country Stays
      • Events
      • Organizations
      • People
      • Status Requests
Powered by GitBook
On this page
  • Measures
  • Count
  • Dimensions
  • Start date
  • End date
  • Valid on
  • Join compatibility
Export as PDF
  1. Analytics
  2. Data Dictionary

Country Stays

PreviousCountriesNextEvents

Last updated 1 year ago

The “Country Stays” cube contains information about the countries that people visit.

A stay in a country is defined as the time interval between entering and exiting the country. Stays which last less than 8 hours (e.g. by people who commute daily between countries) are ignored to reduce noise.

Ongoing stays have an indeterminate length, since their end date is not known yet.

“Country Stays” is a that allows change tracking over time by applying a filter to “Country stays – Valid on” or selecting it as a time dimension.

Measures

Count

The number of distinct country stays in the result set.

Dimensions

Start date

The UTC timestamp at which the person entered the country.

End date

The UTC timestamp at which the person left the country. This value is optional.

Valid on

The UTC period during which the record was valid (i.e. the time from creation to deletion of the record).

Join compatibility

Country stays can be joined with:

Type 2 SCD
Countries
Organizations
People