Hot N Juicy Crawfish

Phoenix, AZ 85054 · O0f2c14b5ffdf · first seen 2026-10-17
4 sourceson premise · restaurantalcohol: alcohol

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
Hot N Juicy Crawfish
the most common name a source statesno other value
Street
7000 East Mayo Boulevard 2 other
ubereats
7000 E MAYO BLVD STE 114 ab-inbevvtinfo ×2
7000 E Mayo Blvd #1114 overture
City
Phoenix
ubereatsno other value
State
AZ
ubereatsno other value
ZIP
85054
ubereatsno other value
Pin
33.65703, -111.93022 map 3 other
ubereats
97 m away ab-inbev
212 m away overture
157 m away vtinfo
Phone
6237038808 1 other
vtinfo
4804625500 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od8c91b8e7d10; O3ae30cf99f1a; O3de9fb6a89de

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-inbevHOT N JUICY CRAWFISH
4335047
7000 E MAYO BLVD STE 114, PHOENIX, AZ, 8505433.65619, -111.929942026-11-112026-11-11
overtureHot N Juicy Crawfish
8644a8f3-8b0f-470f-99ed-8783249eef12
7000 E Mayo Blvd #1114, Phoenix, AZ, 85054480462550033.65617, -111.932272026-11-062026-11-06
ubereatsHot N Juicy Crawfish
KscFkWlvVGqaEdlWBosNIw
7000 East Mayo Boulevard, Phoenix, AZ, 8505433.65703, -111.930222026-10-172026-10-17
vtinfoHOT N JUICY CRAWFISH
a5e419ecbe376ccd
7000 E MAYO BLVD STE 114, PHOENIX, AZ, 85054623703880833.65583, -111.929342026-11-152026-11-15

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 HOT N JUICY CRAWFISHoverture Hot N Juicy Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 215 m apart · name similarity 1.00
ab-inbev HOT N JUICY CRAWFISHubereats Hot N Juicy Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 97 m apart · name similarity 1.00
ab-inbev HOT N JUICY CRAWFISHvtinfo HOT N JUICY CRAWFISH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00
overture Hot N Juicy Crawfishubereats Hot N Juicy Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 212 m apart · name similarity 1.00
overture Hot N Juicy Crawfishvtinfo HOT N JUICY CRAWFISH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 273 m apart · name similarity 1.00 · phone: differs
ubereats Hot N Juicy Crawfishvtinfo HOT N JUICY CRAWFISH1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 157 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Heineken USA, Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
68 within 1 mi · 492 within 3 mi
Off / on premise
8 / 40 within 1 mi · 94 / 267 within 3 mi
Selling alcohol
30 within 1 mi · 248 within 3 mi
Nearest
same channel 0.06 mi · licensed 1.54 mi
Setting
suburban (1,943 people per sq mi)
People within 3 mi
54,927 (45,313 adults 21+, 26,137 households) from 12 tract(s), tracts within 3 mi
Income
per capita $75,336 · median household ~$111,945 (weighted mean of tract medians)
Age and education
median age ~45.5 · bachelor's or higher 62%
Ethnicity
Hispanic 11% · White 76% · Black 2% · Asian 9%
Adults per alcohol outlet
182
Alcohol spend within 3 mi
$22,443,115 a year ($9,809,372 at home, $12,625,825 away) · $90,133 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-15 16:24insertubereats KscFkWlvVGqaEdlWBosNIw ↔ vtinfo a5e419ecbe376ccdsame address and namemerged15
2026-11-15 16:24insertab-inbev 4335047 ↔ vtinfo a5e419ecbe376ccdsame address and namemerged15
2026-11-15 16:24insertoverture 8644a8f3-8b0f-470f-99ed-8783249eef12 ↔ vtinfo a5e419ecbe376ccdsame address and namemerged15
2026-11-11 12:56insertab-inbev 4335047 ↔ overture 8644a8f3-8b0f-470f-99ed-8783249eef12same address and namemerged12
2026-11-11 12:56insertab-inbev 4335047 ↔ ubereats KscFkWlvVGqaEdlWBosNIwsame address and namemerged12
2026-11-06 18:13insertoverture 8644a8f3-8b0f-470f-99ed-8783249eef12 ↔ ubereats KscFkWlvVGqaEdlWBosNIwsame address and namemerged11