MAMA SHIM

NEW HAVEN, CT 06510 · O0f855ab9b345 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed1 licence

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
MAMA SHIM 3 other
the most common name a source states
MA MA SHIM ct-dcp
mama shim new haven doordash
STAMFORD BROTHERS LLC ct-dcp (legal name)
Street
170 COLLEGE ST 1 other
ct-dcp
170 College Street ubereats
City
NEW HAVEN
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06510
ct-dcpno other value
Pin
41.30526, -72.93037 map 1 other
ubereats
54 m away ct-dcp
Phone
2035072159
vtinfono other value
Licences
ct-dcp CT|LIR.0019714
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocb416cef7471; Ob9acdac4fd3a; O6fc727f30a82; O62a56975ba79; O6b477b307e2b

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevMAMA SHIM
4983499
170 COLLEGE ST, NEW HAVEN, CT, 0651041.30558, -72.930052026-11-112026-11-11
ct-dcpMA MA SHIM
legal name: STAMFORD BROTHERS LLC
CT|LIR.0019714
170 COLLEGE ST, NEW HAVEN, CT, 0651041.30564, -72.929972026-11-032026-11-09
doordashmama shim new haven
37688491
170 College St, New Haven, CT, 0651041.30545, -72.930522026-10-082026-11-11
overtureMAMA SHIM
4ffd8c1f-4dc4-4ab1-9806-00e76f685111
170 College St, New Haven, CT, 06510203507215941.30531, -72.930362026-11-062026-11-09
ubereatsMAMA SHIM
ybqWyl_uVd2cbkbED3w00g
170 College Street, New Haven, CT, 0651041.30526, -72.930372026-11-092026-11-09
vtinfoMAMA SHIM
4cb4fda74808bd60
170 COLLEGE ST, NEW HAVEN, CT, 06510203507215941.30545, -72.930522026-11-122026-11-13

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev MAMA SHIMdoordash mama shim new haven1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00
ab-inbev MAMA SHIMoverture MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 39 m apart · name similarity 1.00
ab-inbev MAMA SHIMubereats MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
ab-inbev MAMA SHIMvtinfo MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 42 m apart · name similarity 1.00
doordash mama shim new havenoverture MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
doordash mama shim new havenubereats MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
doordash mama shim new havenvtinfo MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00
overture MAMA SHIMubereats MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
overture MAMA SHIMvtinfo MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00 · phone: equal
ubereats MAMA SHIMvtinfo MAMA SHIM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
ab-inbev MAMA SHIMct-dcp MA MA SHIM0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 9 m apart · name similarity 0.60
ct-dcp MA MA SHIMdoordash mama shim new haven0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 50 m apart · name similarity 0.60
ct-dcp MA MA SHIMoverture MAMA SHIM0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 49 m apart · name similarity 0.60
ct-dcp MA MA SHIMubereats MAMA SHIM0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 54 m apart · name similarity 0.60
ct-dcp MA MA SHIMvtinfo MAMA SHIM0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 50 m apart · name similarity 0.60

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
STAMFORD BROTHERS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LIR
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
242 within 1 mi · 538 within 3 mi
Off / on premise
31 / 116 within 1 mi · 113 / 246 within 3 mi
Selling alcohol
155 within 1 mi · 355 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.05 mi
Setting
urban (5,697 people per sq mi)
People within 3 mi
161,075 (114,270 adults 21+, 64,049 households) from 37 tract(s), tracts within 3 mi
Income
per capita $35,357 · median household ~$62,695 (weighted mean of tract medians)
Age and education
median age ~33.1 · bachelor's or higher 37%
Ethnicity
Hispanic 31% · White 35% · Black 30% · Asian 5%
Adults per alcohol outlet
321
Alcohol spend within 3 mi
$36,606,917 a year ($17,157,869 at home, $19,431,230 away) · $102,828 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-12 14:25insertct-dcp CT|LIR.0019714 ↔ vtinfo 4cb4fda74808bd60same address and namemerged12
2026-11-12 14:25insertubereats ybqWyl_uVd2cbkbED3w00g ↔ vtinfo 4cb4fda74808bd60same address and namemerged12
2026-11-12 14:25insertab-inbev 4983499 ↔ vtinfo 4cb4fda74808bd60same address and namemerged12
2026-11-12 14:25insertdoordash 37688491 ↔ vtinfo 4cb4fda74808bd60same address and namemerged12
2026-11-12 14:25insertoverture 4ffd8c1f-4dc4-4ab1-9806-00e76f685111 ↔ vtinfo 4cb4fda74808bd60same address and namemerged12
2026-11-11 12:56insertab-inbev 4983499 ↔ ct-dcp CT|LIR.0019714same address and namemerged12
2026-11-11 12:56insertab-inbev 4983499 ↔ doordash 37688491same address and namemerged12
2026-11-11 12:56insertab-inbev 4983499 ↔ overture 4ffd8c1f-4dc4-4ab1-9806-00e76f685111same address and namemerged12
2026-11-11 12:56insertab-inbev 4983499 ↔ ubereats ybqWyl_uVd2cbkbED3w00gsame address and namemerged12
2026-11-10 17:05insertct-dcp CT|LIR.0019714 ↔ doordash 37688491same address and namemerged12
2026-11-10 17:05insertdoordash 37688491 ↔ overture 4ffd8c1f-4dc4-4ab1-9806-00e76f685111same address and namemerged12
2026-11-10 17:05insertdoordash 37688491 ↔ ubereats ybqWyl_uVd2cbkbED3w00gsame address and namemerged12
2026-11-09 14:23insertct-dcp CT|LIR.0019714 ↔ ubereats ybqWyl_uVd2cbkbED3w00gsame address and namemerged11
2026-11-09 14:23insertoverture 4ffd8c1f-4dc4-4ab1-9806-00e76f685111 ↔ ubereats ybqWyl_uVd2cbkbED3w00gsame address and namemerged11
2026-11-06 18:13insertct-dcp CT|LIR.0019714 ↔ overture 4ffd8c1f-4dc4-4ab1-9806-00e76f685111same address and namemerged11