SWEET WATER BAR

Detroit, MI 48226 · O1b4da081a55e · first seen 2026-10-08
6 sourceson premise · restaurantchain: Sweetwater Tavern Mialcohol: licensed2 licences

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
SWEET WATER BAR 3 other
the most common name a source states
SWEETWATER TAVERN mi-lccovertureubereats ×4
KSJC ENTERPRISES, INC. mi-lcc (legal name) ×2
sweetwater tavern detroit doordash
Street
400 E Congress St 2 other
mi-lcc
400 E. CONGRESS ubereats
400 East Congress Street doordash
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48226
mi-lccno other value
Pin
42.33173, -83.04182 map
ubereatsno other value
Phone
3139622210
vtinfono other value
Licences
mi-lcc L-000005498 · mi-lcc L-000008959
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeb175ac9974f; Obb76f3b4ea20; O749473c1bb5d; O55f5a0bbadab; O79a9c11db7e6; O697d63f3a0cb

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-inbevSWEET WATER BAR
2515823
400 E CONGRESS ST, DETROIT, MI, 4822642.33203, -83.041382026-11-112026-11-12
doordashsweetwater tavern detroit
215098
400 East Congress Street, Detroit, MI, 4822642.33175, -83.041782026-10-082026-10-10
mi-lccSWEETWATER TAVERN
legal name: KSJC ENTERPRISES, INC.
L-000005498
400 E Congress St, Detroit, MI, 48226313962221042.33182, -83.041912026-11-032026-11-05
mi-lccSWEETWATER TAVERN
legal name: KSJC ENTERPRISES, INC.
L-000008959
400 E Congress St, Detroit, MI, 48226313962221042.33182, -83.041912026-11-032026-11-05
overtureSweetwater Tavern
213ee6a0-450a-4970-b591-dd2c4f26ab33
400 E Congress St, Detroit, MI, 48226313962221042.33170, -83.041792026-11-062026-11-06
ubereatsSweetwater Tavern
B-0FpvpFQMKfCMjYSWBjdg
400 E. CONGRESS, Detroit, MI, 4822642.33173, -83.041822026-10-082026-11-03
vtinfoSWEET WATER BAR
9d348cb68ae01fff
400 E CONGRESS ST, DETROIT, MI, 48226313962221042.33167, -83.041632026-11-112026-11-14

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 SWEET WATER BARvtinfo SWEET WATER BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00
doordash sweetwater tavern detroitmi-lcc SWEETWATER TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash sweetwater tavern detroitmi-lcc SWEETWATER TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash sweetwater tavern detroitoverture Sweetwater Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash sweetwater tavern detroitubereats Sweetwater Tavern1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 3 m apart · name similarity 1.00 · street similarity 0.87
mi-lcc SWEETWATER TAVERNmi-lcc SWEETWATER TAVERN1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SWEETWATER TAVERNoverture Sweetwater Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 · phone: equal
mi-lcc SWEETWATER TAVERNubereats Sweetwater Tavern1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.87
mi-lcc SWEETWATER TAVERNoverture Sweetwater Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 · phone: equal
mi-lcc SWEETWATER TAVERNubereats Sweetwater Tavern1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.87
overture Sweetwater Tavernubereats Sweetwater Tavern1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 4 m apart · name similarity 1.00 · street similarity 0.87
ab-inbev SWEET WATER BARdoordash sweetwater tavern detroit0.31Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Sweetwater bar/tavern same address, name variant.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records share the same street address in Detroit, but the names differ ('SWEET WATER BAR' vs 'sweetwater tavern detroit'), and two businesses are recorded at that address, so the address alone does not confirm they are one outlet.
pair 1f3498b630757c3cd27f

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Sweetwater Tavern Mi — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
KSJC ENTERPRISES, INC. — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 7, computed 2026-11-16 17:15.
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
375 within 1 mi · 897 within 3 mi
Off / on premise
23 / 180 within 1 mi · 117 / 443 within 3 mi
Selling alcohol
288 within 1 mi · 616 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
suburban (2,320 people per sq mi)
People within 3 mi
65,589 (53,108 adults 21+, 34,623 households) from 35 tract(s), tracts within 3 mi
Income
per capita $40,572 · median household ~$46,863 (weighted mean of tract medians)
Age and education
median age ~38.1 · bachelor's or higher 39%
Ethnicity
Hispanic 6% · White 27% · Black 59% · Asian 5%
Adults per alcohol outlet
86
Alcohol spend within 3 mi
$17,193,798 a year ($8,221,270 at home, $8,960,373 away) · $27,867 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

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 17:29insertab-inbev 2515823 ↔ doordash 215098Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2515823 ↔ vtinfo 9d348cb68ae01fffsame address and namemerged12
2026-11-06 18:13insertoverture 213ee6a0-450a-4970-b591-dd2c4f26ab33 ↔ ubereats B-0FpvpFQMKfCMjYSWBjdgstreet written two waysmerged11
2026-11-06 18:13insertdoordash 215098 ↔ overture 213ee6a0-450a-4970-b591-dd2c4f26ab33same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000005498 ↔ overture 213ee6a0-450a-4970-b591-dd2c4f26ab33same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000008959 ↔ overture 213ee6a0-450a-4970-b591-dd2c4f26ab33same address and namemerged11
2026-11-03 14:30backfilldoordash 215098 ↔ ubereats B-0FpvpFQMKfCMjYSWBjdgstreet written two waysmerged
2026-11-03 14:30backfillmi-lcc L-000005498 ↔ ubereats B-0FpvpFQMKfCMjYSWBjdgstreet written two waysmerged
2026-11-03 14:30backfillmi-lcc L-000008959 ↔ ubereats B-0FpvpFQMKfCMjYSWBjdgstreet written two waysmerged
2026-11-03 13:33backfilldoordash 215098 ↔ mi-lcc L-000008959same address and namemerged
2026-11-03 13:33backfilldoordash 215098 ↔ mi-lcc L-000005498same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000005498 ↔ mi-lcc L-000008959one store listed twicemerged