Match tracker
HAMLIN PUB SAINT CLAIR
mi-lcc · 201 N Riverside Ave, Saint Clair, MI, 48079
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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc HAMLIN PUB SAINT CLAIR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| doordash hamlin pub saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Hamlin Pub 201 N Riverside Ave, St Clair, MI, 48079 | 243 m | address+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 m | address+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 m | same source — different name: never merged within one source | not joined |
| mi-lcc THE ANCHOR POINT BISTRO LLC 201 N Riverside Ave, St Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
28 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc S & A LIQUOR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc S & A LIQUOR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ttb SUES COFFEE HOUSE, INC. 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 0 m | address+name rule: does not pass (name similarity 0.17) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ttb WAR WATER, LLC 201 N RIVERSIDE AVE UNIT 8,12,13, ST. CLAIR, MI, 48079 | 0 m | address+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 m | address+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 m | address+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 m | same source — different name: never merged within one source | not joined |
| ubereats Subway 201 N Riverside Ave, St Clair, MI, 48079 | 10 m | address+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 m | address+name rule: does not pass (name similarity 0.42) | not joined |
| doordash subway saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 122 m | address+name rule: does not pass (name similarity 0.47) | not joined |
| overture War Water Brewery 201 N Riverside Ave, St Clair, MI, 48079 | 194 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.17) | not joined |
| overture Subway 201 N Riverside Ave Unit B7, Saint Clair, MI, 48079 | 228 m | address+name rule: does not pass (name similarity 0.11) | not joined |
| ubereats Ace Hardware 201 N Riverside Ave, Saint Clair, MI, 48079 | 228 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.22) | not joined |
| overture Ace Hardware 201 N Riverside Ave, St Clair, MI, 48079 | 243 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.46) | not joined |
| doordash manninas saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 273 m | address+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 m | address+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 m | address+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 m | address+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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc HAMLIN PUB SAINT CLAIR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| doordash hamlin pub saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| ab-inbev HAMLIN PUBS 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 294 m | address+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 m | same source — different name: never merged within one source | not joined |
| mi-lcc S & A LIQUOR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ttb SUES COFFEE HOUSE, INC. 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 0 m | address+name rule: does not pass (name similarity 0.17) | not joined |
16 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| doordash t.a.p cafe saint clair 201 N Riverside Ave # Ste, Saint Clair, MI, 48079 | 118 m | address+name rule: does not pass (name similarity 0.42) | not joined |
| doordash subway saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 122 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.17) | not joined |
| overture Subway 201 N Riverside Ave Unit B7, Saint Clair, MI, 48079 | 228 m | address+name rule: does not pass (name similarity 0.11) | not joined |
| ubereats Ace Hardware 201 N Riverside Ave, Saint Clair, MI, 48079 | 228 m | address+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 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.46) | not joined |
| doordash manninas saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 273 m | address+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 m | address+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 m | address+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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ubereats Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 228 m | street-variant rule: does not pass | not joined |
| overture Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 259 m | street-variant rule: does not pass | not joined |
| ab-inbev MANNINAS WINE HOUSE 201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079 | 294 m | street-variant rule: does not pass | not 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc HAMLIN PUB SAINT CLAIR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| mi-lcc THE ANCHOR POINT BISTRO LLC 201 N Riverside Ave, St Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc THE ANCHOR POINT BISTRO LLC 201 N Riverside Ave, St Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc S & A LIQUOR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc S & A LIQUOR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ttb SUES COFFEE HOUSE, INC. 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 0 m | stratum same-address | not joined |
9 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ttb WAR WATER, LLC 201 N RIVERSIDE AVE UNIT 8,12,13, ST. CLAIR, MI, 48079 | 0 m | stratum same-address | not joined |
| ttb WAR WATER BREWERY 201 N RIVERSIDE AVE UNIT 8, 12, 13, ST. CLAIR, MI, 48079 | 0 m | stratum same-address | not joined |
| ttb MANNINA'S WINE HOUSE LLC 201 N RIVERSIDE AVE UNIT B5, ST. CLAIR, MI, 48079 | 0 m | stratum same-address | not joined |
| mi-lcc MANNINA'S WINE HOUSE LLC 201 N RIVERSIDE AVE, ST CLAIR, MI, 48079 | 0 m | same source — different name: never merged within one source | not joined |
| ubereats Subway 201 N Riverside Ave, St Clair, MI, 48079 | 10 m | stratum same-address | not joined |
6. Claude judge found, not joined
What did Claude's judge say?
answered 2 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 with | Answer | What 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) — Both records sit at 201 N Riverside Ave in a building holding 11 businesses, so the address alone proves little, and the names (T.A.P cafe vs HAMLIN PUB SAINT CLAIR under legal entity M29 VENTURES LLC) do not agree. | not 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 storefront listing while record B is a Michigan liquor licence for Hamlin Pub (legal entity M29 Ventures LLC), a bar with a different name, and the address is shared by 8 differently named businesses, so the addres | 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| mi-lcc HAMLIN PUB SAINT CLAIR 201 N Riverside Ave, Saint Clair, MI, 48079 | 0 m | same source — identical name: a duplicate listing | joined (duplicate-listing) |
| doordash hamlin pub saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: passes (name similarity 1.00) | joined (address+name) |
| overture Hamlin Pub 201 N Riverside Ave, St Clair, MI, 48079 | 243 m | address+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 m | address+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.