Outlets /
SHAMROCKS PUB & GRILL
CORONA, CA 92879 · O19c5637bbb19 · first seen 2026-10-08
5 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 | SHAMROCKS PUB & GRILL 3 other | the most common name a source states | Shamrock's Grille & Pub overture SHAMROCKS PUB & GRILLS INC ca-abc (legal name) shamrocks pub and grill corona doordash |
| Street | 1275 MAGNOLIA AVE 1 other | ca-abc | 1275 Magnolia Avenue doordash |
| City | CORONA | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 92879 | ca-abc | no other value |
| Pin | 33.86713, -117.54096 map 1 other | doordash | 51 m away ca-abc |
| Phone | 9515491352 1 other | vtinfo | 9518084881 overture |
| Licences | ca-abc 00505734|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ocac9b4dd98d8; O6010952709f8; Ob946d71a213a; O269808304f86
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 | SHAMROCKS PUB & GRILL 3238647 | 1275 MAGNOLIA AVE, CORONA, CA, 92879 | 33.86714, -117.54082 | 2026-11-11 | 2026-11-17 | |
| ca-abc | SHAMROCKS PUB & GRILL legal name: SHAMROCKS PUB & GRILLS INC 00505734|47|LIC|0 | 1275 MAGNOLIA AVE, CORONA, CA, 92879 | 33.86667, -117.54100 | 2026-10-08 | 2026-11-17 | |
| doordash | shamrocks pub and grill corona 913700 | 1275 Magnolia Avenue, Corona, CA | 33.86713, -117.54096 | 2026-10-08 | 2026-11-17 | |
| overture | Shamrock's Grille & Pub 34f10751-0f67-4f5c-af49-0b4c32aa2ad8 | 1275 Magnolia Ave, Corona, CA, 92879 | 9518084881 | 33.86705, -117.54099 | 2026-11-06 | 2026-11-17 |
| vtinfo | SHAMROCKS PUB & GRILL 8cb3f396eea09540 | 1275 MAGNOLIA AVE, CORONA, CA, 92879 | 9515491352 | 33.86702, -117.54126 | 2026-11-13 | 2026-11-17 |
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 SHAMROCKS PUB & GRILL | ca-abc SHAMROCKS PUB & GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00 |
| ab-inbev SHAMROCKS PUB & GRILL | doordash shamrocks pub and grill corona | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00 |
| ab-inbev SHAMROCKS PUB & GRILL | vtinfo SHAMROCKS PUB & GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 m apart · name similarity 1.00 |
| ca-abc SHAMROCKS PUB & GRILL | doordash shamrocks pub and grill corona | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 51 m apart · name similarity 1.00 |
| ca-abc SHAMROCKS PUB & GRILL | vtinfo SHAMROCKS PUB & GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00 |
| doordash shamrocks pub and grill corona | vtinfo SHAMROCKS PUB & GRILL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00 |
| ab-inbev SHAMROCKS PUB & GRILL | overture Shamrock's Grille & Pub | 0.74 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 18 m apart · name similarity 0.74 |
| ca-abc SHAMROCKS PUB & GRILL | overture Shamrock's Grille & Pub | 0.74 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 42 m apart · name similarity 0.74 |
| doordash shamrocks pub and grill corona | overture Shamrock's Grille & Pub | 0.74 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 9 m apart · name similarity 0.74 |
| overture Shamrock's Grille & Pub | vtinfo SHAMROCKS PUB & GRILL | 0.74 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + city + state · pins 26 m apart · name similarity 0.74 · phone: differs |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- SHAMROCKS PUB & GRILLS INC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"bar"
]
]
}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-17 17:19 | insert | doordash 913700 ↔ overture 34f10751-0f67-4f5c-af49-0b4c32aa2ad8 | same address and name | merged | 15 |
| 2026-11-17 17:19 | insert | ab-inbev 3238647 ↔ doordash 913700 | same address and name | merged | 15 |
| 2026-11-17 17:19 | insert | ca-abc 00505734|47|LIC|0 ↔ doordash 913700 | same address and name | merged | 15 |
| 2026-11-17 17:19 | insert | doordash 913700 ↔ vtinfo 8cb3f396eea09540 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture 34f10751-0f67-4f5c-af49-0b4c32aa2ad8 ↔ vtinfo 8cb3f396eea09540 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 3238647 ↔ vtinfo 8cb3f396eea09540 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ca-abc 00505734|47|LIC|0 ↔ vtinfo 8cb3f396eea09540 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ab-inbev 3238647 ↔ overture 34f10751-0f67-4f5c-af49-0b4c32aa2ad8 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 3238647 ↔ ca-abc 00505734|47|LIC|0 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00505734|47|LIC|0 ↔ overture 34f10751-0f67-4f5c-af49-0b4c32aa2ad8 | same address and name | merged | 11 |