The Derby Room Perris

PERRIS, CA 92571 · O1b57a44c2c90 · first seen 2026-10-08
4 sourceson premise · restaurantchain: The Derby Room Norcoalcohol: 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 Derby Room Perris 3 other
a source's own spelling of the licence name (record_title.py)
CALIFORNIA SPORTS AND HOSPITALITY LLC ca-abc (legal name) ×2
DERBY ROOM PERRIS THE ca-abc ×2
THE DERBY ROOM ab-inbevvtinfo ×2
Street
18700 LAKE PERRIS DR
ca-abcno other value
City
PERRIS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92571
ca-abcno other value
Pin
33.84732, -117.20197 map 3 other
overture
1314 m away ca-abc ×2
233 m away ab-inbev
77 m away vtinfo
Phone
9516923572 1 other
vtinfo
9512665486 overture
Licences
ca-abc 00615740|47|LIC|0 · ca-abc 00615740|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O7154fd33ded7; O4aab7ea86986; O1d2b6e7a89c4; Oa1dfca2e18e6

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 DERBY ROOM
4388606
18700 LAKE PERRIS DR, PERRIS, CA, 9257133.84638, -117.204222026-11-112026-11-12
ca-abcDERBY ROOM PERRIS THE
legal name: CALIFORNIA SPORTS AND HOSPITALITY LLC
00615740|47|LIC|0
18700 LAKE PERRIS DR, PERRIS, CA, 9257133.85903, -117.203902026-10-082026-11-06
ca-abcDERBY ROOM PERRIS THE
legal name: CALIFORNIA SPORTS AND HOSPITALITY LLC
00615740|58|LIC|0
18700 LAKE PERRIS DR, PERRIS, CA, 9257133.85903, -117.203902026-10-082026-11-06
overtureThe Derby Room Perris
c1fbe587-2157-4fc4-a475-6f32a0af316b
18700 Lake Perris Dr, Perris, CA, 92571951266548633.84732, -117.201972026-11-062026-11-06
vtinfoTHE DERBY ROOM
509a644ce2e0fb96
18700 LAKE PERRIS DR, PERRIS, CA, 92571951692357233.84777, -117.201332026-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
ca-abc DERBY ROOM PERRIS THEoverture 8820a31a-8e52-42ab-916a-6c1ee097f7950.74same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1275 m apart · matched through the licence's legal name: CALIFORNIA SPORTS AND HOSPITALITY LLC · name similarity 0.74
ca-abc DERBY ROOM PERRIS THEoverture 8820a31a-8e52-42ab-916a-6c1ee097f7950.74same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 1275 m apart · matched through the licence's legal name: CALIFORNIA SPORTS AND HOSPITALITY LLC · name similarity 0.74
ab-inbev THE DERBY ROOMvtinfo THE DERBY ROOM1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 308 m apart · name similarity 1.00
ca-abc DERBY ROOM PERRIS THEca-abc DERBY ROOM PERRIS THE1.00one licence filemergedfile: 00615740 · same_address
ca-abc DERBY ROOM PERRIS THEoverture The Derby Room Perris1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1314 m apart · name similarity 1.00
ca-abc DERBY ROOM PERRIS THEoverture The Derby Room Perris1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1314 m apart · name similarity 1.00
ab-inbev THE DERBY ROOMca-abc DERBY ROOM PERRIS THE0.70Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Derby Room same name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records are at 18700 Lake Perris Dr, Perris, and the names are the same distinctive business, THE DERBY ROOM reordered as DERBY ROOM PERRIS THE; B's restaurant licence fits a bar or restaurant account carrying AB InBev beer, though the 1.4 km coordinate gap and the shared building leave some doubt.
pair 2e43a0e22e9e1e751ef5

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
The Derby Room Norco — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
CALIFORNIA SPORTS AND HOSPITALITY 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:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
6 within 1 mi · 90 within 3 mi
Off / on premise
0 / 3 within 1 mi · 23 / 48 within 3 mi
Selling alcohol
2 within 1 mi · 46 within 3 mi
Nearest
same channel 0.66 mi · licensed 0.82 mi
Setting
suburban (2,268 people per sq mi)
People within 3 mi
64,125 (43,282 adults 21+, 14,777 households) from 11 tract(s), tracts within 3 mi
Income
per capita $29,566 · median household ~$109,765 (weighted mean of tract medians)
Age and education
median age ~32.5 · bachelor's or higher 18%
Ethnicity
Hispanic 69% · White 15% · Black 15% · Asian 4%
Adults per alcohol outlet
921
Alcohol spend within 3 mi
$11,949,698 a year ($5,319,611 at home, $6,624,150 away) · $254,249 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:23insertab-inbev 4388606 ↔ vtinfo 509a644ce2e0fb96same address and namemerged15
2026-11-12 17:29insertab-inbev 4388606 ↔ ca-abc 00615740|47|LIC|0Claude judge: samemerged14
2026-11-06 18:13insertca-abc 00615740|47|LIC|0 ↔ overture 8820a31a-8e52-42ab-916a-6c1ee097f795same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00615740|58|LIC|0 ↔ overture 8820a31a-8e52-42ab-916a-6c1ee097f795same address and nameheld: same-source-conflict11
2026-11-06 18:13insertca-abc 00615740|47|LIC|0 ↔ overture c1fbe587-2157-4fc4-a475-6f32a0af316bsame address and namemerged11
2026-11-06 18:13insertca-abc 00615740|58|LIC|0 ↔ overture c1fbe587-2157-4fc4-a475-6f32a0af316bsame address and namemerged11
2026-10-09 13:59backfillca-abc 00615740|47|LIC|0 ↔ ca-abc 00615740|58|LIC|0one licence filemerged