Match tracker

HAMLIN PUB SAINT CLAIR
mi-lcc · 201 N Riverside Ave, Saint Clair, MI, 48079
Trace another record of this outlet: ab-inbevdoordashmi-lcc ✓mi-lccoverture
Joined with 4 other record(s) — by address+name, duplicate-listing.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng), phone
✓ Name: HAMLIN PUB SAINT CLAIR✓ Street with a house number: 201 N Riverside Ave✓ ZIP: 48079✓ City + state: Saint Clair, MI✓ Pin (lat/lng): 42.82383, -82.48589✓ Phone: 2485088261

2. Address joined

Is anyone else at this street + ZIP?
34 found (24 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
doordash hamlin pub saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture Hamlin Pub
201 N Riverside Ave, St Clair, MI, 48079
243 maddress+name rule: does not pass (name similarity 0.56)same outlet (through another record)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.43)same outlet (through another record)
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
28 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ttb SUES COFFEE HOUSE, INC.
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
0 maddress+name rule: does not pass (name similarity 0.17)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ttb WAR WATER, LLC
201 N RIVERSIDE AVE UNIT 8,12,13, ST. CLAIR, MI, 48079
0 maddress+name rule: does not pass (name similarity 0.16)not joined
ttb WAR WATER BREWERY
201 N RIVERSIDE AVE UNIT 8, 12, 13, ST. CLAIR, MI, 48079
0 maddress+name rule: does not pass (name similarity 0.16)not joined
ttb MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE UNIT B5, ST. CLAIR, MI, 48079
0 maddress+name rule: does not pass (name similarity 0.15)not joined
mi-lcc MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE, ST CLAIR, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ubereats Subway
201 N Riverside Ave, St Clair, MI, 48079
10 maddress+name rule: does not pass (name similarity 0.11)not joined
doordash t.a.p cafe saint clair
201 N Riverside Ave # Ste, Saint Clair, MI, 48079
118 maddress+name rule: does not pass (name similarity 0.42)not joined
doordash subway saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
122 maddress+name rule: does not pass (name similarity 0.47)not joined
overture War Water Brewery
201 N Riverside Ave, St Clair, MI, 48079
194 maddress+name rule: does not pass (name similarity 0.13)not joined
doordash hungry howie's saint clair
201 North Riverside Avenue, Saint Clair, MI, 48079
219 maddress+name rule: does not pass (name similarity 0.49)not joined
overture Sue's Coffee House
201 N Riverside Ave, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.17)not joined
overture Subway
201 N Riverside Ave Unit B7, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.11)not joined
ubereats Ace Hardware
201 N Riverside Ave, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.15)not joined
doordash the anchor point bistro 201 n riverside ave saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
232 maddress+name rule: does not pass (name similarity 0.30)not joined
overture The Anchor Point Bistro
201 N Riverside Ave, St Clair, MI, 48079
241 maddress+name rule: does not pass (name similarity 0.22)not joined
overture Ace Hardware
201 N Riverside Ave, St Clair, MI, 48079
243 maddress+name rule: does not pass (name similarity 0.15)not joined
doordash ace hardware saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
267 maddress+name rule: does not pass (name similarity 0.47)not joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
267 maddress+name rule: does not pass (name similarity 0.46)not joined
doordash manninas saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
273 maddress+name rule: does not pass (name similarity 0.56)not joined
overture S and A Liquor
201 N Riverside Ave, St Clair, MI, 48079
287 maddress+name rule: does not pass (name similarity 0.18)not joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.22)not joined
ab-inbev S & A LIQUOR STORE
201 N RIVERSIDE AVE STE A1, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.18)not joined

3. City key joined

Anyone at this street in this city (no ZIP needed)?
22 found (15 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
doordash hamlin pub saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.43)same outlet (through another record)
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ttb SUES COFFEE HOUSE, INC.
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
0 maddress+name rule: does not pass (name similarity 0.17)not joined
16 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
doordash t.a.p cafe saint clair
201 N Riverside Ave # Ste, Saint Clair, MI, 48079
118 maddress+name rule: does not pass (name similarity 0.42)not joined
doordash subway saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
122 maddress+name rule: does not pass (name similarity 0.47)not joined
doordash hungry howie's saint clair
201 North Riverside Avenue, Saint Clair, MI, 48079
219 maddress+name rule: does not pass (name similarity 0.49)not joined
overture Sue's Coffee House
201 N Riverside Ave, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.17)not joined
overture Subway
201 N Riverside Ave Unit B7, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.11)not joined
ubereats Ace Hardware
201 N Riverside Ave, Saint Clair, MI, 48079
228 maddress+name rule: does not pass (name similarity 0.15)not joined
doordash the anchor point bistro 201 n riverside ave saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
232 maddress+name rule: does not pass (name similarity 0.30)not joined
doordash ace hardware saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
267 maddress+name rule: does not pass (name similarity 0.47)not joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
267 maddress+name rule: does not pass (name similarity 0.46)not joined
doordash manninas saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
273 maddress+name rule: does not pass (name similarity 0.56)not joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.22)not joined
ab-inbev S & A LIQUOR STORE
201 N RIVERSIDE AVE STE A1, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.18)not joined

