Common Roots Brewing

ALBANY, NY 12207 · O15731d48a758 · first seen 2026-11-02
1 sourceoff premise · liquor_storealcohol: licensed3 licences

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
Common Roots Brewing 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ALBANY PUMP STATION BREWING CO INC ny-sla (legal name) ×3
COMMON ROOTS BREWING COMPANY ny-sla ×3
Street
19 QUACKENBUSH SQ
ny-slano other value
City
ALBANY
ny-slano other value
State
NY
ny-slano other value
ZIP
12207
ny-slano other value
Pin
42.65404, -73.74775 map
ny-slano other value
Phone
none
no other value
Licences
ny-sla 0014-24-214766 · ny-sla 0340-24-219813 · ny-sla 0340-24-219813-01
every licence and permit record in the outlet
Joined by singleton · absorbed ids: Oc2497a2a32d7; Obfb95fdee311

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
ny-slaCOMMON ROOTS BREWING COMPANY
legal name: ALBANY PUMP STATION BREWING CO INC
0014-24-214766
19 QUACKENBUSH SQ, ALBANY, NY, 1220742.65404, -73.747752026-11-022026-11-05
ny-slaCOMMON ROOTS BREWING COMPANY
legal name: ALBANY PUMP STATION BREWING CO INC
0340-24-219813
19 QUACKENBUSH SQ, ALBANY, NY, 1220742.65404, -73.747752026-11-022026-11-05
ny-slaCOMMON ROOTS BREWING COMPANY
legal name: ALBANY PUMP STATION BREWING CO INC
0340-24-219813-01
19 QUACKENBUSH SQ, ALBANY, NY, 1220742.65404, -73.747752026-11-022026-11-05

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
ny-sla COMMON ROOTS BREWING COMPANYny-sla COMMON ROOTS BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla COMMON ROOTS BREWING COMPANYny-sla COMMON ROOTS BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ALBANY PUMP STATION BREWING CO INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0014; NY 0340; NY 0423 (add-on: follows the base licence)
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
225 within 1 mi · 633 within 3 mi
Off / on premise
44 / 97 within 1 mi · 156 / 300 within 3 mi
Selling alcohol
162 within 1 mi · 411 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (3,748 people per sq mi)
People within 3 mi
105,961 (82,529 adults 21+, 48,373 households) from 31 tract(s), tracts within 3 mi
Income
per capita $39,034 · median household ~$67,053 (weighted mean of tract medians)
Age and education
median age ~34.5 · bachelor's or higher 42%
Ethnicity
Hispanic 10% · White 53% · Black 24% · Asian 9%
Adults per alcohol outlet
200
Alcohol spend within 3 mi
$28,165,976 a year ($13,274,606 at home, $14,875,349 away) · $68,364 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-03 13:33backfillny-sla 0014-24-214766 ↔ ny-sla 0340-24-219813-01one store listed twicemerged
2026-11-03 13:33backfillny-sla 0014-24-214766 ↔ ny-sla 0340-24-219813one store listed twicemerged