Morrow CreekData Services
← Morrow Creek Data Journal

Quick data puzzle: same company or two different companies?

Zachery Knowles
Zachery KnowlesFounder, F.R.A.R.Y. Data Technologies LLC

Here are two completely fictional records:

FieldRecord ARecord B
CompanyNorth Ridge Equipment LLCNorth Ridge Equip.
Address42 Industrial Park Rd42 Industrial Park Road, Suite 100
Phone(555) 014-8821555-014-8821
Websitenorthridgeequipment.examplenorthridgeequipment.example

At first glance, these look like the same company written two different ways.

But would you merge them immediately?

Probably not.

The matching website and phone number are strong clues, but the suite difference still deserves attention. It could be a harmless formatting difference. It could also represent a separate location, department, or record that should remain distinct depending on the purpose of the dataset.

That is one of the small traps in data cleanup: similarity is useful evidence, but context decides what the evidence means.

The best answer is not always “merge” or “keep.” Sometimes the best answer is “verify first.”

Have a dataset that needs to become usable?

Morrow Creek Data Services handles paid research, cleanup, verification, and structured delivery projects.

Start a data project