Match tracker

hamlin pub saint clair
doordash · 201 N Riverside Ave, Saint Clair, MI, 48079
Trace another record of this outlet: ab-inbevdoordash ✓mi-lccmi-lccoverture
Joined with 4 other record(s) — by address+name.

1. Record ready

What does the record carry?
has name, street with a house number, zip, city + state, pin (lat/lng)
✓ 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.82581, -82.48580✗ Phone

2. Address joined

Is anyone else at this street + ZIP?
34 found (27 from another source); joined
RecordDistanceWhat the rule saysWhat the master did
overture Hamlin Pub
201 N Riverside Ave, St Clair, MI, 48079
25 maddress+name rule: passes (name similarity 0.72)joined (address+name)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
91 maddress+name rule: passes (name similarity 0.64)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash hungry howie's saint clair
201 North Riverside Avenue, Saint Clair, MI, 48079
5 msame source — different name: never merged within one sourcenot joined
ubereats Ace Hardware
201 N Riverside Ave, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.15)not joined
28 more
RecordDistanceWhat the rule saysWhat the master did
overture Sue's Coffee House
201 N Riverside Ave, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.15)not joined
overture Subway
201 N Riverside Ave Unit B7, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.12)not joined
overture The Anchor Point Bistro
201 N Riverside Ave, St Clair, MI, 48079
24 maddress+name rule: does not pass (name similarity 0.22)not joined
doordash the anchor point bistro 201 n riverside ave saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
39 msame source — different name: never merged within one sourcenot joined
overture War Water Brewery
201 N Riverside Ave, St Clair, MI, 48079
41 maddress+name rule: does not pass (name similarity 0.13)not joined
doordash ace hardware saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash manninas saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
55 msame source — different name: never merged within one sourcenot joined
overture Ace Hardware
201 N Riverside Ave, St Clair, MI, 48079
62 maddress+name rule: does not pass (name similarity 0.15)not joined
overture S and A Liquor
201 N Riverside Ave, St Clair, MI, 48079
68 maddress+name rule: does not pass (name similarity 0.23)not joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
91 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
91 maddress+name rule: does not pass (name similarity 0.20)not joined
doordash t.a.p cafe saint clair
201 N Riverside Ave # Ste, Saint Clair, MI, 48079
103 msame source — different name: never merged within one sourcenot joined
doordash subway saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
105 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
220 maddress+name rule: does not pass (name similarity 0.22)not joined
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.22)not joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
ttb MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE UNIT B5, ST. CLAIR, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
mi-lcc MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE, ST CLAIR, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
ttb WAR WATER, LLC
201 N RIVERSIDE AVE UNIT 8,12,13, ST. CLAIR, MI, 48079
220 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
220 maddress+name rule: does not pass (name similarity 0.16)not joined
ttb SUES COFFEE HOUSE, INC.
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.15)not joined
ubereats Subway
201 N Riverside Ave, St Clair, MI, 48079
225 maddress+name rule: does not pass (name similarity 0.14)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
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
91 maddress+name rule: passes (name similarity 0.64)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
doordash hungry howie's saint clair
201 North Riverside Avenue, Saint Clair, MI, 48079
5 msame source — different name: never merged within one sourcenot joined
ubereats Ace Hardware
201 N Riverside Ave, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.15)not joined
overture Sue's Coffee House
201 N Riverside Ave, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.15)not joined
16 more
RecordDistanceWhat the rule saysWhat the master did
overture Subway
201 N Riverside Ave Unit B7, Saint Clair, MI, 48079
11 maddress+name rule: does not pass (name similarity 0.12)not joined
doordash the anchor point bistro 201 n riverside ave saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
39 msame source — different name: never merged within one sourcenot joined
doordash ace hardware saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash manninas saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
55 msame source — different name: never merged within one sourcenot joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
91 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
91 maddress+name rule: does not pass (name similarity 0.20)not joined
doordash t.a.p cafe saint clair
201 N Riverside Ave # Ste, Saint Clair, MI, 48079
103 msame source — different name: never merged within one sourcenot joined
doordash subway saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
105 msame source — different name: never merged within one sourcenot joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.20)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
mi-lcc WAR WATER
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.16)not joined
ttb SUES COFFEE HOUSE, INC.
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
220 maddress+name rule: does not pass (name similarity 0.15)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
11 mstreet-variant rule: does not passnot joined
overture Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
43 mstreet-variant rule: does not passnot joined
ab-inbev MANNINAS WINE HOUSE
201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079
91 mstreet-variant rule: does not passnot joined

5. Nearby pins found, not joined

