The Publican

WINDSOR, CA 95492 · O2ffeb2d34ad9 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: licensed2 licences

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
The Publican 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ADBAR MANAGEMENT LLC ca-abc (legal name) ×2
PUBLICAN THE ca-abc ×2
Street
400 EMILY ROSE CIR
ca-abcno other value
City
WINDSOR
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95492
ca-abcno other value
Pin
38.54784, -122.81684 map 1 other
ca-abc
74 m away ab-inbev
Phone
7078387821
vtinfono other value
Licences
ca-abc 00573420|47|LIC|0 · ca-abc 00573420|77|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe312637ceee1; Ofa9663b7a23d; Oc01a03488c25

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-inbevTHE PUBLICAN
4032347
400 EMILY ROSE CIR, WINDSOR, CA, 9549238.54832, -122.817432026-11-112026-11-11
ca-abcPUBLICAN THE
legal name: ADBAR MANAGEMENT LLC
00573420|47|LIC|0
400 EMILY ROSE CIR, WINDSOR, CA, 9549238.54784, -122.816842026-10-082026-11-05
ca-abcPUBLICAN THE
legal name: ADBAR MANAGEMENT LLC
00573420|77|LIC|0
400 EMILY ROSE CIR, WINDSOR, CA, 9549238.54784, -122.816842026-10-082026-11-05
vtinfoTHE PUBLICAN
c3f584d804e4d98b
400 EMILY ROSE CIR, WINDSOR, CA, 95492707838782138.54798, -122.816932026-11-122026-11-13

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 THE PUBLICANca-abc PUBLICAN THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ab-inbev THE PUBLICANca-abc PUBLICAN THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
ab-inbev THE PUBLICANvtinfo THE PUBLICAN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
ca-abc PUBLICAN THEca-abc PUBLICAN THE1.00one licence filemergedfile: 00573420 · same_address
ca-abc PUBLICAN THEvtinfo THE PUBLICAN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
ca-abc PUBLICAN THEvtinfo THE PUBLICAN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ADBAR MANAGEMENT LLC — 3 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 77
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
96 within 1 mi · 329 within 3 mi
Off / on premise
27 / 44 within 1 mi · 99 / 63 within 3 mi
Selling alcohol
79 within 1 mi · 304 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (903 people per sq mi)
People within 3 mi
25,521 (18,921 adults 21+, 9,067 households) from 7 tract(s), tracts within 3 mi
Income
per capita $54,527 · median household ~$127,575 (weighted mean of tract medians)
Age and education
median age ~42.7 · bachelor's or higher 35%
Ethnicity
Hispanic 33% · White 63% · Black 1% · Asian 2%
Adults per alcohol outlet
62
Alcohol spend within 3 mi
$8,060,442 a year ($3,522,608 at home, $4,534,481 away) · $26,428 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-12 14:25insertab-inbev 4032347 ↔ vtinfo c3f584d804e4d98bsame address and namemerged12
2026-11-12 14:25insertca-abc 00573420|47|LIC|0 ↔ vtinfo c3f584d804e4d98bsame address and namemerged12
2026-11-12 14:25insertca-abc 00573420|77|LIC|0 ↔ vtinfo c3f584d804e4d98bsame address and namemerged12
2026-11-11 12:56insertab-inbev 4032347 ↔ ca-abc 00573420|77|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 4032347 ↔ ca-abc 00573420|47|LIC|0same address and namemerged12
2026-10-09 13:59backfillca-abc 00573420|47|LIC|0 ↔ ca-abc 00573420|77|LIC|0one licence filemerged