Match tracker
hamlin pub saint clair
doordash · 201 N Riverside Ave, Saint Clair, MI, 48079
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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Hamlin Pub 201 N Riverside Ave, St Clair, MI, 48079 | 25 m | address+name rule: passes (name similarity 0.72) | joined (address+name) |
| ab-inbev HAMLIN PUBS 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 91 m | address+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 m | address+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 m | address+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 m | same source — different name: never merged within one source | not joined |
| ubereats Ace Hardware 201 N Riverside Ave, Saint Clair, MI, 48079 | 11 m | address+name rule: does not pass (name similarity 0.15) | not joined |
28 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Sue's Coffee House 201 N Riverside Ave, Saint Clair, MI, 48079 | 11 m | address+name rule: does not pass (name similarity 0.15) | not joined |
| overture Subway 201 N Riverside Ave Unit B7, Saint Clair, MI, 48079 | 11 m | address+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 m | address+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 m | same source — different name: never merged within one source | not joined |
| overture War Water Brewery 201 N Riverside Ave, St Clair, MI, 48079 | 41 m | address+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 m | same source — different name: never merged within one source | not joined |
| doordash dollar tree saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 50 m | same source — different name: never merged within one source | not joined |
| doordash manninas saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 55 m | same source — different name: never merged within one source | not joined |
| overture Ace Hardware 201 N Riverside Ave, St Clair, MI, 48079 | 62 m | address+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 m | address+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 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 | 91 m | address+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 m | same source — different name: never merged within one source | not joined |
| doordash subway saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 105 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 | 220 m | address+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 m | address+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 m | address+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 m | address+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 m | address+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 m | address+name rule: does not pass (name similarity 0.20) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+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 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 | 220 m | address+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 m | address+name rule: does not pass (name similarity 0.15) | not joined |
| ubereats Subway 201 N Riverside Ave, St Clair, MI, 48079 | 225 m | address+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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ab-inbev HAMLIN PUBS 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 91 m | address+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 m | address+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 m | address+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 m | same source — different name: never merged within one source | not joined |
| ubereats Ace Hardware 201 N Riverside Ave, Saint Clair, MI, 48079 | 11 m | address+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 m | address+name rule: does not pass (name similarity 0.15) | not joined |
16 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Subway 201 N Riverside Ave Unit B7, Saint Clair, MI, 48079 | 11 m | address+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 m | same source — different name: never merged within one source | not joined |
| doordash ace hardware saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 50 m | same source — different name: never merged within one source | not joined |
| doordash dollar tree saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 50 m | same source — different name: never merged within one source | not joined |
| doordash manninas saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 55 m | same source — different name: never merged within one source | not joined |
| ab-inbev ANCHOR POINT BISTRO 201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079 | 91 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 | 91 m | address+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 m | same source — different name: never merged within one source | not joined |
| doordash subway saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 105 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 | 220 m | address+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 m | address+name rule: does not pass (name similarity 0.20) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+name rule: does not pass (name similarity 0.16) | not joined |
| mi-lcc WAR WATER 201 N Riverside Ave, Saint Clair, MI, 48079 | 220 m | address+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 m | address+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
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| ubereats Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 11 m | street-variant rule: does not pass | not joined |
| overture Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 43 m | street-variant rule: does not pass | not joined |
| ab-inbev MANNINAS WINE HOUSE 201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079 | 91 m | street-variant rule: does not pass | not 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Hamlin Pub 201 N Riverside Ave, St Clair, MI, 48079 | 25 m | stratum addr-agree | joined (address+name) |
| ab-inbev HAMLIN PUBS 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 91 m | stratum addr-agree | joined (address+name) |
| doordash hungry howie's saint clair 201 North Riverside Avenue, Saint Clair, MI, 48079 | 5 m | same source — different name: never merged within one source | not joined |
| ubereats Ace Hardware 201 N Riverside Ave, Saint Clair, MI, 48079 | 11 m | stratum same-address | not joined |
| ubereats Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 11 m | stratum same-address | not joined |
| overture Sue's Coffee House 201 N Riverside Ave, Saint Clair, MI, 48079 | 11 m | stratum same-address | not joined |
13 more
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Subway 201 N Riverside Ave Unit B7, Saint Clair, MI, 48079 | 11 m | stratum same-address | not joined |
| overture The Anchor Point Bistro 201 N Riverside Ave, St Clair, MI, 48079 | 24 m | stratum same-address | not joined |
| doordash the anchor point bistro 201 n riverside ave saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 39 m | same source — different name: never merged within one source | not joined |
| overture War Water Brewery 201 N Riverside Ave, St Clair, MI, 48079 | 41 m | stratum same-address | not joined |
| overture Dollar Tree 201 N Riverside Unit B1, St Clair, MI, 48079 | 43 m | stratum same-address | not joined |
| doordash ace hardware saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 50 m | same source — different name: never merged within one source | not joined |
| doordash dollar tree saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 50 m | same source — different name: never merged within one source | not joined |
| doordash manninas saint clair 201 N Riverside Ave, Saint Clair, MI, 48079 | 55 m | same source — different name: never merged within one source | not joined |
| overture Ace Hardware 201 N Riverside Ave, St Clair, MI, 48079 | 62 m | stratum same-address | not joined |
| overture S and A Liquor 201 N Riverside Ave, St Clair, MI, 48079 | 68 m | stratum same-address | not joined |
| ab-inbev ANCHOR POINT BISTRO 201 N RIVERSIDE AVE STE C1, SAINT CLAIR, MI, 48079 | 91 m | stratum same-address | not joined |
| ab-inbev S & A LIQUOR STORE 201 N RIVERSIDE AVE STE A1, SAINT CLAIR, MI, 48079 | 91 m | stratum same-address | not joined |
| ab-inbev MANNINAS WINE HOUSE 201 N RIVERSIDE STE B5, SAINT CLAIR, MI, 48079 | 91 m | stratum same-address | not 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 with | Answer | What 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 ope | not 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.
| Record | Distance | What the rule says | What the master did |
|---|---|---|---|
| overture Hamlin Pub 201 N Riverside Ave, St Clair, MI, 48079 | 25 m | address+name rule: passes (name similarity 0.72) | joined (address+name) |
| ab-inbev HAMLIN PUBS 201 N RIVERSIDE AVE, SAINT CLAIR, MI, 48079 | 91 m | address+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 m | address+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 m | address+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.