Union Street Public House

Alexandria, VA 22314 · O1f962f07e22c · first seen 2026-11-06
5 sourceson premise · restaurantalcohol: licensed1 licence

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
Union Street Public House 1 other
the most common name a source states
John Macbrian Inc va-abc (legal name)
Street
121 S Union ST 1 other
va-abc
121 South Union Street toast
City
Alexandria
va-abcno other value
State
VA
va-abcno other value
ZIP
22314
va-abcno other value
Pin
38.80348, -77.04059 map 1 other
toast
66 m away ab-inbev
Phone
7035481785
vtinfono other value
Licences
va-abc VA|338|Retail Restaurant or Caterer License
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob7ad867bd88a; O38d1b887f92e; O7f5a995befce; O25a843cc05a5

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-inbevUNION STREET PUBLIC HOUSE
87195
121 S UNION ST, ALEXANDRIA, VA, 2231438.80405, -77.040382026-11-122026-11-19
overtureUnion Street Public House
cc4e4282-f6a9-45bd-a6bb-374f9f30d0eb
121 S Union St, Alexandria, VA, 22314703548178538.80344, -77.040532026-11-092026-11-19
toastUnion Street Public House
253f643d-5e1f-4674-a517-e931feec61ab
121 South Union Street, Alexandria, VA, 22314703548178538.80348, -77.040592026-11-062026-11-19
va-abcUnion Street Public House
legal name: John Macbrian Inc
VA|338|Retail Restaurant or Caterer License
121 S Union ST, Alexandria, VA, 22314703548178538.80356, -77.040492026-11-192026-11-19
vtinfoUNION STREET PUBLIC HOUSE
a7b667a2988c425d
121 S UNION ST, ALEXANDRIA, VA, 22314703548178538.80351, -77.040522026-11-182026-11-19

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 UNION STREET PUBLIC HOUSEoverture Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00
ab-inbev UNION STREET PUBLIC HOUSEtoast Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00
ab-inbev UNION STREET PUBLIC HOUSEva-abc Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ab-inbev UNION STREET PUBLIC HOUSEvtinfo UNION STREET PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 61 m apart · name similarity 1.00
overture Union Street Public Housetoast Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal
overture Union Street Public Houseva-abc Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00 · phone: equal
overture Union Street Public Housevtinfo UNION STREET PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00 · phone: equal
toast Union Street Public Houseva-abc Union Street Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00 · phone: equal
toast Union Street Public Housevtinfo UNION STREET PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal
va-abc Union Street Public Housevtinfo UNION STREET PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
John Macbrian Inc — 1 outlets in the master under this operator
Licence privileges
none — VA Retail Restaurant or Caterer License Restaurant (not mapped)
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-19 20:37insertab-inbev 87195 ↔ va-abc VA|338|Retail Restaurant or Caterer Licensesame address and namemerged17
2026-11-19 20:37insertva-abc VA|338|Retail Restaurant or Caterer License ↔ vtinfo a7b667a2988c425dsame address and namemerged17
2026-11-19 20:37insertoverture cc4e4282-f6a9-45bd-a6bb-374f9f30d0eb ↔ va-abc VA|338|Retail Restaurant or Caterer Licensesame address and namemerged17
2026-11-19 20:37inserttoast 253f643d-5e1f-4674-a517-e931feec61ab ↔ va-abc VA|338|Retail Restaurant or Caterer Licensesame address and namemerged17
2026-11-18 18:58insertab-inbev 87195 ↔ vtinfo a7b667a2988c425dsame address and namemerged15
2026-11-18 18:58insertoverture cc4e4282-f6a9-45bd-a6bb-374f9f30d0eb ↔ vtinfo a7b667a2988c425dsame address and namemerged15
2026-11-18 18:58inserttoast 253f643d-5e1f-4674-a517-e931feec61ab ↔ vtinfo a7b667a2988c425dsame address and namemerged15
2026-11-12 14:25insertab-inbev 87195 ↔ toast 253f643d-5e1f-4674-a517-e931feec61absame address and namemerged12
2026-11-12 14:25insertab-inbev 87195 ↔ overture cc4e4282-f6a9-45bd-a6bb-374f9f30d0ebsame address and namemerged12
2026-11-09 15:32insertoverture cc4e4282-f6a9-45bd-a6bb-374f9f30d0eb ↔ toast 253f643d-5e1f-4674-a517-e931feec61absame address and namemerged11