938 CRAWFISH

ALBANY, CA 94706 · O1f633591dd7b · 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
938 CRAWFISH 2 other
the most common name a source states
938 CRAWFISH CORPORATION ca-abc (legal name) ×2
938 crawfish albany doordash
Street
938 SAN PABLO AVE 1 other
ca-abc
938 San Pablo Avenue doordash
City
ALBANY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94706
ca-abcno other value
Pin
37.88894, -122.29874 map
doordashno other value
Phone
5105252722
overtureno other value
Licences
ca-abc 00540166|47|APP|0 · ca-abc 00540166|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9eae9f1175dd; O4ccd9e6953f4; O4454cb513d1d

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-abc938 CRAWFISH
legal name: 938 CRAWFISH CORPORATION
00540166|47|APP|0
938 SAN PABLO AVE, ALBANY, CA, 9470637.88935, -122.298832026-10-082026-11-06
ca-abc938 CRAWFISH
legal name: 938 CRAWFISH CORPORATION
00540166|47|LIC|0
938 SAN PABLO AVE, ALBANY, CA, 9470637.88935, -122.298832026-10-082026-11-06
doordash938 crawfish albany
78153
938 San Pablo Avenue, Albany, CA, 9470637.88894, -122.298742026-10-082026-11-11
overture938 Crawfish
bba4bb3c-9fdc-405c-a8de-b98e7e990ec9
938 San Pablo Ave, Albany, CA, 94706510525272237.88894, -122.298702026-11-062026-11-06

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 938 CRAWFISHca-abc 938 CRAWFISH1.00one licence filemergedfile: 00540166 · same_address
ca-abc 938 CRAWFISHdoordash 938 crawfish albany1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00
ca-abc 938 CRAWFISHoverture 938 Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ca-abc 938 CRAWFISHdoordash 938 crawfish albany1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 47 m apart · name similarity 1.00
ca-abc 938 CRAWFISHoverture 938 Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
doordash 938 crawfish albanyoverture 938 Crawfish1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 3 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
938 CRAWFISH CORPORATION — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
280 within 1 mi · 1,123 within 3 mi
Off / on premise
58 / 167 within 1 mi · 192 / 708 within 3 mi
Selling alcohol
191 within 1 mi · 679 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (5,854 people per sq mi)
People within 3 mi
165,523 (125,447 adults 21+, 66,728 households) from 50 tract(s), tracts within 3 mi
Income
per capita $69,661 · median household ~$125,029 (weighted mean of tract medians)
Age and education
median age ~38.5 · bachelor's or higher 70%
Ethnicity
Hispanic 14% · White 48% · Black 9% · Asian 22%
Adults per alcohol outlet
184
Alcohol spend within 3 mi
$58,584,747 a year ($25,344,134 at home, $33,221,810 away) · $86,154 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-10 17:05insertca-abc 00540166|47|APP|0 ↔ doordash 78153same address and namemerged12
2026-11-10 17:05insertca-abc 00540166|47|LIC|0 ↔ doordash 78153same address and namemerged12
2026-11-10 17:05insertdoordash 78153 ↔ overture bba4bb3c-9fdc-405c-a8de-b98e7e990ec9same address and namemerged12
2026-11-06 18:13insertca-abc 00540166|47|APP|0 ↔ overture bba4bb3c-9fdc-405c-a8de-b98e7e990ec9same address and namemerged11
2026-11-06 18:13insertca-abc 00540166|47|LIC|0 ↔ overture bba4bb3c-9fdc-405c-a8de-b98e7e990ec9same address and namemerged11
2026-10-09 13:59backfillca-abc 00540166|47|APP|0 ↔ ca-abc 00540166|47|LIC|0one licence filemerged