STRAW HAT PIZZA

BAKERSFIELD, CA 93312 · O328c715987f5 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: licensed1 licence

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
STRAW HAT PIZZA 2 other
the most common name a source states
HOFFMAN RANDY SCOTT ca-abc (legal name)
STRAW HAT BAKERSFIELD ca-abc
Street
9620 HAGEMAN RD
ca-abcno other value
City
BAKERSFIELD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93312
ca-abcno other value
Pin
35.39813, -119.10906 map 1 other
ca-abc
306 m away vtinfo
Phone
6612188201
vtinfono other value
Licences
ca-abc 00652885|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oad5c99c01cd9; O32b796727841

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-inbevSTRAW HAT PIZZA
4752395
9620 HAGEMAN RD, BAKERSFIELD, CA, 9331235.39841, -119.109352026-11-112026-11-12
ca-abcSTRAW HAT BAKERSFIELD
legal name: HOFFMAN RANDY SCOTT
00652885|47|LIC|0
9620 HAGEMAN RD, BAKERSFIELD, CA, 9331235.39813, -119.109062026-10-082026-11-12
vtinfoSTRAW HAT PIZZA
1ce267beae8738a8
9620 HAGEMAN RD, BAKERSFIELD, CA, 93312661218820135.40087, -119.108922026-11-122026-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 STRAW HAT PIZZAvtinfo STRAW HAT PIZZA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 277 m apart · name similarity 1.00
ab-inbev STRAW HAT PIZZAca-abc STRAW HAT BAKERSFIELD0.50Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Straw Hat Pizza same address, restaurant licence
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at the same street address and ZIP in Bakersfield, and the names share the Straw Hat brand (Straw Hat Pizza vs Straw Hat Bakersfield), with the California licence being an on-sale eating place (restaurant) that matches a pizza restaurant; no other business is recorded at that address, so this is most likely one restaurant listed under two sources.
pair 0edcba4f06617346ddf5

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 7, computed 2026-11-16 17:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
126 within 1 mi · 351 within 3 mi
Off / on premise
32 / 80 within 1 mi · 95 / 211 within 3 mi
Selling alcohol
62 within 1 mi · 186 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (3,128 people per sq mi)
People within 3 mi
88,454 (59,871 adults 21+, 28,643 households) from 22 tract(s), tracts within 3 mi
Income
per capita $43,391 · median household ~$112,425 (weighted mean of tract medians)
Age and education
median age ~36.5 · bachelor's or higher 33%
Ethnicity
Hispanic 33% · White 58% · Black 2% · Asian 7%
Adults per alcohol outlet
320
Alcohol spend within 3 mi
$23,851,187 a year ($10,569,974 at home, $13,270,050 away) · $127,546 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 17:29insertab-inbev 4752395 ↔ ca-abc 00652885|47|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 4752395 ↔ vtinfo 1ce267beae8738a8same address and namemerged12