POI Opening Hours

🔢
SKU: DPK-POIADD-OPHO
Field Name
Defintion
Type
Example
poi_id 🔑
Unique identifier of a POI. Use it to recognise the point of interest or as a foreign key to link different files and/or packages together.
STRING
0090d26768e06f41d11bfabcf3d0d2cda69459ef
day_of_week 🔑
The day of the week taken into consideration to evaluate the opening hours of the POI.The valid range of values goes from 0 to 6, where: 0 = Sunday 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday
INTEGER
3
period_time 🔑
Progressive number of openings per day, representing the declared opening and closing time slots.
INTEGER
1
open_time
Opening time of a POI.Please note that if a POI, on one or more specific days, is closed then this field will have a value equal to "Closed".
STRING
10:00
close_time
Closing time of a POI.Please note that if a POI, on one or more specific days, is closed then this field will have a NULL value.
STRING
17:00
date_last_checked
Date corresponding to the last moment opening hours were present in our proprietary systems.The last presence of an opening hours is checked over a period of time equal to the last 3 months, starting from the value of the date_refreshed attribute.This date should not be regarded as a real date, since it does not necessarily mean that the opening hours have changed for the POI.
DATE
2023-10-20