Skip to content

POI Prices and Occupancy Rates

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
occupancy_rate Occupancy rate in the aggregation period detected by OTAs (Online Travel Agencies). DOUBLE
median_price Median price in the aggregation period. DOUBLE
min_price Minimum price in the aggregation period. DOUBLE
max_price Maximum price in the aggregation period. DOUBLE

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