Core schema reference

All countries support the core schema, and then each country has additional schema items .

Opening hours reference

The regular hours of operation for a given opening hours type. Hours are separated by the day of the week. For periods that extend past midnight, the end time is truncated to 23:59:59.999999 and the following day contains an interval starting at 00:00:00.000000 . For example, if a place is open on Fridays from 8 AM to 12 PM and then from 8 PM to 2 AM, the periods for friday would be: [{start_time: "08:00:00", end_time: "12:00:00"}, {start_time: "20:00:00", end_time: "23:59:59.999999"}] .

To query for places open on Friday at 5 pm you could run the following query:

 SELECT 
  
 WITH 
  
 AGGREGATION_THRESHOLD 
  
 COUNT 
 ( 
 * 
 ) 
  
 AS 
  
 count 
 FROM 
  
 ` PROJECT_NAME 
.places_insights___us___sample.places_sample` 
 WHERE 
  
 EXISTS 
 ( 
 SELECT 
  
 * 
  
 FROM 
  
 UNNEST 
 ( 
 regular_opening_hours 
 . 
 friday 
 ) 
  
 WHERE 
  
 '17:00:00' 
  
 BETWEEN 
  
 start_time 
  
 AND 
  
 end_time 
 ) 

The full schema for opening hours fields is as follows: