Guads Old Town

Portsmouth, VA 23704 · O11aae7f036ab · first seen 2026-10-08
5 sourceson premise · restaurantchain: Guads At Granbyalcohol: 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
Guads Old Town 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Guad's Mexican Restaurant ubereats
guad's olde towne portsmouth doordash
Guads Mexican Restaurant overture
Street
612 Court St 1 other
ubereats
612 Court Street doordash
City
Portsmouth
ubereatsno other value
State
VA
ubereatsno other value
ZIP
23704
ubereatsno other value
Pin
36.83388, -76.30099 map
ubereatsno other value
Phone
7573996120
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofdeaa65be3bd; Oed673ee8f4e8; O7ffe9e9498fc; O61d0f744b553

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-inbevGUADS OLD TOWN
3627488
612 COURT ST, PORTSMOUTH, VA, 2370436.83396, -76.300862026-11-122026-11-14
doordashguad's olde towne portsmouth
285252
612 Court Street, Portsmouth, VA, 2370436.83390, -76.301022026-10-082026-11-14
overtureGuads Mexican Restaurant
653123fd-cc37-41e0-95d6-f0a5baff127a
612 Court St, Portsmouth, VA, 23704757399612036.83387, -76.301062026-11-062026-11-14
ubereatsGuad's Mexican Restaurant
i4z1qnziWuOP9FEvC2qsnQ
612 Court St, Portsmouth, VA, 2370436.83388, -76.300992026-10-302026-11-14
vtinfoGUADS OLD TOWN
a4083dfe883f04d0
612 COURT ST, PORTSMOUTH, VA, 23704757399612036.83393, -76.301122026-11-142026-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 GUADS OLD TOWNvtinfo GUADS OLD TOWN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00
overture Guads Mexican Restaurantubereats Guad's Mexican Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ab-inbev GUADS OLD TOWNdoordash guad's olde towne portsmouth0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 16 m apart · name similarity 0.57
doordash guad's olde towne portsmouthvtinfo GUADS OLD TOWN0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 9 m apart · name similarity 0.57
doordash guad's olde towne portsmouthubereats Guad's Mexican Restaurant0.33Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “same-address” pair)
Both records carry the distinctive name 'Guad's' at the same address, 612 Court St, Portsmouth VA 23704; the DoorDash slug just appends 'olde towne portsmouth', and only one business is known at that
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 88% confident — Both records sit at 612 Court Street, Portsmouth, VA 23704, with coordinates about 4 m apart and only one business at the address, and the DoorDash slug 'guad's olde towne' matches the Uber Eats name 'Guad's Mexican Restaurant', so they are very likely one restaurant listed on two apps.
pair e31f877a256974b54f62

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Guads At Granby — overture-brand
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +7 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:34.
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
91 within 1 mi · 563 within 3 mi
Off / on premise
16 / 40 within 1 mi · 101 / 289 within 3 mi
Selling alcohol
57 within 1 mi · 331 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.28 mi
Setting
urban (3,468 people per sq mi)
People within 3 mi
98,042 (70,112 adults 21+, 41,715 households) from 38 tract(s), tracts within 3 mi
Income
per capita $33,159 · median household ~$55,276 (weighted mean of tract medians)
Age and education
median age ~33.1 · bachelor's or higher 29%
Ethnicity
Hispanic 6% · White 30% · Black 58% · Asian 2%
Adults per alcohol outlet
211
Alcohol spend within 3 mi
$21,249,554 a year ($10,228,737 at home, $11,010,088 away) · $64,005 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-14 20:23insertdoordash 285252 ↔ vtinfo a4083dfe883f04d0same address and namemerged15
2026-11-14 20:23insertab-inbev 3627488 ↔ vtinfo a4083dfe883f04d0same address and namemerged15
2026-11-12 14:25insertab-inbev 3627488 ↔ doordash 285252same address and namemerged12
2026-11-06 18:13insertdoordash 285252 ↔ ubereats i4z1qnziWuOP9FEvC2qsnQClaude judge: samemerged11
2026-11-06 18:13insertoverture 653123fd-cc37-41e0-95d6-f0a5baff127a ↔ ubereats i4z1qnziWuOP9FEvC2qsnQsame address and namemerged11