Skip to content

Points Of Interest - Footfall Time of Day Breakdown

This CSV file relates to POI_Main_Listing file through the poi_id key field.

Field Description Type
poi_id primary key Unique POI identifier. STRING
date primary key The date of the analysis, based on the aggregated period chosen:
  • DAILY: the single day (ex. 2022-01-13).
  • WEEKLY: the first day of the week, starting from Monday (ex. 2022-01-10).
  • MONTHLY: the first day of the month (ex. 2022-01-01).
  • QUARTERLY: the first day of the quarter (ex. 2022-01-01).
 DATE
period primary key
  • weekdays.
  • weekend.
 STRING
time_period primary key
  • (05-10) Early morning.
  • (10-12) Late morning.
  • (12-15) Early Afternoon.
  • (15-18) Late Afternoon.
  • (18-20) Evening Afternoon.
  • (20-23) Night.
  • (23-05) Late Night.
 STRING
footfall The footfall score is a proprietary, absolute and uncapped index that measures the foot traffic and popularity of a POI over time. This indicator takes into account various factors, such as the number of geo-localised reviews and social media content and others when available.
Footfall can be compared among POIs/tiles of the same industry.		 DOUBLE

*The above fields in bold are considered the primary keys of the csv file.