4. Street spelling found, not joined

Same house number, street written differently?
3 found (3 from another source); none joined by this step
RecordDistanceWhat the rule saysWhat the master did
ubereats Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
228 mstreet-variant rule: does not passnot joined
overture Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
259 mstreet-variant rule: does not passnot joined
ab-inbev MANNINAS WINE HOUSE
201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079
294 mstreet-variant rule: does not passnot joined

5. Nearby pins found, not joined

Anyone within 100 m?
15 within 100 m — distance alone never merges; these are questions for Claude
Pins are often geocoded from the address itself, so two pins agree whenever the addresses do — they cannot confirm a match, and never merge on their own.
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ttb SUES COFFEE HOUSE, INC.
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
0 mstratum same-addressnot joined
9 more
RecordDistanceWhat the rule saysWhat the master did
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ttb WAR WATER, LLC
201 N RIVERSIDE AVE UNIT 8,12,13, ST. CLAIR, MI, 48079
0 mstratum same-addressnot joined
ttb WAR WATER BREWERY
201 N RIVERSIDE AVE UNIT 8, 12, 13, ST. CLAIR, MI, 48079
0 mstratum same-addressnot joined
ttb MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE UNIT B5, ST. CLAIR, MI, 48079
0 mstratum same-addressnot joined
mi-lcc MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE, ST CLAIR, MI, 48079
0 msame source — different name: never merged within one sourcenot joined
ubereats Subway
201 N Riverside Ave, St Clair, MI, 48079
10 mstratum same-addressnot joined

6. Claude judge found, not joined

What did Claude's judge say?
answered 4 pair(s)
Haiku screens every candidate pair; only Opus judge claude-opus-5-5:v12:low can merge, at confidence ≥ 0.8, with a numbered street on both sides.
Pair withAnswerWhat the master did
doordash t.a.p cafe saint clair
201 N Riverside Ave # Ste, Saint Clair, MI, 48079
claude-haiku-5-5:v9:medium: different (0.80) — The two names (t.a.p cafe vs Hamlin Pub, legally M29 Ventures LLC) do not match, and the address is shared by 11 businesses, so the street address alone does not prove one outlet; only one record names a suite, so the premises cannot be connot joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
claude-haiku-5-5:v9:medium: different (0.93) — Record A is a Dollar Tree store listing while record B is a liquor licence for Hamlin Pub (legal entity M29 Ventures LLC), a bar; the names and business types differ, and the address is shared by eight businesses in a multi-tenant building,not joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
claude-haiku-5-5:v9:medium: different (0.72) — The two records share a street address in a building holding 8 businesses, and their names (Anchor Point Bistro vs Hamlin Pub, legal name M29 Ventures LLC) do not agree, so the address match alone does not show one outlet.not joined
ab-inbev S & A LIQUOR STORE
201 N RIVERSIDE AVE STE A1, SAINT CLAIR, MI, 48079
claude-haiku-5-5:v9:medium: different (0.90) — Record A is S & A Liquor Store and record B is Hamlin Pub filed under M29 Ventures LLC; the names do not match, and the address is shared by 8 differently named businesses, so the address match alone does not identify one outlet.not joined

7. Web agent nothing found

What did the web agent find?
not asked

8. Person nothing found

What did a person answer?
no answers yet

9. Result joined

Where did it end up?
one outlet with 4 other record(s)
Outlet O844fe454b7fc: 5 record(s) from ab-inbev, doordash, mi-lcc, overture.
RecordDistanceWhat the rule saysWhat the master did
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
0 msame source — identical name: a duplicate listingjoined (duplicate-listing)
doordash hamlin pub saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
overture Hamlin Pub
201 N Riverside Ave, St Clair, MI, 48079
243 maddress+name rule: does not pass (name similarity 0.56)same outlet (through another record)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
294 maddress+name rule: does not pass (name similarity 0.43)same outlet (through another record)
Read-only. Every candidate is scored by the same code the master build uses, and "what the master did" is what the last build stored. Each search shows at most 40 records.