Outlets /
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.
| Field | Master value | Taken from | What 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 | ubereats | no other value |
| State | VA | ubereats | no other value |
| ZIP | 23704 | ubereats | no other value |
| Pin | 36.83388, -76.30099 map | ubereats | no other value |
| Phone | 7573996120 | vtinfo | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | GUADS OLD TOWN 3627488 | 612 COURT ST, PORTSMOUTH, VA, 23704 | 36.83396, -76.30086 | 2026-11-12 | 2026-11-14 | |
| doordash | guad's olde towne portsmouth 285252 | 612 Court Street, Portsmouth, VA, 23704 | 36.83390, -76.30102 | 2026-10-08 | 2026-11-14 | |
| overture | Guads Mexican Restaurant 653123fd-cc37-41e0-95d6-f0a5baff127a | 612 Court St, Portsmouth, VA, 23704 | 7573996120 | 36.83387, -76.30106 | 2026-11-06 | 2026-11-14 |
| ubereats | Guad's Mexican Restaurant i4z1qnziWuOP9FEvC2qsnQ | 612 Court St, Portsmouth, VA, 23704 | 36.83388, -76.30099 | 2026-10-30 | 2026-11-14 | |
| vtinfo | GUADS OLD TOWN a4083dfe883f04d0 | 612 COURT ST, PORTSMOUTH, VA, 23704 | 7573996120 | 36.83393, -76.30112 | 2026-11-14 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev GUADS OLD TOWN | vtinfo GUADS OLD TOWN | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00 |
| overture Guads Mexican Restaurant | ubereats Guad's Mexican Restaurant | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 |
| ab-inbev GUADS OLD TOWN | doordash guad's olde towne portsmouth | 0.57 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 16 m apart · name similarity 0.57 |
| doordash guad's olde towne portsmouth | vtinfo GUADS OLD TOWN | 0.57 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 9 m apart · name similarity 0.57 |
| doordash guad's olde towne portsmouth | ubereats Guad's Mexican Restaurant | 0.33 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-14 20:23 | insert | doordash 285252 ↔ vtinfo a4083dfe883f04d0 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ab-inbev 3627488 ↔ vtinfo a4083dfe883f04d0 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 3627488 ↔ doordash 285252 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 285252 ↔ ubereats i4z1qnziWuOP9FEvC2qsnQ | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | overture 653123fd-cc37-41e0-95d6-f0a5baff127a ↔ ubereats i4z1qnziWuOP9FEvC2qsnQ | same address and name | merged | 11 |