SITNBULL

Painted Post, NY 14870 · O54562a91b6f1 · first seen 2026-11-02
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.

FieldMaster valueTaken fromWhat other sources say
Name
SITNBULL 2 other
the most common name a source states
SIT-N-BULL PUB ny-slaoverture ×2
SIMMAP LLC ny-sla (legal name)
Street
107 Village Sq 1 other
ny-sla
107 Village Square overture
City
Painted Post
ny-slano other value
State
NY
ny-slano other value
ZIP
14870
ny-slano other value
Pin
42.15856, -77.09330 map 1 other
overture
95 m away ab-inbev
Phone
6079379464
vtinfono other value
Licences
ny-sla 0370-25-321154
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od2198266a1d2; Of2d6131bd9c9; Obef53a50ff4c

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
ab-inbevSITNBULL
2636965
107 VILLAGE SQ, PAINTED POST, NY, 1487042.15902, -77.094272026-11-112026-11-11
ny-slaSIT-N-BULL PUB
legal name: SIMMAP LLC
0370-25-321154
107 Village Sq, Painted Post, NY, 1487042.15862, -77.093212026-11-022026-11-16
overtureSit-N-Bull Pub
c4f2eef0-f308-4674-a04f-e60f1f2470d6
107 Village Square, Painted Post, NY, 14870607937946442.15856, -77.093302026-11-062026-11-16
vtinfoSITNBULL
fedd979d791fc5bd
107 VILLAGE SQ, PAINTED POST, NY, 14870607937946442.15854, -77.093262026-11-162026-11-17

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
ab-inbev SITNBULLvtinfo SITNBULL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 99 m apart · name similarity 1.00
ny-sla SIT-N-BULL PUBoverture Sit-N-Bull Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
ab-inbev SITNBULLny-sla SIT-N-BULL PUB0.18one name contains the other, same addressmergedjudge: None · pair_id: 4f616ca2bf91f39ac9b6 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SIMMAP LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 137 within 3 mi
Off / on premise
15 / 16 within 1 mi · 30 / 52 within 3 mi
Selling alcohol
18 within 1 mi · 105 within 3 mi
Nearest
same channel 0.17 mi · licensed 0.16 mi
Setting
suburban (658 people per sq mi)
People within 3 mi
18,608 (14,583 adults 21+, 8,747 households) from 6 tract(s), tracts within 3 mi
Income
per capita $48,737 · median household ~$72,586 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 44%
Ethnicity
Hispanic 2% · White 86% · Black 3% · Asian 5%
Adults per alcohol outlet
138
Alcohol spend within 3 mi
$5,564,658 a year ($2,580,124 at home, $2,982,041 away) · $52,497 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”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertab-inbev 2636965 ↔ ny-sla 0370-25-321154one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2636965 ↔ vtinfo fedd979d791fc5bdsame address and namemerged15
2026-11-06 18:13insertny-sla 0370-25-321154 ↔ overture c4f2eef0-f308-4674-a04f-e60f1f2470d6same address and namemerged11