All countries support the core schema, and then each country has additional schema items.
| Field Name | Type | Mode | Description |
|---|---|---|---|
point |
GEOGRAPHY |
NULLABLE |
The location of the place as a Point geography type object. |
id |
STRING |
NULLABLE |
The unique place id. See Place IDs. |
types |
STRING |
REPEATED |
A set of type tags for the place. For example, "restaurant" and "cafe". For the complete list of possible values, see Table A and Table B at Place Types. |
primary_type |
STRING |
NULLABLE |
The primary type of the place. This type must be one of the Places API supported types. For example, "restaurant", "cafe", "airport", etc. A place can only have a single primary type. For the complete list of possible values, see Table A and Table B at Place Types. |
country_code |
STRING |
NULLABLE |
The country code in the Unicode CLDR format. |
location |
RECORD |
NULLABLE |
The position of the place. |
location.latitude |
FLOAT |
NULLABLE |
The latitude in degrees. Ranges from -90.0 to 90.0. |
location.longitude |
FLOAT |
NULLABLE |
The longitude in degrees. Ranges from -180.0 to 180.0. |
rating |
FLOAT |
NULLABLE |
A rating between 1.0 and 5.0, based on user reviews of the place. |
user_rating_count |
INTEGER |
NULLABLE |
The total number of reviews for the place. |
price_level |
STRING |
NULLABLE |
Price level of the place. Possible values are "PRICE_LEVEL_FREE", "PRICE_LEVEL_INEXPENSIVE", "PRICE_LEVEL_MODERATE", "PRICE_LEVEL_EXPENSIVE", and "PRICE_LEVEL_VERY_EXPENSIVE". |
business_status |
STRING |
NULLABLE |
The business status for the place. Possible values are "OPERATIONAL", "CLOSED_TEMPORARILY", and "CLOSED_PERMANENTLY". |
takeout |
BOOLEAN |
NULLABLE |
Place supports takeout. |
delivery |
BOOLEAN |
NULLABLE |
Place supports delivery. |
dine_in |
BOOLEAN |
NULLABLE |
Place supports indoor or outdoor seating options. |
curbside_pickup |
BOOLEAN |
NULLABLE |
Place supports curbside pickup. |
reservable |
BOOLEAN |
NULLABLE |
Place supports reservations. |
serves_breakfast |
BOOLEAN |
NULLABLE |
Place serves breakfast. |
serves_lunch |
BOOLEAN |
NULLABLE |
Place serves lunch. |
serves_dinner |
BOOLEAN |
NULLABLE |
Place serves dinner. |
serves_beer |
BOOLEAN |
NULLABLE |
Place serves beer. |
serves_wine |
BOOLEAN |
NULLABLE |
Place serves wine. |
serves_brunch |
BOOLEAN |
NULLABLE |
Place serves brunch. |
serves_vegetarian_food |
BOOLEAN |
NULLABLE |
Place serves vegetarian food. |
outdoor_seating |
BOOLEAN |
NULLABLE |
Place provides outdoor seating. |
live_music |
BOOLEAN |
NULLABLE |
Place provides live music. |
menu_for_children |
BOOLEAN |
NULLABLE |
Place has a children's menu. |
serves_cocktails |
BOOLEAN |
NULLABLE |
Place serves cocktails. |
serves_dessert |
BOOLEAN |
NULLABLE |
Place serves dessert. |
serves_coffee |
BOOLEAN |
NULLABLE |
Place serves coffee. |
good_for_children |
BOOLEAN |
NULLABLE |
Place is good for children. |
allows_dogs |
BOOLEAN |
NULLABLE |
Place allows dogs. |
restroom |
BOOLEAN |
NULLABLE |
Place has a restroom. |
good_for_groups |
BOOLEAN |
NULLABLE |
Place accommodates groups. |
good_for_watching_sports |
BOOLEAN |
NULLABLE |
Place is suitable for watching sports. |
accepts_credit_cards |
BOOLEAN |
NULLABLE |
Place accepts credit cards as payment. |
accepts_debit_cards |
BOOLEAN |
NULLABLE |
Place accepts debit cards as payment. |
accepts_cash_only |
BOOLEAN |
NULLABLE |
Place accepts cash only as payment. Places with this attribute may still accept other payment methods. |
accepts_nfc |
BOOLEAN |
NULLABLE |
Place accepts NFC payments. |
free_parking_lot |
BOOLEAN |
NULLABLE |
Place offers free parking lots. |
paid_parking_lot |
BOOLEAN |
NULLABLE |
Place offers paid parking lots. |
free_street_parking |
BOOLEAN |
NULLABLE |
Place offers free street parking. |
paid_street_parking |
BOOLEAN |
NULLABLE |
Place offers paid street parking. |
valet_parking |
BOOLEAN |
NULLABLE |
Place offers valet parking. |
free_garage_parking |
BOOLEAN |
NULLABLE |
Place offers free garage parking. |
paid_garage_parking |
BOOLEAN |
NULLABLE |
Place offers paid garage parking. |
wheelchair_accessible_parking |
BOOLEAN |
NULLABLE |
Place offers wheelchair accessible parking. |
wheelchair_accessible_entrance |
BOOLEAN |
NULLABLE |
Place has a wheelchair accessible entrance. |
wheelchair_accessible_restroom |
BOOLEAN |
NULLABLE |
Place has a wheelchair accessible restroom. |
wheelchair_accessible_seating |
BOOLEAN |
NULLABLE |
Place has wheelchair accessible seating. |
regular_opening_hours |
RECORD |
NULLABLE |
The regular hours of operation. 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 regular_opening_hours.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "HAPPY_HOUR". 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 regular_opening_hours_happy_hour.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_happy_hour.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_happy_hour.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_happy_hour.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_happy_hour.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_happy_hour.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_happy_hour.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_happy_hour.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_happy_hour.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_happy_hour.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_happy_hour.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_happy_hour.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "DRIVE_THROUGH". 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 regular_opening_hours_drive_through.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_drive_through.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_drive_through.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_drive_through.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_drive_through.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_drive_through.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_drive_through.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_drive_through.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_drive_through.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_drive_through.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_drive_through.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_drive_through.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "DELIVERY". 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 regular_opening_hours_delivery.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_delivery.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_delivery.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_delivery.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_delivery.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_delivery.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_delivery.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_delivery.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_delivery.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_delivery.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_delivery.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_delivery.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "TAKEOUT". 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 regular_opening_hours_takeout.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_takeout.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_takeout.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_takeout.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_takeout.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_takeout.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_takeout.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_takeout.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_takeout.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_takeout.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_takeout.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_takeout.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "KITCHEN". 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 regular_opening_hours_kitchen.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_kitchen.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_kitchen.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_kitchen.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_kitchen.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_kitchen.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_kitchen.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_kitchen.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_kitchen.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_kitchen.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_kitchen.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_kitchen.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "BREAKFAST". 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 regular_opening_hours_breakfast.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_breakfast.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_breakfast.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_breakfast.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_breakfast.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_breakfast.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_breakfast.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_breakfast.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_breakfast.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_breakfast.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_breakfast.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_breakfast.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "LUNCH". 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 regular_opening_hours_lunch.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_lunch.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_lunch.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_lunch.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_lunch.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_lunch.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_lunch.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_lunch.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_lunch.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_lunch.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_lunch.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_lunch.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "DINNER". 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 regular_opening_hours_dinner.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_dinner.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_dinner.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_dinner.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_dinner.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_dinner.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_dinner.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_dinner.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_dinner.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_dinner.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_dinner.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_dinner.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "BRUNCH". 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 regular_opening_hours_brunch.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_brunch.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_brunch.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_brunch.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_brunch.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_brunch.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_brunch.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_brunch.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_brunch.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_brunch.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_brunch.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_brunch.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "PICKUP". 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 regular_opening_hours_pickup.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_pickup.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_pickup.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_pickup.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_pickup.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_pickup.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_pickup.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_pickup.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_pickup.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_pickup.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_pickup.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_pickup.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "ACCESS". 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 regular_opening_hours_access.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_access.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_access.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_access.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_access.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_access.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_access.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_access.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_access.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_access.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_access.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_access.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "SENIOR_HOURS". 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 regular_opening_hours_senior_hours.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_senior_hours.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_senior_hours.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_senior_hours.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_senior_hours.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_senior_hours.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_senior_hours.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_senior_hours.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_senior_hours.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_senior_hours.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_senior_hours.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_senior_hours.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours |
RECORD |
NULLABLE |
The regular hours of operation for the secondary hours type "ONLINE_SERVICE_HOURS". 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 regular_opening_hours_online_service_hours.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(*) FROM `places` WHERE EXISTS(SELECT * FROM UNNEST(regular_opening_hours_online_service_hours.friday) WHERE '17:00:00' BETWEEN start_time AND end_time)". |
regular_opening_hours_online_service_hours.monday |
RECORD |
REPEATED |
The list of periods on Monday during which the place is open. |
regular_opening_hours_online_service_hours.monday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.monday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.tuesday |
RECORD |
REPEATED |
The list of periods on Tuesday during which the place is open. |
regular_opening_hours_online_service_hours.tuesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.tuesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.wednesday |
RECORD |
REPEATED |
The list of periods on Wednesday during which the place is open. |
regular_opening_hours_online_service_hours.wednesday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.wednesday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.thursday |
RECORD |
REPEATED |
The list of periods on Thursday during which the place is open. |
regular_opening_hours_online_service_hours.thursday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.thursday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.friday |
RECORD |
REPEATED |
The list of periods on Friday during which the place is open. |
regular_opening_hours_online_service_hours.friday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.friday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.saturday |
RECORD |
REPEATED |
The list of periods on Saturday during which the place is open. |
regular_opening_hours_online_service_hours.saturday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.saturday.end_time |
TIME |
NULLABLE |
End of the period. |
regular_opening_hours_online_service_hours.sunday |
RECORD |
REPEATED |
The list of periods on Sunday during which the place is open. |
regular_opening_hours_online_service_hours.sunday.start_time |
TIME |
NULLABLE |
Start of the period. |
regular_opening_hours_online_service_hours.sunday.end_time |
TIME |
NULLABLE |
End of the period. |
ev_charge_options |
RECORD |
NULLABLE |
Information about the EV Charge Station hosted at the place. Terminology follows https://afdc.energy.gov/fuels/electricity_infrastructure.html. One port could charge one car at a time. One port has one or more connectors. One station has one or more ports. |
ev_charge_options.connector_count |
INTEGER |
NULLABLE |
Number of connectors at this station. However, because some ports can have multiple connectors but only be able to charge one car at a time (e.g.) the number of connectors may be greater than the total number of cars which can charge simultaneously. |
ev_charge_options.connector_aggregation |
RECORD |
REPEATED |
A list of EV charging connector aggregations that contain connectors of the same type and same charge rate. |
ev_charge_options.connector_aggregation.type |
STRING |
NULLABLE |
The connector type of this aggregation. |
ev_charge_options.connector_aggregation.max_charge_rate_kw |
FLOAT |
NULLABLE |
The static max charging rate in kw of each connector in the aggregation. |
ev_charge_options.connector_aggregation.count |
INTEGER |
NULLABLE |
Number of connectors in this aggregation. |
brand_ids |
STRING |
REPEATED |
The unique identifiers for brands. |