Anyone within 100 m?
19 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
overture Hamlin Pub
201 N Riverside Ave, St Clair, MI, 48079
25 mstratum addr-agreejoined (address+name)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
91 mstratum addr-agreejoined (address+name)
doordash hungry howie's saint clair
201 North Riverside Avenue, Saint Clair, MI, 48079
5 msame source — different name: never merged within one sourcenot joined
ubereats Ace Hardware
201 N Riverside Ave, Saint Clair, MI, 48079
11 mstratum same-addressnot joined
ubereats Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
11 mstratum same-addressnot joined
overture Sue's Coffee House
201 N Riverside Ave, Saint Clair, MI, 48079
11 mstratum same-addressnot joined
13 more
RecordDistanceWhat the rule saysWhat the master did
overture Subway
201 N Riverside Ave Unit B7, Saint Clair, MI, 48079
11 mstratum same-addressnot joined
overture The Anchor Point Bistro
201 N Riverside Ave, St Clair, MI, 48079
24 mstratum same-addressnot joined
doordash the anchor point bistro 201 n riverside ave saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
39 msame source — different name: never merged within one sourcenot joined
overture War Water Brewery
201 N Riverside Ave, St Clair, MI, 48079
41 mstratum same-addressnot joined
overture Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
43 mstratum same-addressnot joined
doordash ace hardware saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash dollar tree saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
50 msame source — different name: never merged within one sourcenot joined
doordash manninas saint clair
201 N Riverside Ave, Saint Clair, MI, 48079
55 msame source — different name: never merged within one sourcenot joined
overture Ace Hardware
201 N Riverside Ave, St Clair, MI, 48079
62 mstratum same-addressnot joined
overture S and A Liquor
201 N Riverside Ave, St Clair, MI, 48079
68 mstratum same-addressnot joined
ab-inbev ANCHOR POINT BISTRO
201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079
91 mstratum same-addressnot joined
ab-inbev S & A LIQUOR STORE
201 N RIVERSIDE AVE STE A1, SAINT CLAIR, MI, 48079
91 mstratum same-addressnot joined
ab-inbev MANNINAS WINE HOUSE
201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079
91 mstratum same-addressnot joined

6. Claude judge found, not joined

What did Claude's judge say?
answered 5 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
ubereats Dollar Tree
201 N Riverside Unit B1, St Clair, MI, 48079
claude-haiku-5-5:v7:medium: different (0.93) — Record A is a pub (Hamlin Pub) while record B is a Dollar Tree in Unit B1; the building at 201 N Riverside holds 8 businesses, so the shared address says little and the names clearly describe different operations.
claude-haiku-5-5:v9:medium: different (0.93) — Record A is Hamlin Pub, a bar at 201 N Riverside Ave, while record B is a Dollar Tree in Unit B1 of the same building; the names are unrelated and the address is shared by eight businesses, so these are separate operations.
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) — The records have different names (S & A Liquor Store versus Hamlin Pub), the building holds 8 differently named businesses at this address, and nothing else links them, so the shared street address does not make them one outlet.not joined
mi-lcc THE ANCHOR POINT BISTRO LLC
201 N Riverside Ave, St Clair, MI, 48079
claude-haiku-5-5:v9:medium: different (0.70) — Both records sit at 201 N Riverside Ave (0.22 km apart), but the building holds 8 differently named businesses and the names disagree ('hamlin pub saint clair' vs 'THE ANCHOR POINT BISTRO LLC'), so the shared address does not establish one not joined
mi-lcc S & A LIQUOR
201 N Riverside Ave, Saint Clair, MI, 48079
claude-haiku-5-5:v9:medium: different (0.90) — The DoorDash listing is 'hamlin pub', a bar/restaurant brand, while the Michigan licence is 'S & A LIQUOR', a separately named liquor business; the address is shared by 8 businesses, so the matching street address does not establish one openot joined
mi-lcc MANNINA'S WINE HOUSE LLC
201 N RIVERSIDE AVE, ST CLAIR, MI, 48079
claude-haiku-5-5:v9:medium: different (0.90) — The DoorDash listing 'hamlin pub saint clair' and the Michigan licence 'MANNINA'S WINE HOUSE LLC' share a street address in a building holding 8 businesses, and their names do not match, so the address alone does not make them 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
overture Hamlin Pub
201 N Riverside Ave, St Clair, MI, 48079
25 maddress+name rule: passes (name similarity 0.72)joined (address+name)
ab-inbev HAMLIN PUBS
201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079
91 maddress+name rule: passes (name similarity 0.64)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
mi-lcc HAMLIN PUB SAINT CLAIR
201 N Riverside Ave, Saint Clair, MI, 48079
220 maddress+name rule: passes (name similarity 1.00)joined (address+name)
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.