Fiesta Liquor

Redford, MI 48239 · O114beb9cbd54 · first seen 2026-10-23
5 sourcesoff premise · liquor_storealcohol: 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
Fiesta Liquor 3 other
a source's own spelling of the licence name (record_title.py)
FIESTA LIQUOR SHOPPE mi-lcc ×2
K YONO, INC. mi-lcc (legal name) ×2
fiesta party store redford doordash
Street
25707 Plymouth Rd 1 other
mi-lcc
25707 PLYMOUTH ab-inbevvtinfo ×2
City
Redford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48239
mi-lccno other value
Pin
42.37047, -83.29394 map 1 other
doordash
66 m away ab-inbev
Phone
3139372222
vtinfono other value
Licences
mi-lcc L-000201022 · mi-lcc L-000201023
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odbbcc92b6fa6; O912f2121c8a2; O870b16ccbcce; O1c68499bb737; O149a224bf055

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-inbevFIESTA LIQUOR
2763320
25707 PLYMOUTH, REDFORD, MI, 4823942.37074, -83.294662026-11-112026-11-11
doordashfiesta party store redford
33786121
25707 Plymouth Rd, Redford, MI, 4823942.37047, -83.293942026-10-232026-11-12
mi-lccFIESTA LIQUOR SHOPPE
legal name: K YONO, INC.
L-000201022
25707 Plymouth Rd, Redford, MI, 48239313937222242.37076, -83.293842026-11-032026-11-05
mi-lccFIESTA LIQUOR SHOPPE
legal name: K YONO, INC.
L-000201023
25707 Plymouth Rd, Redford, MI, 48239313937222242.37076, -83.293842026-11-032026-11-05
overtureFiesta Liquor
9ac1efc5-0570-458c-8a92-b37d2a53904d
25707 Plymouth Rd, Redford, MI, 48239313937222242.37054, -83.293852026-11-062026-11-06
vtinfoFIESTA LIQUOR
6d324dd82e16c648
25707 PLYMOUTH, REDFORD, MI, 48239313937222242.37047, -83.293932026-11-112026-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 FIESTA LIQUORoverture Fiesta Liquor1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 70 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev FIESTA LIQUORvtinfo FIESTA LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
mi-lcc FIESTA LIQUOR SHOPPEmi-lcc FIESTA LIQUOR SHOPPE1.00one store listed twicemergedsame street + ZIP · name: identical
overture Fiesta Liquorvtinfo FIESTA LIQUOR1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 11 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev FIESTA LIQUORmi-lcc FIESTA LIQUOR SHOPPE0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 68 m apart · name similarity 0.73 · street similarity 0.84
ab-inbev FIESTA LIQUORmi-lcc FIESTA LIQUOR SHOPPE0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 68 m apart · name similarity 0.73 · street similarity 0.84
mi-lcc FIESTA LIQUOR SHOPPEvtinfo FIESTA LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 34 m apart · name similarity 0.73 · street similarity 0.84
mi-lcc FIESTA LIQUOR SHOPPEvtinfo FIESTA LIQUOR0.73street written two waysmergedname Jaro-Winkler 0.93 · matched on zip · pins 34 m apart · name similarity 0.73 · street similarity 0.84
mi-lcc FIESTA LIQUOR SHOPPEoverture Fiesta Liquor0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 24 m apart · name similarity 0.73 · phone: equal
mi-lcc FIESTA LIQUOR SHOPPEoverture Fiesta Liquor0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 24 m apart · name similarity 0.73 · phone: equal
ab-inbev FIESTA LIQUORdoordash fiesta party store redford0.49Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Fiesta liquor/party store same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 25707 Plymouth Rd, Redford MI 48239 with close coordinates, no other business is held at that address, and the names 'Fiesta Liquor' and 'Fiesta Party Store' share the distinctive Fiesta brand, so they most likely describe one store listed by its licence name and its delivery listing.
pair 1f7b5360638818adcc2d
doordash fiesta party store redfordmi-lcc FIESTA LIQUOR SHOPPE0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Fiesta name and same address match.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 25707 Plymouth Rd, Redford, MI 48239, about 34 m apart, and only one business is held at that address; the shared distinctive 'Fiesta' name and the store-type listing support one outlet, though the trade names differ ('Party Store' vs 'Liquor Shoppe').
pair 2ef5bc4d2126a805f19f

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
K YONO, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 456 within 3 mi
Off / on premise
10 / 20 within 1 mi · 136 / 245 within 3 mi
Selling alcohol
12 within 1 mi · 209 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.25 mi
Setting
urban (3,840 people per sq mi)
People within 3 mi
108,568 (80,257 adults 21+, 42,933 households) from 38 tract(s), tracts within 3 mi
Income
per capita $33,834 · median household ~$68,895 (weighted mean of tract medians)
Age and education
median age ~38.2 · bachelor's or higher 25%
Ethnicity
Hispanic 3% · White 57% · Black 35% · Asian 1%
Adults per alcohol outlet
382
Alcohol spend within 3 mi
$24,493,804 a year ($11,582,839 at home, $12,899,246 away) · $116,637 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:29insertdoordash 33786121 ↔ mi-lcc L-000201023Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2763320 ↔ doordash 33786121Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2763320 ↔ mi-lcc L-000201023street written two waysmerged12
2026-11-11 12:56insertmi-lcc L-000201023 ↔ vtinfo 6d324dd82e16c648street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763320 ↔ mi-lcc L-000201022street written two waysmerged12
2026-11-11 12:56insertmi-lcc L-000201022 ↔ vtinfo 6d324dd82e16c648street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763320 ↔ overture 9ac1efc5-0570-458c-8a92-b37d2a53904dstreet written two waysmerged12
2026-11-11 12:56insertoverture 9ac1efc5-0570-458c-8a92-b37d2a53904d ↔ vtinfo 6d324dd82e16c648street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763320 ↔ vtinfo 6d324dd82e16c648same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000201023 ↔ overture 9ac1efc5-0570-458c-8a92-b37d2a53904dsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000201022 ↔ overture 9ac1efc5-0570-458c-8a92-b37d2a53904dsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000201022 ↔ mi-lcc L-000201023one store listed twicemerged