PUBlic House

TEMECULA, CA 92590 · O5e95a75fe0a8 · first seen 2026-10-08
5 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
PUBlic House 3 other
a source's own spelling of the licence name (record_title.py)
PUBLIC HOUSE THE ab-inbevvtinfo ×2
THEHATCH LLC ca-abc (legal name) ×2
public house temecula doordash
Street
41971 MAIN ST 1 other
ca-abc
41970 Main Street doordash
City
TEMECULA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92590
ca-abcno other value
Pin
33.49376, -117.14870 map
ubereatsno other value
Phone
9516767305
vtinfono other value
Licences
ca-abc 00634791|47|LIC|0 · ca-abc 00634791|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9246a975add0; O80e8d355bcd6; Ob9b34ba00fe9; Oacb2e0b972de; Odbfb1f036388

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-inbevPUBLIC HOUSE THE
2936374
41971 MAIN ST, TEMECULA, CA, 9259033.49358, -117.148692026-11-112026-11-11
ca-abcPUBLIC HOUSE
legal name: THEHATCH LLC
00634791|47|LIC|0
41971 MAIN ST, TEMECULA, CA, 925902026-10-082026-11-05
ca-abcPUBLIC HOUSE
legal name: THEHATCH LLC
00634791|58|LIC|0
41971 MAIN ST, TEMECULA, CA, 925902026-10-082026-11-05
doordashpublic house temecula
23983449
41970 Main Street, Temecula, CA, 9259033.49355, -117.148502026-10-082026-11-18
ubereatsPUBlic House
mykQIrCoTo6FGsDCWsTUWA
41971 Main St, Temecula, CA, 9259033.49376, -117.148702026-10-252026-10-25
vtinfoPUBLIC HOUSE THE
91ef43a3e9f65961
41971 MAIN ST, TEMECULA, CA, 92590951676730533.49351, -117.148352026-11-132026-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 PUBLIC HOUSE THEca-abc PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev PUBLIC HOUSE THEca-abc PUBLIC HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ab-inbev PUBLIC HOUSE THEdoordash public house temecula1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “proximity” pair)
Public House Temecula, adjacent street numbers, 18m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — The names match ("PUBLIC HOUSE THE" and the DoorDash slug "public house temecula" with the city appended), both are in Temecula 92590, the coordinates are about 18 m apart, and only one business is held at the address; the one-number difference (41971 vs 41970) is a likely numbering variant.
pair c735ffee6074584d3660
ab-inbev PUBLIC HOUSE THEubereats PUBlic House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ab-inbev PUBLIC HOUSE THEvtinfo PUBLIC HOUSE THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
ca-abc PUBLIC HOUSEca-abc PUBLIC HOUSE1.00one licence filemergedfile: 00634791 · same_address
ca-abc PUBLIC HOUSEdoordash public house temecula1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Same name, adjacent street number, same city
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records are 'Public House' in Temecula, CA 92590 on Main Street, and the ca-abc restaurant (eating place) licence fits a DoorDash restaurant listing, with only one business at the address; the street numbers differ by one (41971 vs 41970), which is a minor discrepancy that leaves some doubt.
pair 9511df9f531181290334
ca-abc PUBLIC HOUSEubereats PUBlic House1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc PUBLIC HOUSEvtinfo PUBLIC HOUSE THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
ca-abc PUBLIC HOUSEdoordash public house temecula1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Public House Temecula, Main St numbers off by one
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are the same distinctive name 'Public House' in Temecula, CA 92590 on Main Street, and A is a restaurant eating-place licence matching a DoorDash restaurant listing; the house numbers differ by one (41971 vs 41970), which is most likely a numbering or entry discrepancy, and only one business is held at that address.
pair e786da6f3446b653afcf
ca-abc PUBLIC HOUSEubereats PUBlic House1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · name similarity 1.00
ca-abc PUBLIC HOUSEvtinfo PUBLIC HOUSE THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · name similarity 1.00
doordash public house temeculaubereats PUBlic House1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same name Public House, adjacent number, 29m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are 'Public House' in Temecula, CA 92590, with coordinates about 29 m apart and only one business held at the address; the one-number street difference (41970 vs 41971) is a minor discrepancy on a distinctive independent name.
pair 545fb507fc28a046ff90
doordash public house temeculavtinfo PUBLIC HOUSE THE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “proximity” pair)
Public House, near-identical address, 15m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are the same bar-restaurant name in Temecula, CA 92590, with coordinates about 15 m apart and only one business counted at the address; the street numbers differ by one (41970 vs 41971), which is a minor discrepancy that does not outweigh the name match.
pair 6453a54c49b0dc4b97bf
ubereats PUBlic Housevtinfo PUBLIC HOUSE THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 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
THEHATCH LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
152 within 1 mi · 584 within 3 mi
Off / on premise
27 / 99 within 1 mi · 126 / 331 within 3 mi
Selling alcohol
115 within 1 mi · 355 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
suburban (1,971 people per sq mi)
People within 3 mi
55,730 (39,630 adults 21+, 19,055 households) from 10 tract(s), tracts within 3 mi
Income
per capita $43,854 · median household ~$111,443 (weighted mean of tract medians)
Age and education
median age ~35.9 · bachelor's or higher 35%
Ethnicity
Hispanic 33% · White 54% · Black 5% · Asian 9%
Adults per alcohol outlet
111
Alcohol spend within 3 mi
$15,328,047 a year ($6,828,757 at home, $8,491,703 away) · $43,056 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-18 18:58insertca-abc 00634791|58|LIC|0 ↔ doordash 23983449Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 2936374 ↔ doordash 23983449Claude judge: samemerged15
2026-11-18 18:58insertca-abc 00634791|47|LIC|0 ↔ doordash 23983449Claude judge: samemerged15
2026-11-18 18:58insertdoordash 23983449 ↔ vtinfo 91ef43a3e9f65961Claude judge: samemerged15
2026-11-18 18:58insertdoordash 23983449 ↔ ubereats mykQIrCoTo6FGsDCWsTUWAClaude judge: samemerged15
2026-11-13 14:10insertca-abc 00634791|47|LIC|0 ↔ vtinfo 91ef43a3e9f65961same address and namemerged15
2026-11-13 14:10insertca-abc 00634791|58|LIC|0 ↔ vtinfo 91ef43a3e9f65961same address and namemerged15
2026-11-13 14:10insertab-inbev 2936374 ↔ vtinfo 91ef43a3e9f65961same address and namemerged15
2026-11-13 14:10insertubereats mykQIrCoTo6FGsDCWsTUWA ↔ vtinfo 91ef43a3e9f65961same address and namemerged15
2026-11-11 12:56insertab-inbev 2936374 ↔ ubereats mykQIrCoTo6FGsDCWsTUWAsame address and namemerged12
2026-11-11 12:56insertab-inbev 2936374 ↔ ca-abc 00634791|47|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 2936374 ↔ ca-abc 00634791|58|LIC|0same address and namemerged12
2026-10-25 00:02backfillca-abc 00634791|47|LIC|0 ↔ ubereats mykQIrCoTo6FGsDCWsTUWAsame address and namemerged
2026-10-25 00:02backfillca-abc 00634791|58|LIC|0 ↔ ubereats mykQIrCoTo6FGsDCWsTUWAsame address and namemerged
2026-10-09 13:59backfillca-abc 00634791|47|LIC|0 ↔ ca-abc 00634791|58|LIC|0one licence filemerged