business_flat_reviews

The business_flat_reviews view will display all available fields in our Business Data Schema.

If using the csv format, it will split each review into its own row. All other fields will be condensed into single cells and repeated along with each review row.

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
domainsN/A
emailsN/A
facebookPageURLN/A
faxesN/A
featureskey
value
hoursday
dept
hour
meal
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
reviewsdate
dateAdded
dateSeen
sourceURLs
text
roomsamountMin
amountMax
capacity
currency
dateSeen
roomType
sicN/A
sourceURLsN/A
twitterN/A
websitesN/A
yearIncorporatedN/A
yearOpenedN/A