FlowsBook a callSign inCreate free accountSign up
Business and places data

How to find the oldest businesses in an area

Use the opening date a places record carries, sort it earliest first, and check what the date really means before you call a shop the oldest on the street.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

To find the oldest businesses in an area, search the area for the kinds of place you care about, keep those whose record carries an opening date, and sort by that date from the earliest. The top of the list is your starting point, not your answer: many records have no date, and a date can mark when a business was first known at that spot rather than the year the company was founded. A short check of the top twenty turns the list into something you can quote.

This guide is for local journalists writing about long-standing shops, tourism boards building a heritage trail, banks and lenders who prefer established borrowers, advisers looking for owners who may be planning to sell, and anyone curious about the old firms of a street. It covers which fields help, a made-up example, the traps, and an AI employee that keeps the list current.

The fields that tell you a business's age

  • The opening date. Nearby places returns an opened field when the database knows when a place opened, and closed if it did. This is the only direct age field, and it is missing for a good share of places.
  • The number of reviews. A place with thousands of reviews has usually been around for years. It is a hint, not a date: a busy new restaurant can pass an old hardware shop in months.
  • Chain or independent. A branch of a chain may be new even when the brand is a century old. Independents are where the genuinely old local firms usually are.
  • The name. Words like 'and sons', 'established' or a year in the name are worth a second look, though they are only words.

How to build the list

  1. Draw the area you care about, such as an old town, a market district or a single high street, as an Area of interest.
  2. Search it with Nearby places for the kinds you want: bakeries, tailors, pharmacies, bookshops, hardware stores, or every kind.
  3. Sort with Sort and limit by Another field, opened, lowest first. Places with no date fall to the bottom by themselves.
  4. Keep the first 50 and set aside chains if you want only local firms.
  5. Check the top of the list against the shop's own sign or website, or a quick call.

A worked example (made up)

Say a made-up tourism office in Lisbon wants a walking trail of long-standing shops in its historic centre. It draws the old quarter, searches for cafes, bakeries, hat makers, grocers and bookshops, and sorts by opening date. The five oldest records it gets back are invented here to show what happens next.

PlaceOpened, per the recordReviewsWhat the check found
A bookshop19713,100Founded far earlier; the record dates from a move to this street
A glove maker1978640Same shop, same family since the record's date
A cafe19809,800Kept; famous and old
A grocer1983210Changed hands in 2019 under the same name
A bakery19861,450Kept

A made-up example. Dates and counts are invented to show how the check works.

The list was the right starting point and the wrong final word. The bookshop is much older than its record says, the grocer is old as a shop but new as a business, and the cafe with nearly ten thousand reviews earns its place. The office keeps all five on the trail, with the dates rewritten from what the shops themselves said.

Mistakes to avoid

  • Publishing the record's date as a founding year. Say 'at this address since' unless the business confirms more.
  • Ignoring the places with no date. Some of the oldest firms have never had their opening recorded. Scan the independents with many reviews among the undated ones too.
  • Searching too wide. 'The oldest in the city' is a much harder claim than 'the oldest on this street'. Start small.
  • Counting closed places. Make sure the status is open before you send people to a shop that shut last year.
  • Mixing chains in. A chain branch opened last year can sit beside a family shop of fifty years. Filter by chain if age is the story.

How to do it with an AI employee

If the list matters beyond one afternoon, an AI employee in xMap Flows can keep it fresh and tell you when an old firm closes.

  1. A Schedule runs every quarter.
  2. An Area of interest holds the district you drew.
  3. Nearby places searches it for your kinds of place, independents only if you like.
  4. Sort and limit orders by opened, earliest first, and keeps 50.
  5. A second, monthly employee reads that list as a saved list in My data, looks each place up again with Map business scan and runs What changed, passing on any place that now shows as closed or renamed.
  6. xMap LLM writes a line about each, and an Email with a map goes to you.

Each quarter you receive the fifty earliest-dated places of the district on a map, with a sentence on each, and a separate note whenever one of them closes or changes its name, which is often the moment a local story is worth writing.

Questions

Does every business have an opening date?

No. Many records have no date. Those places sort to the bottom of the list, so look at the undated independents with many reviews as well.

Is the opening date the year the company was founded?

Not always. It can be when the place was first known at that address, so a business that moved or changed hands may show a later date.

Can I use the number of reviews instead?

As a hint only. Many reviews usually means a place has been around a while, but a popular new place can collect them quickly.

How do I keep the list current?

Run it every quarter and add a check for closures, so you hear when a long-standing business shuts or changes its name.

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.