Outlets /
Bluewater Grill
CARLSBAD, CA 92008 · O159327fcac72 · first seen 2026-10-08
4 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Bluewater Grill 1 other | a licence name in capitals, cleaned (derived; record_title.py) | BLUEWATER CARLSBAD LPSHIP ca-abc (legal name) |
| Street | 417 CARLSBAD VILLAGE DR | ca-abc | no other value |
| City | CARLSBAD | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92008 | ca-abc | no other value |
| Pin | 33.15936, -117.34894 map | ca-abc | no other value |
| Phone | 7607303474 | vtinfo | no other value |
| Licences | ca-abc 00576376|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oe4ddf7933b8d; Oa2a3295f24a1; O3c44d27c7102
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 | BLUEWATER GRILL 4060553 | 417 CARLSBAD VILLAGE DR, CARLSBAD, CA, 92008 | 33.15937, -117.34877 | 2026-11-11 | 2026-11-20 | |
| ca-abc | BLUEWATER GRILL legal name: BLUEWATER CARLSBAD LPSHIP 00576376|47|LIC|0 | 417 CARLSBAD VILLAGE DR, CARLSBAD, CA, 92008 | 33.15936, -117.34894 | 2026-10-08 | 2026-11-20 | |
| inspections | BLUEWATER GRILL inspections|sdcounty|DEH2015-FFPP-006207 | 417 CARLSBAD VILLAGE DR, Carlsbad, CA, 92008 | 2026-11-20 | 2026-11-20 | ||
| vtinfo | BLUEWATER GRILL d7253100f4f5b96f | 417 CARLSBAD VILLAGE DR, CARLSBAD, CA, 92008 | 7607303474 | 33.15914, -117.34886 | 2026-11-12 | 2026-11-20 |
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 BLUEWATER GRILL | ca-abc BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 |
| ab-inbev BLUEWATER GRILL | inspections BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ab-inbev BLUEWATER GRILL | vtinfo BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00 |
| ca-abc BLUEWATER GRILL | inspections BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| ca-abc BLUEWATER GRILL | vtinfo BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00 |
| inspections BLUEWATER GRILL | vtinfo BLUEWATER GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
]
]
}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-20 22:08 | insert | ab-inbev 4060553 ↔ inspections inspections|sdcounty|DEH2015-FFPP-006207 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ca-abc 00576376|47|LIC|0 ↔ inspections inspections|sdcounty|DEH2015-FFPP-006207 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|sdcounty|DEH2015-FFPP-006207 ↔ vtinfo d7253100f4f5b96f | same address and name | merged | 17 |
| 2026-11-12 14:25 | insert | ab-inbev 4060553 ↔ vtinfo d7253100f4f5b96f | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | ca-abc 00576376|47|LIC|0 ↔ vtinfo d7253100f4f5b96f | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4060553 ↔ ca-abc 00576376|47|LIC|0 | same address and name | merged | 12 |