business_flat

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

If using the csv format, it will split out elements in the menus field into separate rows. This means a single business with multiple menu items will show up in multiple, contiguous rows while its each entry in its menus field will show up in a separate row.

Field Name	Included Sub-Fields
`address`	N/A
`careerPageURL`	N/A
`categories`	N/A
`city`	N/A
`claimed`	N/A
`country`	N/A
`cuisines`	N/A
`dateAdded`	N/A
`dateUpdated`	N/A
`descriptions`	`dateSeen` `sourceURLs` `value`
`domains`	N/A
`emails`	N/A
`facebookPageURL`	N/A
`faxes`	N/A
`features`	`key` `value`
`hours`	`day` `dept` `hour` `meal`
`imageURLs`	N/A
`isClosed`	N/A
`keys`	N/A
`languagesSpoken`	N/A
`latitude`	N/A
`longitude`	N/A
`menuPageURL`	N/A
`menus`	`amountMin` `amountMax` `category` `currency` `dateSeen` `name` `sourceURLs`
`name`	N/A
`neighborhoods`	N/A
`numEmployeesMin`	N/A
`numEmployeesMax`	N/A
`numRoom`	N/A
`paymentTypes`	N/A
`people`	`dateSeen` `name` `title`
`phones`	N/A
`postalCode`	N/A
`priceRangeCurrency`	N/A
`priceRangeMin`	N/A
`priceRangeMax`	N/A
`productsOrServices`	N/A
`province`	N/A
`revenueCurrency`	N/A
`revenueMin`	N/A
`revenueMax`	N/A
`rooms`	`amountMin` `amountMax` `capacity` `currency` `dateSeen` `roomType`
`sic`	N/A
`sourceURLs`	N/A
`twitter`	N/A
`websites`	N/A
`yearIncorporated`	N/A
`yearOpened`	N/A