FlowsBook a callSign inCreate free accountSign up
Business and places data

How to read the opened field in a list of places, date by date

Business opening dates data shows when a place started, when known. How to read a date, a blank and a cluster of new dates, and how to filter on them without losing places.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

Business opening dates data gives each place the month or day it is recorded as having started trading, when that is known. Read it as the start of this business at this address, not the age of the building or of the brand, and treat a blank as unknown rather than old. Used that way, the opened field answers three practical questions: what is new near me, how long have my neighbours been here, and is this market churning or settled.

This piece is for people who are about to filter or count on that field: a sales team chasing new openings, an analyst comparing two cities, a landlord pricing a street. It explains what a date can and cannot carry, shows real figures, and ends with how to use the field in a flow without throwing away good places by accident.

What a single date can tell you

When Nearby places returns a place from xMap's places database it can carry opened and, for a place that shut, closed. A recent date usually means a genuinely new business: a new owner, a new concept or a new branch. An old date tells you the business has lasted, which matters when you judge a supplier, a partner or a location.

Three things a date does not carry:

  • The brand's age. A chain founded decades ago opens new branches every month; each branch gets its own date.
  • Continuity at the address. If a restaurant changes hands and name, the new one gets a new date even though the kitchen never closed.
  • Exactness. Some dates are a first day of trading, others the month the listing first appeared. Read them to the month, not the day.

How complete is the field? Real figures

Coverage depends on the kind of place and the city, so look before you rely on it. In the November 2026 figures from xMap's places database, almost every place near a city centre had a date, and the share that opened recently differed sharply between markets.

MarketWith an opening dateOpened in the 12 months before
Dentists, Toronto457 of the 460 nearest the centre42
Cafes, Toronto309 of the 312 nearest the centre31
Cafes, London342 of the 342 nearest the centre5
Bakeries, Sydney369 of the 370 nearest the centre14

xMap's places database, places within 10 km of each city centre, November 2026; each line is worked out from the places nearest the centre named in it.

Read the table carefully. Thirty-one new cafes among 309 dated ones near the centre of Toronto, against five among 342 near the centre of London, says Toronto's central cafe scene was turning over faster that year. It does not say London has fewer new cafes overall: both lines are samples of the places nearest the centre, not whole cities.

Filtering on the field without losing places

Nearby places has an Opened setting with Any time, Last 6 months, Last 12 months and Last 2 years. Choosing one keeps only places that opened in that window, and it leaves out every place the database has no opening date for. That is right when you want a clean list of new openings. It is wrong when you are counting a market, because undated places silently drop out of the total.

  1. For a list of new places, set Opened to Last 6 months and add Only new, so each opening reaches you once.
  2. For a count of a market, leave Opened on Any time and count everything; then read the opened field on the results to see how many are recent.
  3. For an age profile of a street, keep Any time, then use Calculated field to turn the date into years trading, and Sort and limit to list the longest-standing first.

When the data has no dates at all

Some sources carry no opening date. Map business scan, which searches online maps live, is one of them. With it, the practical stand-in is the date your own flow first saw a place. Only new adds first_seen to every item it lets through, so after a few weeks of daily runs you have your own record of when each business appeared in your area, which is often closer to what a sales team means by new.

A made-up example: welcome visits in Sao Paulo

This example is invented. A card-payments company in Sao Paulo visits businesses in their first months, before they have settled on a provider. Its flow searches Restaurant, Bakery and Beauty salon across three districts every Monday with Opened set to Last 6 months, keeps only places with a phone or website, passes them through Only new, and writes a short welcome note for each with xMap LLM. Say twenty places arrive in the first week and four to eight each week after. The rep starts with the most recent dates, because a business that opened last month has not yet signed with anyone.

Reading dates well is a small skill that pays off across location intelligence automation: counts become honest, new-opening alerts stop repeating, and reports say what they actually measured.

Questions

Why do some places have no opening date?

The source never recorded one, often for long-established or very small businesses. A blank means unknown, so do not read it as old.

Does a new opening date mean a new building?

No. It marks this business starting at this address. A change of owner or name gives a new date even when the premises stayed open.

Can I get openings from the last week only?

The Opened setting goes down to the last 6 months. For the last week, run the search daily with Only new and read first_seen, the day your flow first found each place.

Are opening dates available in every country?

Coverage varies by city and kind of place. Look at the opened field on a test run for your own area before you build a report on it.

Templates that do this

Read next

More on business and places data · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.