businesses_all_nested_no_reviews

The businesses_all_nested_no_reviews view will display all available fields in our business schema, except for reviews.

If using the csv format, it will keep all elements in multi-valued field lists in a single cell. This means a field like features will show up as a nested JSON object within the CSV.

Field NameIncluded Sub-Fields
addressN/A
careerPageURLN/A
categoriesN/A
cityN/A
claimedN/A
countryN/A
cuisinesN/A
dateAddedN/A
dateUpdatedN/A
descriptionsdateSeen
sourceURLs
value
emailsN/A
facebookPageURLN/A
faxesN/A
featureskey
value
hoursday
hour
imageURLsN/A
isClosedN/A
keysN/A
languagesSpokenN/A
latitudeN/A
longitudeN/A
menuPageURLN/A
menusamountMin
amountMax
category
currency
dateSeen
name
sourceURLs
nameN/A
neighborhoodsN/A
numEmployeesMinN/A
numEmployeesMaxN/A
numRoomN/A
paymentTypesN/A
peopledateSeen
name
title
phonesN/A
postalCodeN/A
priceRangeCurrencyN/A
priceRangeMinN/A
priceRangeMaxN/A
productsOrServicesN/A
provinceN/A
revenueCurrencyN/A
revenueMinN/A
revenueMaxN/A
roomsamountMin
amountMax
capacity
currency
dateSeen
roomType
sicN/A
sourceURLsN/A
twitterN/A
websitesN/A
yearIncorporatedN/A
yearOpenedN/A