Union Public House

TUCSON, AZ 85718 · O53b197d71ad9 · first seen 2026-10-08
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
Union Public House 1 other
a source's own spelling of the licence name (record_title.py)
union public house tucson doordash
Street
4340 North Campbell Avenue 2 other
doordash
4340 N CAMPBELL AVE STE 103 ab-inbevvtinfo ×2
4340 N Campbell Ave overture
City
Tucson
doordashno other value
State
AZ
doordashno other value
ZIP
85718
doordashno other value
Pin
32.28590, -110.94284 map
doordashno other value
Phone
5203298575
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of3b8f438fbe6; O7828905d452d; Oc89f31366bd2

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 PUBLIC HOUSE
3335952
4340 N CAMPBELL AVE STE 103, TUCSON, AZ, 8571832.28587, -110.942892026-11-132026-11-15
doordashunion public house tucson
171061
4340 North Campbell Avenue, Tucson, AZ, 8571832.28590, -110.942842026-10-082026-11-14
overtureUnion Public House
38e2ee4f-7e03-434a-b3d8-feb7b0b4b82b
4340 N Campbell Ave, Tucson, AZ, 85718520329857532.28594, -110.942822026-11-132026-11-13
vtinfoUNION PUBLIC HOUSE
5b8593cc4b71e93a
4340 N CAMPBELL AVE STE 103, TUCSON, AZ, 85718520329857532.28599, -110.942622026-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 UNION PUBLIC HOUSEdoordash union public house tucson1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00
ab-inbev UNION PUBLIC HOUSEoverture Union Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ab-inbev UNION PUBLIC HOUSEvtinfo UNION PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
doordash union public house tucsonoverture Union Public House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
doordash union public house tucsonvtinfo UNION PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
overture Union Public Housevtinfo UNION PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +10 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
30 within 1 mi · 412 within 3 mi
Off / on premise
8 / 14 within 1 mi · 105 / 254 within 3 mi
Selling alcohol
17 within 1 mi · 169 within 3 mi
Nearest
same channel 0.03 mi · licensed 2.15 mi
Setting
urban (3,522 people per sq mi)
People within 3 mi
99,592 (80,236 adults 21+, 50,047 households) from 25 tract(s), tracts within 3 mi
Income
per capita $39,697 · median household ~$55,142 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 43%
Ethnicity
Hispanic 29% · White 61% · Black 5% · Asian 6%
Adults per alcohol outlet
472
Alcohol spend within 3 mi
$25,520,505 a year ($12,253,906 at home, $13,255,749 away) · $150,121 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:23insertoverture 38e2ee4f-7e03-434a-b3d8-feb7b0b4b82b ↔ vtinfo 5b8593cc4b71e93asame address and namemerged15
2026-11-14 20:23insertab-inbev 3335952 ↔ vtinfo 5b8593cc4b71e93asame address and namemerged15
2026-11-14 20:23insertdoordash 171061 ↔ vtinfo 5b8593cc4b71e93asame address and namemerged15
2026-11-13 19:03insertdoordash 171061 ↔ overture 38e2ee4f-7e03-434a-b3d8-feb7b0b4b82bsame address and namemerged15
2026-11-13 19:03insertab-inbev 3335952 ↔ overture 38e2ee4f-7e03-434a-b3d8-feb7b0b4b82bsame address and namemerged15
2026-11-13 17:47insertab-inbev 3335952 ↔ doordash 171061same address and namemerged15