Outlets /
Big Lou's Liquor
SAN CARLOS, CA 94070 · O19727b851632 · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Big Lou's Liquor 3 other | a licence name in capitals, cleaned (derived; record_title.py) | BIG LOUS LIQUOR ab-inbevvtinfo ×2 Big Lous Liquors overtureubereats ×2 BIG LOU'S LIQUORS ca-abc |
| Street | 1117 LAUREL ST | ca-abc | no other value |
| City | SAN CARLOS | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94070 | ca-abc | no other value |
| Pin | 37.49980, -122.25312 map 1 other | ubereats | 149 m away ab-inbev |
| Phone | 6502327119 | vtinfo | no other value |
| Licences | ca-abc 00675041|21|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe47caec8538f; Oba004af0e2e2; O9084ccf04d31; Ob13b5299d8e8
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | BIG LOUS LIQUOR 4064179 | 1117 LAUREL ST, SAN CARLOS, CA, 94070 | 37.49886, -122.25191 | 2026-11-11 | 2026-11-11 | |
| ca-abc | BIG LOU'S LIQUORS 00675041|21|LIC|0 | 1117 LAUREL ST, SAN CARLOS, CA, 94070 | 37.49983, -122.25305 | 2026-10-08 | 2026-11-11 | |
| overture | Big Lous Liquors a9c93a75-bfd5-4486-b5ba-b564701e1c50 | 1117 Laurel St, San Carlos, CA, 94070 | 6502327119 | 37.49991, -122.25286 | 2026-11-06 | 2026-11-11 |
| ubereats | Big Lous liquors M4hCI33wSpiaOChxgcJ9cA | 1117 Laurel St, San Carlos, CA, 94070 | 37.49980, -122.25312 | 2026-11-02 | 2026-11-11 | |
| vtinfo | BIG LOUS LIQUOR 77acf23facb9bd47 | 1117 LAUREL ST, SAN CARLOS, CA, 94070 | 6502327119 | 37.49992, -122.25287 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev BIG LOUS LIQUOR | vtinfo BIG LOUS LIQUOR | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 145 m apart · name similarity 1.00 |
| ca-abc BIG LOU'S LIQUORS | overture Big Lous Liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00 |
| overture Big Lous Liquors | ubereats Big Lous liquors | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 |
| ab-inbev BIG LOUS LIQUOR | ca-abc BIG LOU'S LIQUORS | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 148 m apart · name similarity 0.73 |
| ab-inbev BIG LOUS LIQUOR | overture Big Lous Liquors | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 144 m apart · name similarity 0.73 |
| ab-inbev BIG LOUS LIQUOR | ubereats Big Lous liquors | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 149 m apart · name similarity 0.73 |
| ca-abc BIG LOU'S LIQUORS | vtinfo BIG LOUS LIQUOR | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 19 m apart · name similarity 0.73 |
| overture Big Lous Liquors | vtinfo BIG LOUS LIQUOR | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 1 m apart · name similarity 0.73 · phone: equal |
| ubereats Big Lous liquors | vtinfo BIG LOUS LIQUOR | 0.73 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 26 m apart · name similarity 0.73 |
| ca-abc BIG LOU'S LIQUORS | ubereats Big Lous liquors | 0.69 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) The two records carry the same distinctive name, 'Big Lou's Liquors', at the same street address and ZIP, 1117 Laurel St, San Carlos 94070, and the address holds only one business; the off-sale licenc Other Claude answers on this pair:
pair d58555523812171cebe0 |
Attributes
- Channel
- off_premise · liquor_store — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- none
- Licence privileges
- beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"ca-licence",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 207 within 1 mi · 761 within 3 mi
- Off / on premise
- 32 / 135 within 1 mi · 127 / 491 within 3 mi
- Selling alcohol
- 135 within 1 mi · 452 within 3 mi
- Nearest
- same channel 0.06 mi · licensed 0.04 mi
- Setting
- urban (4,696 people per sq mi)
- People within 3 mi
- 132,789 (100,914 adults 21+, 50,034 households) from 31 tract(s), tracts within 3 mi
- Income
- per capita $100,592 · median household ~$187,956 (weighted mean of tract medians)
- Age and education
- median age ~39.8 · bachelor's or higher 63%
- Ethnicity
- Hispanic 23% · White 47% · Black 3% · Asian 23%
- Adults per alcohol outlet
- 223
- Alcohol spend within 3 mi
- $54,639,414 a year ($22,884,557 at home, $31,741,581 away) · $120,617 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 14:25 | insert | ca-abc 00675041|21|LIC|0 ↔ vtinfo 77acf23facb9bd47 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | overture a9c93a75-bfd5-4486-b5ba-b564701e1c50 ↔ vtinfo 77acf23facb9bd47 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ubereats M4hCI33wSpiaOChxgcJ9cA ↔ vtinfo 77acf23facb9bd47 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ab-inbev 4064179 ↔ vtinfo 77acf23facb9bd47 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4064179 ↔ overture a9c93a75-bfd5-4486-b5ba-b564701e1c50 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4064179 ↔ ubereats M4hCI33wSpiaOChxgcJ9cA | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4064179 ↔ ca-abc 00675041|21|LIC|0 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | overture a9c93a75-bfd5-4486-b5ba-b564701e1c50 ↔ ubereats M4hCI33wSpiaOChxgcJ9cA | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00675041|21|LIC|0 ↔ overture a9c93a75-bfd5-4486-b5ba-b564701e1c50 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00675041|21|LIC|0 ↔ ubereats M4hCI33wSpiaOChxgcJ9cA | Claude judge: same | merged |