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 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 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) — 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 con | 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 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.
| 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.