The Rose Hotel

PLEASANTON, CA 94566 · O067ac7a9c868 · first seen 2026-10-08
3 sourceson premise · barchain: The Rose Hotelalcohol: 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 Rose Hotel 2 other
a source's own spelling of the licence name (record_title.py)
ROSE HOTEL ca-abcvtinfo ×3
RB HOSPITALITY INC ca-abc (legal name) ×2
Street
807 MAIN ST
ca-abcno other value
City
PLEASANTON
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94566
ca-abcno other value
Pin
37.66403, -121.87466 map
overtureno other value
Phone
9258468802
vtinfono other value
Licences
ca-abc 00415159|48|LIC|0 · ca-abc 00415159|66|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa06a4fae9e4c; O7ef56574f06d; Ofbd822363a52

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
ca-abcROSE HOTEL
legal name: RB HOSPITALITY INC
00415159|48|LIC|0
807 MAIN ST, PLEASANTON, CA, 9456637.66399, -121.874422026-10-082026-11-06
ca-abcROSE HOTEL
legal name: RB HOSPITALITY INC
00415159|66|LIC|0
807 MAIN ST, PLEASANTON, CA, 9456637.66399, -121.874422026-10-082026-11-06
overtureThe Rose Hotel
79646095-5ef3-4eba-bb44-c1395db7ef74
807 Main St, Pleasanton, CA, 94566925846880237.66403, -121.874662026-11-062026-11-06
vtinfoROSE HOTEL
50a96d23c0557d71
807 MAIN ST, PLEASANTON, CA, 94566925846880237.66401, -121.874792026-11-132026-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
ca-abc ROSE HOTELca-abc ROSE HOTEL1.00one licence filemergedfile: 00415159 · same_address
ca-abc ROSE HOTELoverture The Rose Hotel1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc ROSE HOTELvtinfo ROSE HOTEL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
ca-abc ROSE HOTELoverture The Rose Hotel1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc ROSE HOTELvtinfo ROSE HOTEL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
overture The Rose Hotelvtinfo ROSE HOTEL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — ca-licence
Chain
The Rose Hotel — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
RB HOSPITALITY INC — 3 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 48; CA 66
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
147 within 1 mi · 531 within 3 mi
Off / on premise
22 / 109 within 1 mi · 92 / 373 within 3 mi
Selling alcohol
97 within 1 mi · 277 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,667 people per sq mi)
People within 3 mi
75,411 (56,114 adults 21+, 28,020 households) from 14 tract(s), tracts within 3 mi
Income
per capita $81,668 · median household ~$181,997 (weighted mean of tract medians)
Age and education
median age ~41.8 · bachelor's or higher 69%
Ethnicity
Hispanic 13% · White 34% · Black 3% · Asian 47%
Adults per alcohol outlet
202
Alcohol spend within 3 mi
$30,564,058 a year ($12,792,182 at home, $17,763,869 away) · $109,943 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-13 14:10insertca-abc 00415159|48|LIC|0 ↔ vtinfo 50a96d23c0557d71same address and namemerged15
2026-11-13 14:10insertca-abc 00415159|66|LIC|0 ↔ vtinfo 50a96d23c0557d71same address and namemerged15
2026-11-13 14:10insertoverture 79646095-5ef3-4eba-bb44-c1395db7ef74 ↔ vtinfo 50a96d23c0557d71same address and namemerged15
2026-11-06 18:13insertca-abc 00415159|48|LIC|0 ↔ overture 79646095-5ef3-4eba-bb44-c1395db7ef74same address and namemerged11
2026-11-06 18:13insertca-abc 00415159|66|LIC|0 ↔ overture 79646095-5ef3-4eba-bb44-c1395db7ef74same address and namemerged11
2026-10-09 13:59backfillca-abc 00415159|48|LIC|0 ↔ ca-abc 00415159|66|LIC|0one licence filemerged