- query
- The search you submitted, repeated on every row it produced -
bars, NY, USA and the like. - name
- The business name as Bing lists it. Some listings carry promotional text in the name field rather than a clean trading name.
- category
- Bing's specific category for the business -
Bar, Cocktail bar, Restaurant. The detailed one of the two classification columns. Occasionally empty. - style
- A broader bucket than
category - several categories collapse into one style. Useful for grouping; use category when you need the detail. Treat the vocabulary as open. - phone
- The contact number as the listing published it. Not normalised - the format varies by market, so clean it before dialling or deduping. Optional.
- website
- The business's own site. Optional, and it is sometimes a social profile rather than a domain of its own.
- address
- The full address as one line -
18 Lebanon St, Hamilton, NY 13346. Not split into street, city and postcode; parse it yourself if you need the parts. - rating
- The star rating, as a string in half steps. Not zero-padded -
4 occurs alongside 4.5. Read it with the caveat below about reviews. - reviews
- The column exists in the header but carries nothing, so the rating arrives without any volume behind it. See the note below.
- latitude
- The business's latitude, as a string. Cast before you plot.
- longitude
- The business's longitude, as a string. With
latitude, this is what lets you map the file without parsing the address. - image
- A thumbnail for the business, on Bing's image host. Optional.
- ypid
- Bing's own identifier for the place. Not fixed width - usually a short
YN… string, but at least one row carried a much longer encoded token, so size any column for it generously. - position
- 1-based rank within the query, in the order Bing returned the business. JSON only - the CSV and XLSX exports stop at thirteen columns.