Outlets /
The Royal Pub
SHIRLEY, NY 11967 · O1052bedc13c5 · first seen 2026-11-02
4 sourceson premise · baralcohol: 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 | The Royal Pub 1 other | a source's own spelling of the licence name (record_title.py) | ROYAL PUB INC ny-sla |
| Street | 534 WILLIAM FLOYD PKWY | ny-sla | no other value |
| City | SHIRLEY | ny-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 11967 | ny-sla | no other value |
| Pin | 40.79915, -72.86693 map | overture | no other value |
| Phone | 6317725070 | vtinfo | no other value |
| Licences | ny-sla 0370-24-110964 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O820bf001e3d9; O43efeec93db2; Oa19d9641a6f7
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 | THE ROYAL PUB 4104129 | 534 WILLIAM FLOYD PKWY, SHIRLEY, NY, 11967 | 40.79899, -72.86646 | 2026-11-11 | 2026-11-11 | |
| ny-sla | ROYAL PUB INC 0370-24-110964 | 534 WILLIAM FLOYD PKWY, SHIRLEY, NY, 11967 | 40.79900, -72.86639 | 2026-11-02 | 2026-11-11 | |
| overture | The Royal Pub 9861ea24-5d54-489a-9df6-5bffcf4c4d66 | 534 William Floyd Pkwy, Shirley, NY, 11967 | 6317725070 | 40.79915, -72.86693 | 2026-11-06 | 2026-11-11 |
| vtinfo | THE ROYAL PUB f0906e528824e539 | 534 WILLIAM FLOYD PKWY, SHIRLEY, NY, 11967 | 6317725070 | 40.79917, -72.86689 | 2026-11-15 | 2026-11-15 |
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 THE ROYAL PUB | ny-sla ROYAL PUB INC | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 |
| ab-inbev THE ROYAL PUB | overture The Royal Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 43 m apart · name similarity 1.00 |
| ab-inbev THE ROYAL PUB | vtinfo THE ROYAL PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00 |
| ny-sla ROYAL PUB INC | overture The Royal Pub | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00 |
| ny-sla ROYAL PUB INC | vtinfo THE ROYAL PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00 |
| overture The Royal Pub | vtinfo THE ROYAL PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 · phone: equal |
Attributes
- Channel
- on_premise · bar — overture-category
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- ROYAL PUB INC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, wine_on, spirits_on — NY 0370
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"on_premise",
"bar"
]
]
}Trade area
- Other outlets
- 96 within 1 mi · 226 within 3 mi
- Off / on premise
- 34 / 57 within 1 mi · 69 / 112 within 3 mi
- Selling alcohol
- 42 within 1 mi · 130 within 3 mi
- Nearest
- same channel 0.02 mi · licensed 0.03 mi
- Setting
- suburban (2,024 people per sq mi)
- People within 3 mi
- 57,224 (40,659 adults 21+, 17,670 households) from 13 tract(s), tracts within 3 mi
- Income
- per capita $43,639 · median household ~$104,579 (weighted mean of tract medians)
- Age and education
- median age ~37.7 · bachelor's or higher 20%
- Ethnicity
- Hispanic 27% · White 67% · Black 9% · Asian 3%
- Adults per alcohol outlet
- 310
- Alcohol spend within 3 mi
- $14,173,245 a year ($6,322,928 at home, $7,843,618 away) · $108,193 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-15 16:24 | insert | overture 9861ea24-5d54-489a-9df6-5bffcf4c4d66 ↔ vtinfo f0906e528824e539 | same address and name | merged | 15 |
| 2026-11-15 16:24 | insert | ny-sla 0370-24-110964 ↔ vtinfo f0906e528824e539 | same address and name | merged | 15 |
| 2026-11-15 16:24 | insert | ab-inbev 4104129 ↔ vtinfo f0906e528824e539 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ab-inbev 4104129 ↔ overture 9861ea24-5d54-489a-9df6-5bffcf4c4d66 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 4104129 ↔ ny-sla 0370-24-110964 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ny-sla 0370-24-110964 ↔ overture 9861ea24-5d54-489a-9df6-5bffcf4c4d66 | same address and name | merged | 11 |