The Hubb Brick Oven & Bar

Troy, NY 12180 · O016dc8453b07 · 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.

FieldMaster valueTaken fromWhat other sources say
Name
The Hubb Brick Oven & Bar 1 other
the most common name a source states
The Hubb Brick Oven & Bar, LLC ny-sla
Street
28 4th St 1 other
ny-sla
28 FOURTH STREET inspections
City
Troy
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.73285, -73.68839 map
overtureno other value
Phone
5189416251
vtinfono other value
Licences
ny-sla 0370-25-229698
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of063af1f9be1; Oec2aac34eda1; Oe2e76082de40

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
inspectionsThe Hubb Brick Oven & Bar
inspections|nys|1160163
28 FOURTH STREET, Troy, NY, 1218042.73271, -73.688612026-11-192026-11-19
ny-slaThe Hubb Brick Oven & Bar, LLC
0370-25-229698
28 4th St, Troy, NY, 1218042.73285, -73.688692026-11-022026-11-19
overtureThe Hubb Brick Oven & Bar
0d54ee86-b4db-4904-b6d2-c4a79c0c326f
28 4th St, Troy, NY, 12180518941625142.73285, -73.688392026-11-062026-11-19
vtinfoTHE HUBB BRICK OVEN & BAR
7841ed6c4332b29c
28 4TH ST, TROY, NY, 12180518941625142.73283, -73.688462026-11-122026-11-19

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
inspections The Hubb Brick Oven & Barny-sla The Hubb Brick Oven & Bar, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
inspections The Hubb Brick Oven & Baroverture The Hubb Brick Oven & Bar1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00
inspections The Hubb Brick Oven & Barvtinfo THE HUBB BRICK OVEN & BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ny-sla The Hubb Brick Oven & Bar, LLCoverture The Hubb Brick Oven & Bar1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ny-sla The Hubb Brick Oven & Bar, LLCvtinfo THE HUBB BRICK OVEN & BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
overture The Hubb Brick Oven & Barvtinfo THE HUBB BRICK OVEN & BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 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
The Hubb Brick Oven & Bar, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "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”).
WhenEventPairRuleDecisionRule version
2026-11-19 20:37insertinspections inspections|nys|1160163 ↔ overture 0d54ee86-b4db-4904-b6d2-c4a79c0c326fsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|1160163 ↔ vtinfo 7841ed6c4332b29csame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|1160163 ↔ ny-sla 0370-25-229698same address and namemerged17
2026-11-12 14:25insertoverture 0d54ee86-b4db-4904-b6d2-c4a79c0c326f ↔ vtinfo 7841ed6c4332b29csame address and namemerged12
2026-11-12 14:25insertny-sla 0370-25-229698 ↔ vtinfo 7841ed6c4332b29csame address and namemerged12
2026-11-06 18:13insertny-sla 0370-25-229698 ↔ overture 0d54ee86-b4db-4904-b6d2-c4a79c0c326fsame address and namemerged11